SMF Support > phpBB
[SMF Converter] phpBB - 2.0.19+
greddy:
no chance ?
bye, Peter
greddy:
no help for my problem ?
Peter
LaurentGom:
Hi
I'm experiencing the same problem as MariusMax and Adrien while trying to convert my phpBB 2.0.22 to SMF2.0 RC5:
--- Quote ---Converting...
Converting members...
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)
--- End quote ---
The weird thing is that it works perfectly on my local installation of the website, with exactly the same configuration (but a much smaller database).
Any chance to fix this by hacking into the conversion script? Or is the only solution to install SMF 1.1, convert and then upgrade to 2.0?
IchBin™:
--- Quote from: LaurentGom on April 20, 2011, 02:08:58 AM ---Hi
I'm experiencing the same problem as MariusMax and Adrien while trying to convert my phpBB 2.0.22 to SMF2.0 RC5:
--- Quote ---Converting...
Converting members...
Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)
--- End quote ---
Any chance to fix this by hacking into the conversion script? Or is the only solution to install SMF 1.1, convert and then upgrade to 2.0?
--- End quote ---
That is the way I would do it. I don't know much about the conversion process, but I do know about upgrading SMF. Its a very easy process and would be worth the bit of extra work to get there.
Dchidell:
I have kinda same error... Don't know how to fix it to be honest
--- Code: ---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_level = 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_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, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
'' AS member_ip, '' AS member_ip2
FROM `staragwa_staragwardia`.phpbb_users AS u
LEFT JOIN `staragwa_staragwardia`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `staragwa_smf`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
--- End code ---
Any ideas if it is possible to fix it?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version