MyBB Community Forums
SQL Query for clearing polls - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: SQL Query for clearing polls (/thread-92681.html)



SQL Query for clearing polls - Gtman - 2011-04-20

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.



RE: SQL Query for clearing polls - Yaldaram - 2011-04-20

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


RE: SQL Query for clearing polls - Gtman - 2011-04-20

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.