gotcha lol

Thanks! Figured it out, had to be done with the main admin account and not supermoderator!

Sure, but why does DBTech maintenance not update the receiveduserid column properly?
VB maintenance did it right assigning the posts to the new userprofile (post count, search index, etc...)

I have assigned all the posts of a deleted user to a new ID, thus the new user(ID) inherits all the posts and all the thanks they have got.

Should your maintenance script not recollect all the posts a user has made and their thanks they have got? The thanks are still there....MEANS belong actually to the new user.

The description:"This will recalculate how many thanks / likes / dislikes a user should have. Best ran after the above Cleanup function has been ran."

It actually does not. Or am I missing something important?:confused:

Well, what happens to the receiveduserid column in the APTL dbtech_thanks_entry table after the user has been deleted via admin CP? Do they remain there (original userID)?

Because you need to do that yourself. This mod has no way of knowing that what used to be receiveduserid X is now receiveduserid Y.

vBulletin does not automatically assume that either, you manually updated the userid column in the post table to change X to Y.

The same has to be done with the userid and receiveduserid column in the APTL table.

After you have done so, then run the maintenance action you listed.


Fillip

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. :)

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. :)

i got an error:

https://vborg.vbsupport.ru/external/2014/02/44.png

i cant give thanks, or anything.


i use vb 4.2.2

After i click like button, message disapperas :D To see the message refresh needs ??

Good thanks, but thanks to click on goes blank and will not be updated with the username of the person who has given thanks, and apart in the field is not updated postbit goes as seen in the picture, I did you mentioned but still the same. It is noteworthy that use PHP 4.2.2 and 5.4.20 vBuetin. I would appreciate your help.