XF 1.2 Deleted User liking a post

dabollicks

Active member
Ive had a post liked by a deleted user. The board has always been XF, so not an import, and I only have 2 deleted users that immediately spring to mind, but these were deleted a long time ago, so im a bit puzzled as to why or how this happened

Any ideas?

Screenshot attached

photo.PNG
 

Mike

XenForo developer
Staff member
To be sure, we'd need to see the ID of the user attached to that particular like (in the xf_liked_content table). It could be something like merging users (though likes should be brought across if possible).
 

dabollicks

Active member
Hi Mike

Just been looking through the database and can only find one like for that post, highlighted in the attached image

upload_2013-12-2_17-32-34.png
 

Mike

XenForo developer
Staff member
That's a bit strange then. Not sure off hand what would trigger that. If you like and then un-like that post, does it remove the name?
 

Mike

XenForo developer
Staff member
How did you identify that there was just one like? If you just browsed the table directly, you may have missed the other one as they won't necessarily be in order. You likely need to search by the post ID.

There is a unique constraint in place in MySQL that physically prevents the same post twice; the double news feed could be from a like/unlike.

If you did the like/unlike, that would rebuild the like cache which is reading the data fresh from the DB.
 

dabollicks

Active member
I searched by post ID and only found that one entry. I'll have another look in the morning to double check
 

dabollicks

Active member
Had another look at the database and can only find that one entry for the post in question. I've liked and unliked the post several times now but still can't get rid of the deleted user like
 

Mike

XenForo developer
Staff member
I'd have to see what the query is returning. Could you submit a support ticket with FTP and admin CP access details?
 
Top