The Arcive of vBulletin Modifications Site.

Poll question · **Released**: 05-02-2003

Can anyone please tell me what query I need to run to rest the active Polls in a forum? Right now I have a forum with 4 polls in it (and only polls) and it says there are 6 threads in that forum. In the Admin CP the last poll is set at number 6. Apparently there are 2 polls that were created and either backed out of or deleted and it have not taken those polls off of the poll count. I tried running update threads and update forums in the Admin CP but it still shows the count at 6.

Xenon · #2 05-02-2003, 08:08 AM

try to go into the mod cp and moderate posts, maybe you find the missing threads there not validated

Boofo · #3 05-02-2003, 09:37 AM

That was it, thank you. But what would cause them to show up as unvalidated when I don't have that enabled? Also, I got this error on one of the messages to validate in there.

Database error in vBulletin Mod Control Panel 2.2.9:

Invalid SQL: UPDATE thread set lastpost = '1051874818 WHERE threadid='276'
mysql error: You have an error in your SQL syntax near '276'' at line 1

mysql error number: 1064

Date: Friday 02nd of May 2003 04:26:58 AM
Script: http://www.bearfacts2.com/forum/forum/mod/moderate.php
Referer: http://www.bearfacts2.com/forum/mod/...ction=posts&s=

What do I need to do to fix it?

Xenon · #4 05-02-2003, 09:41 AM

there is a missing ' at the end:

lastpost = '1051874818

you should upgrade to vb230

threads are not validated when you start a new poll but haven't finished the poll itself

Boofo · #5 05-02-2003, 10:07 AM

Thank you, sir. It was missing the apostrophe at the end of time() like you said. A mistake in a hack.

No thanks on upgrading to 2.3.0. I did all (or most of them, anyway) of the fixes from 2.2.9 to 2.3.0 so there is no real need to upgrade as far as I can see. Too much hassle with all of the hacks I have installed.