1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to clear down poll import

Discussion in 'XenForo Questions and Support' started by optrex, Dec 14, 2011.

  1. optrex

    optrex Active Member

    I did a poll import as part of a conversion from IPB 3.2 to XF1.1.

    The converted site has been running a few days and we've discovered all the poll information is wrong. Who voted for what is totally out, and poll results do not match what was previously recorded.

    What I would like to do is remove any existence of current polls, so that we can start again. I am assuming this will be a mysql query to empty the tables.

    Could anyone specify the exact details of what needs to be done please?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Does IPB allow guests to vote on polls? I know with my vBulletin import I found that guest votes were not imported. This is the normal behavior because XenForo doesn't allow guests to vote. For reference:

    http://xenforo.com/community/threads/import-polls-guest-votes-arent-imported.14129/

    Run these queries to delete all polls:

    Code:
    TRUNCATE TABLE xf_poll;
    
    TRUNCATE TABLE xf_poll_response;
    
    TRUNCATE TABLE xf_poll_vote;
    
    UPDATE xf_thread
    SET discussion_type = ''
    WHERE discussion_type = 'poll';
    
    I tested these queries myself, but backup first to be safe.
     
    optrex likes this.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    optrex likes this.
  4. optrex

    optrex Active Member

    sweet, thanks guys :)
     

Share This Page