[SMF Converter] YaBB SE 1.5.4

[JayBachatero]

All set and done.

[ajg]

wow!!!!!  cheers, man!  thank you so much!  how did you do it?  i know i've been doing some crazy things with it..  i just can't follow directions. 

thanks once again!

[JayBachatero]

You didn't import the backup and I changed the prefix also.

[SanderF1]

Converting boards... Unsuccessful!
This query:
UPDATE `chapeau_discussion`.discussion_boards
SET memberGroups = '-1,0,2', lastUpdated = 1197215410
WHERE ID_CAT = 4;
Caused the error:

Unknown column 'lastUpdated' in 'field list'

What does this mean???

[JayBachatero]

Use the convert.php from here.  http://www.simplemachines.org/community/index.php?topic=140741.0 and the yabb21_to_smf.php file from this topic.

[d.drenth]

I'm upgrading to SMF from YABB SE, i have used the sql & convert.php from this topic. Then I get the next errors. Can you tell me what the problem is? Thanks.

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting attachments...
Warning: feof(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 20

Warning: fread(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 21

Warning: feof(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 20

Warning: fread(): supplied argument is not a valid stream resource in /usr/local/psa/home/vhosts/gsm-forum.nl/httpdocs/forum/converter/convert.php(831) : eval()'d code on line 21

[SleePy]

Is the attachments folder in yabbse readable/writeable by php?

If I remember right, You should be able to upgrade to SMF from yabb SE if you are using the last version that was released and just upload the large upgrade package.

[d.drenth]

Is the attachments folder in yabbse readable/writeable by php?

If I remember right, You should be able to upgrade to SMF from yabb SE if you are using the last version that was released and just upload the large upgrade package.

Both folder old and new are readable/writeable by PHP, with CHMOD 777.

Your YaBB SE install (v. YaBB SE 1.5.3) is not the most recent (v. YaBB SE 1.5.5).

Your language file version is the most recent.

The most recent version of index.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.3.
Your version of Admin is the most recent.
Your version of BoardIndex is the most recent.
Your version of Calendar is the most recent.
The most recent version of Display.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of Errors is the most recent.
Your version of ICQPager is the most recent.
The most recent version of InstantMessage.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.3.
Your version of Karma is the most recent.
The most recent version of Load.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of LockThread is the most recent.
The most recent version of LogInOut.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.1.
Your version of Maintenance is the most recent.
Your version of ManageAttachments is the most recent.
Your version of ManageBoards is the most recent.
Your version of ManageCats is the most recent.
Your version of Memberlist is the most recent.
Your version of MergeThreads is the most recent.
Your version of MessageIndex is the most recent.
The most recent version of ModifyMessage.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.2.
Your version of ModSettings is the most recent.
Your version of MoveThread is the most recent.
Your version of Notify is the most recent.
Your version of Poll is the most recent.
The most recent version of Post.php is YaBB SE 1.5.4 while your version is YaBB SE 1.5.2.
The most recent version of Profile.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.2.
Your version of Recent is the most recent.
Your version of Register is the most recent.
Your version of RemoveOldThreads is the most recent.
The most recent version of RemoveThread.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.
Your version of RepairBoards is the most recent.
Your version of Search is the most recent.
Your version of Security is the most recent.
Your version of SendTopic is the most recent.
Your version of SplitThreads is the most recent.
The most recent version of Subs.php is YaBB SE 1.5.5 while your version is YaBB SE 1.5.1.

This is informatie about my forum, maybe a problem with the version, if this the problem what can I do to solve the problem?

[d.drenth]

The forum is upgraded to 1.5.5, the upgrade to SMF gives same errors as post before.

[SleePy]

Well you could manually edit the Yabbse files to fake the version and hope the upgrade goes well.

Was that output from the upgrade or converter script?

[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?

[JasonMonette]

can anyone help me?

[JasonMonette]

Can any one help me?

[JayBachatero]

The error is related to your prefix.  Right now it's loading the SMF prefix.  I posted a way to by pass this a few posts back.

[JasonMonette]

My prefix for my SMF forums is 'smf_'  I guess I am not sure what you are saying. I found the fix you were talk about

$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Should be.
$from_prefix = eval('`donbosco_smf`.forum_');

but i am not sure what prefix you are talking about...

[JasonMonette]

Ok I nuked everything and started over.  I am getting this error now:

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

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

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

[JasonMonette]

I have tried pretty much everything in this post and can't get it to work....

Use the convert.php from here.  http://www.simplemachines.org/community/index.php?topic=140741.0 and the yabb21_to_smf.php file from this topic.

this is the error i am getting:

Code Select Expand

Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

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

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

[JasonMonette]

When I use the sql file from this post i get,

Code Select Expand

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

when i use the files from the down load section, i get the error in the previous post

[JasonMonette]

Hello?  This is a support forum right?  Anyone out there?

[JayBachatero]

It's still picking up the old prefix.  What is the prefix for your YaBB SE install?  Also check the file permissions for the file.  That could be the reason for the Internal Server Error.