I am new to MariaD and PHP and I am trying to setup Traq (the project management/issue ticket tracking system) from traq.io on my Windows computer as I am trying to do some testing. 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:Apache24htdocsvendoravalondatabasepdo.php:115 Stack trace: #0 C:Apache24htdocsvendoravalondatabasepdo.php(115): PDO->query(‘ version 3 only…’) #1 C:Apache24htdocsinstallindex.php(150): avalondatabasePDO->query(‘ version 3 only…’) #2 C:Apache24htdocsinstallnanite.php(106): {closure}() #3 C:Apache24htdocsinstallnanite.php(77): Nanite::_process_route(‘/step/3’, Object(Closure)) #4 C:Apache24htdocsinstallnanite.php(39): Nanite::post(‘/step/3’, Object(Closure)) #5 C:Apache24htdocsinstallindex.php(123): post(‘/step/3’, Object(Closure)) #6 {main} thrown in C:Apache24htdocsvendoravalondatabasepdo.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.
I tried to go through the manual for MariaDB but I don’t even know where I would need to start to find what may help me if it is in there.
Michelle Griffin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.