Supermod to SMF, Can\'t get converter to work, HELP

[JasonMonette]

I have tried this a number of times and I keep getting errors.  This seems to be the error that is stopping the whole progress:

Code Select Expand

Converting members... Unsuccessful!
This query:

    SELECT
    mem.ID_MEMBER, SUBSTRING(mem.memberName, 1, 80) AS memberName,
    mem.dateRegistered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.websiteTitle, 1, 255) AS websiteTitle,
    SUBSTRING(mem.websiteUrl, 1, 255) AS websiteUrl, mem.lastLogin,
    mem.birthdate, SUBSTRING(mem.ICQ, 1, 255) AS ICQ,
    SUBSTRING(IFNULL(mem.realName, mem.memberName), 1, 255) AS realName,
    mem.notifyOnce, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.emailAddress, 1, 255) AS emailAddress,
    SUBSTRING(mem.AIM, 1, 16) AS AIM,
    SUBSTRING(mem.personalText, 1, 255) AS personalText,
    SUBSTRING(mem.timeFormat, 1, 80) AS timeFormat,
    mem.hideEmail, SUBSTRING(mem.memberIP, 1, 255) AS memberIP,
    SUBSTRING(mem.memberIP, 1, 255) AS memberIP2,
    SUBSTRING(mem.YIM, 1, 32) AS YIM,
    IF(IFNULL(mem.gender, '') = '', 0, IF(mem.gender = 'Male', 1, 2)) AS gender,
    SUBSTRING(mem.MSN, 1, 255) AS MSN,
    SUBSTRING(REPLACE(mem.signature, '<br>', '<br />'), 1, 65534) AS signature,
    SUBSTRING(mem.location, 1, 255) AS location, mem.timeOffset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    mem.im_email_notify AS pm_email_notify, mem.karmaBad, mem.karmaGood,
    mem.notifyAnnouncements,
    SUBSTRING(mem.secretQuestion, 1, 255) AS secretQuestion,
    IF(mem.secretAnswer = '', '', MD5(mem.secretAnswer)) AS secretAnswer,
    CASE
    WHEN mem.memberGroup = 'Administrator' THEN 1
    WHEN mem.memberGroup = 'Global Moderator' THEN 2
    WHEN mg.ID_GROUP = 8 THEN 2
    WHEN mg.ID_GROUP = 1 THEN 1
    WHEN mg.ID_GROUP > 8 THEN mg.ID_GROUP
    ELSE 0
    END AS ID_GROUP, '' AS buddy_list, '' AS pm_ignore_list,
    '' AS messageLabels, '' AS validation_code, '' AS additionalGroups,
    '' AS smileySet, '' AS passwordSalt
    FROM `jbmaudio_smf1`.smf_members AS mem
    LEFT JOIN `jbmaudio_smf1`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

    Unknown column 'mem.im_email_notify' in 'field list'

A little help?

[Tony Reid]

Do you have a im_email_notify column in your members table of your supermod database?

[JasonMonette]

yes.

     im_email_notify     tinyint(4)              No     0     

[JasonMonette]

can anyone help me?

[Deaks]

do you still require help with this?

[JasonMonette]

Yes, i can't get it to work.   I have tried pretty much everything that I have read and that has been suggested.

[metallica48423]

supermod is YabbSE, no?  Have you tried just upgrading the forum as opposed to trying to convert it?

[JasonMonette]

it seems to be working now