MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL Query for clearing polls
Full Version: SQL Query for clearing polls
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Gtman

2011-04-20, 10:36 PM
After pruning all polls I still see that the polls are visible without any content on threads.

So how would I run a query that completely prunes a forum of all polls.

Yaldaram

2011-04-20, 10:43 PM
Go to: ACP > Tools and Maintenance > Recount and Rebuild > and run the following options;
Recount Statistics
Rebuild Forum Counters
Rebuild Thread Counters
Recount User Post Counts

Gtman

2011-04-20, 10:51 PM
No thank you.
It had nothing to do with a recount but a glitch that had empty polls (No options) on threads.

UPDATE mybb_threads SET poll = '0'

Solved it.
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > SQL Query for clearing polls