Advertisement:

Author Topic: Invision to SMF 2-0  (Read 3679 times)

Offline eddie1973

  • Semi-Newbie
  • *
  • Posts: 23
Invision to SMF 2-0
« on: January 10, 2012, 11:54:31 PM »
I am trying to convert my IPB 3.2 to SMF 2.0. From the Converter section I downloaded the Invision to SMF 2-0 file. When converting I get the following error.

Code: [Select]
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 `flyakaco_myaka`.ibp_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'