Supermod to SMF

[JasonMonette]

I am trying to convert my supermod forum to SMF.  When I run the converter i get this error:

Code Select Expand

Converting...
Converting members... Unsuccessful!
This query:

    UPDATE `jbmaudio_smf1`.smf_members
    SET im_ignore_list = ''
    WHERE ID_MEMBER = 5
    LIMIT 1;

Caused the error:

    Unknown column 'im_ignore_list' in 'field list'

any help would be greatly appreciated.  I am running  YaBBSM V3.5.5

Thanks in advance

[JasonMonette]

I tried to drop that im-ignore_list column and now I get this errror:

Code Select Expand

Converting...
Converting members... Unsuccessful!
This query:

    SELECT ID_MEMBER, im_ignore_list
    FROM `jbmaudio_yabbse`.yabbsm_members
    WHERE im_ignore_list RLIKE '[a-z]'
    LIMIT 512;

Caused the error:

    Unknown column 'im_ignore_list' in 'field list'

[JasonMonette]

Ok, I added the ignore table back and now I am getting the following:

Code Select Expand


Converting...
Converting boards... Unsuccessful!
This query:

    UPDATE `jbmaudio_smf1`.smf_boards
    SET memberGroups = '-1,0,2', lastUpdated = 1200346371
    WHERE ID_CAT = 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

[JasonMonette]

ok, now when I run it, without changing a single thing, i get the following:

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'