PhpBB 2.0.17 -> SMF 1.1RC3 conversion problem

[Fuss]

SMF Version: SMF 1.1 RC3
Hi,

We've got a forum using the PhpBB 2.0.17 software (I know, not the latest version). Few days ago I installed SMF 1.0.8 and was able to convert without problems using the 1.0.x converter.

Now I wanted to give RC3 a try. I first installed TP (0.9.5), then tried the conversion. Following error occured at the first page (using the RC3 converter of course):

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
    SUBSTRING(u.username, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
    u.user_regdate AS dateRegistered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
    u.user_new_privmsg AS instantMessages,
    SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg AS unreadMessages,
    SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
    SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
    SUBSTRING(u.user_icq, 1, 255) AS ICQ,
    SUBSTRING(u.user_yim, 1, 32) AS YIM,
    SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
    SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
    u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
    IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
    '' AS memberIP2
    FROM `website`.phpbb2_users AS u
    LEFT JOIN `website`.phpbb2_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `smf`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_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 emailAddress, 1, 255) AS emailAddress,
    u.user_unread_privmsg

Does the TP package alter the database in that way that a conversion is not possible any more?
Should I first upgrade phpbb to the latest version (which is quite a lot of (useless) work) and try the conversion afterwards? Or is it a better idea to start from the correct 1.0.8 migration and update to 1.1RC3?

Thanks in advance.

[tones_ie]

http://www.simplemachines.org/community/index.php?topic=107868.60

[dede]

I'm still having problems with converting members so can't tell if the rest will work for me yet. Using the download "phpbb2_to_smf_2006_09_02"

Not sure what the message below means?

I'm using phpBB 2.0.18 and smf 1.0.8  Do I have the wrong converter? I originally tried the one from the smf site marked simply "phpBB to smf convertor"

Converting members... Unsuccessful!
This query:
INSERT INTO `semangat_smf1`.smf_attachments
(ID_MSG, ID_MEMBER, filename, attachmentType)
VALUES (0, 2, SUBSTRING('avatar_2.jpg', 1, 255), 0);
Caused the error:

Unknown column 'attachmentType' in 'field list'