Problem with Polls converting IPB 1.3.1

[Jeffry]

While converting I get this error:

Code Select Expand

Converting poll options... Unsuccessful!
This query:

    INSERT INTO `forum`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('3', 1, 255), 'Ik geloof er wel in, maar nog niet mee gemaakt', 1, 255), '5'),
    (1, SUBSTRING('2', 1, 255), 'Nee', 1, 255), '4'),
    (1, SUBSTRING('1', 1, 255), 'Ja, ik heb t wel s mee gemaakt', 1, 255), '5'),
    (2, SUBSTRING('3', 1, 255), 'Ik vond het een saai feest.', 1, 255), '0'),
    (2, SUBSTRING('2', 1, 255), 'Leuk feest, maar ik zou er niet zo snel weer komen.', 1, 255), '0'),
    (2, SUBSTRING('1', 1, 255), 'Fantastisch wat een feest...vaker doen!!', 1, 255), '0'),
    (2, SUBSTRING('4', 1, 255), 'Zo\'n slecht feest heb ik nog nooit meegemaakt.', 1, 255), '1'),
    (2, SUBSTRING('5', 1, 255), 'Leuk feest, heb me goed vermaakt maar het kan altijd beter!', 1, 255), '5'),
    (3, SUBSTRING('1', 1, 255), 'PvdA', 1, 255), '3'),
    (3, SUBSTRING('2', 1, 255), 'Lijst Pim Fortuyn', 1, 255), '1'),

And this error:

Code Select Expand

Caused the error:

    You have an error in your SQL syntax near ''5'),
    (1, SUBSTRING('2', 1, 255), 'Nee', 1, 255), '4'),
    (1, SUBS' at line 4

What's going wrong?

[Jeffry]

I skipped the poll-converting by changing the retry URL and of course more errors concerning Polls showed up, which makes sense since these errors above showed up first and are related. But after a while also errors showed up with permission-settings. Perhaps in some way related, but I think this also stands on itself, but could be wrong.

If someone has solutions or suggestions I'm very willing to test. I have a few forums still running under 1.3.1 IPB and tried phpBB but that's not really my cup of tea. And Invision got to expensive and until now I really enjoy SMF as a solution. It looks even more professional than IPB... so thumbs up!

[Sarke]

I had the same problem, but with IPB2.

In the .sql file, replace

Code Select Expand

$rows[] = "$row[ID_POLL], SUBSTRING('" . implode("', 1, 255), '", $choice) . "'";

with

Code Select Expand

$rows[] = "$row[ID_POLL], SUBSTRING('" . implode("', 1, 255), SUBSTRING('", $choice) . "', 1, 255)";

[JayBachatero]

Did you get this solved?  If not try using the converter in this topic: IPB 1.3.x