Luke F
Well-known member
I had to add a LIMIT to get that second statement to run, but I eventually got all the ids added. Unfortunately, when I ran the recount in the admin panel, it seemed to work at first, but after a few minutes gave me this error:
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/forum/public_html/library/Zend/Db/Statement/Mysqli.php on line 77
I did take a backup before running it, but if I have to restore and do it over again how do I prevent this from happening again?
- Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
- Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
- Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
- Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
- XenForo_Model->fetchAllKeyed() in XenForo/Model/RoutePrefix.php at line 41
- XenForo_Model_RoutePrefix->getPrefixesByRouteType() in XenForo/Model/RoutePrefix.php at line 54
- XenForo_Model_RoutePrefix->getPrefixesForRouteCache() in XenForo/Link.php at line 487
- XenForo_Link::_loadHandlerInfoForGroup() in XenForo/Link.php at line 404
- XenForo_Link::_getPrefixHandler() in XenForo/Link.php at line 370
- XenForo_Link::_buildLink() in XenForo/Link.php at line 97
- XenForo_Link::buildPublicLink() in XenForo/Dependencies/Admin.php at line 197
- XenForo_Dependencies_Admin->getEffectiveContainerParams() in XenForo/FrontController.php at line 635
- XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
- XenForo_FrontController->run() in /home/forum/public_html/admin.php at line 13
(It did seem to partially work; some of my members are now showing some Likes (well, on my forum, Thanks) in their profile totals. It does seem to be only a fraction of the actual number of Thanks they received before the forum change, so I guess it stopped part way through.)
If your server cannot handle recount, you can reduce its speed by dropping the PER_PAGE number at the top of each file in library/Dark/PostRating/Deferred. To begin with I would reduce them to 25% of their current values