+- 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.