I am attempting to setup Traq on my Windows computer as I am trying to do some testing. I am running the following versions:
After opening up http://localhost/install.php, I am able to complete Steps 1-2 of the Traq install but when I get to Step 3, it gives me this 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 posted a thread about this on StackOverflow as I was unsure about what I needed to do to resolve this. A poster responded back saying that this seems to be a known bug in v3.7.3 where they forgot to strip out the SQL comments in install/index.ph. He said that you can see it's fixed in the main branch. He also said that I should urge them to create a new release.
He provided a link to show where it was fixed in the main branch. (https://github.com/nirix/traq/blob/main/install/index.php#L145)
Have you tried to use the
main
branch from GitHub?I ran into no issues on the main branch and will be releasing Traq v3.8 shortly.