XF 1.5 What is 'Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error '

[SEOmers]

Can someone tell me what this is and how to fix it please? I've noticed the last few days that it's getting more error logs but can't work out what it actually is, or how to fix it?

#0 /home/motovlog/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/motovlog/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/motovlog/public_html/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT ses...', Array)
#3 /home/motovlog/public_html/library/XenForo/Session.php(790): Zend_Db_Adapter_Abstract->fetchOne('\n\t\t\t\tSELECT ses...', Array)
#4 /home/motovlog/public_html/library/XenForo/Session.php(484): XenForo_Session->getSessionFromSource('327181739a971e1...')
#5 /home/motovlog/public_html/library/XenForo/Session.php(468): XenForo_Session->_setup('327181739a971e1...', 'SR\x03\xC9')
#6 /home/motovlog/public_html/library/XenForo/Session.php(324): XenForo_Session->start()
#7 /home/motovlog/public_html/library/XenForo/Session.php(257): XenForo_Session::getPublicSession(Object(Zend_Controller_Request_Http))
#8 /home/motovlog/public_html/library/XenForo/Controller.php(293): XenForo_Session::startPublicSession(Object(Zend_Controller_Request_Http))
#9 /home/motovlog/public_html/library/XenForo/Controller.php(306): XenForo_Controller->_setupSession('Index')
#10 /home/motovlog/public_html/library/XenForo/FrontController.php(350): XenForo_Controller->preDispatch('Index', 'LiveUpdate_Cont...')
#11 /home/motovlog/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/motovlog/public_html/index.php(13): XenForo_FrontController->run()
#13 {main}

​

 

[Paul B]

See this thread: https://xenforo.com/community/threads/error-on-install.17901/

It's a bug with certain versions of MySQL.

 

[Mouth]

Sounds like you need to increase you 'table_definition_cache' for mysql. http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_definition_cache
Mine is set to 8192

 

[SEOmers]

Sounds like you need to increase you 'table_definition_cache' for mysql. http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_definition_cache
Mine is set to 8192

How did you do this with Cpanel? If you did?

 

[Mouth]

If you did?

Sorry, no. Never used it.