SMF Support > IPB
Help converting from IPB 3.0.2 please
CoffeeAddict:
I wasn't able to find any converter for 3.0.2 (even in the thread pinned at the top here) so I tried converting with the one for 2.3 and I didn't even get passed the first step of converting members, I get this error.
--- Code: ---This query:
SELECT
m.id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
m.joined AS date_registered,
IF(m.mgroup = 4, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS id_group,
posts, m.last_visit AS last_login, SUBSTRING(m.members_display_name, 1, 80) AS real_name,
SUBSTRING(me.yahoo, 1, 32) AS yim, m.msg_total AS instant_messages,
SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
SUBSTRING(mc.converge_pass_salt, 1, 5) AS password_salt,
SUBSTRING(m.email, 1, 255) AS email_address,
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
SUBSTRING(me.website, 1, 255) AS website_title,
SUBSTRING(me.website, 1, 255) AS website_url, me.signature,
SUBSTRING(me.location, 1, 255) AS location,
SUBSTRING(me.icq_number, 1, 255) AS icq,
SUBSTRING(me.msnname, 1, 255) AS msn, SUBSTRING(me.aim_name, 1, 16) AS aim,
m.hide_email AS hide_email,
IFNULL(m.email_pm, 0) AS pm_email_notify,
SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, '' AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS member_ip2
FROM `bestinsh_ipbforum`.members AS m
LEFT JOIN `bestinsh_ipbforum`.member_extra AS me ON (m.id = me.id)
LEFT JOIN `bestinsh_ipbforum`.members_converge AS mc ON (m.id = mc.converge_id)
WHERE m.id != 0
LIMIT 0, 500;
Caused the error:
Table 'bestinsh_ipbforum.member_extra' doesn't exist
--- End code ---
Any help for what I need to change to make this work? Please?
K@:
If it helps, this version just seems to be a general IPB converter.
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_invision_converter.zip
CoffeeAddict:
Thanks, I tried that one just now and I get the same error. The only tables I have in the ipb database that are member related are "members" and "members_partial", so the code is looking for something that's not there, but I don't know what to replace it with (or where to replace it)
IchBin™:
The closest one we have to your version of IPB is this one.
http://www.simplemachines.org/community/index.php?topic=404732.0
It "should" work with your version, but as usual made need some tweaks since it's a bit behind on the version you are. Post back if you get any errors.
CoffeeAddict:
Thank you! I viewed that thread before I registered here and I guess that's why I didn't see the files to download. I just tried it and got this error
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Edited to add: I read the thread and fixed that problem, but now I get this error instead:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Converting settings...
Fatal error: Call to undefined function updateSettingsFile() in /home/bestinsh/public_html/forums/convert.php(1099) : eval()'d code on line 57
Navigation
[0] Message Index
[#] Next page
Go to full version