Hello I have this error on install: Server Error Mysqli statement execute error : Prepared statement needs to be re-prepared Zend_Db_Statement_Mysqli->_execute() in */library/Zend/Db/Statement.php at line 317 Zend_Db_Statement->execute() in */library/Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in */library/XenForo/Install/Model/Install.php at line 187 XenForo_Install_Model_Install->insertDefaultData() in */library/XenForo/Install/Controller/Install.php at line 197 XenForo_Install_Controller_Install->actionStep2() in */library/XenForo/FrontController.php at line 310 XenForo_FrontController->dispatch() in */library/XenForo/FrontController.php at line 132 XenForo_FrontController->run() in */install/index.php at line 17 ------ Requirements Met Your server meets all of XenForo's PHP requirements. ------ mysql version: 5.1.56
I'm not sure what else I can suggest. We can't offer support for your MySQL server here, but whenever I've encountered the 'prepared statement needs to be re-prepared' error in the past, a restart of the mysqld process has resolved the problem.
Do you have a VPS, Dedicated or are you using a reseller? just so we know what perms you have on that server.
I did some searching and found some information. It is suggested that you try to increase the value of table_definition_cache in your MySQL configuration: http://bugs.mysql.com/bug.php?id=42041 It is also suggested that you try upgrading the client library in PHP: http://dev.mysql.com/doc/refman/5.1/en/statement-repreparation.html
I'm not exactly sure what to do about this to fix it. I'm on a VPS currently and cannot restart the MySQL server.
My post above has some possible fixes. A VPS server should come with root access which would allow you to restart the server. This is a server problem. If you aren't adept with configuring your server then you should ask your host or server person to look into this error.
We approach database access completely differently -- using prepared statements for one. This seems like it might be MySQL or PHP-MySQL integration specific. We can only recommend trying different versions of MySQL and/or PHP.
