I'm hoping someone can help.
A long story short over the past couple of years we allowed under exceptional circumstances accounts to be deleted from our site (not banned) and now we've decided to revert that rule.
The only way to "re-enable" the very few accounts we have that have been deleted was to add a new user and then associate the old "guest" posts to the new accounts
using the following code
that seemed to work fine for the threads/post counts and so on but not the vbseo "like" system as it's empty and posts that the former deleted user liked are showing up as an old username (when we deleted the users we changed the username also before deletion)Code:UPDATE post SET userid='123' WHERE username='Old Username';
I know it's nothing wrong with the vbseo package so I know it's quite cheeky to ask but it would mean a lot if someone could help to try and re-associate the likes to the new user account?
Thank you so much.