OpenAI response – Both row and possibly row_number are SQL reserved keywords (especially in MariaDB) and must be escaped with backticks (row).
Since the query is being generated by Doctrine DBAL, it means one of your entities or metadata definitions is declaring a column as row, but Doctrine isn’t auto-escaping it.
[2025-04-16T03:34:09.783490+00:00] Log.ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'row_number INT DEFAULT NULL, row LONGTEXT DEFAULT NULL COMMENT ‘(DC2Type:json…’ at line 1 in /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72 Stack trace: #0 /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(72): PDO->query() #1 /var/www/atrocore/vendor/doctrine/dbal/src/Connection.php(1035): Doctrine\DBAL\Driver\PDO\Connection->query() #2 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/DBAL/LoggingConnection.php(34): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/Schema/Schema.php(57): Atro\Core\Utils\Database\DBAL\LoggingConnection->executeQuery() #4 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(183): Atro\Core\Utils\Database\Schema\Schema->rebuild() #5 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(156): Atro\Core\DataManager->rebuildDatabase() #6 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(577): Atro\Core\DataManager->rebuild() #7 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(202): Atro\Services\Installer->prepareDataBase() #8 /var/www/atrocore/vendor/atrocore/core/app/Atro/Controllers/Installer.php(130): Atro\Services\Installer->createAdmin() #9 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/ControllerManager.php(185): Atro\Controllers\Installer->actionCreateAdmin() #10 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(273): Atro\Core\ControllerManager->process() #11 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(173): Atro\Core\Application->runInstallerApi() #12 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(83): Atro\Core\Application->runApi() #13 /var/www/atrocore/index.php(12): Atro\Core\Application->run() #14 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'row_number INT DEFAULT NULL, row LONGTEXT DEFAULT NULL COMMENT ‘(DC2Type:json…’ at line 1 in /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:26 Stack trace: #0 /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(77): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /var/www/atrocore/vendor/doctrine/dbal/src/Connection.php(1035): Doctrine\DBAL\Driver\PDO\Connection->query() #2 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/DBAL/LoggingConnection.php(34): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/Schema/Schema.php(57): Atro\Core\Utils\Database\DBAL\LoggingConnection->executeQuery() #4 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(183): Atro\Core\Utils\Database\Schema\Schema->rebuild() #5 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(156): Atro\Core\DataManager->rebuildDatabase() #6 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(577): Atro\Core\DataManager->rebuild() #7 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(202): Atro\Services\Installer->prepareDataBase() #8 /var/www/atrocore/vendor/atrocore/core/app/Atro/Controllers/Installer.php(130): Atro\Services\Installer->createAdmin() #9 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/ControllerManager.php(185): Atro\Controllers\Installer->actionCreateAdmin() #10 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(273): Atro\Core\ControllerManager->process() #11 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(173): Atro\Core\Application->runInstallerApi() #12 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(83): Atro\Core\Application->runApi() #13 /var/www/atrocore/index.php(12): Atro\Core\Application->run() #14 {main} Next Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'row_number INT DEFAULT NULL, row LONGTEXT DEFAULT NULL COMMENT ‘(DC2Type:json…’ at line 1 in /var/www/atrocore/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88 Stack trace: #0 /var/www/atrocore/vendor/doctrine/dbal/src/Connection.php(1768): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/atrocore/vendor/doctrine/dbal/src/Connection.php(1707): Doctrine\DBAL\Connection->handleDriverException() #2 /var/www/atrocore/vendor/doctrine/dbal/src/Connection.php(1040): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/DBAL/LoggingConnection.php(34): Doctrine\DBAL\Connection->executeQuery() #4 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Utils/Database/Schema/Schema.php(57): Atro\Core\Utils\Database\DBAL\LoggingConnection->executeQuery() #5 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(183): Atro\Core\Utils\Database\Schema\Schema->rebuild() #6 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(156): Atro\Core\DataManager->rebuildDatabase() #7 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(577): Atro\Core\DataManager->rebuild() #8 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(202): Atro\Services\Installer->prepareDataBase() #9 /var/www/atrocore/vendor/atrocore/core/app/Atro/Controllers/Installer.php(130): Atro\Services\Installer->createAdmin() #10 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/ControllerManager.php(185): Atro\Controllers\Installer->actionCreateAdmin() #11 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(273): Atro\Core\ControllerManager->process() #12 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(173): Atro\Core\Application->runInstallerApi() #13 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(83): Atro\Core\Application->runApi() #14 /var/www/atrocore/index.php(12): Atro\Core\Application->run() #15 {main}
[2025-04-16T03:34:10.714575+00:00] Log.ERROR: Installer Error: Error while rebuilding database. See log file for details. | #0 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/DataManager.php(156): Atro\Core\DataManager->rebuildDatabase() #1 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(577): Atro\Core\DataManager->rebuild() #2 /var/www/atrocore/vendor/atrocore/core/app/Atro/Services/Installer.php(202): Atro\Services\Installer->prepareDataBase() #3 /var/www/atrocore/vendor/atrocore/core/app/Atro/Controllers/Installer.php(130): Atro\Services\Installer->createAdmin() #4 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/ControllerManager.php(185): Atro\Controllers\Installer->actionCreateAdmin() #5 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(273): Atro\Core\ControllerManager->process() #6 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(173): Atro\Core\Application->runInstallerApi() #7 /var/www/atrocore/vendor/atrocore/core/app/Atro/Core/Application.php(83): Atro\Core\Application->runApi() #8 /var/www/atrocore/index.php(12): Atro\Core\Application->run() #9 {main}