hi !

am working on moving my site from phpbb3 to bbpress, of course there is no converters out there for that purpose, so i decided to write my own.

am still testing it and trying to improve the code a little bit. right now it can convert the following :

1- forums

2- topics, completely with topic types and status.. announcements and glopal announcements are stickied to front page.

3- posts, all bbcode is converted into html, smiles are changed into img tags, so you might want to install allow images plugin.

4- users, including permissions .. notice that bbpress doesn’t support per forum permissions as phpbb3, so it only convert users as following :

founder -> key master

inactive -> inactive

banned -> blocked

moderators and admins are converted into normal users, so you have to assign them again

because phpbb3 doesn’t use md5 hashing anymore, the script copies passwords as it is. to solve that problem i modified the md5 insecurity for bbpress plugin to first check the passwords the phpbb3 way, if it matches, it will rehash it using bbpress functions.

the script converts all the table rows at once, so it’s very heavy and consumes too much cpu depending on your forum size, i strongly suggest that you do the conversion on your own machine, not on a shared hosting account. you might also want to increase the php max execution time on your machine before starting the script cause it takes lots of time converting posts.

here is the steps for converting your phpbb3 board :

1- make a backup from your database and files.

2- install bbpress anywhere, just use the same database of phpbb3. this is important cause the script assumes that all tables are in the same database.

3- download the script from here. extract it, and you’ll get 2 files.

4- copy the file phpbb3tobbpress.php to phpbb3 directory.

5- copy the file _phpbb3_pass.php to bb-plugins directory.

6- go to http://path-to-phpbb3/phpbb3tobbpress.php and start converting your board.

7- voila .. all your data is converted to bbpress tables, go to your bbpress installation and login. don’t forget to visit admin->manage->recount to make sure your converted board is updated.

i can’t stress enough on how consuming is the process of converting posts, my board has 25,000 posts, and it takes nearly 15 minutes to convert them on my local machine, so again : i don’t recommend using this converter on shared hosting.

ciao !

[@helgetry Participant 15 years, 10 months ago]

I see now in the script that it checks

if ($user_type == USER_FOUNDER)

However, according to the table, USER_FOUNDER is not a user type. User Type is set with IDs. My user type is for instance 3…

[@chrishajer Participant 15 years, 10 months ago]

https://bbpress.org/plugins/topic/fix-admin-access/

You would need to change the ID to 3 in your case I believe.

[@helgetry Participant 15 years, 10 months ago]

Hm, it still doesn’t work. I have even cheched in the database, and my user has

meta_value: a:1:{s:9:”keymaster”;b:1;}

meta_key: bbpress_capabilities

Just as it’s supposed to.

Even so, I don’t get the admin link when I’m logged in. And I’ve tried to use the plugin which you linked to.

[@helgetry Participant 15 years, 10 months ago]

…and just for your information; I’ve changed the script so that it looks for ID == 3 instead of ID == 1.

[@chrishajer Participant 15 years, 10 months ago]

Have you tried dumping all the cookies to be sure there is nothing left over fouling things up?

[@helgetry Participant 15 years, 9 months ago]

I figured it out. There were two records for my capabilitues in the database. I don’t know why. When I changed both of them to keymaster, I got admin rights.

[@gadgets Member 15 years, 9 months ago]

It’s work good thank you.

[@gavinj77 Member 15 years, 8 months ago]

When I tried to convert my forum, I got this error:

General Error

SQL ERROR [ mysqli ]

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 ‘s workouts logs)’, ’18’, ‘2’, ‘9’, ‘162’)’ at line 1 [1064]

SQL

INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES (’19’, ‘Workout Logs’, ‘Place to log the workouts you do, times, & weights used. (Please do not post on other people’s workouts logs)’, ’18’, ‘2’, ‘9’, ‘162’)

BACKTRACE

FILE: includes/db/mysqli.php

LINE: 163

CALL: dbal->sql_error()

FILE: phpbb3tobbpress.php

LINE: 201

CALL: dbal_mysqli->sql_query()

“

Do you know what the problem might be? Maybe it’s an easy fix, but I’m a novice. Thank you.

[@matiaspunx Member 15 years, 8 months ago]

yeah you need to use the addslash function to insert data in your db…

I think you need to edit the phpbbtobbpress.php

[@gavinj77 Member 15 years, 8 months ago]

Okay….let’s imagine for a minute that I’m 10 years old.

LOL Can you explain how I would do that? Where do I place addslashes? In phpbbtobbpress.php? If so where? I’m really not good at this. It’s completely Greek to me.

[@matiaspunx Member 15 years, 8 months ago]

Ok, i will send you my edited file, use it under your own risk, it’s works like a charm but, nobody knows…

Examine the file and see the changes made by me

PD: PLEASE, back up your db first!

DOWNLOAD: http://www.mediafire.com/?nmmymgg0z0j

Hope this works for you!

Best regards!

[@gavinj77 Member 15 years, 8 months ago]

Thank you for the file. I used the file, (did not edit it at all because I have no idea what I’m doing). I get this error when I try to access the forum

bbPress database error: [Table ‘db279681361.bb_topicmeta’ doesn’t exist]

SELECT meta_value FROM bb_topicmeta WHERE topic_id = 0 AND meta_key = ‘uri’

Warning: Cannot modify header information – headers already sent by (output started at /homepages/34/d279666578/htdocs/forums/bb-includes/db-mysql.php:130) in /homepages/34/d279666578/htdocs/forums/bb-includes/functions.php on line 2271

Is this a simple error to fix? If not, I’m going to have resolve myself to using phpbb3, (which I don’t want to do of course). Thank you again. I appreciate it.

[@chrishajer Participant 15 years, 8 months ago]

Are you using bb_ as your bbPress table prefix? Maybe the bb_ table prefix is hard coded and it does not match up with your installation.

[@gavinj77 Member 15 years, 8 months ago]

I checked via phpMyAdmin and all my bbPress files start with bb_ . I didn’t change any files from the install. The phpbb3 files all begin with phpbb_

[@matiaspunx Member 15 years, 8 months ago]

oh! what version for bbpress are you trying to convert?

this file just works with a new fresh install of “0.9.x”

the converter finished without problems?

[@gavinj77 Member 15 years, 8 months ago]

It worked! Thank you guys for your help! I realized I forgot to delete the bb_ files via phpMyAdmin, (from the first time I tried the conversion without the edited file from matiaspunx. I had removed the files via FTP only.

Thanks again!

[@webrulon Member 15 years, 7 months ago]

matiaspunx I am receiving the same error as gavinj77, I tried to download your fix at http://www.mediafire.com/?nmmymgg0z0j but the file was no longer available. Could you kindly repost the updated file?

Thanks,

Russell

[@webrulon Member 15 years, 7 months ago]

Can someone please help me out with this, I’m willing to pay anyone who can solve my issue.

Thanks,

Russell

[@jurasiks Participant 15 years, 6 months ago]

bbpress 0.9.0.5 and phpbb 3.0.5 at localhost:

when i click on “converting users data”

i have:

SQL ERROR [ mysqli ]

Data too long for column ‘user_url’ at row 1 [1406]

to small? how to fix and convers users data properly?

updated: fixed!

ALTER TABLE bb_users CHANGE user_url user_url VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

[@jleuze Member 15 years, 5 months ago]

I got pretty close with wmnasef’s script, but I think I am having a problem similar to gavinj77’s.

SQL ERROR [ mysql4 ]

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 ‘opinions on current political questions.’, ‘0’, ‘2’, ’48’, ‘235’)’ at line 1 [1064]

I’m trying to convert an install of phpBB 3.0.4 to bbPress 0.9.0.5, a small amount of data did transfer over to bbPress before I received the error.

I tried to download matiaspunx’s edited file and I was also unable to.

Does anyone know exactly what I have to edit to “use the addslash function”, or happen to have a copy of this file they would be kind enough to share with me?

[@jleuze Member 15 years, 5 months ago]

I got it to work, the converter did a great job, thanks wmnasef!

I was trying to do the conversion on fairly standard VPS with a typical LAMP stack, I’m not really sure why it didn’t work on there.

But after that I tried the conversion on my Media Temple Grid Service account and it worked fine. (The forum is quite small, 7000 posts) So if someone else runs into a similar problem, try a different web host or a local web server, maybe you’ll have better luck too!

[@andrewrh Member 15 years, 5 months ago]

Any word on whether this converter works for phpBB3 v3.0.5 and bbpress v1.0? (asking before trying!)

Thanks,

~Andrew~

[@jleuze Member 15 years, 5 months ago]

Andrew, I just converted a test install of phpBB 3.05 to bbPress 1.0.1 without any problems.

[@mrpresident Member 15 years, 5 months ago]

Just done this myself on a live phpBB3 forum, worked like a dream, no issues. Thanks very much!

[@michele83 Member 15 years, 5 months ago]

I have this problem on the second step:

SQL ERROR [ mysqli ]

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 ‘uso, critiche e suggerimenti’, ‘Aiutaci a migliorare la community!’, ‘142’, ’11” at line 1 [1064]

SQL

INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES (‘2’, ‘istruzioni per l’uso, critiche e suggerimenti’, ‘Aiutaci a migliorare la community!’, ‘142’, ’11’, ’47’, ‘1129’)

BACKTRACE

FILE: includes/db/mysqli.php

LINE: 163

CALL: dbal->sql_error()

FILE: phpbb3tobbpress.php

LINE: 201

CALL: dbal_mysqli->sql_query()