How to clear down poll import


Well-known 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?

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:

Run these queries to delete all polls:


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.