Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: xmariox on May 01, 2007, 10:33:08 AM

Title: IPB 1.3 -> SMF 1.1.2: Error converting polls
Post by: xmariox 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)
Title: Re: IPB 1.3 -> SMF 1.1.2: Error converting polls
Post by: JayBachatero on May 17, 2007, 02:00:58 AM
Try using the converter in this topic: IPB 1.3.x (http://www.simplemachines.org/community/index.php?topic=146211)