• 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

optrex

Active member
#1
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?
 

Jake Bunce

XenForo moderator
Staff member
#2
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.