markku
Well-known member
@Xon I'm getting this error when upgrading from Multi Prefix 1.5.5 to 1.7.5:
Code:Server Error Mysqli prepare error: 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 2 Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115 Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381 Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478 Zend_Db_Adapter_Abstract->query() in SV/MultiPrefix/Installer.php at line 99 SV_MultiPrefix_Installer::install() in XenForo/Model/AddOn.php at line 214 XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169 XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237 XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in /home/public/admin.php at line 13
I tried restarting php-fpm and nginx, not helping.
Here's the entry from server error log when trying to do the above upgrade:
Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: 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 2 - library/Zend/Db/Statement/Mysqli.php:77
Stack Trace
#0 /home/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n ...')
#1 /home/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n ...')
#2 /home/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n ...')
#3 /home/public/library/SV/MultiPrefix/Installer.php(99): Zend_Db_Adapter_Abstract->query('\n ...', Array)
#4 /home/public/library/XenForo/Model/AddOn.php(214): SV_MultiPrefix_Installer::install(Array, Array, Object(SimpleXMLElement))
#5 /home/public/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), 'XMMultiPrefix')
#6 /home/public/library/XenForo/ControllerAdmin/AddOn.php(237): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpmd7qQK', 'XMMultiPrefix')
#7 /home/public/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_AddOn->actionUpgrade()
#8 /home/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/public/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(68) "https://ourdomain.com/admin.php?add-ons/XMMultiPrefix/upgrade"
["_GET"] => array(1) {
["add-ons/XMMultiPrefix/upgrade"] => string(0) ""
}
["_POST"] => array(3) {
["server_file"] => string(0) ""
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}