#479 - Comments not stripped from install SQL
Type Defect
Status Fixed
Milestone 3.8
Version 3.4.3
Component -
Priority Normal
Severity Normal
Owner Michelle
Assigned to -
Reported 5 months ago
Updated 3 months ago
Votes 0
Related tickets
Proposed time
Worked time

I am attempting to setup Traq on my Windows computer as I am trying to do some testing. I am running the following versions:

  • Windows 10 (x64)
  • MariaDB v11.4
  • PHP v8.3.8 (Trace Safe version for Windows x64)
  • Traq v3.7.3

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)

Ticket History

maleficent84 created as New 5 months ago

3 months and 3 weeks ago by Jack

  • Status New Accepted

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.

Jack closed as Fixed 3 months and 2 weeks ago