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:
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?
Do you have a im_email_notify column in your members table of your supermod database?
yes.
im_email_notify tinyint(4) No 0
can anyone help me?
do you still require help with this?
Yes, i can't get it to work. I have tried pretty much everything that I have read and that has been suggested.
supermod is YabbSE, no? Have you tried just upgrading the forum as opposed to trying to convert it?
it seems to be working now