Make all polls private?

[dj83]

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

[Adobe]

This user has been denied support.

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' 

[dj83]

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

[Adobe]

This user has been denied support.

Ehh I'm bad at SQL queries. I would recommend someone else to help you out, hopefully someone else sees this.

[pandaa]

The table is mybb_polls, I believe.

[dj83]

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'