vb.org Archive - Removing thread ratings?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Removing thread ratings? (https://vborg.vbsupport.ru/showthread.php?t=259342)

shibby2

02-23-2011 08:44 PM

Removing thread ratings?

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 [DATE]1298502122[/DATE] at [TIME]1298502122[/TIME] ---------------

Actually, I found this thread regarding it..

https://vborg.vbsupport.ru/showthrea...=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	02-23-2011 09:06 PM

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

02-23-2011 09:09 PM

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

kh99	02-23-2011 09:18 PM

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

Code:

//        ****** 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

02-23-2011 11:04 PM

I'm not quite understanding this..

This is the query they say to run:

Code:

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	02-24-2011 12:03 AM

I guess then it would be

Code:

UPDATE raptorrethread

SET

    votenum = 0,

    votetotal = 0

shibby2

02-24-2011 12:32 AM

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

All times are GMT. The time now is 03:53 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01122 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: