Removing thread ratings?

[shibby2]

Hey everyone, a spambot seems to have rated every single thread in my forum with a 5-star rating. Is there a way I can reset or delete all of these ratings? I can't seem to find anything in my Admin panel, but maybe I'm overlooking something. I'm using 3.8.4.

Any help is appreciated! :)

--------------- Added 1298502122 at 1298502122 ---------------

Actually, I found this thread regarding it..

https://vborg.vbsupport.ru/showthread.php?t=187612&highlight=thread+rating

I tried running that query, but I get this message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'myforum_vb.thread' doesn't exist



Any ideas? :(

[kh99]

Do you maybe have a table prefix defined in config.php? (If you look at the tables in your database it should be obvious).

[shibby2]

I guess I do...should I not? I'm kinda dumb when it coms to this stuff.. lmao

[kh99]

I'm a mysql beginner myself. But if you look in includes/config.php, you should find something like this:

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'XXX';

and if you have something between the quotes at the end of that line (in place of XXX), then you'd have to add that to the beginning of the table name in your query (like myforum_vb.XXXtable). But it's possible that you don't have anything where XXX is in which case, never mind. (And of course you don't want to change what it says in config.php).

You could also try leaving out 'myforum_vb.' although I guess if that's the actual name of the database it should work that way. (ETA: the database name is defined just above that table prefix in config.php, in case there's any doubt).

[shibby2]

I'm not quite understanding this..

This is the query they say to run:

UPDATE thread
SET
votenum = 0,
votetotal = 0

This is what it lists the table prefix as in my config file: raptorre

So what exactly should I do?

[kh99]

I guess then it would be

UPDATE raptorrethread
SET
votenum = 0,
votetotal = 0

[shibby2]

Ahh I gotcha...and it worked...thanks so much! :)