New install, cannot register admin

[lukebarone]

Hi folks,

Attempted to install on a fresh Debian Bookworm server with PHP 8.2, MariaDB, and Apache 2.

After commenting out two ALTER TABLE lines in /database_schema/upgrades/2.9/schema.sql, I can get through the install (the tables pending_reservations and users_customers do not exist, so the ALTER TABLE statements throw an error), I can get through the installation, but cannot register any users.

Checking the log, I get the following when attempting to register my admin user:

[2025-03-25T21:39:28.461028+00:00] app.ERROR: [User=  ()] ProcessAction Error. Action register, Error Exception: There was an error executing your query\nCannot add or update a child row: a foreign key constraint fails (`librebooking`.`users`, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`status_id`) REFERENCES `user_statuses` (`status_id`) ON UPDATE CASCADE) in /var/www/booking/lib/Database/MySQL/MySqlConnection.php:119 Stack trace: #0 /var/www/booking/lib/Database/MySQL/MySqlConnection.php(106): MySqlConnection->_handleError() #1 /var/www/booking/lib/Database/Database.php(79): MySqlConnection->Execute() #2 /var/www/booking/Domain/Access/UserRepository.php(406): Database->ExecuteInsert() #3 /var/www/booking/lib/Application/Authentication/Registration.php(108): UserRepository->Add() #4 /var/www/booking/Presenters/RegistrationPresenter.php(138): Registration->Register() #5 /var/www/booking/Presenters/ActionPresenter.php(68): RegistrationPresenter->Register() #6 /var/www/booking/Pages/RegistrationPage.php(229): ActionPresenter->ProcessAction() #7 /var/www/booking/Pages/ActionPage.php(27): RegistrationPage->ProcessAction() #8 /var/www/booking/Web/register.php(8): ActionPage->PageLoad() #9 {main} [File=/var/www/booking/Presenters/ActionPresenter.php,Line=71] [] {"url":"/booked/Web/register.php?action=register","ip":"10.3.11.139","http_method":"POST","server":"10.3.10.13","referrer":"http://10.3.10.13/booked/Web/register.php"}

This is fixed if we switch to the master branch

[DavidEdell]

This issue is reproducible on the docker develop tag for a fresh install. Switching to a tagged release worked.

[colisee]

This issue is reproducible on the docker develop tag for a fresh install. Switching to a tagged release worked.

Hi @effgarces,

I think that @DavidEdell had the right reflex to confirm the issue through the docker images (last stable and develop).

Maybe this is something that should be documented and requested when someone raises a perceived bug-related issue... On my side, I am open to adapt the versions of mariadb and php being used for building the image.

[JohnVillalovos]

This issue is reproducible on the docker develop tag for a fresh install. Switching to a tagged release worked.

Hi @effgarces,

I think that @DavidEdell had the right reflex to confirm the issue through the docker images (last stable and develop).

Maybe this is something that should be documented and requested when someone raises a perceived bug-related issue... On my side, I am open to adapt the versions of mariadb and php being used for building the image.

Hi @colisee,

This sounds like a good idea to me. I'm happy to help with getting documentation updates merged. On a related note I am playing around with using Sphinx https://www.sphinx-doc.org/en/master/ for our documentation. I see projects like phpMyAdmin use it.

[JohnVillalovos]

@lukebarone I will see if I can reproduce your issue this weekend, no promises though.

[JohnVillalovos]

@lukebarone I was unable to reproduce this.

I did a fresh install and then went to: http://librebooking/Web/install (adjust URL as needed). First time I did all three options which create the default 'admin' user. And second time I did it where I did not create the default 'admin' user but went to http://librebooking/Web/registration.php to register the user. (As a note I had to set the registration.captcha.enabled setting to false).

As a note a fix for the schema 2.9 upgrade has been merged in. I tested with the latest version of the develop branch, which included the fix from #541

[JohnVillalovos]

Can't reproduce this so closing.