PHPBB2 2.0.21 converter

[redactor007]

I don't guess the converter in the downloads section (for version 2.0.7) will work with the current version of PHPBB?  I remember having to upgrade the database when I moved from 2.0.7 to 2.0.21.

Thanks
-Bera

[jerm]

You can try to see if it works. If it doesn't, we will have to upgrade the converter.

[redactor007]

Yeah, it didn't work.  I had to delete my install of SMF 1.1 RC3, install SMF 1.0.8, use the phpBB 2.0.7 converter, and then upgrade SMF to 1.1 RC3.  Kind of a pain.

[sawz]

i'm also trying to convert a phpbb to SMF and here is the error:

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 `sawz_phpbb1`.phpbb_users AS u
    LEFT JOIN `xxxx_phpbb1`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `xxxx_phpbb1`.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 AS unreadMessag' at line 9

i am trying to convert from a phpbb 2.0.21 to SMF 1.0.8 naked install.

[redactor007]

Which converter did you use, the one for 1.0.8 or the one for 1.1RC3?  I had to use the one for 1.0.8 in order for it to work.  Also, is SMF in the same database as phpBB? 

These are just shots in the dark (I haven't any real experience in the matter) but it's information that's helped me so I thought I'd just pass it on.

[sawz]

Which converter did you use, the one for 1.0.8 or the one for 1.1RC3?  I had to use the one for 1.0.8 in order for it to work.  Also, is SMF in the same database as phpBB? 

good shot, i was using the wrong one, worked nicely thank you