[pkruk]

Hi
I have a bbpress forum 2.6-rc-5 (WordPress 4.9.8, php 7.2)
Google does’t index topics and replyies 🙁
I moved content from another domain (phpbb2) – 3 months ago.

I have 63k not indexed sites in Google console – condition: excluded
12k – excluded: Page scanned but not yet indexed
51k – excluded: Site detected – currently not indexed

WTF with this script?

My forum here -> https://mojakosmetyczka.pl/forum/

Has anyone had a similar problem?
Thx, regards
Pawel

[Gregg]

Forgot to provide the URLs.

Old phpBB forum: http://www.cpakayaker.com/forums/
New Site: http://cpakayaker.wpengine.com/

Current versions of WordPress and bbPress

[Gregg]

Hello,
I’m working with a 3.1v of phpBB. I’ve worked my way through a few hurdles but I’m stuck on the current one. The latest error I’m getting is [Unknown column ‘forums.forum_topics’ in ‘field list’]. For the life of me, I have no idea where this is coming from. The error info

SELECT convert(forums.forum_id USING “utf8mb4”) AS forum_id,convert(forums.parent_id USING “utf8mb4”) AS parent_id,convert(forums.forum_topics USING “utf8mb4”) AS forum_topics,convert(forums.forum_posts USING “utf8mb4”) AS forum_posts,convert(forums.forum_topics_real USING “utf8mb4”) AS forum_topics_real,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 /* From…

The very first error I had to overcome was the utf8mb4 issue. I backed up the database and then restored it in a new database. Judging by what I’m seeing it looks like I wasn’t successful?

[jh20001]

I finally gave up and spent the ungodly amount of hours repairing and bringing the phpbb board back to life and went with that. This was a nice hope for a good change though as WordPress is so much easier to work with stability wise.

[jh20001]

Update: I was able to pull it off (the users at least) with this: https://gist.github.com/pixelnated/5c27a64c450578440554ba902560178f

However, using that the users imported fine, but the forums/topics didn’t. It would list the forums. However when you click on one it will lead to a page that lists the number of content but then show none of it as if there wasn’t any subforums or topics.

So then I used the script I just mentioned but stopped it after the user import. Then I switched back to the original importer which dragged everything else back in (but had to uncheck the stop on errors option).

However, all of the topics loaded as anonymous regardless and it is stuck on step 8, saying Converting anonymous topic authors (500 through 500 of 500), over and over and over and over…every two seconds. This last part also happened when I originally tried the normal importer in the RC 6 release.

At this point, I am just confused and wish the phpbb forums wouldn’t be all mucked up (server 500 error, not db related). *shrug*

[jh20001]

I have the latest RC of bbpress, trying to import from a phpbb 3.2.0 install. I have reset it and started it and reset it and started it and no matter what I do, it starts with “no users to import” and then it imports thousands of forums/topics all assigned to anonymous.

Is there a way to only import users at first and once it successfully does it, then do the normal import of the forums/topics and so forth?

Or is there a common issue that has been found with importing users that can be fixed by adjusting something in the source database (or…something)?

[jh20001]

I finally had enough with phpbb and installed a wordpress JUST for my forums. I installed bbpress in it and have been trying to import the forums over. First it kept erroring saying missing table fields or whatever, so I kept adding the table fields to the areas of the phpbb’s sql DB where it was looking for them..then it got stuck with the “Starting Conversion” and a spinning wheel. Everytime I had chosen “Start Over” I would get the “Specified key was too long; max key length is 1000 bytes” error. Just not my day I guess. 🙁

I had a few questions…

1) Does the importer not support 3.2.0? I figured it does by now since it states phpBB 3.x
2) Can you make the main index page of the WordPress site the forums? This way the wordpress is for nothing other than the forums? (once things do get working…)
3) Am I missing anything lol…I’m rackin my mind on this and it’s driving me nuts 🙂

I can’t wait to be in a better environment for the forums…

[Robin W]

@clivesmith

If you fine with code, then this is how I would go about it

1. create a split in topic & replies, so you have a place to put the ‘featured reply’
Use this piece of code in your functions file

bbp_show_lead_topic

2. then you’ll need a flag for the featured reply.

This code does an ‘advert’ flag for a topic, but has much of the code you’d need to do a flag for a reply to show it is featured – I’ll leave you to work out which bits you’ll need, but the key is the hook to

add_action( 'bbp_theme_before_topic_form_submit_wrapper', 'at_checkbox' );

change this to

add_action( 'bbp_theme_before_reply_form_submit_wrapper', 'at_checkbox' );

amend the references from topic to reply

and add some if(bbp_keymaster() ) to make it only show for you, and you will be most of the way there

// show the "Mark if it is an advert" checkbox on topic form
	add_action( 'bbp_theme_before_topic_form_submit_wrapper', 'at_checkbox' );
		
function at_checkbox() {
    // Text for the topic form
	global $topic_advert_text ;
	?>
		<p>

			<input name="at_advert" id="at_advert" type="checkbox"<?php checked( '1', at_is_advert( bbp_get_topic_id() ) ); ?> value="1" tabindex="<?php bbp_tab_index(); ?>" />

			<?php if ( bbp_is_topic_edit() && ( get_the_author_meta( 'ID' ) != bbp_get_current_user_id() ) ) : ?>

				<label for="at_advert"><?php echo '<span class="dashicons dashicons-awards"></span>'.$topic_advert_text.'</label>' ;?>

			<?php else : ?>

				<label for="at_advert"><?php echo '<span class="dashicons dashicons-awards"></span>'.$topic_advert_text.'</label>' ;?>

			<?php endif; ?>

		</p>
<?php
}
	
//check if topic is advert
function at_is_advert( $topic_id = 0 ) {
	
	$retval 	= false;

	if ( ! empty( $topic_id ) ) {
		$retval = get_post_meta( $topic_id, 'at_topic_is_advert', true );
	}
	return (bool) apply_filters( 'at_is_advert', (bool) $retval, $topic_id );
}

// save the advert state
		add_action( 'bbp_new_topic',  'at_update_topic' );
		add_action( 'bbp_edit_topic',  'at_update_topic' );

//update topic 
function at_update_topic( $topic_id = 0 ) {

		if( isset( $_POST['at_advert'] ) )
			update_post_meta( $topic_id, 'at_topic_is_advert', '1' );
		else
			delete_post_meta( $topic_id, 'at_topic_is_advert' );

	}

3. amend content-single-topic-lead.php in your child theme’s bbpress directory.

by

create a directory on your theme called ‘bbpress’
ie wp-content/themes/%your-theme-name%/bbpress

where %your-theme-name% is the name of your theme

find
wp-content/plugins/bbpress/templates/default/bbpress/content-single-topic-lead.php
Make a copy of this file, and put in in the directory called bbpress that you created above, so you end up with
wp-content/themes/%your-theme-name%/bbpress/content-single-topic-lead.phpbbPress will now use this template instead of the original and you can amend this

This then you can use to add some code

if (at_is_advert( $reply_id )) then….. display this reply

and you should be there

so

the reply form will show a checkbox to make a reply featured available only to say keymaster, and as keymaster you can edit a topic to make it a featured
the content_single_topic_lead will check if a reply is featured and then show it if it is

I wish I had the time to code this all for you, but please if you do work oyt some code, post back here for other to benefit

[Robin W]

ok, so concentrating on a topic and it’s reply list and ignoring forums, you are saying that you would like

from clicking a topic in the forum list (a list of topics in the forum) you are taken to a page which displays

• the topic name
• some content/info but styled and controlled by you
• the replies as per normal
• the reply form

If so I suspect you need to do two things

1. use this piece of code in your functions file

bbp_show_lead_topic

2. amend content-single-topic-lead.php in your child theme’s bbpress directory.

by

create a directory on your theme called ‘bbpress’
ie wp-content/themes/%your-theme-name%/bbpress

where %your-theme-name% is the name of your theme

find
wp-content/plugins/bbpress/templates/default/bbpress/content-single-topic-lead.php
Make a copy of this file, and put in in the directory called bbpress that you created above, so you end up with
wp-content/themes/%your-theme-name%/bbpress/content-single-topic-lead.phpbbPress will now use this template instead of the original and you can amend this

I have no idea how technical you are and whether that gives you enough to go ahead and fix, or if you need further help – let me know

[elawrenc01]

I’m new to BBPress and I was looking at a few different sites for ideas. I run a PHPBB forum right now but I want to switch to BBPress (already have, it’s just not live yet)
I was curious how I can achieve this look? I’m guessing this isn’t CSS but some coding snippet, I want to be able to create a category and have the sub forums listed like this picture. If someone can point me in the right direction I can probably take it from there…

View post on imgur.com

[elawrenc01]

Just an update, I was able to successfully import a PHPBB 3.22 database into Bbpress, including users. I hope to try it again with a bigger database, but so far, so good.

[opeth85]

Hi,
I have the WP page http://www.jdmspritturkey.com and the phpbb forum http://www.jdmspiritturkey.com/forum and its all alive for 2 years. I have some problems with the phpbb so i want to import it to bbpress so the portal and the forum will be fully integrated.

If i import to bbpress what will happen to wp portal writings, users etc or is there any strategy with no casulties?

Our wp page version is 4.9.8 and the phpbb is 3.2.2

Thanks for the answers.

[elawrenc01]

Hi,

PHPBB is now on 3.22 . Apparently a bunch of the table columns have changed.

I’m willing to install bbpress 2.6 to see what happens, I have installed a test wordpress site, but I can’t seem to find where to download it.

Any info about converting a 3.22 PHPBB database?

[Ray Konopka]

I am trying to import the forums and topics from our existing phpBB forums. There are about a dozen forums, and about 400 topics and 1600 posts. I have set the values on the Import Forums page to the following:

Select Platform = phpBB
Database Server = mssql2.<hostingdomain>.com
Database Port = 3306
Database Name = <name of the database>
Database Username = <admin user>
Database Password = <password>
Table Prefix = phpbb_

However, when I start the conversion, it reports “No forums to convert”, “No forum parents to convert”, and so on.

I do not get any errors when I run the conversion. The existing phpBB forums are in a MSSQL database and not a MySQL database. I suspect that this may be the reason nothing is discovered.

Any help would be appreciated.

Ray
bbPress Version 2.5.14
WordPress 4.9.6 running Divi theme

[Anonymous User]

Because here is a reference to it from 5 years ago:

phpBB import username issue

and I can confirm that it is happening because of bbpress, though I don’t understand why.

[matrixino]

Hello,
I migrated from phpBB to bbPress recently. My forum has ~1Million posts. My postmeta table is 30GB.
Is there anything I can do to shrink it?
I noticed there are many lines for every post like _bbp_old_xxxx, which i suspect comes from migration.
It’s safe to delete all those records with _old_ in it? Or anything else? 30GB seems quite too much even for that amount of posts, compared to the old phpbb db size…

[Stephen Edgar]

Checkout the phpBB converter, it’s one of the best example implementations.

Use _bbp_old_topic_id to grab your old topic id:
https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/phpBB.php#L183

p.s. The above phpBB converter uses bbPress 2.6 alpha which has many new refinements for the importer over bbPress 2.5, I’d suggest you use bbPress 2.6 alpha for any imports due to those improvements, it can be found here https://bbpress.org/download (bbPress.org and wordpress.org both use bbPress 2.6)

[saulmayo]

I wanted to know if you can help me.

I get to import everything except the users.

I’m trying to import a phpBB3.2.2 to bbPress.
I’ve tried with bbPress 2.5.14, bbPress 2.6 RC5 and bbPress 2.6 beta2.
I’ve tried in the 3 modes with the phpBB.php of dintintos topics but none of them work for me;
– https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/phpBB.php
– https://gist.github.com/pixelnated/5c27a64c450578440554ba902560178f

I’m desperate. could you help me?

[jameshogan03]

Bbpress users and developers,

After creating my bbpress forum I was disappointed to find there is no easy way to get full functionality (notifications etc) on smartphone, since tapatalk cut ties with wordpress.

I have found a new application called Topic’it, who have established compatibility with Forumotion and PHPbb software. Their app appears in both the android and ios app stores, and is essentially the same proposed thing as tapatalk.

They are searching for people to create plugins to make their app compatible with more forum platforms. They have given me permission to access their API, so I’m going to attempt this as a solo project, but it will take me time as I’m a computer hobbyist and not a developer in any way.

For the love of Bbpress, let someone more adept than me get over there and give it a shot!

Of course I’ll share my work here if I manage to connect.

[irishhealer]

I’ve tried the import using 2.6-RC5 and all I get when trying to import my phpbb 3.2.2 forum is

Stopped

Continuing Import…

So it tries to import for a second and then it stops without error.

[d d]

Just in case anyone is interested, I added to my BuddyPress support thread. Still no reply, but here’s what I found…

I’m seeing the pattern now. Even in forums more than a decade old (and before @ mentions became a feature on many sites), people used @username even if it did nothing. This was simply shorthand for getting a specific person’s attention in a thread with many participants.

Looks as though BuddyPress is trying to be smart and pull these @ mentions from old content and add them to the activity stream. Since it’s a new addition to the activity stream, BuddyPress also thinks it’s new and therefore sends out an email notification. This is why it only affects old members.

Now… How do stop it?

Stopping notifications across the board is not a good idea. Even if I do it now and turn it back on later, we’ll never know when an old member might join us again. So really the only solution is to have BuddyPress stop importing old forum posting with the ‘@’ character into a new activity.
Still open to suggestions. Thanks.

After import of phpBB, sending notifications to users on very old replies

[d d]

I had an old WP site that came back to life. It was running phpBB and I successfully imported everything to bbPress. In the new site, we are also using BuddyPress. Old users are reporting that they are now getting email notifications on replies from posts many years old.

Thoughts? Ideas?

[dheerajsharma14]

Hi all,

have gone through numerous posts on the issues of importing phpbb to bbpress. I have been using the latest RC version of bbpress. I am using latest version of WP and phpbb 3.0.11

I have tried cleaning, repairing, resetting and trying again. Nothing works. It shows everything as 0 items to import, no forum, no topics. Only it imports replies without anything else.

Any help will be appreciated. I really want to move away from phpbb forum 🙁

[lantaarntje]

This fix indeed has the intention to convert my phpbb3.2 forum to bbpress 2.6 beta 2 😉 The conversion is still running so i don’t know for sure 😛 #goodjob

[ladolce]

Want to know if it’s possible to use bbprss like phpbb where you can set userpermissions to access certain files. We have a site where it is a forum but there is a section where users and subscribe and be able to download files that are on certain posts. It this possible to setup the same as this site – http://www.plasmaspider.com ?
Thanks