IPB 3.1.3 > SMF 1.1.12 - "Unknown column 'id' in 'field list'"

[Supernaut]

Hello,

I'm attempting to run the converter and the following error is generated:

Converting members... Unsuccessful!
This query:
SELECT
id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
joined AS dateRegistered, posts,
IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS emailAddress,
SUBSTRING(website, 1, 255) AS websiteTitle,
SUBSTRING(website, 1, 255) AS websiteUrl,
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 hideEmail,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
'' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
'' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
'' AS smileySet, '' AS passwordSalt, '' AS memberIP
FROM `hubble_mice`.ibf_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:

Unknown column 'id' in 'field list'

I have searched the forum for a solution but have been unable to find one.  I have double checked the version of converter I am using etc.

If someone could help I'd appreciated it.

Tom

[ThorstenE]

please check the table ibf_members via phpMyAdmin.. is there a column named 'id'?

[EdisonLiu]

Hi,

I have the same problem. I checked the database under member, but there is a bunch ending with id.

Member_Id, Member_group_Id, org_perm_id, live_id, and twitter_id.

So which one is the problem?

[ThorstenE]

EdisonLiu,
are you sure your Invision Power Board is the old 1.3 version?

if yes, then please edit invision_to_smf.sql and find:

Code Select Expand

id AS ID_MEMBER
replace with:

Code Select Expand

Member_Id AS ID_MEMBER

[UpyR]

Hello. After replacement as it is told above:

Caused the error:
Unknown column 'mgroup' in 'field list'