• 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.

Error from most likes addon


Mike Edge

Member
Hi Andy,

I am receiving the following error in logs since installing most likes.

Code:
[LIST]
[*]XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xenforo.xf_liked_content' doesn't exist
[*]src/XF/Db/AbstractStatement.php:217
[*]Generated by: Unknown account
[*]Dec 26, 2018 at 3:02 AM
[/LIST]
[SIZE=5][B]Stack trace[/B][/SIZE]
        SELECT xf_liked_content.content_user_id,
        COUNT(*) AS mostLikesCount
        FROM xf_liked_content
        INNER JOIN xf_user ON xf_user.user_id = xf_liked_content.content_user_id
        WHERE xf_liked_content.like_date >= ?
        AND xf_liked_content.content_type = ?
        AND xf_user.is_banned != 1
        GROUP BY xf_liked_content.content_user_id
        ORDER BY mostLikesCount DESC
        LIMIT ?    
       
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(89): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(106): XF\Db\AbstractAdapter->query('
        SELECT xf_li...', Array)
#5 src/addons/Andy/MostLikes/XF/Cron/MostLikes.php(43): XF\Db\AbstractAdapter->fetchAll('
        SELECT xf_li...', Array)
#6 [internal function]: Andy\MostLikes\XF\Cron\MostLikes::runMostLikes(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#9 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#10 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#11 job.php(42): XF\Job\Manager->runQueue(false, 8)
#12 {main}
 

Andy

Administrator
Hi Mike,

I have made the update. Most likes v1.8 will now work properly on XF v2.0 and v2.1.

It would be great if you could give it a quick test before I publish it.

Thank you.
 

Attachments

Top