Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: JayBachatero on January 08, 2007, 11:25:48 AM

Title: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 08, 2007, 11:25:48 AM
Software: YaBB SE
Version: 1.5.4

This is the official support topic for YaBB SE 1.5.4 converter.  Use this topic to ask for support for this converter.

Changelog

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Cyberclone on January 10, 2007, 04:08:30 PM
My Problem:

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... Unsuccessful!
This query:

    SELECT m.ID_MEMBER, lt.ID_TOPIC, lt.notificationSent AS sent
    FROM (`spocrati_ht4uforum`.yabbse_log_topics AS lt, `spocrati_ht4uforum`.yabbse_members AS m)
    WHERE notificationSent != 0
    AND lt.memberName = m.memberName
    LIMIT 0, 500;

Caused the error:

    Unknown column 'lt.memberName' in 'where clause'


I have no any idea what I can do... My solution was create a new field memberName in yabbse_log_topics. After them, the script works but for ever on the same step
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 10, 2007, 04:43:05 PM
Try the one attached in the first post.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Cyberclone on January 12, 2007, 04:22:18 PM
Thanks for your help  ;)
With your new file, I have no error messages, but the script works for ever:


Converting...
Converting topic notifications... Incomplete.

Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.


in the last 24 hour it works on the same step. Have you an another soloution?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 12, 2007, 10:27:17 PM
Try this file.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Cyberclone on January 13, 2007, 06:20:41 PM
 :D :D Now it works wonderfull, thanks for your support  :-*

Quote
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on February 14, 2007, 12:52:59 AM
Hi,  I have been trying to convert my yabbse forum to SMF using the files in this thread.  It works fine until after it converts the post and then it gets an Internal Sever Error.

Any ideas?

Thanks.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chris Cromer on February 15, 2007, 06:44:37 AM
I don't know why but after using this converter random members have an ID_GROUP setting of 11... even though that group does not exist. This caused me alot of headaches since the members with that group id could not see anything. It was funny that when they logged in the boards where gone, but when they logged back out they came back. ;D

I already fixed it in my conversion since it was just a matter of running an update query, but thought I would report it for you to look into.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on February 15, 2007, 10:08:45 AM
Quote from: Chuck on February 14, 2007, 12:52:59 AM
Hi,  I have been trying to convert my yabbse forum to SMF using the files in this thread.  It works fine until after it converts the post and then it gets an Internal Sever Error.

Any ideas?

Thanks.
Does the post conversion make any process at all or once it gets there it gets the error?

Quote from: Chris Cromer on February 15, 2007, 06:44:37 AM
I don't know why but after using this converter random members have an ID_GROUP setting of 11... even though that group does not exist. This caused me alot of headaches since the members with that group id could not see anything. It was funny that when they logged in the boards where gone, but when they logged back out they came back. ;D

I already fixed it in my conversion since it was just a matter of running an update query, but thought I would report it for you to look into.
Chris that is weird.  Was it a primary or secondary group?  If you look at this part it shows you that it gets the correct group.

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
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on February 15, 2007, 02:12:35 PM
Yes, all the post are converted successfully.. When it says converting priveat messages, or after that, I get the internal sever error.  When I look in the datatbase it appears that the pm's have been converted-at least there is the same amount in the new table.  
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on February 15, 2007, 02:40:19 PM
The last message that I get before the internal sever error is

Converting private messages step 2 incomplete..
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on February 15, 2007, 02:57:07 PM
I got this from the server error log, it seems to have somethng to do with it

Allowed memory size of 8388608 bytes exhausted (tried to allocate 10240 bytes)
[Thu Feb 15 19:48:44 2007] [error] [client 65.24.102.63] Premature end of script headers:..........
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chris Cromer on February 15, 2007, 06:17:14 PM
That's just it, there is no group 11 in either the YaBBSE forum or in the SMF forum. Infact the groups in the YaBBSE are unaltered, there are no new groups.

Oh and just to let you know, attachments where an issue as well for me. The directory is missing alot of attachment files and I had to do some pruning on the attachments from the admin center to get it to convert. If I didn't do it the script would die and all you see is a white screen. My error log shows it trying to access files that don't exist and having trouble and failing.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on February 16, 2007, 01:04:44 PM
Umm I'll have to look more into this.  I still don't understand how the ID_GROUP was set to 11.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: tinfoilhat on February 24, 2007, 08:09:44 PM
Quote from: Chuck on February 15, 2007, 02:40:19 PM
The last message that I get before the internal sever error is

Converting private messages step 2 incomplete..
I had the same error.  The way I solved it was by using the yabbse_to_smf.sql file in the 4th post rather than the file in the 1st post.  After that it worked well for me.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on February 26, 2007, 01:04:09 AM
Hey, thanks for the reply.  That is the file that I use and I  still get the error.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on February 28, 2007, 10:25:42 AM
Post your phpinfo.php file.
What is phpinfo.php? (http://www.simplemachines.org/community/index.php?topic=18250.0)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chris Cromer on March 04, 2007, 04:11:42 AM
I don't know if this is because the forum I converted was converted from YaBB to YaBBSE to SMF. But I noticed in the database in the members table, old members that didn't set their birthday are set to 0000-00-00, where as members who signed up after the conversion to SMF have 0001-01-01.

I doubt it affects anything, but I thought I would report it since I didn't know if it's something specific to the forum I converted or a bug that happens for all conversions.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on March 04, 2007, 03:03:17 PM
I'll look into it.  If I'm correct the correct format is 0001-01-01 cause of MySQL running in strict mode.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chris Cromer on March 04, 2007, 05:28:49 PM
Yeah, I updated all the rows to the 0001 setting. I just wanted to report it incase it might be a issue with the converter.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on March 13, 2007, 05:34:07 PM
I got my board to convert but.....

Some members are able to log in, but apparently do not have the proper permission to post or do other things.

Also, when I view permissions on the admin center it only shows that there are 1419 regualr members-I have 2300+.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chris Cromer on March 13, 2007, 10:06:23 PM
Quote from: Chuck on March 13, 2007, 05:34:07 PM
I got my board to convert but.....

Some members are able to log in, but apparently do not have the proper permission to post or do other things.

Also, when I view permissions on the admin center it only shows that there are 1419 regualr members-I have 2300+.
Sounds like you have the same problem I had on the last page. That group id of 11 thing. It caused me permission problems and them to not be listed on the permissions page as members.

Open up members table and see if you notice any members with odd group numbers. If you see alot of people, post that group id number and I can write you a query that will fix it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Chuck on March 13, 2007, 11:07:01 PM
Thanks, I figured it out after reading your post.  Some of the users group id's were set to 22??  I was able to fix it using a mysql query.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on March 19, 2007, 10:21:40 AM
This is really weird.  I'll have to check YaBB SE and see what's up with the converter.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: mefistofeles on April 05, 2007, 05:06:22 PM
I have tryed to convert Yabb SE 1.5.5 to SMF 1.1.2 but get this error:


Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
UPDATE `300power_com`.smf_boards
SET memberGroups = '-1,0,2', lastUpdated = 1175806904
WHERE ID_CAT = 2;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


I hope that its ok to ask about this Yabb SE version in this post?!  :)

//David

 
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Marcosms on April 11, 2007, 04:20:51 PM
I found a few topics about problems converting attachments but no answer to my questions.
I'm unable to import the attachments and the converter produce long error logs as said at
http://www.simplemachines.org/community/index.php?topic=162750.0
I had success converting everything else excepting attachments (JPGs).
Any suggestion?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on April 16, 2007, 04:11:46 PM
Are you using the .sql file from this topic?  The one in the downloads page is different from the one on this topic.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Marcosms on April 16, 2007, 06:07:08 PM
I used it but had no results at first. Now with more tries I'm able to have the files linked in the messages but not showing. I'll work on this more... 
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Marcosms on April 19, 2007, 11:19:00 AM
I understand that files needs width and lenght to show under the messages and the size is generated by the -getimagesize- function. After converting, the attachments in the mysql table have width and eight at 0. Seems like the getimagesize doesn't work but I can't understand why and how to fix it.

At first the converter produced a very large error log that indicated a problem with lines 826 and 827 of convert.php

I escluded the lines:

//if ($special_code !== null)
//   eval($special_code);

Then the conversion worked giving an error at step=1&substep=39 for converting banned members. Going directly at step=1&substep=40 the conversion ended succefully.
The attachments files copied in the smf attachments dir were cancelled by the converter. I copied them back in the same dir and recalculated the kb sizes from the admin page. Now the attachmet are linked and download correctly when clicked but don't show under the message. The width and eight are at 0 in the mysql table so apparently getimagesize function doesn't work and I can't find what's disturbing the process.

At first I had 6 files left in the attachments dir after conversion. They had two or more dots inside their names. I supposed they to cause the problem so I cancelled them from the yabbse messages and attachments dir and converted again.
The result don't changed at all: error log from lines 826 and 827 or no size to have images showing under the messages. I still have the doubt that other attachments files have something bad in their nemes for the converter to work correctly.

I suppose getimagesize can work as a standalone query but I'm not able to do such things with php.

Any tips to have everything (including getimagesize) working while converting and to have attachments showed under the messages?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on April 21, 2007, 02:26:24 AM
The error you got was an error with the .sql file and not the convert.php file.  With you commenting out those lines it diables the converter from running the PHP snippets inside the .sql file.  What convert.php and .sql are you using?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Marcosms on April 21, 2007, 06:23:08 PM
The second .sql of this topic and the converter of the downloads.
You mean there is a malfunction danger due to the exclusion of the two lines?
What kind of malfunction?

In the meantime I managed to have everything working another way. Not so many attachments so I copied manually widhts and lenghts in the mysql table. Now everything is working right and I'm happy with smf. Hard work for me to convert but for sure it's my fault.


Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on June 12, 2007, 09:37:34 PM
Greetings,

I'm using convert.php from the downloads area, and the .sql script from this topic (the 2nd follow-up attachment).

Here is the code and error I am receiving:


     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 `my_forums`.smf_members AS mem
    LEFT JOIN `my_forums`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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


There is a memberGroup column defined in the members table of the yabb SE db.

Any insight on this would be greatly appreciated  :)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on June 20, 2007, 04:30:40 AM
Quote from: endurics on June 12, 2007, 09:37:34 PM
Greetings,

I'm using convert.php from the downloads area, and the .sql script from this topic (the 2nd follow-up attachment).

Here is the code and error I am receiving:


     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 `my_forums`.smf_members AS mem
    LEFT JOIN `my_forums`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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


There is a memberGroup column defined in the members table of the yabb SE db.

Any insight on this would be greatly appreciated  :)


OK, I believe the moderator is away for the time being, is there anyone else that can assist?  It has now become a situation of moderate desperation !

Would it help to state publicly that there is no bigger SMF fan on the planet than myself?  ;)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: cspeech19 on July 21, 2007, 04:27:51 AM
is it too late to convert 1.5.5 to SMF?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: mysiar1 on August 04, 2007, 11:23:46 AM
thanks JayBachatero for the updated SQL file
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 11, 2007, 01:36:52 PM
enduris and cspeech so you still need help?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 15, 2007, 10:00:47 PM
Quoteenduris and cspeech so you still need help?

Hi Jay,

Yes, I still need some assistance please, thanks.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 15, 2007, 10:07:32 PM
Can you post the structure of the members table?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 15, 2007, 11:22:15 PM
OK, I have attached a PDF printout from phpMyAdmin.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 16, 2007, 12:13:51 AM
After taking a second look I noticed that the prefix is being set to smf_.  Can you check in your Settings.php file for YaBB SE for the $db_prefix.  Tell me what is it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 16, 2007, 01:40:50 AM
QuoteCan you check in your Settings.php file for YaBB SE for the $db_prefix.

Well I can tell you without looking that the prefix for all of the tables that I exported (including members) is "forum_"

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 16, 2007, 02:20:13 AM
Ok but what is the setting in the Settings.php file?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 17, 2007, 12:40:28 AM
QuoteOk but what is the setting in the Settings.php file?

You are referring to the YaBB SE Settings.php file, correct?

This is actually an export from a multi-board version of YaBB SE, so $db_prefix is a variable that is set dynamically.

One question I have though: How does the converter know which db to find the YaBB SE tables in?  I know that the db has to exist on the same MySQL server as the SMF installation, but our server has many db's on it.

The first error I actually receive when running the converter is this:

Quote
Caused the error:

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

So now, I am wondering if we have extra columns in the YaBB SE members table that is causing the converter to error out?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 17, 2007, 02:39:02 AM
Try running upgrade.php instead.  SMF is able to upgrade certain versions of YaBB SE.  Download the upgrade package.  Change the prefix in the SMF Settings.php file to the yabb se prefix and upgrade.  Do a backup first though.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 17, 2007, 03:02:41 PM
QuoteTry running upgrade.php instead.  SMF is able to upgrade certain versions of YaBB SE.  Download the upgrade package.  Change the prefix in the SMF Settings.php file to the yabb se prefix and upgrade.  Do a backup first though.

Hi Jay,

I ran across this old post (http://www.simplemachines.org/community/index.php?topic=41128.0), and this looks like the exact problem we are experiencing.

I have been trying to convert our YaBB SE data directly into SMF 1.1.3.  Instead, is this the process I should follow:

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 19, 2007, 04:17:42 AM
OK, problem solved!

Convert.php worked with the .sql file found in this topic (the second posting), but only after I hardcoded in the "from" (or source) database in convert.php.  The problem was that the script was not detecting the database where my YaBB SE tables were.

The only problem I have noticed so far is that membergroups did not all get converted.  This particular  YaBB SE board had several custom member groups, and the custom groups did not make the transition.

But other than that, members, boards and posts look great, converted straight into SMF 1.1.3  :)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on August 20, 2007, 10:26:08 AM
Since you just had a backup the Settings.php from YaBB SE was not found.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: endurics on August 20, 2007, 07:46:05 PM
QuoteSince you just had a backup the Settings.php from YaBB SE was not found.

Yes, that makes sense.

There was another issue I should note here: When non-Admin members logged in to the new SMF forum, they did not have access to any of the boards (basically they saw news items and stats, that's about it).  The forum Admin had to reset all of their passwords to something new, and when they logged back in, they had full access.

I am not sure, but this might be related to the fact that the YaBB SE membergroups did not get converted?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 12, 2007, 09:10:17 PM
QuoteConvert.php worked with the .sql file found in this topic (the second posting), but only after I hardcoded in the "from" (or source) database in convert.php.  The problem was that the script was not detecting the database where my YaBB SE tables were.

can someone please point exactly where the "from" or source in convert.php file as there are many instances of this word in the convert.php file.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 13, 2007, 02:07:58 AM
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";'); is what you are looking for.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 13, 2007, 04:56:20 AM
Thanks for the reply Jay!  but i'm still encountering errors and installation is unsuccessful.  i got these errors

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of YaBB SE 1.5.x. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: No database selected

Notice: Undefined index: don_bosco.sql in /home/donbosco/public_html/convert.php on line 343

$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');

all i have is a backup of my database.  and what i did is change 'from_prefix' to 'don_bosco.sql'.  is this correct?  that's the filename of my backup exported from a yabbse remote hosting forum.

just a newbie here, so a step by step solution is needed  ;D
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 13, 2007, 10:44:57 AM
Actually no that's not correct.  You need to import the backup back to the database and then run the converter.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 13, 2007, 02:58:10 PM
just did that Jay, imported the backup and run the converter.  the error was

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


how do i edit this line based on endurics post?

$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 13, 2007, 05:24:21 PM
That's a different issue.  What version of YaBB SE do you have?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 13, 2007, 05:48:02 PM
no idea, i'm assuming it's 1.5.5  :D  i've got my backup database from Boardnation, a remote forum hosting, now owned by endurics.   and from his post here, he said he managed to convert a backup of yabbse to smf.  the instructions he emailed me was

"I had to edit convert.php and put in the source database name.  So, just open up convert.php and edit the line that says "source" or "from" with  your database name."  which is basically what he posted here.  but i don't know what part of the convert.php to edit and what to put in that part of code.. 

help please  :(
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 13, 2007, 10:40:40 PM
If the backup is not too big send me an email with it and I'll take a look into it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 01:51:15 AM
it's 3MB.  is it ok?  pls pm me your email add.. 

Thanks again, Jay
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 01:56:32 AM
Yes that's ok.  lilj625@gmail.com
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 04:32:31 PM
database sent, it's actually a 3Mb archived.. 
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 04:51:46 PM
Ok just looked at the backup and the column is there in the backup.  Check in phpMyAdmin if you see the im_email_notify column is there.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 06:32:30 PM
Hi Jay,

there is no im_email_notify column, or i might not be searching hard enough.  or i don't know where to look at   :(

i've posted the screenshot of phpmyadmin,..
http://www.donboscoforum.com/ScreenHunter_01%20Nov.%2015%2012.28.jpg (http://www.donboscoforum.com/ScreenHunter_01%20Nov.%2015%2012.28.jpg)
http://www.donboscoforum.com/ScreenHunter_02%20Nov.%2015%2012.28.jpg (http://www.donboscoforum.com/ScreenHunter_02%20Nov.%2015%2012.28.jpg)

thanks
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 08:20:12 PM
Image links are broken.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 08:22:35 PM
opppsss.. fixed.. pls check them again.. 
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 09:41:22 PM
It's inside the members table.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 09:44:17 PM
found it!  there's im_email_notify

http://www.donboscoforum.com/ScreenHunter_03 Nov. 15 15.46.jpg (http://www.donboscoforum.com/ScreenHunter_03Nov.1515.46.jpg)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 10:07:06 PM
Ok I don't get why it's giving that error.  Can you try it again?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 14, 2007, 10:14:03 PM
even endurics got that error but he managed to fixed it.  i'll give it another try..  do i have to do a fresh reinstall of smf and reupload my yabbse database?

i just tried converting it again but same error

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 `donbosco_smf`.smf_members AS mem
    LEFT JOIN `donbosco_smf`.smf_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

    Unknown column 'mem.im_email_notify' in 'field list'
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 14, 2007, 11:05:33 PM
Ok I see the issue.  What is the prefix of the SMF tables?  The prefix seems to be the issue.  Needs to be forum not smf.

$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Should be.
$from_prefix = eval('`donbosco_smf`.forum_');
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 03:21:14 AM
got this error

Parse error: syntax error, unexpected $end in /home/donbosco/public_html/convert.php(343) : eval()'d code on line 1
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 03:30:31 AM
Must have replaces something else while doing this.  Redownload the file.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 05:38:13 AM
Quote from: JayBachatero on November 14, 2007, 11:05:33 PM
Ok I see the issue.  What is the prefix of the SMF tables?  The prefix seems to be the issue.  Needs to be forum not smf.

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

if i use forum as prefix of the smf tables, i then get an error. 

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 12, 2007 at 12:12 AM
-- Server version: 4.1.20
-- PHP Version: 4.3.9
--
-- Database: `db_dumps`
--
-- --------------------------------------------------------
--
-- Table structure for table `forum_banned`
--
CREATE TABLE `forum_banned` (
`type` tinytext NOT NULL ,
`value` tinytext NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1050 - Table 'forum_banned' already exists



i just did another reinstall.  fyi, database name is donbosco_smf and prefix is smf_

is this line still ok to use?

$from_prefix = eval('`donbosco_smf`.forum_');

thanks for your efforts, man..  it's just getting frustrating on my part...  >:(
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 11:09:16 AM
Where do you have smf installed and yabb se?  In the same database?

If you want pm me ftp info and accedd to phpmyadmin.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 01:45:20 PM
Hi!

I have them on the same database.  check your messages..

thanks heaps, mate!

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 02:05:28 PM
I'll look at it when I get home tonight :).
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 02:36:27 PM
thanks, mate!   :D
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 06:12:31 PM
Ok I imported the backup again.  Upload the convert.php and use
$from_prefix = '`donbosco_smf`.forum_'; as the prefix.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 06:52:58 PM
can you please do the conversion so that you could see the errors being generated.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 06:54:28 PM
Upload the convert.php and I'll do it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 06:59:11 PM
uploaded convert.php and yabbse_to_smf.sql

thanks!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 08:00:10 PM
Alright I'm the the train on my way home so I'll do it in a bit.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 08:26:53 PM
All set and done.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: ajg on November 15, 2007, 09:23:52 PM
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!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on November 15, 2007, 09:41:06 PM
You didn't import the backup and I changed the prefix also.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SanderF1 on December 09, 2007, 10:53:53 AM
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???
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on December 09, 2007, 11:36:51 PM
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.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: d.drenth on December 28, 2007, 07:46:15 PM
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
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on December 29, 2007, 01:05:30 AM
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.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: d.drenth on December 29, 2007, 05:50:21 AM
Quote from: SleePy on December 29, 2007, 01:05:30 AM
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.


Quote
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?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: d.drenth on December 29, 2007, 07:51:09 AM
The forum is upgraded to 1.5.5, the upgrade to SMF gives same errors as post before.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on December 30, 2007, 11:38:28 AM
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?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 15, 2008, 10:46:54 AM
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?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 16, 2008, 09:09:00 AM
can anyone help me????
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 16, 2008, 09:10:24 AM
Can any one help me?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 17, 2008, 12:25:14 AM
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.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 17, 2008, 10:16:21 AM
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...
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 17, 2008, 11:00:28 AM
Ok I nuked everything and started over.  I am getting this error now:

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'

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 17, 2008, 11:18:10 AM
I have tried pretty much everything in this post and can't get it to work....

QuoteUse 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:

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'
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 17, 2008, 12:28:45 PM
When I use the sql file from this post i get,

Internal Server Error

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

Please contact the server administrator, webmaster@forums.jbmaudio.com 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
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 20, 2008, 08:44:25 PM
Hello?  This is a support forum right?  Anyone out there?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 20, 2008, 11:12:03 PM
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.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 21, 2008, 09:22:00 AM
The supermod database is named:

jbmaudio.yabbse

The prefix for supermod tables is:

yabbsm

The Simple Machines database is  named:

jbmaudio.smf1

the prefix for my simple machines tables are:

smf


I hope this helps
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 22, 2008, 03:49:53 AM
Ok do this.

Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 23, 2008, 04:01:25 PM
QuoteOk do this.

Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';

Ok I made that change and now I get the following error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of YaBB SE 1.5.x. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'jbmaudio_smf1'@'localhost' for table 'yabbsm_members'


I went back to the orginal convert.php and got this error:

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

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

Caused the error:

    Unknown column 'lastUpdated' in 'field list'



Any suggestions
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 23, 2008, 04:09:35 PM
Keep the change and look at Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 23, 2008, 04:31:10 PM
I did this, i have added the user to both databases.  it can access it the data base when i use the original covert.php.  why can't it access it with the modified one?  The SMF user has all privileges for my supermod database so why would i be getting this error?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 23, 2008, 04:41:00 PM
(http://www.jbmaudio.com/Assets/users.JPG)

as you can see my smf user is on all of my databases.  Unless I am not understanding what you are saying.

Just incase you can't see the image

Click here (http://www.jbmaudio.com/Assets/users.JPG) for a bigger copy
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 23, 2008, 05:16:29 PM
What permissions did you give to that user on that database though?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 23, 2008, 06:38:24 PM
all privileges.  the user should have total access
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 23, 2008, 06:50:31 PM
Is it possible for you to PM me access to your site or can you contact me on IM?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 24, 2008, 10:09:29 AM
sent you an IM
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JasonMonette on January 27, 2008, 12:04:11 PM
Jay you out there?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: JayBachatero on January 27, 2008, 07:57:19 PM
I'm here now. Just got your IM.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: dig7er on May 17, 2008, 04:30:28 AM
Hello! We're trying to convert our YaBB SE 1.5.5 installation to SMF. With the converter on the site we couldn't do it. There were some errors. After we tried yabbse_to_smf.sql which one can get in this topic it worked! But all our messages on the new SMF are like "???????? ?????". Obviously we are experiencing problems with the encoding. Actually the encoding on the YaBB SE is windows-1251 (cp1251) and database encoding and collation is latin1. Any ideas on how can we convert messages so they stay like normal messages and not question marks?

Appreciate your help!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on May 17, 2008, 05:49:54 PM
Are you using the convert.php script linked in the first post of this topic?

That one has a convert.php that lets you choose your SMF encoding. Choose UTF-8 for it and it should hopefully convert things correctly.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: dig7er on May 18, 2008, 10:21:48 AM
Thank you for your reply, but i don't see convert.php in the first post.

I found convert.php in the neighbour-topic "[SMF Converter] Yabb - 2.1", but it didn't help with my problem :(
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on May 18, 2008, 09:47:25 PM
Ohh, sorry thank you. I fixed it

Quote
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: dig7er on May 20, 2008, 05:00:32 AM
Looks like it worked! Thank you very much for such a wonderful support, SleePy!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: TheRealWaldo on June 18, 2008, 11:07:51 AM
The convert.php link links to http://www.simplemachines.org/community/index.php?topic=140741.0 which links back to here.... circular... Where can I get this convert.php file?

W.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: TheRealWaldo on June 18, 2008, 11:10:25 AM
Scratch that, a little confusing, but the file was actually attached at the end of that linked thread, but not visible at all if you aren't logged in.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: TheRealWaldo on June 18, 2008, 11:19:45 AM
I get the error:

Fatal error: Cannot redeclare ip2range() (previously declared in /home/nwrsuser/public_html/convert.php(910) : eval()'d code:1) in /home/nwrsuser/public_html/convert.php(913) : eval()'d code on line 20

Suggestions?

W.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on June 18, 2008, 03:29:14 PM
Reupload the file. It sounds like it is corrupted :|

It might actually be easier, since you are using YaBB SE, to just get the large upgrade package from the downloads page. Since SMF came form YaBB SE the upgrade package was designed so it should work all the way from YaBB SE.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: TheRealWaldo on June 18, 2008, 04:56:01 PM
Re-downloaded and re-uploaded several times, confirmed file is identical to what was downloaded.  It appears the code itself is redeclaring a function it already declared.

I'm using fantastico, I don't think that package will suit my needs as SMF is already installed.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: TheRealWaldo on June 18, 2008, 05:04:00 PM
I confirmed this as the problem, and edited the attached SQL file as follows:

Line 490, added

if (!function_exists('ip2range')) {

and 511, added

}

So now the before the function is redeclared, a check to see if it is already declared is run first.

It executes without problems after those changes.

W.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Neplug on July 12, 2008, 01:55:57 PM
On this moment I try to convert a forum of my wife. Its a Yabbse forum and I use the files from here and became the follow error(I'm convert in a test site)

Converting...
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... Successful.
Converting activity logs... Successful.
Converting banning logs... Successful.
Converting mark as read history... Successful.
Converting karma logs... Successful.
Converting topic view logs... Successful.
Converting moderators... Successful.
Converting banned members... Unsuccessful!
This query:
INSERT INTO `ps4fun_forum`.smf_ban_groups
(name, ban_time, expire_time, cannot_access, reason, notes)
VALUES ('yabbse_bans', 1215886152, NULL, 1, '', 'Imported from YaBB SE';
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3


What's going wrong and what can I do?
I'm just a simple user.
Please help
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on July 12, 2008, 04:15:05 PM
The attached one should fix that :)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Neplug on July 12, 2008, 04:39:11 PM
Quote from: SleePy on July 12, 2008, 04:15:05 PM
The attached one should fix that :)
Thanx this problem are fixed. Do you have more solutions  :)

Now I become this error:

Converting banned members... Successful.
Converting calendar events... Successful.
Converting membergroups... Successful.
Converting basic settings... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `ps4fun_forum`.smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: SleePy on July 12, 2008, 05:05:53 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Neplug on July 13, 2008, 03:03:36 AM
Quote from: SleePy on July 12, 2008, 05:05:53 PM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Thanks, everything was successfully. Now can my wife test the functionality and change the layout.

Thanks very much
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: pospelov on December 04, 2009, 02:14:56 AM
Hello.
I convert YaBB SE 1.5.5 to SMF 2.0 RC2
File used http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc2_yabbse_converter.zip
I have problem:

Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/mydomen/convert.php on line 1295

-////-

Warning: array_keys() [function.array-keys]: The first argument should be an array in  /home/mydomen/convert.php on line 1295

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in  /home/mydomen/convert.php on line 2635

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/mydomen/convert.php on line 2635

Warning: Invalid argument supplied for foreach() in  /home/mydomen/convert.php on line 2647

Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in  /home/mydomen/Sources/Subs-Db-mysql.php on line 641

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3

Help me, please!

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: Norv on December 04, 2009, 11:52:43 AM
Please, try using the attached file, instead.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: mikemotors on January 01, 2010, 08:53:31 AM
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'
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: console65 on March 21, 2010, 06:18:13 PM
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.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 04, 2019, 08:15:50 PM
Is there a converter for YaBB SE 1.5.5 to SMF 2.0/SMF 2.1?

I have an old forum YaBB SE 1.5.5 that I want to upgrade to SMF.

I have installed the SMF 2.0 successfully. YaBB SE is also installed on the same server. I make sure that both the SMF and YaBB SE share the same database user so that the converter at public_html/smf/convert.php is able to access both the SMF and YaBB databases.

I downloaded the converter from this link:

https://download.simplemachines.org/?converters;software=yabbse

It did not state which version of YaBB SE it is designed to convert.  I tried it anyway but was unsuccessful.  I tested with PHP 5.2 ( YaBB SE 1.5.5 only works with this PHP version ), 5.3 (YaBB SE starts to fail), 5.4, 5.5, 5.6 and 7.0. 

It appears that SMF 2.0 requires >= PHP 5.4 but YaBB SE can only runs on PHP <= 5.2

When I ran the convert.php on PHP 7.0 I got the following errors:

Converting...
Converting members...
------------------------------------------------------
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/xxxxxx/public_html/smf/convert.php on line 2499
Fatal error: Uncaught Error: Call to undefined function mysql_errno() in /home/xxxxxx/public_html/smf/convert.php:2500 Stack trace: #0 /home/xxxxxx/public_html/smf/convert.php(1248): convert_query('SELECT\n\tmem.id_...') #1 /home/xxxxxx/public_html/smf/convert.php(51): doStep1() #2 {main} thrown in /home/xxxxxx/public_html/smf/convert.php on line 2500

When I ran the convert.php on PHP 5.2 convert.php shows the following errors:

Parse error: syntax error, unexpected T_FUNCTION in /home/xxxxxx/public_html/smf/Sources/Subs.php on line 1271

On PHP 5.3 it shows a blank screen with no message.  On PHP 5.4, 5.5 & 5.6 it throws the following errors:

Converting...
Converting members...
Warning: mysqli_error(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/xxxxxx/public_html/smf/convert.php on line 2499

Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/xxxxxx/public_html/smf/convert.php on line 2499
Unsuccessful!
This query:

    SELECT
    mem.id_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
    mem.date_registered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.website_title, 1, 255) AS website_title,
    SUBSTRING(mem.website_url, 1, 255) AS website_url, mem.last_login,
    mem.birthdate, SUBSTRING(mem.icq, 1, 255) AS icq,
    SUBSTRING(IFNULL(mem.real_name, mem.member_name), 1, 255) AS real_name,
    mem.notify_once AS notify_once, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.email_address, 1, 255) AS email_address,
    SUBSTRING(mem.aim, 1, 16) AS aim,
    SUBSTRING(mem.personal_text, 1, 255) AS personal_text,
    SUBSTRING(mem.time_format, 1, 80) AS time_format,
    mem.hide_email, SUBSTRING(mem.member_ip, 1, 255) AS member_ip,
    SUBSTRING(mem.member_ip, 1, 255) AS member_ip2,
    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.time_offset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    mem.im_email_notify AS pm_email_notify, mem.karma_bad, mem.karma_good,
    mem.notify_announcements,
    SUBSTRING(mem.secret_question, 1, 255) AS secret_question,
    IF(mem.secret_answer = '', '', MD5(mem.secret_answer)) AS secret_answer,
    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 message_labels, '' AS validation_code, '' AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `xxxxxx_yabbse`.yabbse_members AS mem
    LEFT JOIN `xxxxxx_yabbse`.yabbse_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

It seems like I have not been able to move beyond the Member conversion. Anyone has an answer?

P/S. We would be happy to pay for help if need be for someone to help convert our YaBB SE 1.5.5 forum to SMF 2.0 or 2.1.

Thanks!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 04, 2019, 08:24:47 PM
Try this one for new versions of PHP
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/Yabbse/1.5
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 04, 2019, 10:36:36 PM
Thanks for the quick reply on a Sunday! (I wasn't too hopeful given that the last post was a long time ago).

I have downloaded the "convert.php" and "yabbse_to_smf.sql" from the given link. I got essentially the same error message after trying on PHP 5,4, 5.6 and 7.0:

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

    SELECT
    mem.id_member, SUBSTRING(mem.member_name, 1, 80) AS member_name,
    mem.date_registered, mem.posts, SUBSTRING(mem.passwd, 1, 64) AS passwd,
    SUBSTRING(mem.website_title, 1, 255) AS website_title,
    SUBSTRING(mem.website_url, 1, 255) AS website_url, mem.last_login,
    mem.birthdate, SUBSTRING(mem.icq, 1, 255) AS icq,
    SUBSTRING(IFNULL(mem.real_name, mem.member_name), 1, 255) AS real_name,
    mem.notify_once AS notify_once, REPLACE(mem.lngfile, '.lng', '') AS lngfile,
    SUBSTRING(mem.email_address, 1, 255) AS email_address,
    SUBSTRING(mem.aim, 1, 16) AS aim,
    SUBSTRING(mem.personal_text, 1, 255) AS personal_text,
    SUBSTRING(mem.time_format, 1, 80) AS time_format,
    mem.hide_email, SUBSTRING(mem.member_ip, 1, 255) AS member_ip,
    SUBSTRING(mem.member_ip, 1, 255) AS member_ip2,
    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.time_offset,
    SUBSTRING(mem.avatar, 1, 255) AS avatar,
    SUBSTRING(mem.usertitle, 1, 255) AS usertitle,
    mem.im_email_notify AS pm_email_notify, mem.karma_bad, mem.karma_good,
    mem.notify_announcements,
    SUBSTRING(mem.secret_question, 1, 255) AS secret_question,
    IF(mem.secret_answer = '', '', MD5(mem.secret_answer)) AS secret_answer,
    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 message_labels, '' AS validation_code, '' AS additional_groups,
    '' AS smiley_set, '' AS password_salt
    FROM `xxxxxx_yabbse`.yabbse_members AS mem
    LEFT JOIN `xxxxxx_yabbse`.yabbse_membergroups AS mg ON (mg.membergroup = mem.memberGroup)
    LIMIT 0, 500;

Caused the error:

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

Except that this time it did report the cause of error which is 'mem.member_name' in 'field list' being unknown.  There are member_name field in both YaBB SE and SMF databases but why is there a prefix of "mem." which caused the issue?

Thanks again!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 04, 2019, 10:48:42 PM
can you do a sql command
describe yabbse_members;

On your yabbse members table or do show create table  tablenamehere;
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 04, 2019, 11:20:32 PM
Attached is the screen shot after running the SQL command "describe yabbse_members;"

Thanks.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 04, 2019, 11:24:59 PM
Try using this sql file in this post instead
https://www.simplemachines.org/community/index.php?topic=140776.msg905770#msg905770

Use with the new convert.php
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 04, 2019, 11:49:27 PM
Thanks again.

This time it seems to proceed to try to copy members from YaBBSE to SMF but failed again. The whole error message is too long to list and contains some user data which I list only as **************


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

    INSERT INTO `xxxxxx_smf`.smf_members
    (ID_MEMBER, memberName, dateRegistered, posts, passwd, websiteTitle, websiteUrl, lastLogin, birthdate, ICQ, realName, notifyOnce, lngfile, emailAddress, AIM, personalText, timeFormat, hideEmail, memberIP, memberIP2, YIM, gender, MSN, signature, location, timeOffset, avatar, usertitle, pm_email_notify, karmaBad, karmaGood, notifyAnnouncements, secretQuestion, secretAnswer, ID_GROUP, buddy_list, pm_ignore_list, messageLabels, validation_code, additionalGroups, smileySet, passwordSalt)

**************
**************
Caused the error:

    Unknown column 'memberName' in 'field list'


I then ran the SQL command "describe smf_members;" and got the attached screen shot. So it seems like this "convert.php" file is trying to specify the "member_name" on the smf as "memberName" which is what it got for the YaBB SE.  Essentialy the error appears to be that YaBB SE 1.55 is using different field name than the SMF in the database?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 04, 2019, 11:54:06 PM
Ok yeah looks like major changes need to be made to the sql to get it to work properly...will have time tomorrow to look into it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 05, 2019, 02:25:45 AM
Thanks again for your advise. Based on what you described I am beginning to understand what caused the conversion problem:

Basically the convert.php and the yabbse_to_smf.sql for the YaBBSE 1.5.x can only be converted to SMF version 1.1 and not to version 2.x because for some reason SMF decided to change the database field names such as "memberName" in version 1.1 to "member_name" in version 2.x and the converter could not handle the change.

I decided to install SMF version 1.1 and activated PHP version 5.4. I then use the convert.php and the yabbse_to_smf.sql in this link you provided:

https://www.simplemachines.org/community/index.php?topic=140776.msg905770#msg905770

I did have to comment out a section of the convert.php that references 'SQL_MAX_JOIN_SIZE'   as described in this post: http://www.simplemachines.org/community/index.php?topic=528263.0 in order for the conversion to work.

In the end I managed to convert the YaBB SE 1.5.5 forum to SMF 1.1 using the above steps.  That is great! 

I next have to figure out how to upgrade SMF 1.1 to SMF 2.0 because SMF 1.1. would not run on PHP 7.0. I hope it won't give me as much problem.

Once again thanks for the great help. Good night.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 05, 2019, 07:41:42 AM
Glad you figured it out. Yes it was the case of SMF changing some variables adding a _ to make a space to the names. Going to SMF 2.0.x is easy though.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 05, 2019, 10:25:20 AM
Just noticed that although all messages and members were posted correctly from YaBBSE 1.5.5 to SMF 1.1, all the attachments in the messages in YaBBSE posts were lost.

I tried to re-do the conversion again by re-installing the SMF 1.1 database and ensure that all attachment are allowed from admin. The conversion was completely successful but the attachment were still lost. The conversion message is shown below in brown.

I have used the attached convert.php and yabbse_to_smf.sql to do the conversion. I found that there was mention of the attachment conversions inside the yabbse_to_smf.sql file but there was still no attachment.

Is this expected or is there something else that need to be done to convert the attachment as well? Many of these attachments are quite valuable and since there are more than 8000 messages in the old forum it is not quite practical to manually restore them.

Thanks for any advise.


YaBB SE 1.5.x to SMF Converter
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
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.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the YaBB SE 1.5.x installation.

We hope you had a smooth transition!
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 05, 2019, 11:10:39 AM
Do you see the attachments in your smf's attachments folder
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 05, 2019, 11:27:17 AM
No the only file in the SMF attachments folder is "index.php" and there is no other files.

I noticed that in YaBBSE the attachments are captured by the "attachmentFilename" field in the yabbse_messages table . But on SMF 1.1, the table  "smf_messages" there isn't such a field. How is an attachment info linked to a message in SMF 1.1?
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 05, 2019, 11:31:06 AM
is your smf_attachments table filled with entries.

If so copy your attachments from yabbse to your smf attachments folder.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 05, 2019, 11:40:51 AM
No. Strangely  the smf_attachments table is completely empty. I have attached the screen shot.

Thanks.

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 05, 2019, 04:16:08 PM
For some reason the screen shot was not attached in the last post. Here it is.

I tried to create a post in my new SMF 1.1 forum with an attachment and sure enough the entry showed up in the smf_attachments table with all the relevant fields. I then ran the convert.php again to re-do the conversion. After conversion the smt_attachments table again showed blank. So the conversion process wiped out the new post that I created with the attachment. I guess the convert.php somehow did not manage to convert the attachment in YaBBSE. 
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 05, 2019, 11:04:45 PM
See if this attached file does anything...
I saw the conversion stopped at Converting topic notifications... Successful.
And didn't do any steps after from your log

It just does the steps after the first one
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 06, 2019, 12:04:11 PM
Tried that and got the following errors:

Converting...
Converting attachments...
Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/automa11/public_html/smf/convert.php(1109) : eval()'d code on line 13

Fatal error: Call to undefined function getAttachmentFilename() in /home/automa11/public_html/smf/convert.php(1109) : eval()'d code on line 13

Anyway we have decided to manually transfer the attachment info (attachmentFilenaame, attachmentSize, ID_MSG and and ID_MEMBER) from yabbse_massages table to the smf_attachments. Fortunately only several hundreds of the posts have attachment and it took a few hours of manual labor to do that. But now we got a converted SMF 1.1. forum that is more or less complete and will next try to convert from 1.1 to 2.0.

I wonder if the large upgrade installer posted at:  https://download.simplemachines.org/  is meant for upgrading from 1.1 to 2.0.15? Or is it meant for an upgrade from one version of 2.0.xx to 2.0.15?  Since the conversion from YaBBSE to SMF 1.1 was quite a struggle we are hoping not to encounter similar difficulties when upgrading from 1.1. to 2.0.15.

Thanks.

Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: vbgamer45 on August 06, 2019, 12:13:12 PM
yes it is meant to go from 1.1 to 2.0.x
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 06, 2019, 12:47:13 PM
Thanks for the confirmation. We will work on it.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 06, 2019, 02:00:36 PM
We have upgraded from 1.1. to 2.0. We are glad to report that the upgrade proceeded smoothly without any hiccup. The upgraded SMF 2.0 has all the topics and posts.

However, the attachment issue came back up again. Although the posts show the attachment file name and file type but when I click on the attachment it returns a "404 - Attachment Not Found".  The same attachment was available when in SMF 1.1. I check that there are still lots of files in the public_html/smf/attachments folder but the forum is unable to locate it.

Comparing the smf_attachments table between 1.1 and 2.0 (see attached) show that aside from the column heading changes SMF 2.0 added more columns in the table. e.g. There was no fileext column in 1.1 but now there is in 2.0. There is no file_hash in those entries because it was manual input (when upgrading from YaBBSE to SMF 1.1). It did work in 1.1.

I tried to remove the extension from the file name itself (e.g. I renamed "numerical_code_tube1.png" in the "filename" column to "numerical_code_tube1" thinking that maybe SMF2.0 would append the file extension to the actual filename but that did not help either.

In the end I examined the files in the public_html/smf/attachments on the server and realized that a number of files that were in that folder were deleted by the SMF upgrader during the upgrade from 1.1 to 2.0.  The attachment that I clicked on happened to be the one that was deleted.

I then copied the original files from my yabbse/attachments folder to the smf/attachments and now the forum is able to serve up those files.

In other words for some reasons SMF upgrade.php decided that some of those files in the smf/attachments should be deleted during the upgrade. However there was no report of this actions and it is fortunate that we notice it during the testing.

Was that a know deliberate action by the upgrader or is that a bug?

Thanks.
Title: Re: [SMF Converter] YaBB SE 1.5.4
Post by: trilogi on August 06, 2019, 02:28:20 PM
I just realized that the attachments only showed up when I logged in as the forum administrator. When I logged in as a regular user (even at the highest level as a moderator but is not Admin) the message board  still does not show the attachments.

[Edit] Just found out that this need to be enabled by Admin and set the permission to view the attachment.