Advertisement:

Author Topic: [SMF Converter] YaBB SE 1.5.4  (Read 175791 times)

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #40 on: August 16, 2007, 01:40:50 AM »
Quote
Can 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_"

Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #41 on: August 16, 2007, 02:20:13 AM »
Ok but what is the setting in the Settings.php file?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #42 on: August 17, 2007, 12:40:28 AM »
Quote
Ok 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?
« Last Edit: August 17, 2007, 01:16:30 AM by endurics »
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #43 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #44 on: August 17, 2007, 03:02:41 PM »
Quote
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.

Hi Jay,

I ran across this old post, 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:

  • Install SMF 1.0.5
  • Run the YaBB SE converter
  • Run upgrade.php
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #45 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  :)
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #46 on: August 20, 2007, 10:26:08 AM »
Since you just had a backup the Settings.php from YaBB SE was not found.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline endurics

  • Semi-Newbie
  • *
  • Posts: 27
  • Gender: Male
  • A Board is a Terrible Thing to Waste.
    • Boardnation
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #47 on: August 20, 2007, 07:46:05 PM »
Quote
Since 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?
Boardnation - Since 2001, Free & Advanced Message Board Hosting Services

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #48 on: November 12, 2007, 09:10:17 PM »
Quote
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.

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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #49 on: November 13, 2007, 02:07:58 AM »
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";'); is what you are looking for.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #50 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

Code: [Select]
$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
« Last Edit: November 13, 2007, 05:26:58 AM by alving »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #51 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #52 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'] . '";');

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #53 on: November 13, 2007, 05:24:21 PM »
That's a different issue.  What version of YaBB SE do you have?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #54 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  :(
« Last Edit: November 13, 2007, 05:49:40 PM by alving »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #55 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #56 on: November 14, 2007, 01:51:15 AM »
it's 3MB.  is it ok?  pls pm me your email add.. 

Thanks again, Jay

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #57 on: November 14, 2007, 01:56:32 AM »
Yes that's ok.  lilj625@gmail.com
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline ajg

  • Semi-Newbie
  • *
  • Posts: 51
  • Gender: Male
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #58 on: November 14, 2007, 04:32:31 PM »
database sent, it's actually a 3Mb archived.. 

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] YaBB SE 1.5.4
« Reply #59 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert