Duplicate XF\Db\InvalidQueryException: MySQL statement prepare error [1064]

[mcatze]

Affected version

XF2.3 Beta 5

I tried a fresh installation of XenForo 2.3 Beta 5 on a LAMP with MariaDB 10.11.7 and got this error..

XF\Db\InvalidQueryException: MySQL statement prepare error [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 '' at line 15 in src/XF/Db/AbstractStatement.php at line 230

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 40
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Install/Helper.php at line 352
XF\Install\Helper->insertDefaultData() in src/XF/Install/Controller/Install.php at line 179
XF\Install\Controller\Install->actionStep2() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2592
XF\App->run() in src/XF.php at line 532
XF::runApp() in install/index.php at line 14

 

[Abraham54]

I got the same error just now!

 

[mcatze]

It's this one from Beta 4. The solution is working..

Fixed Thread '2.3.0 Beta 5 Install Bug'

Apr 12, 2024

I get this error when trying to install XF 2.3.0 Beta 4 as a fresh install, at Step 2...

XF\Db\InvalidQueryException: MySQL statement prepare error [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 '' at line 15 in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 40...

• Daveo16
• Replies: 11
• Forum: Resolved bug reports

• 

 

[Abraham54]

I replaced ChrisD's code an now a get a smaller error:

ParseError: syntax error, unexpected string content "", expecting "-" or identifier or variable or number in src/XF/Install/Data/MySql.php at line 3408

    Composer\Autoload\{closure}() in src/vendor/composer/ClassLoader.php at line 427
    Composer\Autoload\ClassLoader->loadClass() in src/XF/Install/Helper.php at line 315
    XF\Install\Helper->createApplicationTables() in src/XF/Install/Controller/Install.php at line 176
    XF\Install\Controller\Install->actionStep2() in src/XF/Mvc/Dispatcher.php at line 352
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2592
    XF\App->run() in src/XF.php at line 532
    XF::runApp() in install/index.php at line 14

 

[mcatze]

You just have to delete the , at the end of the line.

 

[Abraham54]

You just have to delete the , at the end of the line.

I did it and got the mentioned smaller error.

 

[Simon2]

You just have to delete the , at the end of the line.

Thanks for pointing this out (worked for me). I saw another thread where @Chris D recommended this for Beta 4.

 

[mcatze]

Thanks for pointing this out (worked for me). I saw another thread where @Chris D recommended this for Beta 4.

This is marked as fixed in Beta 5, but I don't think so.