I just cant get the converter to work, no matter how many diffrent methods I try.
My current error
Converting members... Unsuccessful!
This query:
SELECT
id AS id_member, SUBSTRING(name, 1, 80) AS member_name,
joined AS date_registered, posts,
IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS id_group,
last_visit AS last_login, SUBSTRING(name, 1, 255) AS real_name,
IFNULL(msg_total, 0) AS instant_messages,
SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS email_address,
SUBSTRING(website, 1, 255) AS website_title,
SUBSTRING(website, 1, 255) AS website_url,
SUBSTRING(location, 1, 255) AS location,
SUBSTRING(icq_number, 1, 255) AS icq, signature,
IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
SUBSTRING(aim_name, 1, 16) AS aim, SUBSTRING(yahoo, 1, 32) AS yim,
SUBSTRING(msnname, 1, 255) AS msn, hide_email AS hide_email,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
IFNULL(email_pm, 0) AS pm_email_notify, '' 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 password_salt, '' AS member_ip
FROM *****************************************
WHERE id != 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'
Could anyone help me out on this? I really want to make the switch and its driving me crazy for the past week
Hello Mittens and welcome to the forum. :)
Exactly which converter did you download?
Please try one of those you find in this board (see the sticky topics) depending on the exact version of IPB you are using. ;)
ive tried the one in the downloads section and the one you posted for 3.4. Both had same error ><
mmm...the one from the download site may be quite old, so probably for IPB 1.x or 2.x.
But the one from this topic (http://www.simplemachines.org/community/index.php?topic=477019.0) can't give you that error for one very simple reason:
---* {$to_prefix}members
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
the query is different.
So, download again the converter from this topic (http://www.simplemachines.org/community/index.php?topic=477019.0) (the .sql file is the important one) and upload them to your forum directory and try again. ;)
Oh thank you that helped but now its stuck on Successful.
Recalculating forum statistics...
Its been three hours now
Did you see any progress in these three hours?
I have the feeling it failed a while ago.
You may want to try again the conversion enabling the debug of disabling javascript (usually that gives a bit more possibilities to catch weird errors as far as I remember).