• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Not a bug  Problem with mysqli

#1
We've already have mysqli-extenstion with php. But got this problem:

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 292
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 468
3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 706
4. Zend_Db_Adapter_Abstract->fetchAll() in XenForo/Importer/vBulletin.php at line 443
5. XenForo_Importer_vBulletin->stepUsers() in XenForo/Importer/Abstract.php at line 77
6. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 161
7. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 213
8. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 156
9. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 303
10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
11. XenForo_FrontController->run() in /home/4gamers/data/www/4gamers.ru/newforum/admin.php at line 13

Could you help us? Thanx
 

Mike

XenForo developer
Staff member
#7
That's still not including the actual error message. It's the part below "server error" and above the numbered lines. Alternatively, you can look at the "server error logs" in the admin CP and that should have details.
 
#8
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Prepared statement needs to be re-prepared - library/Zend/Db/Statement/Mysqli.php:214
Generated By: KAP, Today at 12:05 PM
Stack Trace

#0 /home/4gamers/data/www/4gamers.ru/newforum/library/Zend/Db/Statement.php(292): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/4gamers/data/www/4gamers.ru/newforum/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/4gamers/data/www/4gamers.ru/newforum/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Abstract->query('?????SELECT use...', Array)
#3 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/Importer/vBulletin.php(443): Zend_Db_Adapter_Abstract->fetchAll('?????SELECT use...')
#4 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/Importer/Abstract.php(77): XenForo_Importer_vBulletin->stepUsers(0, Array)
#5 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/ControllerAdmin/Import.php(161): XenForo_Importer_Abstract->runStep(Object(XenForo_ControllerAdmin_Import), Object(XenForo_ImportSession), 'users', 0, Array)
#6 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/ControllerAdmin/Import.php(213): XenForo_ControllerAdmin_Import->_runStep(Object(XenForo_Importer_vBulletin), Object(XenForo_ImportSession), 'users', 0, Array)
#7 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/ControllerAdmin/Import.php(156): XenForo_ControllerAdmin_Import->_startStep(Object(XenForo_Importer_vBulletin), Object(XenForo_ImportSession), 'users', Array)
#8 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/FrontController.php(303): XenForo_ControllerAdmin_Import->actionStartStep()
#9 /home/4gamers/data/www/4gamers.ru/newforum/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/4gamers/data/www/4gamers.ru/newforum/admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
["url"] => string(54) "http://newforum.4gamers.ru/admin.php?import/start-step"
["_GET"] => array(1) {
["import/start-step"] => string(0) ""
}
["_POST"] => array(3) {
["options"] => array(1) {
["_dummy"] => string(1) "1"
}
["step"] => string(5) "users"
["_xfToken"] => string(53) "1,1291194310,c038197f688f644b6d045c97ee41416f016bd0d8"
}
}
Hope this help
 

Brandon Sheley

Well-known member
#11
Unfortunately, this is a server error or a MySQL bug; there is nothing that we can do to prevent it (well, except not using prepared statements). (The MySQL issue is discussed here: http://dev.mysql.com/doc/refman/5.1/en/statement-repreparation.html )
I'm getting a similar "error" on both my sites.
Is this just a hosting issue, surely there has to be something we can do, I don't think we should consistently see reports in our error log?
 

Micheal

Well-known member
#12
i got onto my host and they found this

I noticed that InnoDB was disabled in your /etc/my.cnf.
I've enabled that since your site may need it and restarted MySQL.
and so far its all working.