WBB 2.3.6 => SMF 2.0.2 with DB only? [solved]

[novamax]

Hej All,

I tried to consult search but couldn't find what I was looking for. There is a converter for WBB 2.3.6, but instead of just converting DB tables it requires access to the files of the original installation. Problem is: I have a backup of my DB, but the webserver has run out, and I don't want to reconstruct the complete installation just to migrate to SMF.

Is there any procedure or work around available to just import WBB tables previously uploaded to the SMF DB/user?

[Looking]

You have the WBB and SMF on same database with same mySQL user credentials?

[novamax]

Yes:
1 set of clean installed tables for SMF 2.0.2
1 set of imported old tables for WBB 2.3.6

Both in the same:
1 DB, 1 User, 1 PWD
Just different suffixes (smf_ and bb2_)

[Looking]

Just get the configuration file for WBB and put it in a folder with the correct paths and passwords and see if that does it.

[ThorstenE]

Just get the configuration file for WBB and put it in a folder with the correct paths and passwords and see if that does it.

this or edit burningboard23_to_smf.sql and find:

Code Select Expand

---~ settings: "/acp/lib/config.inc.php"
---~ from_prefix: "`$sqldb`.bb{$n}_"
replace with:

Code Select Expand

---~ parameters: wbb_database text=MySQL database used by  BurningBoard 2.3
---~ parameters: wbb_prefix text=Prefix used by BurningBoard 2.3
---~ from_prefix: "`$wbb_database`.$wbb_prefix"

[novamax]

Great I tried Thorsten's method, and it worked.

I get an error message, though:

Converting topics...Duplicate entry '3664' for key 'PRIMARY'

I can login afterwards, but I see only top categories (no posts at all).

I somewhere read that the phpBB2 converter does not like sub-forums (which the old forum had...) - I hoped the SMF converter doesn't mind. Does it?

[ThorstenE]

in burningboard23_to_smf.sql find

Code Select Expand

---* {$to_prefix}topics
add after

Code Select Expand

---{
$ignore = true;
---}
then re-run the converter..

[novamax]

Thank you deeply for your high speed support! 

Your modifications work. Still some problems:
Converter says

Converting posts (this may take some time...) ... Incomplete
Not quite done yet
The conversion has paused...

Then it erases the screen, continues saying:

Converting...
Converting posts (this may take some time)...

The side screen marks

(...)
- Attachments...
Recount Totals and Statistics
Done

In the forum's Home Screen, I only see the Test-Category (Although all categories are visible in Admin area) and one Thread with 5 posts (should be several thousend threads and even more posts...). When I go to "new posts", I see 190 pages of Threads )this looks more like it...). When I click one of them, I get the error message:

Board structure corrupt: unable to find parent board

I will try to install SMF anew with a clean DB, and test the converter with your suggested modifications tonight. If you have another idea, I would be happy to know

[ThorstenE]

I've never seen such error message.. After the conversion you should run some maintenance tasks in SMF:
Admin - Maintenance - Routine - "Find and Fix any errors" and "Recount Forum statistics"

The converter doesn't convert permissions, thus all Boards are set to "Admins only" by default. You can change ther permissions by editing the board within the admin area.
http://wiki.simplemachines.org/smf/Boards

[novamax]

Great - I like the logic in that.

Final Feedback: Find and fix errors did the job. I dont' know if the forum is complete (Co-Admin did a lot of Mods I have no record on). But thanks to your converter and your support, most of it is there and accessible.

Just one thing is missing:
Thorsten, please let me know the bank / paypal address of any of your projects, resp. a project of your choice (I could not find one for your converter) for a small recognition of your support. You have no idea how much hours I spent researching for a WBB2 converting solution and how happy I am to have access to my data again!

[ThorstenE]

Just one thing is missing:
Thorsten, please let me know the bank / paypal address of any of your projects, resp. a project of your choice (I could not find one for your converter) for a small recognition of your support. You have no idea how much hours I spent researching for a WBB2 converting solution and how happy I am to have access to my data again!

You're welcome Thanks four your offer to donate. I don't have a personal paypal account for donations, but I'm sure the SMF project will be happy:
http://www.simplemachines.org/contribute/donate.php

[novamax]

Done. SMF, the converter, and your support provided help on professional level. If I employed commercial service for this, it would have been more expensive, and with more preconditions. Please continue your good work.

@looking:
Sorry for not replying to your suggestion. I have no backup of any web-files (incl. the config file), so I had to follow Thorsten's sql-edit method. Still thanks for the good idea.