Advertisement:

Author Topic: [SMF Converter] Burning Board 3  (Read 82232 times)

ThorstenE

  • Guest
[SMF Converter] Burning Board 3
« on: January 19, 2009, 02:31:02 PM »
Software: Burning Board
Version: 3.0.x

This is the official support topic for Burning Board3 converter.  Use this topic to ask for support for this converter.

Note: This was tested on Burning Board 3, but should in theory work on other versions of  Woltlab Burning Board 3.x if the database changes have not been to great.

wbb3_migration.php
For the conversion to be able to complete, the wbb3_migration.php file is required. You will need to modify this file to reflect your Database name and Database prefix and upload to your Burning Board directory.

Does Not Convert
  • Permissions (This might not be supported at all so please check permissions before making the board live.  Everything will be admin only for board access.)
  • Membergroups

Password Support
Burning Board 3 has their own custom password hash so you need to edit LogInOut.php to add support for password conversion. Alternatively, you can used the wbb3_Login_Fix.zip modification (attached below) via Package Manager.

How to convert
Use this convert.php with the .sql file attached in this topic.
« Last Edit: July 18, 2009, 02:40:42 PM by TE »

Offline zeitwort

  • Semi-Newbie
  • *
  • Posts: 38
  • Gender: Male
    • Zeitwort SMF Testforum
Re: [SMF Converter] Burning Board 3
« Reply #1 on: May 31, 2009, 01:56:48 PM »
I tried to convert from wbb3 and got this info:  :(

Code: [Select]
Converting members... Unsuccessful!
This query:

    ALTER TABLE `zeitwortsql5`.smf_members
    CHANGE COLUMN passwordSalt passwordSalt varchar(40) NOT NULL default '';

Caused the error:

    Unknown column 'passwordSalt' in 'smf_members'

Now I can't login in SMF with my old username.
Wenn du merkst, dass du ein totes Pferd reitest - steig ab!

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #2 on: May 31, 2009, 02:47:02 PM »
The converter is for SMF 1.1.x only at the moment. I believe you tried converting to SMF 2.0 RC1 instead?

Offline zeitwort

  • Semi-Newbie
  • *
  • Posts: 38
  • Gender: Male
    • Zeitwort SMF Testforum
Re: [SMF Converter] Burning Board 3
« Reply #3 on: June 01, 2009, 04:09:38 AM »
Thank you for this converter - he works good and fast ( only 1 hour for 150.000 posts)  :)

Is it possible to convert also the Links in the quotes?

I give you an example:

SMF
Code: [Select]
[quote author=krahi link=topic=8616.msg157025#msg157025 date=1243797356]
wbb3
Code: [Select]
[quote='krahi',index.php?page=Thread&postID=157025#post157025]
Wenn du merkst, dass du ein totes Pferd reitest - steig ab!

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #4 on: June 01, 2009, 10:35:29 AM »
in general that's possible, but it requires a lot of developement time.. Internal SMF links use the ID_TOPIC (unique ID from a Topic) whereas WBB3 Links only use the ID_MSG  (unique ID from the messages).




Offline JaKe.OnE

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] Burning Board 3
« Reply #5 on: June 08, 2009, 08:20:01 AM »
I converted from wbb3.0.9 to SMF1.1.9. Worked fine!
The only problem are still the passwords, but it seems the fault is only on my side because I have not set a FTP user to apply the package because I only have a SSH root.
I will check this.

Thanks for the good work!

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #6 on: June 08, 2009, 08:26:48 AM »
there is only one line changed in /Sources/LoginOut.php

you can change these line manually, open the LogInOut.php with a text-editor and search for:

Code: [Select]
// Maybe they are using a hash from before the password fix.
add after:

Code: [Select]
// BurningBoard3 Login Method (double salted SHA1)
elseif (strlen($user_settings['passwordSalt']) == 40)
$other_passwords[] = sha1($user_settings['passwordSalt'] . sha1($user_settings['passwordSalt'] . sha1($_REQUEST['passwrd'])));
      


Offline zeitwort

  • Semi-Newbie
  • *
  • Posts: 38
  • Gender: Male
    • Zeitwort SMF Testforum
Re: [SMF Converter] Burning Board 3
« Reply #7 on: June 08, 2009, 02:00:42 PM »
in general that's possible, but it requires a lot of developement time.. Internal SMF links use the ID_TOPIC (unique ID from a Topic) whereas WBB3 Links only use the ID_MSG  (unique ID from the messages).

Would you help me to design a step by step query?

We have id_msg and id_topic in the same table

Code: [Select]
UPDATE `smf_messages`
SET `body` = replace(`body`, "[quote='","[quote author=")
Code: [Select]
UPDATE `smf_messages`
SET `body` = replace(`body`, "[#post","#msg")
Code: [Select]
UPDATE `smf_messages`
SET `body` = replace(`body`, "',index.php?page=Thread&postID=","xxxxxxxxx")

I don't know how to get the id_topic for xxxxxxxxx


Wenn du merkst, dass du ein totes Pferd reitest - steig ab!

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,656
  • Gender: Male
Re: [SMF Converter] Burning Board 3
« Reply #8 on: July 08, 2009, 04:15:38 PM »
zeitwort, do you still want help with this? :)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline zeitwort

  • Semi-Newbie
  • *
  • Posts: 38
  • Gender: Male
    • Zeitwort SMF Testforum
Re: [SMF Converter] Burning Board 3
« Reply #9 on: July 20, 2009, 04:35:26 PM »
Of course - I would be very happy if you could help me. :D
Wenn du merkst, dass du ein totes Pferd reitest - steig ab!

Offline Neakro

  • SMF Hero
  • ******
  • Posts: 2,855
  • Moeh!
    • Neakro.net
Re: [SMF Converter] Burning Board 3
« Reply #10 on: July 21, 2009, 04:43:26 PM »
I found a bug: If more than one WBB's board id/category id are > 255 the converter cannot convert.

The converter will complain about "duplicate entry 255" and stops. I'm still trying to figure out how to solve this problem.

*edit*
A dirty fix: Increase all ID_BOARD and ID_Cats to INT(10).

*edit2*
At "Recalculation statistics" the converter stops because of "Undefined variable: to_prefix". But the forum is working as far as I tested.
« Last Edit: July 21, 2009, 08:03:33 PM by Neakro »
Dumdidum...   Links zum Merken:
    

Kein Support per PM

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #11 on: July 22, 2009, 01:03:20 AM »
Thanks Neakro ;)
Our tools "Fix High Category ids" should fix the issues related to high categories.. (not a bug, the ID_CAT column is TINYINT unsigned )
http://www.simplemachines.org/community/index.php?topic=274252.0

Offline Neakro

  • SMF Hero
  • ******
  • Posts: 2,855
  • Moeh!
    • Neakro.net
Re: [SMF Converter] Burning Board 3
« Reply #12 on: July 22, 2009, 06:04:13 AM »
Oops, sorry :(

The forum runs very well, thank you guys :D
Dumdidum...   Links zum Merken:
    

Kein Support per PM

Offline asadmaloja

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] Burning Board 3
« Reply #13 on: August 27, 2009, 12:53:45 AM »
Hi,

Complete newbie here, trying to help a forum in distress.
I have installed SMF (a breeze) and I am now trying to convert existing Woltlab Burning Board.

First hurdle is, how do I find out which version of Burning Board is current forum using. Forum is currently down, but I do have access to MySQL database and files on the webhost.

I assumed, but could be wrong (see above) that the current forum is using 3.x Burning Board. However, I find instructions a bit lacking.

I downloaded all three files from the opening post and placed them in smf folder, however there is no convert.php file in my smf folder.
I tried using wbb3_migration.php in the url , but I am presented with a blank page with no errors. Same happens if I try renaming wbb3_migration.php to convert.php.

Am I missing a step somewhere? Probably something stupid.

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #14 on: August 27, 2009, 01:27:40 AM »
WBB3 is splitted into the board and the community framework.. check your database with phpMyAdmin first. Are there tables named wcf_1_1.yyyy (then it's a WBB3).

Then download convert.php, wbb3_to_smf.sql and wbb3_migration.php. create a folder named wbb3 and place the wbb3_migration.php in this folder (after you have edited that file and changed the variables with your databasename / table prefix).
upload convert.php and wbb3_to_smf.sql to your newly installed SMF and start convert.php with a webbrowser.

Offline asadmaloja

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] Burning Board 3
« Reply #15 on: August 27, 2009, 07:00:54 PM »
Thanks TE. Let me try this and I'll keep you posted.

Offline asadmaloja

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] Burning Board 3
« Reply #16 on: August 27, 2009, 08:37:00 PM »
I was able to get to convert.php, but I run into a new problem(s).
The first problem is within convert.php where it asks for paths to SMF and Burning Board.
It accepts the default entry for SMF (e.g. /public_html/smf) but does not accept Burning Board entry /public_html/forum. I thought I found a workaround and that it was looking for wbb3_migration.php which I placed in /public_html/smf/wbb3 and it started chugging along converting stuff. Everything looked fine until:

Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1251418046),
    ("conversion_from", "wbb3_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1251418046)' at line 1

I thought that this might be just an entry that tells when the conversion was done, and therefore rather uninmportant. So I went and logged into new smf forum but it is empty, although it does accept my username/password from the old forum. There are no posts, no topics, and no boards visible in the new smf forum.
On top of that, my administrator user/password that I created when I installed smf does not exist anymore.

I checked MySQL and tables seem to be populated, but no boards, topics or posts can be seen when I login (remember I login with my username/password from old forum).

SO, how do I declare myself admin again? What happened with boards, topics and posts, why are they not visible?

Your help is truly appreciated.


ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #17 on: August 28, 2009, 01:17:29 AM »
asadmaloja,
the pathes in convert.php are absolute pathes.. path for SMF is automatically detected right (something like /home/user1/public_html ...)the path from WBB should be slightly different at the end.

maybe the board was fully converted but you don't have the login fix installed?

I accidentally deleted my admin account, what do I do?

note: the permissions are not converted,  everything will be admin only for board access.

Offline asadmaloja

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] Burning Board 3
« Reply #18 on: August 28, 2009, 09:34:24 PM »
Thank you once again TE.

I figured out that everything was converted but hidden.
I resolved the issue of no admin account by running install again, created admin account and I was able to get in.

However, a lot of members are compalining about their passwords not working (old ones), although there are some members for whom old passwords work. I think that (at least) some of them forgot their original passwords.

I will look elsewhere on the forum, but is there an option where a member can enter their registered email address and that a new password gets generated and sent to it. I know that this can be done for the new members, but I would like to give this option to already existing members.

Oh, and ungrateful b^%4stards are complaining about smiley's already, forgetting that for weeks they were not able to login into their (old) forum.  >:( Just kidding, I know that would be the case, so I will have to research smileys.

Thanks for your help.

ThorstenE

  • Guest
Re: [SMF Converter] Burning Board 3
« Reply #19 on: August 29, 2009, 01:40:59 AM »
WBB3 is using a new password encryption, this encryption is not supported by default.  You should install the burningboard_login_fix.zip  (attachment, first post from this topic), then users can login witzh their old passwords.

For the Smileys: enable custom smileys in SMF and set the old Smileys-Code for your smileys.
Smileys and Message Icons