[paripari]

Hi guys

Please see attached screenshot. When not logged into the forum, there is the standard message “You must be logged in to create new topics”

I want to change that text and add a link there to signup to my membership page, i used the explore inspection tool, and think i pin pointed it to this file ” bbp-template-notice” BUT i cant find that file any where…

Please advice

[newz12]

I have hired someone to look at the database and this is his comments:

==========================================

so, basically your query is processing too many records in a couple of tables wp_posts(1’980’935 records) and wp_postmeta(10’818’678). It matches and returns 57’639 records.

The core query is:
select SQL_NO_CACHE wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (wp_posts.ID = 515125 OR wp_posts.post_parent = 515125);

which returns 399’291 record for 2.1s
which is a huge join

Then the extra “where” conditions add extra time. The query bellow:

select SQL_NO_CACHE wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (wp_posts.ID = 515125 OR wp_posts.post_parent = 515125) AND wp_postmeta.meta_key = ‘_bbp_forum_id’;

reduces the returned records to: 57’639 and in fact the rest of the where statements do not change the final result but are only adding more time for processing.
The query takes about 3s.

Both queries above are well indexed and are execucuted in the optimal way.
With this amount of returned records matched against the 2 big tables (~11mln and ~2mln records in each) executon time of less than 3s can not be achieved.

is this forum using a custom php code developed in house?

ME: It is using bbPress, which runs on WordPress

the thing is, this code is not optimal in term of database design
because it’s using a couple of wordpress general storage tables
to store the forum posts and threads
as you can guess this 2 tables have a lot more data in it along the forum data
from other hand the query you sent has too many “where” conditions
which are not relevant at all

AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN (‘515120′,’515123’) ) )
AND wp_posts.post_type IN (‘topic’, ‘reply’)
AND (
(wp_posts.post_status = ‘publish’ OR (wp_posts.post_status = ‘pending’ AND wp_posts.post_author = 0) OR wp_posts.post_status = ‘closed’ OR wp_posts.post_status = ‘hidden’)
OR
(wp_posts.post_author = 0 AND (wp_posts.post_status = ‘private’))
)

non of this are changing the final result at all, but are slowing the core query with extra time

in short – there is not an easy “magic” fix in the database side
as I said the core query is well indexed and runs optimal by the SQL engine
the only thing can be done is to change the query a bit
but we can hardly get it under 2.5s
and this will require PHP code changes

ME: What would be your suggestion to achieve a similar performance with database?

get rid of the WP
the WP pluggin you use is a forum implementation on top of WP
understand that, but you are expecting something by this WP pluggin that it can’t provide

with storring everyhing in a couple of tables – that can’t be done

won’t even comment:
AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN (‘515120′,’515123’) ) )

this part
wp_postmeta | CREATE TABLE wp_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (meta_id
)

as you can see meta_value field is a longtext!!!
you can imagine how can you filter by this field
without index
scanning millions of records by a field that holds huge strings
in same table wp stores all sessions, etc..

just to imagine how much extra data is stored in wp_postmeta table
here is a some stats by meta_key and the number of records (top 20 or so):

| external_image_id | 100828 |
| external_place_lat | 100845 |
| external_place_lng | 100862 |
| external_upload_batch | 110848 |
| amazonS3_cache | 121546 |
| _bbp_activity_id | 199233 |
| filter | 239951 |
| id_field | 239952 |
| __defaults_set | 239974 |
| _bbp_post_id | 1418227 |
| _bbp_topic_id | 1426899 |
| _bbp_author_ip | 1426899 |
| _bbp_forum_id | 1426909 |
| _barcelona_vote_up | 1732202 |
| _barcelona_views | 1732206 |

in fact this WP pluggin is using mysql as a simple storage and not as a relational DB
as I said above it’s a bad DB design problem
because it’s a just a pluggin/extension of a CMS system

==========================================================

Basically he is telling me that we won’t be able to achieve good loading time, because it is running on WordPress and the database design is a problem.

What do you think, is there hope?

We run a forum with 1.4 million posts and almost 100k members, if it can give you an idea.

[sagetopia]

I’m seeing issues that seem to only affect public forums (private or hidden work as expected). Public forums don’t appear in the admin ‘All’ list view, although they do appear under ‘Published’. Attempting to view the single page for a public forum gives a 404 when logged in. When not logged in, it gives the following fatal error: Fatal error: Uncaught Error: [] operator not supported for strings in .../plugins/bbpress/includes/forums/functions.php on line 1855 Looking at that line, the get method of WP_Query returns an empty string if no matching key is found. That explains the [] operator error and adding a default empty array to the call does fix the issue for non logged in users. However, the root cause must be higher up the call chain because it doesn’t fix the permalink problem.

[Pascal Casier]

Hi,
Probably seen as spam ? Check any ‘Pending/draft/spam’ under replies, in Akismet, or any other plugins that could block this.
If you don’t find it, deactivate all plugins except bbPress and try again. Also switch to a default theme to see if that helps.
Pascal.

[dominikb]

now i added this to functions.php:

//code to add forum-roles

function add_new_roles( $bbp_roles )
{
    /* Add a role called tutor */
    $bbp_roles['bbp_mentor'] = array(
        'name' => 'Mentor',
        'capabilities' => custom_capabilities( 'bbp_mentor' )
        );

    /* Add a role called pupil */
    $bbp_roles['bbp_kursteilnehmer'] = array(
        'name' => 'Kursteilnehmer',
        'capabilities' => custom_capabilities( 'bbp_kursteilnehmer' )
        );

    return $bbp_roles;
}

add_filter( 'bbp_get_dynamic_roles', 'add_new_roles', 1 );

function add_role_caps_filter( $caps, $role )
{
    /* Only filter for roles we are interested in! */
    if( $role == 'bbp_mentor' )
        $caps = custom_capabilities( $role );

    if( $role == 'bbp_kursteilnehmer' )
        $caps = custom_capabilities( $role );

    return $caps;
}

add_filter( 'bbp_get_caps_for_role', 'add_role_caps_filter', 10, 2 );

function custom_capabilities( $role )
{
    switch ( $role )
    {

        /* Capabilities for 'mentor' role */
        case 'bbp_mentor':
            return array(
                // Primary caps
                'spectate'              => true,
                'participate'           => true,
                'moderate'              => false,
                'throttle'              => false,
                'view_trash'            => false,

                // Forum caps
                'publish_forums'        => false,
                'edit_forums'           => false,
                'edit_others_forums'    => false,
                'delete_forums'         => false,
                'delete_others_forums'  => false,
                'read_private_forums'   => true,
                'read_hidden_forums'    => false,

                // Topic caps
                'publish_topics'        => true,
                'edit_topics'           => true,
                'edit_others_topics'    => false,
                'delete_topics'         => false,
                'delete_others_topics'  => false,
                'read_private_topics'   => true,

                // Reply caps
                'publish_replies'       => true,
                'edit_replies'          => true,
                'edit_others_replies'   => false,
                'delete_replies'        => false,
                'delete_others_replies' => false,
                'read_private_replies'  => true,

                // Topic tag caps
                'manage_topic_tags'     => false,
                'edit_topic_tags'       => false,
                'delete_topic_tags'     => false,
                'assign_topic_tags'     => true,
            );

            /* Capabilities for 'kursteilnehmer' role */
        case 'bbp_kursteilnehmer':
            return array(
                // Primary caps
                'spectate'              => true,
                'participate'           => true,
                'moderate'              => false,
                'throttle'              => false,
                'view_trash'            => false,

                // Forum caps
                'publish_forums'        => false,
                'edit_forums'           => false,
                'edit_others_forums'    => false,
                'delete_forums'         => false,
                'delete_others_forums'  => false,
                'read_private_forums'   => true,
                'read_hidden_forums'    => false,

                // Topic caps
                'publish_topics'        => true,
                'edit_topics'           => true,
                'edit_others_topics'    => false,
                'delete_topics'         => false,
                'delete_others_topics'  => false,
                'read_private_topics'   => true,

                // Reply caps
                'publish_replies'       => true,
                'edit_replies'          => true,
                'edit_others_replies'   => false,
                'delete_replies'        => false,
                'delete_others_replies' => false,
                'read_private_replies'  => true,

                // Topic tag caps
                'manage_topic_tags'     => false,
                'edit_topic_tags'       => false,
                'delete_topic_tags'     => false,
                'assign_topic_tags'     => true,
            );

            break;

        default :
            return $role;
    }
}

it still does not work.

Any hints, whats wrong here?

[akira010203]

Hello!

I’ve added a new custom forum main page with some bb-codes instead of the default main page and I get a little disapointment, I can’t find out how to change the forums root page which redirect to mysite/forums instead of mysite/mynewmainforumpage.

Is it possible to do it?

Thanks!

[vikefans]

Hello I am interested in setting up bbpress but I already have a forum software that is using the page named Forums. Is this going to cause problems or can I set the default page to use as a different page? Say Forum instead?

[Roman Matovsky]

I use last version. And I downloaded from here https://translate.wordpress.org/projects/wp-plugins/bbpress/stable/ru/default
But problem is: files shouldn’t be here /wp-content/languages/bbpress/ , files should be here /wp-content/languages/plugins/
Change instruction please https://codex.bbpress.org/getting-started/bbpress-in-your-language/

[kbaldac]

We are running WordPress 4.7.3 with bbpress 2.5.12 at http://one-name.org. This mysql error started appearing last night when accessing any forum, topic or reply. I believe it relates to the ‘AND ((()))’ clause:

Apr 06, 13:03:46
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘))) AND ggx_posts.post_type IN (‘topic’, ‘reply’) AND (ggx_posts.post_status = ‘ at line 1 for query SELECT ggx_posts.* FROM ggx_posts FORCE INDEX (PRIMARY, post_parent) WHERE 1=1 AND (ggx_posts.ID = 29822 OR ggx_posts.post_parent = 29822) AND ((())) AND ggx_posts.post_type IN (‘topic’, ‘reply’) AND (ggx_posts.post_status = ‘publish’ OR ggx_posts.post_status = ‘closed’ OR ggx_posts.post_status = ‘retained’ OR ggx_posts.post_author = 5528 AND ggx_posts.post_status = ‘private’ OR ggx_posts.post_author = 5528 AND ggx_posts.post_status = ‘hidden’) ORDER BY ggx_posts.post_date ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), apply_filters(‘template_include’), WP_Hook->apply_filters, call_user_func_array, bbp_template_include, apply_filters(‘bbp_template_include’), WP_Hook->apply_filters, call_user_func_array, bbp_template_include_theme_compat, BBP_Shortcodes->display_topic, bbp_get_template_part, bbp_locate_template, load_template, require(‘/plugins/bbpress/templates/default/bbpress/content-single-topic.php’), bbp_has_replies, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

[Roman Matovsky]

Didn’t work 🙁
I have /wp-content/languages/ So, I created /wp-content/languages/bbpress/
I dowloaded .PO from here https://translate.wordpress.org/projects/bbpress/2.4.x/ru/default
Changed what I need. Saved as bbpress-ru_RU.po Compilated to .MO and put both (PO and MO) to /wp-content/languages/bbpress/ (bbpress-ru_RU.po and bbpress-ru_RU.mo)
I even clean cash. But nothing.
Help me please.

[angrywarrior]

1.) I have tested and deactived all plugins, but there is no difference. BBpress just throws 404 on all child forums.

2.) i have tested with permalinks. Nothing works except for “default”, then it finds the sub forums and displays them all other permalink modes/options fails.

3.) I have checked .htaccess and cannot find anything special that could make a difference. I haven’t changed anything for sometime. It (bbpress) has worked fine until now.

4.) I’m using the latest version of wordpress, bbpress & buddypress.

Any idea what could be worng here? I would appreciate anything that would point me in the right direction!

Thanks!

[Pascal Casier]

Hi,
bbPress translation is centralized here: https://translate.wordpress.org/projects/wp-plugins/bbpress/stable/ru/default

If you want to propose a new translation so everybody in the world that uses it in Russian gets your update (when it gets approved), then you can do that using the above link.

If you only want to change it on your local installation, you can read the codex on https://codex.bbpress.org/getting-started/bbpress-in-your-language/

[expectancy]

Sharing this here in case anyone else has this issue. It’s a combination of using bbPress with either the bbPress Toolkit or the code snippet to use the TinyMCE editor in place of the standard editor.

When using the TinyMCE editor, clicking “Reply” to a thread (using nested threads) would move the reply box to be under the thread, but the box itself loses the text area so you can’t type anything in.

The workaround is to remove and reenable the TinyMCE instance. In the bbpress/templates/default/js/reply.js file, add these two lines to the “try” block (line 38):

tinymce.get(‘bbp_reply_content’).remove();
tinymce.execCommand(‘mceAddEditor’, false, ‘bbp_reply_content’);

[HW]

Hi There,

My client had reported a strange issue that started recently. If I navigate to the forum page, then login to WP, the WP admin bar displays at the top as normal. When I navigate back to the forum page after logging in, the admin bar does not show up on this page only until I refresh the page. At first I thought it was a caching issue with a Autoptimize cache plugin but it still occurs after I deactivate.

There is an error logging for bbPress repeatedly:
[04-Apr-2017 17:56:26 UTC] WordPress database error 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 ‘))) AND hn09m16p3_posts.post_type IN (‘topic’, ‘reply’) AND (hn09m16p3_posts.po’ at line 1 for query SELECT hn09m16p3_posts.* FROM hn09m16p3_posts FORCE INDEX (PRIMARY, post_parent) WHERE 1=1 AND (hn09m16p3_posts.ID = 8481 OR hn09m16p3_posts.post_parent = 8481) AND ((())) AND hn09m16p3_posts.post_type IN (‘topic’, ‘reply’) AND (hn09m16p3_posts.post_status = ‘publish’ OR hn09m16p3_posts.post_status = ‘closed’ OR hn09m16p3_posts.post_status = ‘reported’ OR hn09m16p3_posts.post_status = ‘acf-disabled’ OR hn09m16p3_posts.post_author = 217 AND hn09m16p3_posts.post_status = ‘private’ OR hn09m16p3_posts.post_author = 217 AND hn09m16p3_posts.post_status = ‘hidden’) ORDER BY hn09m16p3_posts.post_date ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), apply_filters(‘template_include’), WP_Hook->apply_filters, call_user_func_array, bbp_template_include, apply_filters(‘bbp_template_include’), WP_Hook->apply_filters, call_user_func_array, bbp_template_include_theme_compat, BBP_Shortcodes->display_topic, bbp_get_template_part, bbp_locate_template, load_template, require(‘/plugins/bbpress/templates/default/bbpress/content-single-topic.php’), bbp_has_replies, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

I used the repair forums tools one by one and now all the forums/topic/replies content is not displaying but the count is correct for each forum/topic, when I go into any of the forums/topics it says “Oh bother! No topics found here”.

I’m currently setting up a test site to strip it down and see if I can find the cause but I wanted to post this to make sure it isn’t a general bbPress issue with the SQL statement. Any help would be appreciated.

Wordpress version: 4.7.3
bbPress version: 2.5.12

Thanks!

[akira010203]

wp-config and .htaccess no. It’s the default one generated by wordpress.

About php.ini and php-config, I don’t have these files and I’m on a shared hosting.

[Pascal Casier]

Hi,
I tried several CSS hacks but did not manage. I suspect something in your theme is causing this. As a test could you switch to a default theme (like twenty sixteen) ? If it then works fine, you will have to get support from the theme author.

[guybrushpixelwood]

If somebody stumble upon the same problem here is a solution to get Wp PostRatings Plugin Stars into bbpress topics:

wp-content/plugins/bbress/templates/default/bbpress/loop-single-reply.php <–

Search for the line

<?php bbp_reply_admin_links(); ?>

and place this under it:

<span class="bbp-admin-links">
		<?php if(function_exists('the_ratings')) { the_ratings(); } ?>
 </span>

😀

[gpdesign93]

I am also anxious to learn how to do this. I’d settle for learning how to customize the default bbpress pages, if it’s not possible to redirect. This seems extremely fundamental, but I can’t find any answers.

[theredeclipse]

Tho still trying to figure out how to replace default classes.

Code in BBpress:

			// Link class
			$link_class = ' class="bbp-author-' . esc_attr( $r['type'] ) . '"';

			// Add links if not anonymous and existing user
			if ( empty( $anonymous ) && bbp_user_has_profile( bbp_get_reply_author_id( $reply_id ) ) ) {

				// Assemble the links
				foreach ( $author_links as $link => $link_text ) {
					$link_class = ' class="bbp-author-' . $link . '"';
					$author_link[] = sprintf( '<a href="%1$s"%2$s%3$s>%4$s</a>', esc_url( $author_url ), $link_title, $link_class, $link_text );
				}

Hook:

function hw_get_reply_author_link($link_class) {  
  $link_class = preg_replace('/ class="bbp-author-"/','/ class="myclass" /',$link_class);  
  return $link_class;  
}  
add_filter('bbp_get_reply_author_link','hw_get_reply_author_link'); 

Cant make this work. Well output itself works as should, but it doesn’t replace bbp-author- to myclass. Can you tell me what’s wrong with it?

[cocreationcoaching]

In BBPress if no role is found, it defaults to Member. I found that much in the code.

I solved it though. It wasn’t working as long as my code was in my theme’s functions.php. I had to actually add it to a custom plugin for it to work. Not sure why this was.

[Saravanan]

One Month. Still i did not get solution. Any MyBB Intelligent is there ? Help me Please

Repair any missing information: ContinueConversion CompleteNo threaded replies to convertNo anonymous reply authors to convertNo replies to convertNo favorites to convertNo topic subscriptions to convertNo topic tags to convertNo closed topics to closeNo super stickies to stickNo stickies to stickNo anonymous topic authors to convertNo topics to convertNo forum subscriptions to convertNo forum parents to convertNo forums to convertNo passwords to clearNo users to convertStarting ConversionRepair any missing information: Continue
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_bbp_converter_translator ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key(191), meta_value(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
No data to cleanStarting ConversionRepair any missing information: Continue
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_bbp_converter_translator ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key(191), meta_value(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
No data to cleanStarting ConversionRepair any missing information: ContinueConversion CompleteNo threaded replies to convertNo anonymous reply authors to convertNo replies to convertNo favorites to convertNo topic subscriptions to convertNo topic tags to convertNo closed topics to closeNo super stickies to stickNo stickies to stickNo anonymous topic authors to convertNo topics to convertNo forum subscriptions to convertNo forum parents to convertNo forums to convertStarting Conversio

[la818]

Hello, I’m on WordPress 4.7.3 and BBPress Version 2.5.12. Site is still in development and not yet live.

I have a large number of forums (around 35k). Some of the forums work fine to post topics to, others are throwing a 502 error. The topics still post to the forum regardless of the error, but the page does not load upon clicking the “Submit” button. If I stop the page load almost immediately after posting a topic and re-navigate to the specific forum where I was posting the topic, or wait for the page load to throw the 502 error and then re-navigate, the topic always successfully posts regardless of the error.

I have spent hours with WP Engine support and after thorough investigation, disabling all plugins, switching the theme to a default theme, the server is still responding with a 502 and I’ve been told it’s an issue with BBPress. They told me to mention my database contains the following number of rows as it may be helpful:

Table rows | Table
465283 | wp_postmeta
34858 | wp_posts

Any help would be immensely appreciated!

[Stefan Sebechlebsky]

I am experiencing exactly the same problem. BP Group Moderators do have capabilities like edit, close, merge, split topics or replies in the Group Forum but they do not see the textbox to assign or edit tags. I tried to show the box by hacking the files
/wp-content/plugins/bbpress/templates/default/bbpress/form-topic.php
and
/wp-content/plugins/bbpress/templates/default/bbpress/form-reply.php
by removing the condition “&& ( current_user_can( ‘assign_topic_tags’ )”
but then the tags assigned in the box have not been saved, anyway.
There must be a bug in the capabilities mapping from BP group moderator to bbP forum moderator. The capabilities like ‘assign_topic_tags’, ‘edit_topic_tags’, etc. are missing there.
For BP group admins and ordinary members it works well, they can assign and edit topic tags in their group forum.
But where is the code of this mapping? I cannot find it.

[PrancingHorse]

Hello,

My website: http://www.yorkregiontutoring.com is showing the WordPress Dashboard on the top left when a participant is logged in. And when you do click on the wordpress graphic on the top left for example, it asks you to create a page..etc. How do you disable this?

Does everyone just have this turned on by default on their websites?

Furthermore, I don’t want to just disable the top bar as I want people to be able to see their user icon and click on the it and access shortcuts within the top bar if needed.

Thank you
Diana

[repyourhood619]

Hey Robin and Kajzh, did you ever get this to work? I am having the exact same problem. the custom made role is showing up under the forum role dropdown on the user profile but when the profile is saved after selecting the new role it does the default message when no role is assigned “No Role For These Forums”. Robin I did what you suggested by deactivating plugins and changing the theme but to no avail. Please see the function below.

function np_add_custom_role( $bbp_roles ) {
 
	$bbp_roles['beta_tester'] = array(
			'name' => 'Beta Tester', 'bbpress',
            'capabilities' => bbp_get_caps_for_role( bbp_get_participant_role() )
	);
	return $bbp_roles;
}
add_filter( 'bbp_get_dynamic_roles', 'np_add_custom_role', 10 , 2 );

Thanks in advanced!