Unable to start LWT after installation

[MrSalehSalem]

Describe the bug
Internal Server Error - A database error occurred. Please try again later.
when the docker finished the setup process and opened localhost:8010 the app doesn't start at all

To Reproduce
I followed the quick installation method and got the error.

Expected behavior
LWT should open and work properly

Screenshots

Server (please complete)
You can copy/paste data from http://[.. your LWT installation]/server_data.php.

• LWT version: 3.2.0

Desktop (if necessary):

• OS: Windows 11
• Browser Zen browser (Firefox)
• Version 1.21.4b (Firefox 152.0.3) (64-bit)

Additional context

Context:

{
"query": "CREATE TABLE IF NOT EXISTS _migrations (\r\n\tfilename VARCHAR(255) NOT NULL,\r\n\tapplied_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\r\n\tchecksum VARCHAR(64) DEFAULT NULL,\r\n\tPRIMARY KEY (filename)\r\n);\r\n\r\n\r\nCREATE TABLE IF NOT EXISTS users (\r\n UsID int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n UsUsername varchar(100) NOT NULL,\r\n UsEmail varchar(255) DEFAULT NULL,\r\n UsPasswordHash varchar(255) DEFAULT NULL,\r\n UsApiToken varchar(64) DEFAULT NULL,\r\n UsApiTokenExpires datetime DEFAULT NULL,\r\n UsRememberToken varchar(64) DEFAULT NULL,\r\n UsRememberTokenExpires datetime DEFAULT NULL,\r\n UsPasswordResetToken varchar(64) DEFAULT NULL,\r\n UsPasswordResetTokenExpires datetime DEFAULT NULL,\r\n UsRecoveryCodeHash varchar(255) DEFAULT NULL,\r\n UsWordPressId int(10) unsigned DEFAULT NULL,\r\n UsGoogleId varchar(255) DEFAULT NULL,\r\n UsMicrosoftId varchar(255) DEFAULT NULL,\r\n UsCreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n UsLastLogin timestamp NULL DEFAULT NULL,\r... [TRUNCATED]",
"sql_error_code": 1064
}

Stack Trace

#0 /var/www/html/src/Shared/Infrastructure/Database/Connection.php(104): Lwt\Shared\Infrastructure\Exception\DatabaseException::queryFailed()
#1 /var/www/html/src/Shared/Infrastructure/Database/Connection.php(222): Lwt\Shared\Infrastructure\Database\Connection::query()
#2 /var/www/html/src/Shared/Infrastructure/Database/Migrations.php(448): Lwt\Shared\Infrastructure\Database\Connection::execute()
#3 /var/www/html/src/Shared/Infrastructure/Bootstrap/DatabaseBootstrap.php(103): Lwt\Shared\Infrastructure\Database\Migrations::checkAndUpdate()
#4 /var/www/html/src/Shared/Infrastructure/Container/CoreServiceProvider.php(57): Lwt\Shared\Infrastructure\Bootstrap\DatabaseBootstrap::bootstrap()
#5 /var/www/html/src/backend/Application.php(190): Lwt\Shared\Infrastructure\Container\CoreServiceProvider->boot()
#6 /var/www/html/src/backend/Application.php(152): Lwt\Application->registerServiceProviders()
#7 /var/www/html/index.php(29): Lwt\Application->bootstrap()
#8 {main}

[HugoFara]

Thanks for signalling the issue. Basically, the database migration system does line splitting manually. Since you are on Windows, lines were converted when you cloned the repository and it broke the line splitting. I have implemented a fix in #242 , it should be enough.