successful convert smf -> phpbb2 -> bbpress!!!!
-
After a day of on-again, off-again effort I have successfully imported my SMF to bbPress – and integrated it with WP.
I did this on a local test server, then installed bbPress live, then drop/imported my bbpress tables and user tables (my wp user tables in this case).
Steps:
1. Installed PhpBB 2.0.23 (legacy version available from phpbb people) and made sure it worked
2. Used files within a zip file called convert_smf_111_v1b.zip to convert SMF -> Phpbb. Unfortunately, I can’t find the link to the thread right now… I found this
http://www.phpbb.com/community/viewtopic.php?f=10&t=306321&st=0&sk=t&sd=a
but it isn’t as new a version.
I believe the file I used is here:
http://sourceforge.net/project/showfiles.php?group_id=141446
sorry I lost the link to the discussion.
NOTE 1 : I had to manually go into the database and upgrade my main account to ‘level 1’ to become admin again.
NOTE 2 : Your password probably won’t work and you probably can’t send yourself an email either. I hacked phpbb/includes/emailer.php and included the variable $this->msg into the error message so that the email appeared on the screen. This gave me the ability to reset my account and get a new password.
3. Implemented the following MOD on PhpBB to switch conflicting User Ids
http://www.phpbb.com/community/viewtopic.php?t=388155&sid=3d5e8f776a7086b6fec64c3e80c7cbca
(this part is tedious! the MOD is a pain to install and rearranging is no fun either)
Here are directions on how to install a Phpbb mod:
http://www.phpbb.com/community/viewtopic.php?t=61611
4. installed Jaim3’s PhpBB to bbPress converter per instructions
http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter
This created a .sql file.
NOTE 1: Make sure to create a temp folder where the file wants to be created
5. Important edits to .sql file
A) since I did an integrated WP/BBpress install, I needed to search and replace bb_user for wp_user
Delete any lines that add users who already exist in BB/WP
C) add a field called topic_resolved to bb_topics
D) Delete the sample test posts and forums in the bbpress tables
6. Import the .sql into your database. The above should have solved any conflicts, but if you get an error it should be relatively easy to figure out.
7. At this point, since I wasn’t doing it live I installed bbPress live, and then drop/created my test tables (all bb tables plus user tables) on my live server and all went well.
8. This should be everything. Have a drink.
- You must be logged in to reply to this topic.