Advertisement:

Author Topic: Problem with Polls converting IPB 1.3.1  (Read 4228 times)

Offline Jeffry

  • Newbie
  • *
  • Posts: 4
Problem with Polls converting IPB 1.3.1
« on: January 09, 2007, 12:33:31 PM »
While converting I get this error:

Code: [Select]
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]
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?

Offline Jeffry

  • Newbie
  • *
  • Posts: 4
Re: Problem with Polls converting IPB 1.3.1
« Reply #1 on: January 09, 2007, 01:28:31 PM »
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!

Offline Sarke

  • Jr. Member
  • **
  • Posts: 315
Re: Problem with Polls converting IPB 1.3.1
« Reply #2 on: January 11, 2007, 03:53:13 PM »
I had the same problem, but with IPB2.

In the .sql file, replace

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

Code: [Select]
$rows[] = "$row[ID_POLL], SUBSTRING('" . implode("', 1, 255), SUBSTRING('", $choice) . "', 1, 255)";
My MODs          Please don't PM me for support, post in the appropriate topic.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Problem with Polls converting IPB 1.3.1
« Reply #3 on: January 29, 2007, 10:21:41 PM »
Did you get this solved?  If not try using the converter in this topic: IPB 1.3.x
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert