Help with installation

[Hakush]

Hi i need help with some steps of the installlation process, im supposed to download the source tar.gz / rar file that appears in the last release or the zip file that weights 70MB

I decided to use the tar.gz file, but the /database_schema/full-instal.sql file is not there for example, in this step i dont understand if its optional or not to run that script.

Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE.
Click the 'Add User to Db' button. 'Creating tables'
Open phpMyAdmin.
Click on the database name that you just created in the left panel.
Click the SQL tab at the top of the page.
Import /database_schema/create-schema.sql to librebooking (or whatever database name was used in the creation process)
Import /database_schema/create-data.sql to librebooking (or whatever database name was used in the creation process)

If you have database creation privileges in MySQL
Open /database_schema/full-install.sql and edit the database name and username/password to match your config.php database values
Run or import /database_schema/full-install.sql Optionally - run/import /database_schema/testdata-utf8.sql to librebooking (sample application data will be created with 2 users: admin/password and user/password).
These users are available for testing your installation.

I already did create_schema.sql and create_data.sql (btw this last sql has an error because it tries to insert 3 columns of data into the 'layouts' table but it only has 2) but the install readme says i have to execute the full-install.sql next and modify the user and db names, which are nowhere to be found, it seems that this file its just a concatenation of create_schema and create_data

[Hakush]

After some troubleshooting, i think i fixed some of my missconceptions:

1. its better to use the 70MB file
2. if not, the installation guide is missing a 'execute composer install'
3. i still dont know what user or db names need to be modified when running full-install.sql but i executed it either way using the correct database and it worked just fine
4. Now i im running into another issue but i will create another discussion for it.
5. I hope that the installation file can be adjusted a little bit to clarify this things, including the error when running create_data.sql.

[brettdiaz]

can you explain the errors. i am having a very hard time getting it running again, in 2023 I got it to run but now errors when uploading the sql i understand the first error but the errors keep coming as I try to import the sql's files when using the master branch. I am even uploading them in the same order as listed in the /Presenters/Installer/Installer.php at import create-schema.sql the errors start. I understand error #1 about the 3 columns in layouts but after that error comes some constraint key error.

    $create_database = new MySqlScript(ROOT_DIR . 'database_schema/create-db.sql');
    $create_database->Replace('librebooking', $database_name);

    $create_user = new MySqlScript(ROOT_DIR . 'database_schema/create-user.sql');
    $create_user->Replace('librebooking', $database_name);
    $create_user->Replace('lb_user', $database_user);
    $create_user->Replace('localhost', $hostname);
    $create_user->Replace('password', $database_password);

    $populate_sample_data = new MySqlScript(ROOT_DIR . 'database_schema/sample-data-utf8.sql');
    $populate_sample_data->Replace('librebooking', $database_name);

    $create_schema = new MySqlScript(ROOT_DIR . 'database_schema/create-schema.sql');
    $populate_data = new MySqlScript(ROOT_DIR . 'database_schema/create-data.sql');

[Hakush]

I did it manually, created a new database with a db viewer called HeidiSQL, and then just imported and executed create-schema.sql, create-data.sql and full-install.sql

After that just make sure the db user and the db server matches the one in the config file. if you are still having issues at create-schema on a fresh db then you should upload exactly what key contraint error you are having