[giobby]

I try to post here the steps I did to import from PHPBB to BuddyPress v2.6 alpha.
The concept is the same of what you’ve already read in my previous post but I think the SQL scripts are different.

So first of all I’ve created manually all the missing columns in my PHPBB tables (I was converting from an old version of PHPBB and the converter was expecting some columns that didn’t exist – this could not be your case):

ALTER TABLE forum_forums
ADD forum_posts_approved numeric;

ALTER TABLE forum_forums
ADD forum_topics_approved numeric;

ALTER TABLE forum_topics
ADD topic_posts_approved numeric;

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_facebook varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_twitter varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_occupation varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_interests varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_location varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_youtube varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_skype varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_googleplus varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_website varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_aol varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_yahoo varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_icq varchar(255);

ALTER TABLE forum_profile_fields_data
ADD pf_phpbb_wlm varchar(255);

Then I’ve performed this KEY STEP: insert a dummy row in the WP_USERS table with a very high userid (e.g.: 99999). This should be higher than the highest userid you have in your phpbb installation.
In this way, when the users get converted, the system will assigned IDs starting from 100000 (again, if you have more than 100K users, then you need a higher value).
This step is necessary, so you will always be able to distinguish the old id (PHPBB, < 100000) from the new one assigned after conversion (>= 100000).

After that I’ve started the conversion (it took long).
After converting, the authors of certain posts were wrong.
There is a table that is generated after the conversion that maps the old IDs to the new ones.
So I’ve execute the following scripts to readjust (cannot guarantee this would fix entirely the problem):

/* Get all posts with wrong author and correspondent right author from translator table */

create table TMP_ORPHANS as
select
<YOUR_SCHEMA>.wp_posts.ID,
<YOUR_SCHEMA>.wp_posts.post_author,
<YOUR_SCHEMA>.wp_bbp_converter_translator.value_id real_author,
IFNULL(<YOUR_SCHEMA>.wp_posts.post_date, NULL) post_date,
IFNULL(<YOUR_SCHEMA>.wp_posts.post_date_gmt, NULL) post_date_gmt,
<YOUR_SCHEMA>.wp_posts.post_content,
CASE
WHEN <YOUR_SCHEMA>.wp_posts.post_type = ‘reply’
THEN (SELECT tmposts.post_title from <YOUR_SCHEMA>.wp_posts as tmposts where tmposts.id = <YOUR_SCHEMA>.wp_posts.post_parent)
ELSE <YOUR_SCHEMA>.wp_posts.post_title
END post_title,
<YOUR_SCHEMA>.wp_posts.post_excerpt,
<YOUR_SCHEMA>.wp_posts.post_status,
<YOUR_SCHEMA>.wp_posts.comment_status,
<YOUR_SCHEMA>.wp_posts.ping_status,
<YOUR_SCHEMA>.wp_posts.post_password,
<YOUR_SCHEMA>.wp_posts.post_name,
<YOUR_SCHEMA>.wp_posts.to_ping,
<YOUR_SCHEMA>.wp_posts.pinged,
IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified, NULL) post_modified,
IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified_gmt, NULL) post_modified_gmt,
<YOUR_SCHEMA>.wp_posts.post_content_filtered,
<YOUR_SCHEMA>.wp_posts.post_parent,
<YOUR_SCHEMA>.wp_posts.guid,
<YOUR_SCHEMA>.wp_posts.menu_order,
<YOUR_SCHEMA>.wp_posts.post_type,
<YOUR_SCHEMA>.wp_posts.post_mime_type,
<YOUR_SCHEMA>.wp_posts.comment_count,
( select <YOUR_SCHEMA>.wp_postmeta.meta_value
from <YOUR_SCHEMA>.wp_postmeta
where
<YOUR_SCHEMA>.wp_postmeta.meta_key = ‘_bbp_author_ip’ and
<YOUR_SCHEMA>.wp_postmeta.post_id = <YOUR_SCHEMA>.wp_posts.id
) user_ip
from <YOUR_SCHEMA>.wp_posts
left join <YOUR_SCHEMA>.wp_users on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_users.id
left join <YOUR_SCHEMA>.wp_bbp_converter_translator on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_bbp_converter_translator.meta_value
where
<YOUR_SCHEMA>.wp_posts.post_type in (‘forum’, ‘reply’, ‘topic’) and
(<YOUR_SCHEMA>.wp_users.id is null or
<YOUR_SCHEMA>.wp_users.id = 1) and
<YOUR_SCHEMA>.wp_bbp_converter_translator.value_type = ‘user’ and
<YOUR_SCHEMA>.wp_bbp_converter_translator.meta_key = ‘_bbp_old_user_id’;

/* Do this to be able to create indexes later – some may not work */
ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);

/* we create indexes to speed up the update process */
ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);

/* Revert bad authors to good authors */
UPDATE
<YOUR_SCHEMA>.wp_postsINNER JOIN <YOUR_SCHEMA>.TMP_ORPHANS
ON <YOUR_SCHEMA>.wp_posts.id = <YOUR_SCHEMA>.TMP_ORPHANS.id
set <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.TMP_ORPHANS.real_author
where <YOUR_SCHEMA>.wp_posts.post_type in (‘reply’, ‘topic’) ;

DROP TABLE <YOUR_SCHEMA>.TMP_ORPHANS;

I hope this helps.

Gio

[dandr69]

I deactivated bbpress today, and the next thing all site is broke with HTTP code 500.
I tried to reset plugins, reset themes, checked for htaccess entries, nothing.
I put it back, no chance.

Class ‘BBP_Theme_Compat’ not found in /home/sites/pcforum.ro/public_html/wp-content/themes/pcf/functions_bb.php on line 32

Update – i fix it.
Found the code and remove it. Thanks

[mbfit]

Ah ok thanks! I did find the code for that on here

[Stephen Edgar]

Check out the docs in the codex, this I think should help you get started:

Functions files and child themes – explained !

[Stephen Edgar]

You can do this by creating a child theme and editing the form-anonymous template, you can find details on doing this here https://codex.bbpress.org/functions-files-and-child-themes-explained/

[403laura]

I read through this forum because I am experiencing similar issues…(I am a keyholder). I am using both Buddypress and bbpress. I do not have programming knowledge or experience, I do not understand codex or php, I’m just looking for someone to hopefully assist me with a simple solution to these issues, so that when people sign up as users, their interactions are seamless and they are able to quickly find the information they are looking for.

1. When logged in as a user, I am not able to access forums without using the URL to the page. I used the “user roles and capabilities” plugin as recommended above, to change the user settings in the back end so I could view “private” posts and that sort of worked but I still have to use the URL to find the forum page. I have also run the tools for both Buddypress and bbpress. There are several links in the user profile area but they all seem to direct me to the user activities only…I cannot link to any of the content posted by other users through those links. (Same with the tool bar at the top of the page and all of the drop down menus).

2. I just created a topic to post under a forum. Under my keyholder account, I am able to see the topic when I click on it but when I try clicking on it as a user, it doesnt show up. It just tells me there is “0 replies, has 1 post, and last updated by me” and the topic is not there.

[evila]

No plugin bbpress Login Register Links OnForumPage

Quando coloco echo do_shortcode(‘[bbp-login]‘); já imprime o formulário, como que eu faço para colocar o nome login e quando eu clicar ir para esse formulário?

[Robkk]

here is what I got.

I had to edit loop-single-reply.php after all,

I used a conditional to output the minimal layout only for single topics only.

I had to use bbp_reply_permalink(); instead of bbp_reply_url();.

Like I said you for sure do have to edit the bbPress reply titles plugin for what you exactly want, your gonna have to possibly make the reply title required as well.

You are going to end up doing a lot of customization to get the rest of the funcitonality, because I am not sure how submitting a threaded reply works on the other forum.

You are also going to figure out how to show the threads on the single reply page, for the specific topic they were originally from.

Bunch more customizing, much more than free support could possible help with.

I will share any custom templates I used later.

[milliways2650]

Thank you for your help. Unfortunately I think I have reached a dead end.

I decided to give another try. I created a new phpbb database, and a new WordPress installation, just in case I had caused some damage.

Attempting the import produced the following error. Presumably it is objecting to something in my phpbb database. I can not find ‘forum_topics_approved’ anywhere (but have little experience with MySQL).

WordPress database error: [Unknown column ‘forums.forum_topics_approved’ in ‘field list’]
SELECT convert(forums.forum_id USING “utf8mb4”) AS forum_id,convert(forums.parent_id USING “utf8mb4”) AS parent_id,convert(forums.forum_topics_approved USING “utf8mb4”) AS forum_topics_approved,convert(forums.forum_posts_approved USING “utf8mb4”) AS forum_posts_approved,convert(forums.forum_name USING “utf8mb4”) AS forum_name,convert(forums.forum_desc USING “utf8mb4”) AS forum_desc,convert(forums.left_id USING “utf8mb4”) AS left_id,convert(forums.forum_type USING “utf8mb4”) AS forum_type,convert(forums.forum_status USING “utf8mb4”) AS forum_status FROM phpbb_forums AS forums LIMIT 0, 100

No forums to convert

Starting Conversion

My comment about lack of stats was that there was no positive feedback e.g. x forums imported, which would be helpful.

I did not understand the comment “If you also view the source of the page, right click and “inspect” will also bring this up, you should see some debug code showing the SQL queries being performed during the import:”

[Robkk]

Use this custom CSS, add it anywhere you can put custom css like in a child themes style.css file or in a custom css plugin.

#bbpress-forums p.bbp-topic-meta img.avatar, 
#bbpress-forums ul.bbp-reply-revision-log img.avatar, 
#bbpress-forums ul.bbp-topic-revision-log img.avatar, 
#bbpress-forums div.bbp-template-notice img.avatar, 
#bbpress-forums .widget_display_topics img.avatar, 
#bbpress-forums .widget_display_replies img.avatar {
  float: none;
  margin-bottom: auto;
  border: none;
  vertical-align: middle;
  padding: 0;
}

[Robkk]

@douglsmith

Oh shoot your right Doug. I might have suggested the wrong thing.

I have also seen this happen with TinyMCE activated. It seems to be iOS users and they claim that they haven’t pasted anything, but I have not observed this for myself yet.

I have no idea if it could be IOS specific?? I can check I guess?? Damn thats weird if it is.

@harjindersingh645

You will need to use this since you copied text to your forums. Pasting other articles content in the Visual Editor in TinyMCE could end up posting the HTML content, its recommended to post any articles content into the HTML editor, but you can also use this PHP code snippet from this guide below, that I think Doug did add, that would help resolve this issue that could be caused pasting articles in the visual editor for any further posts submitted.

function bbp_tinymce_paste_plain_text( $plugins = array() ) {
    $plugins[] = 'paste';
    return $plugins;
}
add_filter( 'bbp_get_tiny_mce_plugins', 'bbp_tinymce_paste_plain_text' );

https://codex.bbpress.org/enable-visual-editor/

For editing the already messed up posts, I think you can just copy the original post, edit it, and paste the text into the HTML editor over the original content and hopefully that would fix it. THere might be also a chance of it going away just by editing it, then just republishing after you used the code snippet.

[Stephen Edgar]

No, you should not be using phpBB Converter file 5795, you should be using the version that is included with 2.6-alpha.

That will fix the problem in your screenshot.

[Stephen Edgar]

It does give stats as it imports, you should be something similar to:

If you also view the source of the page, right click and “inspect” will also bring this up, you should see some debug code showing the SQL queries being performed during the import:

The forums, if imported will be in the wp_posts table of your WordPress database, if you filter the posts and search the post_type column for forum, topic, or reply you should see any imported posts.

[Robin W]

sorry the code is/was untested.

Try this with a correction

function add_custom_role( $bbp_roles ) {
 
$bbp_roles['my_custom_role1'] = array(
'name' => 'vip',
'capabilities' => bbp_get_caps_for_role( bbp_get_participant_role() ) // the same capabilities as participants
);
return $bbp_roles;
}
add_filter( 'bbp_get_dynamic_roles', 'add_custom_role', 1 );

[Stephen Edgar]

On the importer screen there is an option to select what forum you are importing from, I presume you selected phpBB from that dropdown?

[Robkk]

Install the other wpfix 2 plugin. It should have the same code snippet you are trying to use, without having to place any code anywhere.

I recommend users who are beginners to not edit bbPress core files. Or any other plugin/theme/wordpress core files unless you know exactly what you are doing code wise.

[Robkk]

Okay, yeah this site does have an interesting layout.

http://eat.at/swap/forum1/251729_Help_Need_recipe_for_fig_jam_ASAP

From what I can see real quick.

Your not going to edit the loop-single-reply.php file like @netweb suggested, because after clicking the reply title link you are redirected to a normal layout single reply. So to get this layout you are going to edit content-single-topic.php, remove the pagination, and place a custom template instead of loop-replies..php so that you won’t mess with replies in a forum profile.

<?php if ( bbp_has_replies() ) : ?>

	<?php bbp_get_template_part( 'pagination', 'replies' ); ?>

	<?php bbp_get_template_part( 'loop',       'replies' ); ?>

	<?php bbp_get_template_part( 'pagination', 'replies' ); ?>

<?php endif; ?>

Replace the above code with this for example.

<?php if ( bbp_has_replies() ) : ?>

	<?php bbp_get_template_part( 'loop',       'classic-threads' ); ?>

<?php endif; ?>

The code that will be in loop-classic-threads.phpwill be a copy of loop-replies.php and a very minimal loop-single-reply.php. Wherever say <?php bbp_get_template_part( 'loop', 'single-reply' ); ?> is called in the new loop-classic-threads.php file, I would just copy the whole loop-single-reply.php template where that get template function was and keep only the code you need.

The code that is going to be in the area you put the loop-single-reply.php code is only going to have the username, date, maybe the reply positions, and reply title. The reply title is going to mostly come from a customized version of the bbPress reply title plugin. But you are going to output the reply title in the template as a link. A link (I think bbp_reply_url() is the right function ) to the single reply template, which is only 1 reply isolated, which bbPress can do.

Does this help enough??

I’m gonna see if I can recreate most of this layout later

[Robkk]

You did try Robins plugin right. I think this plugin was created to solve this exact issue that might occur when using membership plugins. It mainly fixes a bug in bbPress that is triggered using these plugins.

http://www.rewweb.co.uk/bbpress-wp4-fix/

There is also this which basically includes the show lead function in the plugin, that is still here.

https://codex.bbpress.org/bbp_show_lead_topic/

http://www.rewweb.co.uk/bbpress-wp4-fix2/

[xmanca]

Hi Stephen,
I had actually created the custom template previously and tried what you said. But all it does is eliminate the content and this is why I moved on to try to identify what is going on in the function. I would much rather not touch the function code and do everything via custom template for a lot of reasons including staying safe with future updates.

As it is, if I remove the reply_content code in the child theme, it still leaves the replies in there but just with no content in them other than the author area. If I remove the author area as well then I no longer see anything but there are no links to the replies.

I tried figuring out some sort of reply_url but nothing has worked for me – where I’m stuck. The closest I’ve come is to use this:

<?php bbp_reply_url(); ?>

in that same area. The result is that I get plain text urls (not hyperlinks) in a thread tree of sorts. However those links do not link to the actual content of the reply. So what you get is like this:

The topic is at the url http://testsite.com/forum/topic/test1/
The content of the original post is at the top and underneath are urls like:
August 27, 2016 at 9:04 pm http://testsite.com/forum/topic/test1/#post-10
August 27, 2016 at 9:06 pm http://testsite.com/forum/topic/test1/#post-11
August 27, 2016 at 9:03 pm http://testsite.com/forum/topic/test1/#post-8
August 27, 2016 at 9:04 pm http://testsite.com/forum/topic/test1/#post-9

If I go to any of those urls then it just displays the original post and scrolls down to where that URL exists in the tree below the original post content. The actual content of the reply is not displayed – just the content of the original post.

[Pascal Casier]

Did you try to switch of the main one ? https://codex.bbpress.org/layout-and-functionality-examples-you-can-use/#4-turning-off-or-changing-breadcrumbs

Pascal.

[istrix]

@robin-w
I undo my post above in functions file then paste the code you provide.

Then…

The site.domain page isn’t working

site.domain is currently unable to handle this request.
HTTP ERROR 500

please help

[Robin W]

if tyoun just want a role called VIP with participant capabilities, then undo whatever you did above, and then put this in your functions file

function add_custom_role( $bbp_roles ) {
 
$bbp_roles[''my_custom_role1'] = array(
'name' => 'vip',
'capabilities' => bbp_get_caps_for_role( bbp_get_participant_role() ) // the same capabilities as participants
);
return $bbp_roles;
}
add_filter( 'bbp_get_dynamic_roles', 'add_custom_role', 1 );

[milliways2650]

I have setup WordPress on a computer (Raspberry Pi3 running Ubuntu MATE 16.04) and it is working.

I installed bbPress and am trying to import my phpBB Forum http://binnie.id.au/BulletinBoard/index.php

It is unclear exactly what I need to enter in the “Import Forums” dialog.
I have tried many different options. I am assuming that this is asking for MySQL details.

My CPanel reports
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.48-cll – MySQL Community Server (GPL)
Protocol version: 10
User: iabi1038@localhost
Server charset: UTF-8 Unicode (utf8)

MySQL® Databases shows
Database Size Privileged Users
iabi1038_phpb1 2.32 MB iabi1038_phpb1

I have tried

Database Server binnie.id.au
Database Name iabi1038_phpb1
Database User iabi1038_phpb1
Table Prefix phpbb_

This chugs along, with no obvious errors, except it seems to find nothing.

No reply_to parents to convert

No replies to convert

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

[istrix]

Please help me create a new bbp role w/c is VIP.

add_filter( 'bbp_get_dynamic_roles', 'ntwb_bbpress_custom_role_names' );
  
function ntwb_bbpress_custom_role_names() {
    return array(
  
        // Keymaster
        bbp_get_keymaster_role() => array(
            'name'         => 'Administrator',
            'capabilities' => bbp_get_caps_for_role( bbp_get_keymaster_role() )
        ),
  
        // Moderator
        bbp_get_moderator_role() => array(
            'name'         => 'Moderator',
            'capabilities' => bbp_get_caps_for_role( bbp_get_moderator_role() )
        ),
  
        // Participant
        bbp_get_participant_role() => array(
            'name'         => 'Member',
            'capabilities' => bbp_get_caps_for_role( bbp_get_participant_role() )
        ),
  
        // VIP
        bbp_get_participant_role() => array(
            'name'         => 'VIP',
            'capabilities' => bbp_get_caps_for_role( bbp_get_participant_role() )
        ),
  
        // Spectator
        bbp_get_spectator_role() => array(
            'name'         => 'Guest',
            'capabilities' => bbp_get_caps_for_role( bbp_get_spectator_role() )
        ),
  
        // Blocked
        bbp_get_blocked_role() => array(
            'name'         => 'Banned',
            'capabilities' => bbp_get_caps_for_role( bbp_get_blocked_role() )
        )
    );
}

[Stephen Edgar]

If you’re using any phpBB mods this might cause issues.

You also need to make sure you use bbPress 2.6 alpha, which includes all the changes required , you cannot simply copy the changed phpBB.php file to a different bbPress version.

To use the most up to date phpBB importer use bbPress 2.6-alpha as I pointed out, if you have to use the old phpBB version use bbPress 2.5.10.

But as I’ve said, there are huge improvements to the phpBB importer in 2.6-alpha so updating phpBB to the latest version is my recommendation.