There might be a way. I think there are a couple of hooks to change the users forum role??
But if phpBB added/removed forum participation capabilities then you might need to hire a develop to create this for you.
If it was just a rank then you can use this. I am not sure if its the points system that changes the rank or posts made.
https://wordpress.org/plugins/mycred/
There might be another plugin that ranks by just post count though.
I believe this is because of DB differences between phpBB 3.0x and 3.1x.
Current import only supports phpBB 3.0x
I was able to get rid of the error messages by creating the columns it complains about.
You can also try this: https://bbpress.trac.wordpress.org/attachment/ticket/2716/2716.1.diff
Hello,
As the topic says, i’m having issues importing from an upgraded phpBB v2.x forum.
I have approximately 4200 users, 1900 topics and 4400 replies on a phpBB v2 platform. I was able to successfully upgrade to v3.0.x and v3.1.x. As far as the phpBB upgrade goes, everything works, including authentication.
I am now trying to import into bbPress. I’ve tried using version bbPress 2.5.7 and 2.5.5. I’ve also tried using the new patch file that supports phpBB 3.1. I’m running WordPress 4.2.2, but also tried with 4.2. All on fresh installs with bbPress as the only plugin installed and activated.
I can see the passwords in user_meta. But I can’t login. No error other than the password is incorrect.
Would anyone be able to help? Am I out of luck coming form version 2.x of phpBB? If i’m out of luck, is the “Lost your password?” link the only route to fix passwords?
Thanks!!
SD17.
Is it possible to automatically change the user role based on the number of post in the forum?
In the past I was using phpBB and there you could do that. New user were catagorized as “beginner” and after eg. 100 posts they automatically became “Advanced”.
This did not change anything in their permissions but gave them some kind of status.
Thanks
Thomas
I’m attempting to import from a current install of phpBB, but when I do, I get errors. Here’s what I’m getting so far:
Repair any missing information: Continue
WordPress database error: [Unknown column ‘forums.forum_topics’ in ‘field list’]
SELECT convert(forums.forum_id USING “utf8”) AS forum_id,convert(forums.parent_id USING “utf8”) AS parent_id,convert(forums.forum_topics USING “utf8”) AS forum_topics,convert(forums.forum_posts USING “utf8”) AS forum_posts,convert(forums.forum_topics_real USING “utf8”) AS forum_topics_real,convert(forums.forum_name USING “utf8”) AS forum_name,convert(forums.forum_desc USING “utf8”) AS forum_desc,convert(forums.left_id USING “utf8”) AS left_id,convert(forums.forum_type USING “utf8”) AS forum_type,convert(forums.forum_status USING “utf8”) AS forum_status FROM phpbb_forums AS forums LIMIT 0, 100No forums to convertNo passwords to clearStarting Conversion
Is there then a way to merge users? So that if someone registered on the WordPress site and separately on the forums that afterwards they can be combined?
You can delete a user then attribute their content to another user
We have a members-only section for our forums. I understand these forums will be made public and we would need to hide them, but is there a way to set up users that have access only to certain sections while the general public has access to everything else? I don’t want to assign all of our members the ability to edit content on the site, just have access to a members only forum.
There are a couple of membership plugins that are compatible with bbPress, you could also use the bbPress private groups plugin.
Will this create two separate MySQL databases? Will the old phpBB still be there and operational? Can the two be used simultaneously and will content posted in one cross-post to the other once merged to bbpress?
Your phpbb data will be imported into the WordPress database where bbPress would usually be. Cross posting I’m not sure. You should test this out on a test site to make sure everything is working okay and to your expectations.
Thanks for that. I didn’t see that FAQ before. Here are some questions not specified here:
Is there then a way to merge users? So that if someone registered on the WordPress site and separately on the forums that afterwards they can be combined?
We have a members-only section for our forums. I understand these forums will be made public and we would need to hide them, but is there a way to set up users that have access only to certain sections while the general public has access to everything else? I don’t want to assign all of our members the ability to edit content on the site, just have access to a members only forum.
Will this create two separate MySQL databases? Will the old phpBB still be there and operational? Can the two be used simultaneously and will content posted in one cross-post to the other once merged to bbpress?
If I use the bbPress import tool to import the database of an existing phpBB board, will it pull over the users and their passwords or will it require new usernames and passwords for everyone who signs up? I’m concerned that old posts won’t be attributable to their original posters.
Hi Stephen,
I think I’ve read about every post on importing a phpBB forum into bbpress, but to no avail. I have managed to find above info in the php.config file and used these in the import settings in bbpress import (I was quite sure I finally found what I was looking for, because I first used user:’root’ and password ‘root’), but I’m getting the exact same result as above: “no users to convert. no passwords to clear, etc. etc.
This is what is running:
I have bbpress 2.5.7 No forums created
WP version 4.2.2
phpBB 3.0.x
Clean install of MAMP 3.2.1.
This is what I did:
I made an export of the phpBB database to be imported.
I am running MAMP
Created a new database on MAMP with the same name as the exported one, then imported the database into MAMP
Use ‘localhost’ on port 3306 (same as on MAMP) and dbname, user, password and prefix as found in the php.config file from the phpBB install.
No luck: “no users to convert. no passwords to clear”, etc. etc…
Your help would be much appreciated!
Thanks!
Henk
Just so you guys know WordPress comes with its own emoticons and also since the latest version you can post emojis.
wp-monalisa is a good plugin for custom smilies and stickers though.
It also has a cool feature to import some phpBB smiley packs.
Ha… Using bb_ as your table prefix really did throw me 😉
If you look at lines 59-60 for your topics your selecting the forum_id from the phpbb_topics table and inserting it into post_parent
https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d#file-gistfile1-sql-L59-L60
The same needs to happen for replies, so you should be able to get the topic_id that the reply is for and then insert that into the reply post_parent
https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d#file-gistfile1-sql-L59-L60
The following should do it, assuming that topic_id is actually in the phpbb_posts_text table.
INSERT INTO
bb_posts(post_title,post_excerpt,post_name,post_content,post_type,post_parent)
SELECT post_subject, post_id, post_subject, REPLACE (post_text, CONCAT (":", bbcode_uid), ""), 'reply', topic_id FROM phpbb_posts_text;
No, i have bbPress 2.5.7
Actually, first i tried to use your phPBB v3.x importer and rebuild it for phpBB 1.
But i gave up (just couldn’t understand all the points).
Anyway, – for this moment most problems are already resolved. The only question is:
Isn’t it enough to import replies to bb_posts table?
So I edited the post and copied the SQL code to a gist on GitHub:
https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d
First, it looks like you are importing the phpBB into bbPress 1.x, bbPress 1.x is not supported anymore.
Per @robkk post immediately above you should checkout that link to our docs on the codex on importing to bbPress 2.x, and in general look toward using the bbPress 2.x plugin for WordPress https://wordpress.org/plugins/bbpress/
I’d suggest taking a look at our phPBB v3.x importer and making any change to match the phpBB v1.x database schema changes you would need:
https://bbpress.trac.wordpress.org/browser/branches/2.5/includes/admin/converters/phpBB.php
So your importing from phpBB v1?
Indeed our importers only support phpBB 3.x for bbPress 2.5.x and phpBB v3.1 for bbPress 2.6
Did you write your own phpBB v1 importer or copy and modify the one that is included with bbPress?
There are also some fixes and improvements in our repair tools coming for bbPress 2.6 that hopefully will be released in the next couple of weeks.
I’m happy to take a look at the importer if you made one and/or some data examples, you can post code examples on GitHub here https://gist.github.com/ntwb
(If you added the raw MySQL data from a single forum, a topic of that forum, and a reply of that topic I could give you some tips on what the main issues are that your most likely having)
But i can’t! And, well, what’s the matter, – from wich version of phpBB do i import my forum, as i do it manually?
hmmm you might need @netweb’s help on this one.
You might need to update phpBB (but not to the latest 3.0) but I am not entirely sure.
It is currently on PHPbb 3.1.3.
Known issue that is being worked on.
https://bbpress.trac.wordpress.org/ticket/2716
if you want you can also just patch the current phpbb importer using the most recent file @netweb posted.
Hi,
I just run a small forum and am looking to move it to bbpress. It is currently on PHPbb 3.1.3. I have everything entered in correct I am sure, but all I get when I import is the replies… No users, categories, topics, etc… just replies.
Let me know if you have any suggestions please.
Repair any missing information: Continue
Conversion Complete
No reply_to parents to convert
Converting replies (100 - 199)
Converting replies (0 - 99)
No tags to convert
No super stickies to stick
No stickies to stick
No topics to convert
No forum parents to convert
No forums to convert
No passwords to clear
No users to convert
Starting Conversion
I am importing data from a PHPBB3 3.1.4 installation.
Known issue that is being worked on.
https://bbpress.trac.wordpress.org/ticket/2716
In a WordPress 4.2.2 installation, using bbPress 2.5.7, I am importing data from a PHPBB3 3.1.4 installation. Both PHPBB and WP4.2.2/BBPress 2.5.7 are on the same server.
The import of data (a MySQL database of about 95MB) includes ONLY “replies.” And those imported replies are added to the DB as posts, but those posts are not visible in the WP Admin (they can be seen using a DB tool like PHPMyAdmin). NO forums are imported.
Running Repair Forums tools all work successfully, except the following:
Recalculating reply menu order … No reply positions to recalculate!
Counting the number of topics in each forum… Failed!
Repairing BuddyPress group-forum relationships… Failed!
Counting the number of topics each user has created… Failed!
Counting the number of topics to which each user has replied… Failed!
Counting the number of replies in each forum… Failed!
Basically, so far, I cannot import any data from a PHPBB3 installation, except “replies”.
The PHPBB3 installation is fully functional. It works properly.
Based on the information above, who can give me guidance toward a solution?
Many thanks for your time.
Bill
Hello! I’ve been importing forum from phpBB *the v.1, so converters are not working for me and i’m working through the database.
Well, – forums are showing, so do topics, – when i click on “Replies” in admin – i get no response from server. Yep, there’re about 7,5M replies there, but i guess it has to work despite of that fact?
Those replies are shown in frontend and forums seem to work well.
Another issue is: as i imported forums and topics to db – i could see them both listed at backend and frontend. But if i tried to come into the forum or topic on frontend i’ve got “not found”.
Open forum in backend, then just “save” helped that.
Bulk select topics, edit, changing nothing, just “save” helped that.
What could be the reason? I couldn’t find any changes in _posts table @db. Maybe bbpress uses some other tables for it? Just couldn’t find it out.
Hi guys,
I recently released a plugin for bbPress+WordPress, which adds a brand new shortcode that displays various statistics for your forum, and also includes the bbPress Statistics as an on/off toggle.
For those trying to replicate a similar look and feel to say, phpBB or vBulletin, this will help!
In future versions, I plan on implementing an actual widget – however, due to the way I have written the plugin I get the feeling it would require a full rewrite to achieve that – so it may be a while off yet.
Anyway, if you’re interested, check it out here: https://wordpress.org/plugins/bbpress-improved-statistics-users-online/
I’m pretty happy with what I’ve managed to do with the bbpress installation on my site, rockstarwire.net/community
I have even released a plugin of my own, bbPress Advanced Statistics, which essentially adds a shortcode that displays a phpbb / vBulletin-esque “who’s online & statistics” section, you can see an example on the bottom of my site or you can check out the screenshots.
I’m optimistic about the future of bbPress, I just wish my community actually used the forum after all the work I’ve put into it!
I found the problem and it was really my fault.
1. I had a password that included a character that needed to be escaped. In my case I had a ‘ in a similar manner as this. Not a real password that we use aVgt’67A. Wnen I changed it to a password that was characters and numbers it worked fine.
2. When it asked for the table name I left off the underscore. So I put down phpbb instead of phpbb_.
I hope this will help someone else if they have a similar problem.
