Removing individual thread ratings - tried deleting row from threadrate table

[addamroy]

So I have this one user who slapped a 1 star rating on a paid thread from another member (past grudge I guess?). So his thread in the list shows a 1 star rating which isn't fair and I want to remove it.

I went into the database and removed the row from the threadrate table associated with this thread, however the thread rating remains at a 1 star rating on the thread list page.

I added the row back into the table since it didn't work. I'll remove it again if I have to just not sure how to do this.

This is the only rating on this thread so shouldn't the rating for that thread have gone away all together? Do I need to edit something else in the database somewhere to get rid of this rating?

[mokujin]

There are also 2 columns in table thread, votenum and votetotal
You should update these columns by -1 for each.

Hope it helps you

[addamroy]

That did the trick my friend thanks!