Question How to remove Likes from deleted users?

[lomik]

Just imported the Likes from vbseo, now I have a few "dead" likes who should get removed from under the posts.

sample:
abcd, efgh, 1234, N/A, blah liked this post

Username link to their profiles, N/A links to the mainpage, as this users are gone.

Do I have to do this manually in the database?

Thank You

 

[Fillip H.]

You would need to do this in the database, something like

SELECT entry.* FROM vb_dbtech_thanks_entry AS entry LEFT JOIN vb_user AS user USING(userid) WHERE user.userid IS NULL

Replace vb_ with your own table prefix.

 

[DragonByte Technologies]

Hello lomik,

This ticket has now been closed with the status Answered.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!