I am new to MariaD and PHP and I am trying to setup Traq (the project management/issue ticket tracking system) on my Windows computer as I am trying to do some testing for something. I am currently running the following versions:
Windows 10 x64 MariaDB: v11.4 PHP: v8.3.8 (Trace safe version for Windows x64) Traq v3.7.3
I am able to complete step 1, which asks you to provide the root username/password as well as the database name that I referenced from MariaDB. I was then able to complete step 2 where you set up the admin account username/password and e-mail address. But when I try to get to Step 3, I receive an error message.
Fatal error: Uncaught 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 'version 3 only. # # Traq is distributed in the hope that it will be useful, #...' at line 1 in C:\Apache24\htdocs\vendor\avalon\database\pdo.php:115 Stack trace: #0 C:\Apache24\htdocs\vendor\avalon\database\pdo.php(115): PDO->query(' version 3 only...') #1 C:\Apache24\htdocs\install\index.php(150): avalon\database\PDO->query(' version 3 only...') #2 C:\Apache24\htdocs\install\nanite.php(106): {closure}() #3 C:\Apache24\htdocs\install\nanite.php(77): Nanite::_process_route('/step/3', Object(Closure)) #4 C:\Apache24\htdocs\install\nanite.php(39): Nanite::post('/step/3', Object(Closure)) #5 C:\Apache24\htdocs\install\index.php(123): post('/step/3', Object(Closure)) #6 {main} thrown in C:\Apache24\htdocs\vendor\avalon\database\pdo.php on line 115
I opened up the pdo.php file and when I reference line 115, I see this:
$rows = $this->connection->query($query);
My question is whether or not there is an issue with the syntax on line 115 or am I misreading this? I could really use some help.
Remove this ticket as this should have been listed as a Defect and not as a Task!