Having issues deleting all likes

Note that this doesn’t delete likes from topics.

I had to run update topics set like_count = 0 where like_count > 0 on top of the post rake to fully remove them.

1 Like

Nevermind - likes are still present on profiles too! No idea how to remove them because they don’t exist on any topics or posts now

1 Like

You may need to give it 24-48 hours for all the cached counts to update.

2 Likes

It’s been ~9 days since I ran the last update command

Can you post screenshots of your problem?

3 Likes

Of course :slight_smile:

Here is my /summary page as an example:

Here is the /u?period=all page:

Thank you guys!

1 Like

all rows set to 0 for:

top_topics table:

yearly_op_likes_count
yearly_likes_count
quarterly_op_likes_count
quarterly_likes_count
monthly_op_likes_count
monthly_likes_count
weekly_op_likes_count
weekly_likes_count
daily_op_likes_count
daily_likes_count

directory_items table:

likes_received
likes_given

user_stats table:

likes_received
likes_given

Also deleted all rows in given_daily_likes.



Didn’t seem to make any difference :cold_sweat:

Apologies for the bump, if anyone has any ideas at all please let me know