Prune all likes (queries)

Prune all likes (queries)

Before you perform any action with the database, don't forget to backup!

Queries are executed sequentially:

PHP:

DELETE FROM xf_liked_content;

UPDATE xf_user AS u

SET like_count = (SELECT COUNT(*)FROM xf_liked_content AS lc

WHERE lc.content_user_id = u.user_id

GROUP BY lc.content_user_id);

PHP:

UPDATE xf_post SET likes = 0, like_users = 0x613a303a7b7d;

Source: Team Skull
Prune all likes (queries)

Read
more @ www.teamskull.com