Then run this query to recalculate the like_count for all users (big query, might take some time):
Code:
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
);
This will correct the user like counts, but it won't correct the like counts in the posts themselves.