Not a bug Problem with mysqli

[sparhawk]

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]

You didn't include the actual error message.

 

[Mike]

Also, please associate your customer account with your forum account: http://xenforo.com/customers/forum-users

This way you can post in the support forums.

 

[sparhawk]

full error message :

* Tools
* Import External Data

Admin Control Panel - Игровой форум на 4Gamers.ru
Server Error

 

[sparhawk]

The problem detected while importing from VB.
And the mysql version is 5.1.53

 

[sparhawk]

Also, please associate your customer account with your forum account: http://xenforo.com/customers/forum-users

This way you can post in the support forums.

Ok, thanx for advise, already did it. Should I try this post on support forum?

 

[Mike]

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.

 

[sparhawk]

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

 

[sparhawk]

Not sure, but it seems that we found the solution

 

[Mike]

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 )

 

[Brandon Sheley]

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]

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.