#478 - Error during Traq Setup at Step 3: Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064
Type Task
Status Closed
Milestone 3.8
Version 3.4.3
Component -
Priority Normal
Severity Normal
Owner Michelle
Assigned to -
Reported 2 months ago
Updated 1 month ago
Votes 0
Related tickets
Proposed time
Worked time

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.

Ticket History

maleficent84 created as New 2 months and 3 weeks ago

2 months and 3 weeks ago by Michelle

Remove this ticket as this should have been listed as a Defect and not as a Task!

Jack closed as Invalid 1 month and 2 weeks ago

1 month and 1 week ago by Jack

  • Status Invalid Closed