Okay so Im trying to do another Conversion from phpBB3 I get this SQL error. Im not having much joy and I abandoned it last time due to too many errors I faced having to resolve. If this happens again, I will finally lay it to rest and forget about SMF.
Any help?
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_rank = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
SUBSTRING(u.user_msnm, 1, 255) AS msn,
SUBSTRING(u.user_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 website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, 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,
CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
u.user_ip AS member_ip2
FROM `juliegee_zforums`.phpbb_users AS u
LEFT JOIN `juliegee_zforums`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `juliegee_smfn1`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
WHERE u.group_id NOT IN (1, 6)
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:
Unknown column 'u.user_from' in 'field list'
Which converter are you using?
The one located here: "Phpbb 3 to SMF 2-0"
http://download.simplemachines.org/?converters;software=phpbb (http://download.simplemachines.org/?converters;software=phpbb)
Strange... There was a recent conversion
http://www.simplemachines.org/community/index.php?topic=527586.0
Yes, there were issues, but that didn't occur... Which phpBB version are you coming from?
Ahh, thats maybe why, as this is the new phpBB 3.1.1 version that was just released.
Well in that case it would be expected to have problems :P
Sorry, there is no functional converter yet...
So I took a version of my board from 3.0.12 and tried the converter and get this:
Converting...
Notice: Undefined index: convert_script in /home1/juliegee/public_html/SMF/convert.php on line 972
Warning: Invalid argument supplied for foreach() in /home1/juliegee/public_html/SMF/convert.php on line 975
Notice: Undefined index: convert_script in /home1/juliegee/public_html/SMF/convert.php on line 987
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home1/juliegee/public_html/SMF/convert.php on line 2494
Notice: Undefined variable: result in /home1/juliegee/public_html/SMF/convert.php on line 2495
Notice: Undefined index: db_fetch_assoc in /home1/juliegee/public_html/SMF/convert.php on line 1386
Fatal error: Function name must be a string in /home1/juliegee/public_html/SMF/convert.php on line 1386
The never ending nightmare of keeping convertors updated :\
I just dont understand why I run into so many different errors when trying to convert my phpBB board (3.0.12). I had a lot of issues with the last one (collation problems) and its not like I changed anything in phpAdmin, so I have a hard time understanding why the converter is failing with so many errors.
Okay, so after I did a re-install and convert, it worked this time.
:)
The reasons for the converter to fail are... A lot and varied :P
if you have a good backup of your database, before you start using PHPBB 3.1.1 then you will probally convert that with the right converter to an good end ;)
have a feeling that your database stucture has been infected by 3.1.1