News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

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: