[Vaira]

Ah OK, that sounds reasonable. (It's not getting the relation from the post table)
So simply:

UPDATE dbtech_thanks_entry SET userid='xxx' WHERE username='Old Name';
UPDATE dbtech_thanks_entry SET receiveduserid='xxx' WHERE username='Old Name';

(xxx userID of new user) would work?


...sorry for the questions I am not familiar with db-tech table structure and what happens when the user has been deleted.
So userid and receiveduserid both have to get the same new ID there???
What is actually different of both, I'd think receiveduserid are those from who have thanked and should be untouched....

Thanks for your efforts answering my questions.