[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.

[Roman Matovsky]

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/

Thank you! That’s what I need.

[Pascal Casier]

So it’s display only ? But the input of the topics and replies is happening somewhere in a ‘normal’ bbPress forum, right ?

I think you need to create a theme that only displays what you need. It will be easier then just displaying everything with the shortcodes.

Step-by-Step Guide to Creating a Custom bbPress Theme

[Pascal Casier]

Hi,
It’s a bit difficult to understand where this is coming from (it might be part of your theme), so if the site is publically availalble, a link to it might be nice.

It might be that following point 3 of this codex page will help you: https://codex.bbpress.org/step-by-step-guide-to-setting-up-a-bbpress-forum/

[theredeclipse]

Thanks a lot, it works now! I’ve removed “class=”bbp-author-” and rest of the code doesn’t display so its suits perfectly for me.

Now I trying to change args of bbp_get_reply_admin_links (stored in bbpress/includes/replies/template.php)

Thats my hook

function hw_get_reply_admin_links ($args) {
$args = array (
			'before' => '<div class="list">',
			'after'  => '</div>',
);
return $args;
}
add_filter ('bbp_get_reply_admin_links', 'hw_get_reply_admin_links' );

What’s wrong here?

[DessertGuru]

I’m going to use bbPress but via shortcodes so that only topics and posts within the topics are displayed on pages. I don’t want the full Forum Root, Forums, Topics etc., displayed on a page. so I’m going to create individual pages for each topic assign the bbpress shortcode for the topic and posts. So is it really necessary to do page/slug assignments in bbpress setup and have the full thing displayed even though I’m not going to use the full bbpress forum display structure and I certainly don’t want to the public to see it.

or does anyone have any other suggestions on how to accomplish this?

The “forum” will the individual Page, the Topic will be the posts from users on the assigned page. there won’t be an actual “topic” for each forum since the forum is the topic.

[drbgaijin]

Further clarification.
If I reply to a Topic, and have selected “email me replies to this Topic”, the email I get has an active link.
But what I wanted to achieve, and could do with bbPress Notify, was to automatically send a notification to members when a new topic or new forum was created.
Regards
Douglas

[drbgaijin]

Thanks for the reply. I had installed “bbPress Notify(No-Spam)”. I have deactivated it now to see what happens. Now there are no notifications being sent at all!
I have been unable to get the barebones bbPress send notifications from the start. So I found the Notify plugin and could get notifications to work – but with no active links.
Does bbPress have a basic setting to send notifications when a new topic is started? Or can you recommmend a plugin that integrates better with bbPress and can do this?
Regards
Douglas

[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]

Did you try importing in the latest bbPress 2.6-beta 2 ?

Download

[Pascal Casier]

Hi,
If you have only installed bbPress, links should be clickable… Did you add any other plugins on your installation ?

[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/

[tonipetrov91]

I’m trying to add a parent/child relationship between bbpress forums and a custom post type I’ve created. Is there a way to do that, currently I can only make forum a child of another forum?

I’ve tried adding a custom meta box that would allow that:

function my_add_meta_boxes() {
	add_meta_box( 'lesson-parent', 'Module', 'lessons_attributes_meta_box', 'forum', 'side', 'high' );
}
add_action( 'add_meta_boxes', 'my_add_meta_boxes' );
function lessons_attributes_meta_box( $post ) {
	$post_type_object = get_post_type_object( $post->post_type );
	$pages = wp_dropdown_pages( array( 'post_type' => 'lesson', 'selected' => $post->post_parent, 'name' => 'parent_id', 'show_option_none' => __( '(no parent)' ), 'sort_column'=> 'menu_order, post_title', 'echo' => 0 ) );
	if ( ! empty( $pages ) ) {
		echo $pages;
	}
}

This shows the metabox and I can select the CPTs from a dropdown list, they are not saved. This should be because the forum post type has hierarchy=>true. So I’ve tried to disable it using the below code, but it doesn’t work:

add_action('registered_post_type', 'disable_hierarchical', 10, 2 );

// Runs after each post type is registered
function disable_hierarchical($post_type, $pto){

    // Return, if not post type posts
    if ($post_type != 'forum') return;

    // access $wp_post_types global variable
    global $wp_post_types;
    $wp_post_types['forum']->hierarchical = false;
}

The above code works fine with the page post type, but not with the forum. What’s special about it that I’m missing?

[Roman Matovsky]

Dear friends.
I installed BBpress on my Russian site. Everything is ok. All words in admin panel and public are translated to Russian. I need change some words. I thought I can change what I need in bbpress.pot file, but there only English. I totally don’t understand where BBpress takes Russian words. I even tried download language file bbpress-ru_RU.po and changed there, but its didn’t work anyway. I totally confused here BBpress takes Russian words. Which file I should change? And where?

[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]

Thanks, Robin. It appears that the Search Everything plugin was causing the bbPress database error also. I’ve removed that plugin now so no longer require that fix (for now). 🙂

My main issue with the forum page not showing the WordPress admin bar when logged in until you refresh the page is still happening with every plugin disabled.

[drbgaijin]

I am new to bbPress, so I am probably just missing a setting.
When a notification to a new reply arrives, the topic url is not active. Members have to copy and paste the url to get to the link.
Have I missed a setting? Or is this just how it should work?
Regards
Douglas

[DessertGuru]

Looking for some advice on the best way to tackle this issue while using bbPress. I’m creating a new retailer review site where users will be able to post directly to a retailer’s listing.

using bbPress I have
forum root assigned as Reviews
forum slug assigned as Retailers
New Forum as an example – Retailer-1

so the URL looks like http://www.mysite.com/reviews/retailers/retailer-1/

which is just crazy long. Is there anyway to simply cut out the first two levels in the URL and go directly to retailer-1 within bbPress or is that just the way bbPress makes you do things?

Thanks…

[katmac_aus]

BBPress is redirecting my users to their profile when logged in. I want specific user roles to get redirected to a specific page in the site. I’ve tried the following function in the theme functions.php file that normally works but it is being ignored.

function my_login_redirect_employers() {
  if ( current_user_can('employer') ){
      return '/welcome-employers/';
  }
}
add_filter('login_redirect', 'my_login_redirect_employers',10,3);

[gpdesign93]

I am still looking for help with this, but I moved my question to another topic so @dropshot can still get their answer.

bbPress overwriting page styles

[gpdesign93]

WP Version: 4.7.3
bb Version: 2.5.12
Theme: Uncode 1.4.2 – compatibility confirmed
bb Forum Root: “forums”

I’ve had some difficulty setting up and styling my bbPress forums root page, similar to this user: how-to-actually-partner-root-with-a-wp-page/

I have since figured out how to establish a custom WP page as a root for my forum. I had to match the slug declared in the forum settings, AND use the [bbp-forum-index] shortcode. I thought it was either/or. If I only matched the slug, I would just get an empty page. If I just used the shortcode, I would have inconsistencies in the bbPress breadcrumb.

Now that I have declared a custom root, I’m getting my styles ignored or rejected or something. I have my page options set to hide the page title, WP breadcrumb, and some “inline” CSS to hide the menu. (My client needs a custom menu.) These options and styles work on all pages except for the forums root. They just get ignored.

I tested with fresh pages built from scratch multiple times to see where the problem was. I can use the shortcode just fine, but then my custom page is no longer my root page. As soon as I set my custom page’s slug to match the slug in the forum settings, I lose my styles.

How can I get a custom forum root that also has custom styles?

What I want: (Visually at least)
http://kadpf.org/kadpf2017update/forums-ideal/

What I get:
http://kadpf.org/kadpf2017update/forums/

Thanks!

[HW]

Update: I used Query Monitor to get a better/nicer view of the database error. It appears there is some blank part “…AND ((())) AND…” see here: https://www.dropbox.com/s/pvrwhd5druvykus/Screen%20Shot%202017-04-04%20at%202.29.01%20PM.png?dl=0

I resolved the topics and replies not displaying by using the wp4fix plugin here: http://www.rewweb.co.uk/bbpress-wp4-fix/ that had the issues with the search string. That was conflicting with Search Everything.

Thanks!

[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!

[Pascal Casier]

BuddyPress is based on bbPress. So if BuddyPress has the things you look for, then go for it 🙂

Both BuddyPress and bbPress are WordPress plugins, so user management is done in WordPress. It are all ‘normal’ WordPress users with extra roles/capabilities.

Hope this helps you making your choice.

Pascal.