Query to delete all thread ratings

[Nick]

A forum I just began working on was completely junked up by spammers. For some reason they rate every single thread they come across, so many of the threads on the forum have non-genuine ratings.

What query can I run to completely erase all thread ratings?

Thanks

[Lats]

Try this...

TRUNCATE TABLE threadrate

[Nick]

Try this...

TRUNCATE TABLE threadrate

Hmm... that didn't work.

Although, after I ran that query, I can no longer browse the threadrate table. Perhaps it did get emptied, but the thread ratings still appear on my forum.

[Lats]

After running manual queries on the database, you will need to update forum counters - in this case Rebuild Thread Information.

[Nick]

After running manual queries on the database, you will need to update forum counters - in this case Rebuild Thread Information.

Whoops; doh.

Thanks