Tweet
Hi,
I'm currently performing a test import of a larger ubb.threads board and got a db error message while importing the polls:
UPDATE vb3_thread
SET pollid = 30 WHERE importthreadid =
Unfortunately, the current ubb.threads impex code isn't able to import polls with more than one question per poll. This feature is available in ubb.threads since version 6.0.x, if I remember correctly.
Your current implementation grabs all questions from the PollQuestions table and inserts them as a new poll into vbulletin. That's necessary because vbulletin can only handle one question per poll.
Doing that for the second, third etc. question of a poll will result in the error above, as this questions isn't associated with a thread.
What would be the best way to handle this?
- Only import the first question as a new poll if a poll has multiple questions in ubb.threads -> Would probably be the easiest one and could be done with a simple DISTINCT while grabbing the questions.
- create a new thread for all questions of poll > 1.
- Just skip polls with multiple questions and don't import them.
I'm currently performing a test import of a larger ubb.threads board and got a db error message while importing the polls:
UPDATE vb3_thread
SET pollid = 30 WHERE importthreadid =
Unfortunately, the current ubb.threads impex code isn't able to import polls with more than one question per poll. This feature is available in ubb.threads since version 6.0.x, if I remember correctly.
Your current implementation grabs all questions from the PollQuestions table and inserts them as a new poll into vbulletin. That's necessary because vbulletin can only handle one question per poll.
Doing that for the second, third etc. question of a poll will result in the error above, as this questions isn't associated with a thread.
What would be the best way to handle this?
- Only import the first question as a new poll if a poll has multiple questions in ubb.threads -> Would probably be the easiest one and could be done with a simple DISTINCT while grabbing the questions.
- create a new thread for all questions of poll > 1.
- Just skip polls with multiple questions and don't import them.
Comment