Question Remove Dislikes

Status
Not open for further replies.

weave

New member
I had a user that was set to Global Ignore. He then proceeded to click "dislike" on pretty much every thread until he got tired or bored. He is now banned but left a mess in his wake.

Is there a way to undo all of the dislikes short of removing all the records from the database? Also, is there any risk to removing the records from the database?
 
You'll need to run a query to remove all dislikes from the DB. Something like
Code:
delete from dbtech_thanks_entry where varname = 'dislikes' and userid = 'x'
where x is his user ID. Remember to add your table prefix if you use one. Afterwards, run all the APTL maintenance actions to rebuild your statistics.
 
If you run the maintenance actions as per my previous post, the entry cache will be rebuilt and it will no longer show up there :)
 
I see the same "dislikes" under "dbtech_thanks_recententry" for the same user.

Simulate Query shows same as first query you gave me.
SQL query:
delete from dbtech_thanks_recententry where varname = 'dislikes' and userid = 'x'
Matched rows: 95

Run this too?
 
I'm a little bit confused here... The maintenance actions I've asked you to run in my previous two replies will rebuild the Recent Entry table, as well as rebuild the statistics so that all the Dislikes from that user will not count towards your other members' "Dislikes Received" statistic.

It's very important that you do this, as direct database deletions will not rebuild these statistics.

If you are having difficulties locating the section, it's under DBTech - Post Thanks -> Maintenance, and the actions I want you to run are Recalculate, Rebuild Statistics and Rebuild Button Click Cache.

If you have already ran these maintenance actions and you're still seeing their dislikes in the recententry table, then that's an entirely different issue, but I need you to confirm for me whether you have ran those maintenance actions as requested.
 
You need to update the user table as well
UPDATE `user` SET `dbtech_thanks_dislikes`='0' WHERE (`userid`='x')
replace x with user id
 
I'm a little bit confused here... The maintenance actions I've asked you to run in my previous two replies will rebuild the Recent Entry table, as well as rebuild the statistics so that all the Dislikes from that user will not count towards your other members' "Dislikes Received" statistic.

It's very important that you do this, as direct database deletions will not rebuild these statistics.

If you are having difficulties locating the section, it's under DBTech - Post Thanks -> Maintenance, and the actions I want you to run are Recalculate, Rebuild Statistics and Rebuild Button Click Cache.

If you have already ran these maintenance actions and you're still seeing their dislikes in the recententry table, then that's an entirely different issue, but I need you to confirm for me whether you have ran those maintenance actions as requested.

I have run the query you suggested and EVERY single task/action in the Maintenance section; several times
 
I have run the query you suggested and EVERY single task/action in the Maintenance section; several times

Just to be clear....I have clicked every button in the below image at least 1o times, in order. The dislikes for the removed user are still in the forum.

Screen Shot 2015-02-11 at 7.53.05 AM.png
 
Can you please PM me with an FTP and AdminCP account, as well as a link to a post affected by this issue?
 
Just to be clear....I have clicked every button in the below image at least 1o times, in order. The dislikes for the removed user are still in the forum.

View attachment 6340
Just a quick follow-up to let you know I'm still waiting for the FTP / AdminCP information as requested in my previous post :)
 
Just a quick follow-up to let you know I'm still waiting for the FTP / AdminCP information as requested in my previous post :)

Have not forgotten. Just got really busy with work and then got sick. I will get you the information in the next few days.
 
Status
Not open for further replies.

Legacy Advanced Post Thanks / Like

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
4,024
Customer rating
5.00 star(s) 1 ratings
Back
Top