invision_to_smf.sql downloaded yesterday... problem with polls

[Green Hornet]

Hello,

I search for this problem in the forum but it still does'nt work...

Code Select Expand



Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:

    INSERT INTO `forumstvb`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (46, SUBSTRING('0', 1, 255), 'c ma position sexuelle préféré', 1, 255), '6'),
    (46, SUBSTRING('1', 1, 255), 'wahoo trop il est beau jalabert', 1, 255), '1'),
    (46, SUBSTRING('2', 1, 255), 'wahoo trop il a des idées bien ki sont bien besancenot', 1, 255), '2'),
    (46, SUBSTRING('3', 1, 255), 'j'aime les piqures alors....', 1, 255), '1'),
    (46, SUBSTRING('4', 1, 255), 'la poste a tjrs du retard alors....', 1, 255), '1'),
    (46, SUBSTRING('5', 1, 255), 'tagueule la sncf aussi...', 1, 255), '6'),

.../...

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 ''6'),
    (46, SUBSTRING('1', 1, 255), 'wahoo trop il est beau jalabert', 1,' at line 3



i think there is a problem in the invision_to_smf.sql with the "1, 255,)" but i don't understand how to change it...

my forum is a IPB 1.3.x and i want to convert to a SMF 1.1RC3

thanks for help, thanks for everyone who work on SMF, it's a great job

and sorry for my english... (i'm french)

[Green Hornet]

nobody to answer?
i just want to know if you can resolve this problem as soon as possible ... i can wait

[Oldiesmann]

Here you go. This one should work better

[Green Hornet]

  thanks i try it...

I restart the script, thinking all data will be delete but i have :

Code Select Expand

Converting members... Unsuccessful!
This query:

    INSERT INTO `forumstvb`.smf_members
    (ID_MEMBER, memberName, dateRegistered, posts, ID_GROUP, lastLogin, realName, instantMessages, passwd, emailAddress, websiteTitle, websiteUrl, location, ICQ, signature, birthdate, AIM, YIM, MSN, hideEmail, avatar, pm_email_notify, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt)

.../...

Caused the error:

    Duplicate entry '575' for key 1


so i delete data of this table manually to try another time

.../...



i got another problem but i search in the forum before

[Green Hornet]

the problem is not with the truncate of the table members but with the inset because the script try to insert 5 members twice!!!???

[Deeze]

I also ran into this same problem, and it led me to this new query file. It got me past that problem, but I did find another in it, a simple typo. Search the file for "SUBSRING" and replace with "SUBSTRING". After that it completed without difficulty. Thanks!

[Green Hornet]

i had read the problem with th SUBSRING but my problem is with the table members!!! i think that the reloading of the page is going wrong and the script want to insert some members who have been inserted before... after deleted all members which id is greater than 574 it's going good

[Marc40000]

I tried to convert an IPB 1.3 to SMF 1.1 with the convert script from the download section as well and encountered both issues described here. Encountering the first one is really surprising because according to some earlier post it seems to have been fixed. However, I had to fix it myself again + replace SUSTRING with SUBSTRING and uploaded the fixed version here: hxxp:rochel.s83.deinprovider.de/temp/smf_1-1_invision_converter-marc'sfix.zip [nonactive].