[Vaira]

I have a special question which could be interesting for others as well:

One has accidentally deleted a user via adminCP. The user has had ~300 posts, some of them have got thanks.
The posts are still there but assigned as guest (userid = 0, AFAIK) but the original username is still there.

A SQL query: UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts....

...reassigned the posts to the new userID. After recount (vb maintenance) they appeared, also the thanks the others gave below the posts. Posts are search-able as well.

But by executing DBTech maintenance I was not able to assign the thanks the others gave him at his posts to the new userprofile, why? It should, shouldn't it?

I mean the thanks all the other users gave have reference to the posts (otherwise whey would not appear below there) and the posts have reference to the new userID.

Do I need to execute an additional SQL query and if yes what would be the right one?

It would be great to find a solution.
Thanks in advance.