Problem converting from phpbb2 to SMF 1.1 RC3

[ultra_smooth01]

I have run the convert.php file to convert phpbb 2.0.20 to SMF 1.1 RC3 conversation was successful except for the memberlist can anyone help?

Below is the info I recieved:

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, hxxp:mg.id [nonactive]_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 `phpbb_1`.phpbb_users AS u
LEFT JOIN `phpbb_1`.phpbb_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

[J. Williams]

Try this, and see if this fixes your problem:

http://smf.person-lab.net/phpbb2_to_smf_2006_09_21.zip

[coldfusion20006]

Try this, and see if this fixes your problem:

http://smf.person-lab.net/phpbb2_to_smf_2006_09_21.zip [nofollow]

Its 2am here in the states and I have been battling an issue for one of my clients for 2 days. I too have been trying to use SMFs PHPBB2 Converter to SMF with the same problem as the other guy posted above. I dont know who you are or if you made this new updated converter, but I just wanted to say THANK YOU so much! I am going to head off to bed now with a better feeling about getting up tomorrow and speaking with my customer.

If you didn't create this script, Thanks for posting it. If you did create this script, you should at least be allowed to make it available on the page with the rest of the downloads. Good Job!

This type of thing is what a community forum is ALL about!

[chipmandoo]

Sorry. How do you use this script? Just put both files in the root folder of FMF and run the php? or upload the sql into the database and run the php from root?

[J. Williams]

You upload the file and sql file to your SMF forum directory, then run the convert.php