News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

IPB 1.3 -> SMF 1.1.2: Error converting polls

Started by xmariox, May 01, 2007, 10:33:08 AM

Previous topic - Next topic

xmariox

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)

JayBachatero

Follow me on Twitter

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

Advertisement: