SMF Support > YaBB/YaBB SE
[SMF Converter] YaBB SE 1.5.4
mikemotors:
Any idea why this does not work?
Thank You in advance.
Problem below:
Warning: set_time_limit() has been disabled for security reasons in /usr/local/www/data/d/7889/html/forum/convert.php on line 29
YaBB SE 1.5.x to SMF Converter
Converting...
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 `db7889`.members AS mem
LEFT JOIN `db7889`.membergroups AS mg ON (mg.membergroup = mem.memberGroup)
LIMIT 0, 500;
Caused the error:
Unknown column 'mem.im_email_notify' in 'field list'
console65:
Hi,
I am trying to convert a board, each time it fails at different stages with 500 "Internal Server Error".
In PHP error log are the following lines repeated 1000s of times:
[21-Mar-2010 22:13:35] PHP Warning: fread() expects parameter 1 to be resource, boolean given in I:\emsu\convert.php(1109) : eval()'d code on line 21
[21-Mar-2010 22:13:35] PHP Warning: feof() expects parameter 1 to be resource, boolean given in I:\emsu\convert.php(1109) : eval()'d code on line 20
Followed by a timeout error which creates the Server Error.
Any idea how I can fix this?
Thanks.
Navigation
[0] Message Index
[*] Previous page
Go to full version