Fixed  User likes counter shows wrong value

Pepelac

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:
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
And one more thing. It is possible to remove likes two times. Firstly, XF removes likes when you 'softly' delete content by removing it from the public view. Secondly, XF removes likes for the same content when you delete it permanently.
 

Attachments

Pepelac said:
And one more thing. It is possible to remove likes two times. Firstly, XF removes likes when you 'softly' delete content by removing it from the public view. Secondly, XF removes likes for the same content when you delete it permanently.
Click to expand...

This issue is now fixed. I suspect it is related to your inconsistent user like counters.
 
Kier said:
This issue is now fixed. I suspect it is related to your inconsistent user like counters.
Click to expand...
Thank you.

Can I expect some kind of "rebuild script" which will be possible to run from rebuild cache page in ACP and which will rebuild like counters?
 
Pepelac said:
Thank you.

Can I expect some kind of "rebuild script" which will be possible to run from rebuild cache page in ACP and which will rebuild like counters?
Click to expand...
There won't be one for 1.0.1, but we could look at doing one a little further down the road.
 
I had to do this for both post count and like count...I wrote queries before I bought this PC, so I had them saved on the old one.

It happened again today, so it is a recurring bug.
 
Top Bottom