Advertisement:

Author Topic: IPB 1.3 -> SMF 1.1.2: Error converting polls  (Read 3591 times)

Offline xmariox

  • Newbie
  • *
  • Posts: 3
IPB 1.3 -> SMF 1.1.2: Error converting polls
« on: May 01, 2007, 10:33:08 AM »
Hi,

I get an error using the converter (yes the one for IPB1 ;D)
Quote
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:

    INSERT INTO `dbname`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (8, SUBSTRING('0', 1, 255), 'somePolloption', 1, 255), '0'),
    [...]
    (13, SUBSTRING('0', 1, 255), 'yes', 1, 255), '3'),
    (13, SUBSTRING('1', 1, 255), 'no', 1, 255), '4'),
    (13, SUBSTRING('2', 1, 255), 'whatever', 1, 255), '2');

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0'),
    (8, SUBSTRING('1', 1, 255), 'polloption1', 1, 255), '1')' at line 3

If I delete the polls from the old forum and import the data I get past this point but get another error:

Quote
"Duplicate entry '0-1-0' for key 1"

So it's no option to just delete the polls. I'd also rather keep them if possible :)

Can anyone help me with this?

Thanks
Mario  8)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: IPB 1.3 -> SMF 1.1.2: Error converting polls
« Reply #1 on: May 17, 2007, 02:00:58 AM »
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