[Vaira]

Thanks for your reply, but it's not that easy since the original userid no. vanished at dbtech_thanks_entry table after deletion of the user, you have programmed it that way???? ... .
Finally I had the chance to run several SQL SELECT queries myself to get an idea of your table.

To directly update (replace) the ID works only at receiveduserid column.
At the SQL UPDATE query the userid received 0 rows. (I am sure the user thanked, though)...I had tried that query already.
The original userid must have been lost already, the question is when and how...

What happens when a user has been deleted (and dbtech maintenance has been run afterwards), does it delete the db entryid? Does it change the userid? Fact is the old userid is not there anymore! Your first query is actually useless.
I also had a look at the db backup I've made right before I ran those queries and before I ran any maintenance, it seems the userid has been removed already there...

Vbulletin's post table gets userid = 0 guest BUT still has reference to the username. Also abe's table has the username column.

My original thoughts are realized at abe's mod. He does not use receiveduserid, the relation is gotten through the post table.

Any other way to get back the thanks given?
Thanks again.