News:

Wondering if this will always be free?  See why free is better.

Main Menu

IPB Converter Problems

Started by bros, July 15, 2008, 04:41:41 PM

Previous topic - Next topic

bros

Converting members...
Notice: Undefined index: admin_group in /home/xxxx/public_html/convert.php(974) : eval()'d code on line 4
Unsuccessful!
This query:
SELECT
m.id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
m.joined AS dateRegistered,
IF(m.mgroup = , 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_total AS instantMessages,
SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
SUBSTRING(m.email, 1, 255) AS emailAddress,
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 websiteTitle,
SUBSTRING(me.website, 1, 255) AS websiteUrl, 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 hideEmail, m.email_pm AS pm_email_notify,
SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
'' 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 smileySet, '' AS memberIP2
FROM `polarord_smf1`.ibf_members AS m
LEFT JOIN `polarord_smf1`.ibf_member_extra AS me ON (m.id = me.id)
LEFT JOIN `polarord_smf1`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
WHERE m.id != 0
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
posts,' at line 4

bros

Never mind.

I ran the 2.3.x converter instead of the 2.2.x one :D

Advertisement: