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.
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
Any help for what I need to change to make this work? Please?
