MyBB Community Forums

Full Version: Make all polls private?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

Is there anyway to set all of my polls to private without having to edit each one?

I have over 200 polls on my forum
Before doing so, please backup your tables.

Run the query below in phpmyadmin>Your DATABASE>SQL

UPDATE `mybb_poll` SET `public` = '1' WHERE `public` = '0' 
Hello,

Thanks for your reply but I keep getting this message when I go to phpmyadmin and try to run it:

#1146 - Table 'forum1_forum.mybb_poll' doesn't exist
Ehh I'm bad at SQL queries. I would recommend someone else to help you out, hopefully someone else sees this.
The table is mybb_polls, I believe.
thanks so much to the both of you!

This is what worked if anyone else needs to do this:
UPDATE mybb_polls SET public = '0' WHERE public = '1'