This is a beta, don't just scrap your working forum at the end of the process!I picked a local install of WBB 4.0.5, created some content and, using the existing converter for WBB 3 (http://download.simplemachines.org/?converters;software=wbb), I tried to get something working for this software.
What the converter will convert:
- Members
- Categories
- Boards
- Topics/Posts
- PMs
- post attachments
- avatars
- polls
Known issues/limitations
- Boards/Categories: Correct mapping only possible until first child board.
Attachments/avatars: files are fetched from a fixed folder structure but it is possible that it is random- Notifications: no idea about this :P No notifications are converted
- Passwords: passwords are *not* converted (check below)
Password recoverySince passwords are not converted, you need to follow the usual steps for password recovery. If you cannot email yourself a new password, use this trick from the wiki (http://wiki.simplemachines.org/smf/I_accidentally_lost_my_admin_account!_What_can_I_do):
QuoteResetting an admin users password
Use phpMyAdmin (or similar) to locate (within the "_members" table) the member whose password is to be reset. In the database field entitled "passwd", enter a new password using plain text.
Then, clear out (erase) any existing content in the database field entitled "password_salt".
The next time the member logs in (using the new password), SMF will automatically re-encrypt his credentials.
How to use the converter* Install SMF in the same server as WBB, in a separate folder, in the same or different database
* If installed in different databases, make sure that the MySQL user from SMF is allowed to SELECT (at least) the database from WBB
* Upload the files "convert.php" and "wbb4_to_smf.sql" to your SMF folder
* Edit the file "wbb4_migration.php" and define the correct database information, as in the example below:
<?php
// Change this to the database name you are using.
$wbb4_database = 'wbb4';
// Change this to the database prefix for your Woltlab Community Framework you are using in the above database (default is wcf1_).
$wcf_prefix = 'wcf1_';
// Change this to the database prefix for your BurningBoard4 you are using in the above database (default is wbb1_).
$wbb_prefix = 'wbb1_';
?>(unlike the other converters, this one needs a separate configuration file because WBB uses 2 table prefixes)* Upload the file to your WBB folder
* Run the converter --> www.whatever-path-to-smf.com/convert.php
That's it. If interested test and let us know the outcome.
Thnx, i will try it this evening, a short try with 2 databases doest go, i now put in in one database and try it again.
Now i tried quickly, but there is a mistake:
Converting members...Wrong value type sent to the database. Integer expected. (gender)
When i want to log in my smf forum, the Username is away.
If it doesn't work with separate databases, that's because SMF's user can't access WBB's database.
As for that problem, I'll check.
Ok,by the way,i respect your work at the importers, thumbs up for this ;)
Updated the .sql file in the first post, please give it another try ;)
The same mistake
Converting members...Wrong value type sent to the database. Integer expected. (gender)
Oh memory, why do you fail on me? :(
Sorry, forgot to revisit this...
I can't really understand why you get that. I know how to fix it (not fix it, go around it) but it would be nice to understand why...
So, in the local setup I got, "gender" is stored as 0/1/2 in the table "wcf1_user_option_value" , column "userOption4"
Can you check which values you got in this column?
edit: also fixed a typo in the .sql file, please re-download it ;)
I look this evening, now i must go to work, someone who want to go for me? ;D
Now i have tried converting, first step is ok now, but now this:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_started)
Don't you just love converters? :)
I'm driving now, will check later. Thank you for reporting.
lol yes i love it :D I like testing new things, no problem ;) Drive carefully ;)
Just in time :) Just finished it. Posts made by removed users, I didn't try that before :(
Updated the original topic, please give it a spin ;)
Next step is done till the Poll Votes, now the attachments:
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting attachments...
Warning: copy(/kunden/.../oc/wcf/attachments/b2/14-f45f9fb1d86db44e0285f422e261bee11c5343e2): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/15-c184499a3c4b88c86fa3d74661d03dbc011eac9d): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/16-c0b60548cd13d299393ea973e7cc661d47cff0b0): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/17-aa17749e0961585f4f4e896b0dce53e2d7138fee): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/18-9e0817e30449d1ab99b4f0a9bdf4f1722d3c67a0): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/19-3a0e371dc4c9e94418c503e127078a949d58bc4f): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/26-9967551f68788c2cae53a7431124e5b9ea59e19d): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/27-3be6a61320d07655490200ab65a63558256d8f8d): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/28-804a91ac9306c958992ad0a9010426c4e0caba29): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/29-734d1eb794eb7588f9e2b0cf901a44349cbb147e): failed to open stream: No such file or directory in /kunden/2.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/30-b5eb983d0bf561d7aa9ff50f73a8298c5ede4545): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Warning: copy(/kunden/.../oc/wcf/attachments/b2/31-d27079bbf081135eadb42082cda1d9e1f6447747): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
And there are not all threads importet i see just?
Did it finish?
2 things:
1- the attachments might be borked. I'm using a fixed path for the files (the path I got in my tests) but I recognize it might be wrong (check known issues in the first post). Can you please check what do you have inside this folder here: oc/wcf/attachments
2- which treads are you missing? Don't forget to login to your converted SMF and perform the maintenance tasks "check for errors" and "recount totals" ;)
Ok, after i performed the maintenance tasks all threads are there :)
In the folder you talked about, there are more folders (/00, /0a, /0b etc.)
Hmmm I need to check how exactly the attachments work, then...
As for the remaining content, everything's cool? Any suggestions for improvement?
Content is cool, avatars and attachments are the last walk, then its perfect ;)
Hey margarett, first, i wish you a nice Weekend ;)
Did you check the attachments? :)
I did not :(
These last 2 weeks were totally crazy with my job, and I'm really not sure when it will calm down...
A nice weekend for you too ;)
edit: and I think I finally got how the folders distribution work in WBB. Stupid thing, it uses the first 2 characters of the file hash to create a folder :P Now I just need to fix the converter :)
First post updated, I think I nailed the attachments stuff ;)
Thank you ;)
Now the attachments are imported, but next step:
Converting personal messages (step 1)...Wrong value type sent to the database. Integer expected. (id_member_from)
I think PMs i need not to import, because i say to my users before i import to another system, they shoud download the PM if needed :) But the Importer stands still now, last step after PMs are Avatars, this point i need and then its perfekt :)
That should be fixed also ;)
Next fix please ;D
Converting...
Converting attachments...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Wrong value type sent to the database. Integer expected. (id_member)
Updated ;)
Converting attachments...
Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)...Duplicate entry '173-0' for key 'PRIMARY'
Next one ;) I am really exited, we came to the end, i think :D
This is a bit stranger... I can see why it happens, I don't understand why WBB stores that...
Anyway, updated ;)
Now the last step, like the attachments before updating:
Warning: copy(/kunden/.../wcf/images/avatars/38/1-e2c918fa769b771ea594833d7760116b33e8b3b2.png): failed to open stream: No such file or directory in /kunden/.../smf/convert.php(1254) : eval()'d code on line 7
Sorry,sorry,sorry! It works ;) I set the permissions of the avatars to 777 and then it works ;) Thank you!!!
:)
Is everything in place? Be sure to run the maintenance tasks --> recount totals and check for errors.
Also, you probably noticed that *ALL* boards are only visible to administrators. That needs to be corrected manually. Check also the membergroups, posts with attachments, etc.
Welcome to SMF ;D
The avatars are not in the smf folder and there is no avatar to see in threads or profiles. All members,Threads an topics are imported, the private messages too ;)
Avatars... Hummm... In my test forum it copied it.
Tell me something: is your avatar uploaded via your PC, a link on the internet, ...?
In SMF no avatars are uploaded to that folder by default. Only avatar packs do. Avatars are treated like attachments ;)
Uploadet from PC. In my importet SMF has no member his avatar from wbb4, but importer said, its done.
The fact that the importer said it's done should not be taken literally ;D ;D ;D ;D
I will retry that part later today. TBH, I was expecting it to be broken :P but, surprisingly, my avatar got converted so I thought "hey, how about that?!" ;D
Can you post your avatar image?
This is my Avatar in my Forum.
And thanks for your top work on this converter ;)
And I managed to forget this :(
Looking at it now.
edit: should be fixed ;)
I wanna test it soon, first i musst install all programms on my new pc ;)
How is this WIP coming along, I am thinking about ditching WBB4 for SMF and I see that this is being worked on.
Hopefully it is closer to a RC than a WIP??
It's a WIP because I can't guarantee a complete conversion because I don't know the ins and outs of WBB, I just did this because someone requested it :P
You can try it, it should be painless ;)
Let us know if any issues arise. The more issues are reported, better ;)
Quote from: margarett on August 27, 2014, 05:10:34 AM
It's a WIP because I can't guarantee a complete conversion because I don't know the ins and outs of WBB, I just did this because someone requested it :P
You can try it, it should be painless ;)
Let us know if any issues arise. The more issues are reported, better ;)
Is it possible to do a trial run by setting up SMF in a sub-domain and then test the conversion before I commit? Or will it span domains like that??
Yup, of course ;)
Let's say your actual forum runs in www.example.com
You set up SMF in a sub folder "test" so that it runs in www.example.com/test then you run the converter and check what's going. You can even install some mods, maybe search for a theme, etc.
When you're happy, you can redo stuff, this time for real. During all this time, your original forum was still running without issues or interruptions ;)
Just one more question before I try this out. Passwords can they be reset through the"forgot password" function or do I have to do something to reset them all.?
this is the error I am getting and cant seem to sort it.
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 4.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'vapersgu_smf911'@'localhost' for table 'wcf1_user'
Quote from: Papa Hoyt on August 27, 2014, 07:57:44 PM
this is the error I am getting and cant seem to sort it.
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Burning Board 4.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: SELECT command denied to user 'vapersgu_smf911'@'localhost' for table 'wcf1_user'[/s]
Nevermind had permission backwards but I now get this error
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards...Wrong value type sent to the database. Integer expected. (id_cat)
if it helps this is the software stats
Burning Board® Version
4.0.8
Community Framework™ Version
2.0.8 (Maelstrom)
and if need be I can grant you access to my forum to look at the database directly
Oh, the joys of converters :P
It seems you have a board with a NULL or somehow not integer id. Can you check via your boards table in wbb for such strange occurrence? That's something the converter isn't really prepared to handle (because it makes no sense to have a board without id)
I have quite a few with the 'parentID' as NULL but these are the section headers that help break my board up into categories.
I'm currently working in another converter. I'll try to check this as soon as possible (after today's beach session :P )
Thank you so much, I will continue to look over thedB and see if something jumps out at me.
Take your time and Thank You so much for what you are helping me with.
Not sure if this helps
I can go to ' » Administration Center » Boards » Modify Boards' and see the categories that are marked NULL in the db. so that is not it.
What makes me scratch my head is that the repair and recount was run successfully and i cannot see these categories on the main board.
Also styleID on every row (including the categories) are marked NULL.
added a new board to one of the empty categories and it now appears on the front page so it is merely not showing due to lack of boards in that category.
Yes, that's common behavior in SMF. If a category doesn't have boards inside, it is not shown ;)
Nevertheless, categories should have been converted in the previous step. I'll have to check that...
Now that I think about it... Could it be that you have child boards with more than 1 level? The converter can only convert up until the first child board level. Eg:
Cat --> Main board --> Child board.
I do have a few I did not catch that, let me rearrange and try again.
still getting same error and reformatted all boards to
Cat > Board 1
Cat > Board 2
etc etc
Can you please PM me a link and login details to your database manager?
I need to check in place what can cause that...
Any update? Did my previous tip help?
yes sorry the holiday weekend has me away from computerbut the converter did work and I am looking through the files now the one thing I did notice is that it added a lot of backslashes2 titles advertising links.
More to come as we look more into it.
For future reference, the current version of the converter does not support boards not under a category (directly on the "root" of the board index)
Can you post an example of the issue you're having? I'm not sure I understand it...
I have not forgotten this topic. I have just been to busy to get back to the conversion to grab you am example. Real life first and then online presence.
I am having a little problem guys:
QuoteWhich software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.
Try again
Quote from: Diazz72 on March 04, 2015, 07:29:52 PM
I am having a little problem guys:
QuoteWhich software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.
Try again
The problem was whit premissions, now that is fixed but:
QuoteUnable to find the settings for Burning Board 4.0. Please double check the path and try again.
You need to create the file "wbb4_migration.php" with the correct WBB info and put it in WBB's folder (like described in the first post)
Then you need to tell the converter the full path (server path, not URL) to the folder where that file was put ;)
First at all nice work and thank you for the converter :)
the first steps are done but now im stuck at "Converting boards"
Converting members... Successful.
Converting categories... Successful.
Converting boards...Wrong value type sent to the database. Integer expected. (id_cat)
I could see that the main Categories are imported but nothing more :/
Hi ;)
Before you perform the conversion, make sure that all your boards are inside a category.
WBB supports boards directly on the root, SMF doesn't...
Hi Margarett
thanks fpr your answer i've rechecked my board and all Boards are in a Category Placed, or is there a problem because of the subboards?
for example a snapshot in the attachments :) from the board tree inside the ACP (Category: Blue Banner, Boards: Blue Text)
Edit: aww damnit sorry i had a hidden Board marked as Forum not as Category ;) it worked now ^^
Great! :)
Welcome to SMF ;)
thanks ;D