Info
- 57 posts
- 28 voices
- Started 3 years ago by jaim3
- Latest reply from rspowers
- This topic is not a support question
A phpBB to bbPress database converter
-
Hi!
I switched my site's phpBB forum to bbPress, and I've released the script I used for this purpose under the terms of the GPL.
It's largely based on the excellent starting point from Bruno Torres, to which I added some new features — like bbCode conversion with clean XHTML 1.1 compliant output, smily to text transcription, and the ability to import topics marked as closed, sticky and announcements as such.
I made also some little bugfixing, and the resulting script was able to cleanly import almost everything valuable from my old phpBB database.
You can have a look here if interested: http://www.iteisa.com/phpbb2bbpress/
Hope it helps to spread bbPress and web standards all around! ;-)
-
- Posted 3 years ago #
nice dude, when I first made the move, I looked at how different the db's were and said "meh, screw it." I got the users over easily, but very good job on dealing with topics and posts!
-
I've got my bbpress install (just a simple thing to test with) integrated into my WordPress database. I'd like to be able to import selectively for testing but no screw everything up -- is that possible? I note that the script calls for importing into a FRESH NEW bbpress install. :)
-
IMHO, the best thing to do first is, make sure you've imported the phpBB stuff, into a fresh bbpress install, that doesn't have the integration with WordPress.. then, integrate it with WordPress.. =/
As is now, *some* people are still having problems with the bbpress+wordpress integratation deal.. again, IMHO.. I would just play it safe, by doing the phpBB (import) to a normal bbpress install first.. then go from there.. ?
Trent, what do you think?
spencerp -
- Posted 3 years ago #
I have thought about this a was thinking that it really doesn't matter, but my preference would be to get the login integration with WP first if you are going to have it and this doesn't apply to everyone because not everyone is going to sync logins with WP. The reason is that seems to be the hardest part and you have to have your key admin being the one you want and associated with the right user in WP.
Once you are ready to go, then test the import of phpBB becauase if it doesn't go according to plan, you can just empty tables in bbPress and the hardcoding part for integration is still done.
Trent
-
Your PHP version is rather old, use this:
if (!function_exists('file_put_contents')) {
function file_put_contents($filename, $content) {
if ($fp = fopen($filename, 'w')) {
$result = fwrite($fp, $content);
fclose($fp);
return $result;
}
else {
return false;
}
}
}
-
- Posted 3 years ago #
I'm getting an 'out of memory error' as so:
Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 5803 bytes) in /home/pith/domains/pithrecords.com/public_html/phpbb2bbpress.php on line 910
... is it just that my server sux?
-
- Posted 3 years ago #
I would get your host to up the memory in php.ini to accomodate the script. How big is your phpbb2 database? I moved over a forum that was 1600 entries without too much hassle....(needed 16 megs in php.ini though)
Trent
-
- Posted 3 years ago #
Yeah, I needed about 80 megs of memory for this particular script, luckily my host upped it while I ran it.
jaim3, perhaps note that somewhere in a readme, for the not-so-smart users like myself. :)
-
Any of you php/mySQL whizkids out there wanna see if you can make this script work with invision power board? I only know enough php to be dangerous and know my limits well enough to know that trying to do this (for me) would be a big, big timewaster.
I'd be willing to dish out a bit of cash to anyone who wants to play.
I'll supply the ipb db for you to play with.
-
Thanks jaim3. I can't tell you how excited I am about going from a board with 86 tables to one with 8! Light and fast is what my members will appreciate. I think the simpler design will result in higher adsense revenues from my message board channels.
I have integrated bbpress to match the tech-o-crunch theme and will be releasing it to the bbpress community once I have it like I want it.
I'll also be posting a casestudy of the bbpress adsense theory I mentioned above on my blog.
-
- Posted 3 years ago #
Hmm....maybe the function name changed? What version of bbPress? 0.75?
Trent
-
kickass! yes our server was set by default to php4. The server guys said:
We have checked our server logs. The reason for the issue is not related to the memory limits for your account.
The file_put_contents() function is only available in PHP 5.
By default our servers handle any requests to .php file through the PHP 4 interpreter. By default the PHP 5 interpreter processes only files with .php5 extension.
If you want to change this in a way that .php files are processed by the PHP 5 interpreter you should put the following line in your /www/blog/.htaccess file:
AddHandler application/x-httpd-php5 .php"
-
- Posted 3 years ago #
Ok i hope that last part:
"Sending all your database e-mails to all major world-wide spam sending mafias..."Is a joke? I am moving from phpbb because of spam and this does not sit too lightly on me...ok i need to take a chill pill.
Ok back to the task as hand. It totally does not work for me i get no databases installed? When i run it, I get all the exporting scripts, then point 8. about the mafia. And then I get a row of numbers "39816"
I'm using 0.75. Is there a version conflict?Thanks.
-
- Posted 3 years ago #
I tried to contact the author of this list, and his email is dead. I would becareful as it seems this list sends all your forums members emails to spammers. Just to be safe DONT use this script!
I'll have to suffer with the conciquences!
-
- Posted 3 years ago #
Once again, don't think this is the case.
http://bbpress.org/forums/topic/47?replies=6#post-4238
Trent
-
One problem I ran into was that I already had a few existing users on the wordpress side, which led to conflicting unique user IDs. I got the importer to work, but some of the posts were under the wrong user names b/c of conflicting unique user IDs between wordpress/bbpress and the old phpbb board I tried to import.
I haven't been able to try it yet (phpbb.com is down), but they have a mod called Change User ID that seems to do exactly what its name suggests. If so, I intend to use it to change the three user IDs that are conflicting from 2, 3, and 6 to 99992, 99993, and 99996 respectively. That way, when I import the phpbb tables there will just be "blanks" in the sequential unique user IDs for the existing wordpress IDs to fit into.
Hope this is helpful...
-
I know this topic is pretty old, but I have a problem ... I converted members and forums succesfully, but topics and posts didn't show up. I got these errors when converting:
#
Warning, there was an error with the following query#Exporting Topics: INSERT INTO bb_topics (topic_id, topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id, topic_status, topic_resolved, topic_open, topic_last_post_id, topic_sticky, topic_posts, tag_count) VALUES ( 4, 'Pravila!', 2, 'Zala', 2, 'Zala', '2007-02-13 16:13:01', '2007-02-13 16:13:01', 1, 0, 'no', 1, 765, 0, 2, 0)
Unknown column 'topic_resolved' in 'field list'
...
And a lot more of them. I don't know much about php really, so I have no idea what is wrong. It's probably a stupid mistake I made, but I don't know what it is. Help me, please?
-
The topic resolved thing is probably because that was written for an older version of bb which had that in it by default. I think installing the forum support plugin will add that column, worth a shot anyway?
http://bbpress.org/plugins/topic/16?replies=7
Otherwise you could edit the php file and remove the bits about the topic_resolved column (remember to back up the original file in case it doesn't work!).
