phpbb2 -> smf converter error when converting personal messages

[slinouille]

Hello,

I've worked a lot on converting my phpmaximus forum. My 1st step was to convert it into phpbb2 forum.
THis step done, I've started converting it into SMF using version 1.3RC.

Every thing seems ok until I've received this message:

Code Select Expand

Converting personal messages (step 1)... Unsuccessful!
This query:

    SELECT
    pm.privmsgs_id AS ID_PM, pm.privmsgs_from_userid AS ID_MEMBER_FROM,
    pm.privmsgs_type IN (0, 1, 3) AS deletedBySender,
    pm.privmsgs_date AS msgtime,
    SUBSTRING(uf.username AS fromName, 1, 255) AS fromName,
    SUBSTRING(pm.privmsgs_subject, 1, 255) AS subject,
    SUBSTRING(REPLACE(IF(pmt.privmsgs_bbcode_uid = '', pmt.privmsgs_text, REPLACE(REPLACE(pmt.privmsgs_text, CONCAT(':1:', pmt.privmsgs_bbcode_uid), ''), CONCAT(':', pmt.privmsgs_bbcode_uid), '')), '\n', '<br />'), 1, 65534) AS body
    FROM (`vag-techniquefr`.phpbb_privmsgs AS pm, `vag-techniquefr`.phpbb_privmsgs_text AS pmt)
    LEFT JOIN `vag-techniquefr`.phpbb_users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
    WHERE pmt.privmsgs_text_id = pm.privmsgs_id
    LIMIT 0, 500;

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 'AS fromName, 1, 255) AS fromName,
    SUBSTRING(pm.privmsgs_subject, 1, 255) AS sub' at line 5

I've search on the forum but the only guy that has the same problem is writting in German and I just don't understand German 
Can anyone help me resolving this problem ?

I'm so close to succeed and so exited 

Thank you

[sawz]

i recently converted a phpbb2 and i was going to start with 1.1rc3.
well that didn't work too good for me, i read in another thread that i should
start with 1.0.8 and after the conversion, upgrade if i liked.

so i installed 1.0.8

it worked for me using this converter.

[slinouille]

Thank you for your answer ... I'm installing the 1.08 and restart converting 

I'll give you the results ... hoping it will be OK 

[slinouille]

Yes it worked ... i've seen many errors but the converter has continued ... great ! 

All the messages are their, and all members.

Only one thing ... all the members are administrators 

I'll need to do a little script to change that !

Thanks

[powerPT]

I also have got this problem, anyone can help me 

It´s very important, I definitively wanna phpBB2 out of my life 

[Oldiesmann]

phpbb2_to_smf.sql

Find

Code Select Expand

    SUBSTRING(uf.username AS fromName, 1, 255) AS fromName,

Replace

Code Select Expand

    SUBSTRING(uf.username, 1, 255) AS fromName,