• Welcome to XF2 Addons. All the XF2 addons located in the Resources area are available for download once you upgrade your account to Premium membership. In addition, Premium members will get technical support. Premium membership costs only $35.00 USD a year. Once the year has expired you can continue to use the installed addons on your forum as long as you like.

Most likes 1.8 XF 2.1 beta 5


Active Member
Server error log
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:217
Stack trace
        UPDATE xf_user SET
            andy_most_likes_count = ?
            WHERE andy_most_likes_count > ?

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Andy/MostLikes/XF/Cron/MostLikes.php(29): XF\Db\AbstractAdapter->query('
        UPDATE xf_us...', Array)
#4 [internal function]: Andy\MostLikes\XF\Cron\MostLikes::runMostLikes(Object(XF\Entity\CronEntry))
#5 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#6 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#7 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#8 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#9 job.php(42): XF\Job\Manager->runQueue(false, 8)
#10 {main}


Hi Robru,

I assume this server error log only occurred once and you're not able to reproduce, is this correct?


I have not heard anyone else having this issue, so I would suspect your server getting too load is likely the issue. Are you on a VPS?