Assistance with Converting Ipb 3 to SMF 2

[Mittens]

I just cant get the converter to work, no matter how many diffrent methods I try.

My current error

Code Select Expand

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

[emanuele]

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.

[Mittens]

ive tried the one in the downloads section and the one you posted for 3.4. Both had same error ><

[emanuele]

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 can't give you that error for one very simple reason:

Code Select Expand

---* {$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 (the .sql file is the important one) and upload them to your forum directory and try again.

[Mittens]

Oh thank you that helped but now its stuck on Successful.
Recalculating forum statistics...

Its been three hours now

[emanuele]

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).