How to clear down poll import

[optrex]

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]

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:

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.

 

[Paul B]

I am anticipating the next question, so I'll post the answer here now in advance...

http://xenforo.com/community/threads/how-to-add-a-poll-to-an-existing-thread.14303/

 

[optrex]

sweet, thanks guys