Pepelac
Well-known member
It's a bit strange, but there seems to be some kind of bug in the likes counter.
I've started to search for bug after one user's message, where he has written, that he has wrong count of likes in his counter and on the Latest Alerts page.
So, I've written a SQL query, which compare likes counter from the xf_user table with records from the xf_liked_content table.
Results of this query you can find in attached archive (for 3 forums).
Query, which I've used:
Fields description:
I've started to search for bug after one user's message, where he has written, that he has wrong count of likes in his counter and on the Latest Alerts page.
So, I've written a SQL query, which compare likes counter from the xf_user table with records from the xf_liked_content table.
Results of this query you can find in attached archive (for 3 forums).
Query, which I've used:
Code:
SELECT
u.user_id,
u.like_count AS user_like_count,
COUNT(l.like_id) AS content_like_count,
SUM(IF(l.content_type = 'post', 1, 0)) AS post_like_count_total,
SUM(IF(l.content_type = 'post', IF(p.message_state='visible', 1, 0), 0)) AS post_like_count_visible,
SUM(IF(l.content_type = 'post', IF(p.message_state='moderated', 1, 0), 0)) AS post_like_count_moderated,
SUM(IF(l.content_type = 'post', IF(p.message_state='deleted', 1, 0), 0)) AS post_like_count_deleted,
SUM(IF(l.content_type = 'profile_post', 1, 0)) AS profile_post_like_count_total,
SUM(IF(l.content_type = 'profile_post', IF(pp.message_state='visible', 1, 0), 0)) AS profile_post_like_count_visible,
SUM(IF(l.content_type = 'profile_post', IF(pp.message_state='moderated', 1, 0), 0)) AS profile_post_like_count_moderated,
SUM(IF(l.content_type = 'profile_post', IF(pp.message_state='deleted', 1, 0), 0)) AS profile_post_like_count_deleted
FROM
xf_liked_content AS l
LEFT JOIN xf_user AS u ON u.user_id = l.content_user_id
LEFT JOIN xf_post AS p ON p.post_id = l.content_id
LEFT JOIN xf_profile_post AS pp ON pp.profile_post_id = l.content_id
GROUP BY l.content_user_id
HAVING content_like_count <> user_like_count
Fields description:
- user_id - user's ID
- user_like_count - likes counter from the table xf_user
- content_like_count - total likes count for user from the table xf_liked_content
- post_like_count_total - total likes count for posts
- post_like_count_visible - likes count for visible posts
- post_like_count_moderated - likes count for moderated posts
- post_like_count_deleted - likes count for deleted posts
- profile_post_like_count_total - total likes count for profile posts
- profile_post_like_count_visible- likes count for visible profile posts
- profile_post_like_count_moderated - likes count for moderated profile posts
- profile_post_like_count_deleted - likes count for deleted profile posts