Announcement

Collapse
No announcement yet.

How can I move all polls from one forum to another in vBulletin or PhPMyAdmin?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can I move all polls from one forum to another in vBulletin or PhPMyAdmin?

    I currently have a ton of polls in my "General" forum and have created a new "Polls" forum. I thought I would just go into the /Admin and move them, but the options to move posts does not have one for polls.

    So, is there any way to do this? I'm fine with hacking code (a little) or using PhpMyAdmin and some raw SQL.

    I am on the current version of vBulletin.

  • #2
    This query should work. Backup first:

    UPDATE thread SET forumid = X WHERE pollid > 0 AND open != 10

    Where X is the forumid of your Polls forum. After running this query you will need to update your various counters:

    Admin CP -> Import & Maintenance -> Update Counters

    Comment


    • #3
      Will this query still work on 3.8.0? I want to move all Polls into a newly created forum dedicated to polls.

      Thanks

      Comment


      • #4
        Can anybody help with the query, please?

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X