XF 1.5 Mysqli statement execute error

[Satix]

Hi. For a while now, my server error log has been filled with Mysqli statement execute errors. I did a lot of looking into it but couldn't find a solution. Every time, the error is a bit different, but here is the most recent one:

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

Stack Trace
#0 /library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT *\r\n...', 1313)
#3 /library/XenForo/Model/Template.php(605): Zend_Db_Adapter_Abstract->fetchAll('\r\n\t\t\tSELECT *\r\n...', 1313)
#4 /library/XenForo/Model/Template.php(1367): XenForo_Model_Template->getMappedTemplatesByTemplateId(1313)
#5 /library/XenForo/Model/Template.php(1329): XenForo_Model_Template->compileTemplateInStyleTree(Array)
#6 /library/XenForo/Model/Template.php(1268): XenForo_Model_Template->compileNamedTemplateInStyleTree('EWRdiscord_BotP...', 0)
#7 /library/XenForo/Deferred/Template.php(36): XenForo_Model_Template->compileAllTemplates(7.99999785423, 0, 433)
#8 /library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Template->execute(Array, Array, 7.99999785423, 'Rebuilding... T...')
#9 /library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.99999785423, 'Rebuilding... T...', false)
#10 /library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, 'Rebuilding... T...', false)
#11 /library/XenForo/ControllerAdmin/Tools.php(159): XenForo_Model_Deferred->run(true, NULL, 'Rebuilding... T...', false)
#12 /library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_Tools->actionRunDeferred()
#13 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#14 /admin.php(13): XenForo_FrontController->run()
#15 {main}

Request State
array(3) {
  ["url"] => string(50) "https://lakevalor.net/admin.php?tools/run-deferred"
  ["_GET"] => array(1) {
    ["tools/run-deferred"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["redirect"] => string(39) "https://lakevalor.net/admin.php?styles/"
    ["execute"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

These errors are only visible on the admin side, as far as I'm aware, but the URL to my site is https://lakevalor.net

This is my debug setting in config: $config['debug']= false;

We're on a shared host, so our options are a bit limited. Unfortunately, I lack the knowledge and time to set up a droplet via DigitalOcean or similar services, and funds are fairly tight, so that isn't an option right now.

Has anyone else encountered this error and found a fix?

 

[Paul B]

It's a MySQL bug.

There's some discussion related to it here: https://xenforo.com/community/threa...nt-needs-to-be-re-prepared.63797/#post-674450

 

[Satix]

It's a MySQL bug.

There's some discussion related to it here: https://xenforo.com/community/threa...nt-needs-to-be-re-prepared.63797/#post-674450

I read that thread already, but my host won't change those values as it affects other servers. Is there another solution to this?

 

[Paul B]

Not within XF, no.

It's something which must be resolved on the server.

 

[Satix]

Not within XF, no.

It's something which must be resolved on the server.

Okay, thank you. I've just noticed that I posted this in the wrong section - sorry about that! That's what I get for lurking in this forum so much.