Upgrading, is there any other way??

[Proenski]

Hi, currently I'm still using the YabbSE board 1.5.5 but I would like to upgrade to the latest SMF version.

However I would like to keep my YabbSE board running right up until the moment I make the switch.

Because we use our own design and other board/ site modifications we would like to get the new site up and running, test things etc. and then move on.

Also because I want to get rid of some errors that kinda sneaked into the old YabbSE application/ database.

So far I've been suggested that we should upgrade the excisting board but that would make the above impossible.

My question is simple; is there really no other way to import data from YabbSE into SMF?? Especially things like the board members, and boards/ threads.

Please let me know about every possible alternative.

Thank you!

Proenski

[Oldiesmann]

Yes there is actually. You can use the converter at http://www.simplemachines.org/download.php?converters to do it. This will leave your YaBB SE install intact for as long as you want.

[Proenski]

Ok, that sounds great! 

I got some further questions/ remarks (I'm not a programmer, just a user):

- I take it we need to install SMF and convert files from YabbSE to this install?
- As far as I understand PHP I think this convertor also converts threads and member accounts?

Just to ease my mind 

Thank you again!

[[Unknown]]

- I take it we need to install SMF and convert files from YabbSE to this install?

You have to install SMF first, yes... but you don't have to do anything complicated.

- As far as I understand PHP I think this convertor also converts threads and member accounts?

Yes, but it's not as good as upgrade.php, which I would recommend for the "final upgrade".

Just remember to backup.  Always backup.  Backup if you suspect the dog is coming in.  Just backup.

-[Unknown]

[Proenski]

Thanks again, I understand. Got SMF already up and running 



Backup you say?     

[Proenski]

One final question: I take it I need to upload the converter.php to the YabbSE source directory and run it?

And then answer questions about "source and target database" etc?

Thank you!

[Oldiesmann]

It should be uploaded to the SMF directory and run from there.

[Proenski]

Thanks I tried that but I get this error:

The database password you entered was incorrect. Please make sure you are using the right password (for the SMF user!) and try it again.

It seems simple however I am using the correct password. I even reset it to be 100% sure of this. 

[Oldiesmann]

Make sure the database settings in SMF's Settings.php are the same as the ones in YaBB SE's Settings.php (except for the database prefix, which should be different in SMF than in YaBB SE).

[Proenski]

Ok, I get the idea but can you please indicate what should be equal to eachother because I'm a little lost here. There are quite a few settings and SMF is structured different from YabbSE.

Code Select Expand

<?php
/******************************************************************************
* Settings.php                                                                *
*******************************************************************************
* SMF: Simple Machines Forum                                                  *
* Open-Source Project Inspired by Zef Hemel ([email protected])                *
* =========================================================================== *
* Software Version:           SMF 1.0                                         *
* Software by:                Simple Machines (http://www.simplemachines.org) *
* Copyright 2001-2005 by:     Lewis Media (http://www.lewismedia.com)         *
* Support, News, Updates at:  http://www.simplemachines.org                   *
*******************************************************************************
* This program is free software; you may redistribute it and/or modify it     *
* under the terms of the provided license as published by Lewis Media.        *
*                                                                             *
* This program is distributed in the hope that it is and will be useful,      *
* but WITHOUT ANY WARRANTIES; without even any implied warranty of            *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                        *
*                                                                             *
* See the "license.txt" file for details of the Simple Machines license.      *
* The latest version can always be found at http://www.simplemachines.org.    *
******************************************************************************/

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode'; # Title for the Maintenance Mode message.
$mmessage = 'Ok faithful users...we\'re attempting to restore an older backup of the database...news will be posted once we\'re back!'; # Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'depechemodeforum.com'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://www.depechemodeforum.com/board'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10'; # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'mysql1.depechemodeforum.com';
$db_name = 'dmforum_smf';
$db_user = 'proenski';
$db_passwd = 'example';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/.jasper/proenski/depechemodeforum.com/board'; # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/.jasper/proenski/depechemodeforum.com/board/Sources'; # Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 1128183639;

# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = dirname(__FILE__);
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = $boarddir . '/Sources';

?>

Code Select Expand

<?php
/*****************************************************************************/
/* Settings.php                                                              */
/*****************************************************************************/
/* YaBB SE: Yet another Bulletin Board Splinter Edition                      */
/* Open-Source Project inspired by Zef Hemel ([email protected])              */
/* Software Version:           YaBB SE 1.5.1                                 */
/* Software by:                The YaBB SE Development Team                  */
/* ========================================================================= */
/* Software Distributed by:    http://www.yabbse.org                         */
/* Copyright 2001-2003 by:     http://www.lewismedia.com (Lewis Media)       */
/* Support, News, Updates at:  http://www.yabbse.org/community               */
/* Inspired and Ported From:   http://www.yabbforum.com                      */
/*****************************************************************************/
/* This program is free software; you may redistribute it and/or modify it   */
/* under the terms of the provided license as published by Lewis Media.      */
/*                                                                           */
/* This program is distributed in the hope that it will be useful, but       */
/* WITHOUT ANY WARRANTY; without even the implied warranty of                */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the provided    */
/* license for more information.                                             */
/*                                                                           */
/* See license.txt for details of the YaBB SE license. The latest version    */
/* of this license can be found at the distributor's site seen above.        */
/*****************************************************************************/

########## Board Info ##########
# Note: these settings must be properly changed for YaBB to work

$maintenance = 0; # Set to 1 to enable Maintenance mode
$mtitle = "Maintenance"; # Subject for display
$mmessage = "Sorry, but this has to be done"; # Message Description for display

$guestaccess = 1; # Set to 0 to disallow guests from doing anything but login or register

$yyForceIIS = 0; # Set to 1 if you encounter errors while running on an MS IIS server
$yyblankpageIIS = 0; # Set to 1 if you encounter blank pages after posting (usually on MS IIS servers)

$language = "english.lng"; # Change to language pack you want to use
$mbname = "depechemodeforum.com"; # The name of your YaBB forum
$boardurl = "http://www.depechemodeforum.com/yabbse"; # URL of your board's folder (without trailing '/')

$Cookie_Length = 60; # Cookies will expire after XX minutes of person logging in (they will be logged out after)
$cookiename = "YaBBusername3791"; # Name of the cookie

$RegAgree = 1; # Set to 1 to display the registration agreement when registering
$emailpassword = 0; # 0 - instant registration. 1 - password emailed to new members
$emailnewpass = 0; # Set to 1 to email a new password to members if they change their email address
$emailwelcome = 1; # Set to 1 to email a welcome message to users even when you have mail password turned off

$mailprog = "/usr/sbin/sendmail"; # Location of your sendmail program
$smtp_server = "127.0.0.1"; # SMTP-Server
$webmaster_email = "[email protected]"; # Your e-mail address.
$mailtype = 0; # 0 - sendmail, 1 - SMTP

########## Database Info ##########
$db_name = "dmforum";
$db_user = "proenski";
$db_passwd = "example";
$db_server = "mysql.depechemodeforum.com";
$db_prefix = "dmforum_";

########## Directories/Files ##########
# Note: directories other than $imagesdir do not have to be changed unless you move things

$boarddir = "/home/proenski/depechemodeforum.com/yabbse"; # The absolute path to the board's folder (usually can be left as '.')
$sourcedir = "/home/proenski/depechemodeforum.com/yabbse/Sources"; # Directory with YaBB source files
$facesdir = "/home/proenski/depechemodeforum.com/yabbse/YaBBImages/avatars"; # Absolute Path to your avatars folder
$facesurl = "http://www.depechemodeforum.com/yabbse/YaBBImages/avatars"; # URL to your avatars folder
$imagesdir = "http://www.depechemodeforum.com/yabbse/YaBBImages"; # URL to your images directory
$ubbcjspath = "http://www.depechemodeforum.com/yabbse/ubbc.js"; # Web path to your 'ubbc.js' REQUIRED for post/modify to work properly!
$faderpath = "http://www.depechemodeforum.com/yabbse/fader.js"; # Web path to your 'fader.js'
$helpfile = "http://www.depechemodeforum.com/yabbse/YaBBHelp/index.html"; # Location of your help file


########## Colors ##########
# Note: equivalent to colors in CSS tag of template.html, so set to same colors preferrably
# for browsers without CSS compatibility and for some items that don't use the CSS tag

$color['titlebg'] = "#999999"; # Background color of the 'title-bar'
$color['titletext'] = "#FFFFFF"; # Color of text in the 'title-bar' (above each 'window')
$color['windowbg'] = "#E6E6E6"; # Background color for messages/forms etc.
$color['windowbg2'] = "#FFFFFF"; # Background color for messages/forms etc.
$color['windowbg3'] = "#8E8E8E"; # Color of horizontal rules in posts
$color['catbg'] = "#E6E6E6"; # Background color for category (at Board Index)
$color['bordercolor'] = "#444444"; # Table Border color for some tables
$color['fadertext']  = "#000000"; # Color of text in the NewsFader ("The Latest News" color)
$color['fadertext2']  = "#000000"; # Color of text in the NewsFader (news color)

########## Layout ##########

$MenuType = 0; # 1 for text menu or anything else for images menu
$curposlinks = 1; # 1 for links in navigation on current page, or 0 for text without link
$profilebutton = 1; # 1 to show view profile button under post, or 0 for blank
$timeformatstring = "%B %e, %H:%M"; # Select your preferred output Format of Time and Date
$allow_hide_email = 1; # Allow users to hide their email from public. Set 0 to disable
$showlatestmember = 1; # Set to 1 to display "Welcome Newest Member" on the Board Index
$shownewsfader = 0; # 1 to allow or 0 to disallow NewsFader javascript on the Board Index
# If 0, you'll have no news at all unless you put <yabb news> tag
# back into template.html!!!
$Show_RecentBar = 1; # Set to 1 to display the Recent Posts bar on Board Index
$Show_MemberBar = 1; # Set to 1 to display the Members List table row on Board Index
$showmarkread = 1; # Set to 1 to display and enable the mark as read buttons
$showmodify = 1; # Set to 1 to display "Last modified: Realname - Date" under each message
$ShowBDescrip = 1; # Set to 1 to display board descriptions on the topic (message) index for each board
$showuserpic = 1; # Set to 1 to display each member's picture in the message view (by the ICQ.. etc.)
$showusertext = 1; # Set to 1 to display each member's personal text in the message view (by the ICQ.. etc.)
$showgenderimage = 0; # Set to 1 to display each member's gender in the message view (by the ICQ.. etc.)
$showyabbcbutt = 1; # Set to 1 to display the yabbc buttons on Posting and IM Send Pages

########## Feature Settings ##########

$enable_ubbc = 1; # Set to 1 if you want to enable UBBC (Uniform Bulletin Board Code)
$enable_news = 1; # Set to 1 to turn news on, or 0 to set news off
$allowpics = 1; # set to 1 to allow members to choose avatars in their profile
$enable_guestposting = 0; # Set to 0 if do not allow 1 is allow.
$enable_notification = 1; # Allow e-mail notification
$autolinkurls = 1; # Set to 1 to turn URLs into links, or 0 for no auto-linking.

$timeoffset = 8; # Time Offset (so if your server is EST, this would be set to -1 for CST)
$TopAmmount = 15; # No. of top posters to display on the top members list
$MembersPerPage = 35; # No. of members to display per page of Members List - All
$maxdisplay = 25; # Maximum of topics to display
$maxmessagedisplay = 40; # Maximum of messages to display
$MaxMessLen = 10000; # Maximum Allowed Characters in a Posts
$MaxSigLen = 75; # Maximum Allowed Characters in Signatures
$ClickLogTime = 60; # Time in minutes to log every click to your forum (longer time means larger log file size)
$max_log_days_old = 60; # If an entry in the user's log is older than ... days remove it
# Set to 0 if you want it disabled
$fadertime = 5000; # Length in seconds to display each item in the news fader
$timeout = 5; # Minimum time between 2 postings from the same IP


########## Membergroups ##########

$JrPostNum = 50; # Number of Posts required to show person as 'junior' membergroup
$FullPostNum = 100; # Number of Posts required to show person as 'full' membergroup
$SrPostNum = 250; # Number of Posts required to show person as 'senior' membergroup
$GodPostNum = 500; # Number of Posts required to show person as 'god' membergroup


########## MemberPic Settings ##########

$userpic_width = 65; # Set pixel size to which the selfselected userpics are resized, 0 disables this limit
$userpic_height = 65; # Set pixel size to which the selfselected userpics are resized, 0 disables this limit
$userpic_limits = "Please note that your image has to be <b>gif</b> or <b>jpg</b> and that it will be resized!"; # Text To Describe The Limits
?>

[Oldiesmann]

$db_name, $db_user, $db_passwd and $db_server should all be the same.

[Proenski]

$db_name, $db_user, $db_passwd and $db_server should all be the same.

Darn, my hosting provider (and I'm sure many, many others) requires a unique DB name and a unique DB server... Which in itself is very logical.

Any idea on how to work around this??

[Oldiesmann]

I didn't mean that all of them should be the same thing. I meant that they needed to be the same in both files. In this case, changing $db_name in SMF's Settings.php to dmforum should be enough.

[Proenski]

Ah, ok. I did exactly that but now I get two messages:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/.jasper/proenski/depechemodeforum.com/board/yabbse_to_smf.php on line 119

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/.jasper/proenski/depechemodeforum.com/board/yabbse_to_smf.php on line 120

and

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

The YabbSE version is 1.5.5 (latest) and SMF is 1.0.5 (to RC1 wouldn't work).

Any more suggestions?

[Oldiesmann]

1. Make sure that the converter is in your SMF directory.
2. Make sure you entered the right paths for SMF and YaBB SE

[Proenski]

1. Make sure that the converter is in your SMF directory.
2. Make sure you entered the right paths for SMF and YaBB SE

1) it is, right next to the Settings.php
2) they are correct:

/home/.jasper/proenski/depechemodeforum.com/board

/home/.jasper/proenski/depechemodeforum.com/yabbse

But I was thinking; isn't it logical that if I change the db name in the settings.php to be different than the actual name on the server that this is going to cause problems??