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

[Pascal Casier]

That a standard feature of WordPress: Subscriptions.

If somebody is subscribed to a forum, that person will receive an email upon new topic creation.
If somebody is subscribed to a topic, that person will receive an email upon new reply creation.

When you are in a forum, somewhere on top it should say ‘subscribe’. Clicking there should send you emails when new topics are created.

If you, as admin (keymaster) or moderator wants to deal with (manage) subscriptions, have a look at my bbP Toolkit plugin that has ways of activating/deactivating for other users.

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

[Michał]

I took the phpBB.php modification. I replaced the names of 3 tables in the database: from “xoops_bb_posts” to “posts”, from “xoops_bb_posts_text” to “posts_text”, from “xoops_bb_topics” to “topics”.

I am working on a converter, converting a forum category -> OK, the first error appears when it starts to convert topics:

Błąd bazy danych WordPressa: [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 'INNER JOIN posts_text AS posts_text USING (topic_id) WHERE posts.post_id = topic' at line 1]
SELECT convert(topics.topic_id USING "mypass") AS topic_id,convert(topics.topic_replies USING "mypass") AS topic_replies,convert(topics.forum_id USING "mypass") AS forum_id,convert(topics.topic_poster USING "mypass") AS topic_poster,convert(topics.poster_name USING "mypass") AS poster_name,convert(posts.poster_ip USING "mypass") AS poster_ip,convert(posts_text.post_text USING "mypass") AS post_text,convert(topics.topic_title USING "mypass") AS topic_title,convert(topics.topic_status USING "mypass") AS topic_status,convert(topics.topic_type USING "mypass") AS topic_type,convert(topics.topic_time USING "mypass") AS topic_time,convert(topics.topic_last_post_time USING "mypass") AS topic_last_post_time FROM topics AS topics INNER JOIN posts AS posts USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id INNER JOIN posts_text AS posts_text USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 0, 100

It seems to me that the problem is because the “newbb” system uses two tables to display the response content: xoops_bb_posts and xoops_bb_posts_text. The structures are both here; http://www.kulturystyka.org.pl/newbb_table_structure.txt

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

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

[danwakeweb]

Hey Guys,

I have been developing WordPress themes for about 6 years now. I need to create a website where the landing/home page is visible to the public and a few pages that are for members only. The members also need profiles and can only be signed up by the admin.

Ive been thinking maybe I could create a WordPress site with just a few pages for the public and a private bbpress forum with the registered users and their profiles? I have no experience with bbpress at all so don’t know if it would suit this application.

The other option that I saw was buddypress but can this be made private and have restricted content for the members?

It is essentially for a private association.

Thanks guys

[Michał]

Good morning, my name is Michael and I am writing from a distant country of Poland :). I have a website dedicated to bodybuilding based on xoops, but I will soon change to wordpress. I have converted all 1200 articles, comments and users, but I have a problem moving forums …

The newbb script is similar to phpbb, so I used the available converter in the admin panel, I modified it a little, basically the beginning of the category and description of the forum sections. It looks like:
http://www.kulturystyka.org.pl/test/forums/

Further modification of the phpBB.php file unfortunately did not produce the expected results, because the newbb script has changed a bit, and the converter in the BBpress package is probably not updated for a long time ….?

Please help me to modify this file so that it finishes work ie it has moved topics, utterances and users. Below I show how the structure of individual tables in the newbb module (xoops) looks like. I am green in terms of these matters, I am surprised myself that I have moved the forum sections. My WP version is 4.7.3

I found something like this: https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/Example.php?order=name

Yesterday and today I’m struggling with it …

I will be very, but very grateful for the help shown. Regards, Michal

Link to the structure of table; posts, posts_text, topics and users:
http://www.kulturystyka.org.pl/newbb_table_structure.txt

[gbxdigital]

Hi
Thank you for the feedback!

bbPress 2.5.12
WP Version: 4.7.3

We got this error….ERROR: admin-ajax.php: 502 Bad Gateway
Since the forum is checking for new replies every minute per user
we had to adjust some settings on nginx configuration.

We added this config to reduce the amount of queries:
nginx_fastcgi_buffers: 8 8k
nginx_fastcgi_buffer_size: 4k

We found this but cannot figure out what to do: http://www.inmotionhosting.com/support/website/wordpress/heartbeat-ajax-php-usage

We do not often get error messages but rather what we get are the following as more users come on the site.
-Site slows down to a crawl
-site locks up, freezes
-When it regains questions duplicate or triplicate.

Could I give you WP access?

Our web site is dfiuniversity.com and while want to use bbpress for our forum it seems we are not setting it up properly or bbpress cannot manage 150 – 500+++ users at one time. Maybe we should try firebase for such an intense forum? We expect our users to increase to 1k plus soon.

Regards

[PrancingHorse]

Hi Robin,

I just installed BBPress onto the website maybe 3 weeks ago with a brand new WordPress installation. It’s been happening since inception.

Its not happening for the keymaster account, but it’s happening for everyone else.

[5lions]

Here is the original graph.

View post on imgur.com

That massive CPU use that was bringing the site to a crawl and destroying this brand new server that ONLY has this single forum running on is, is due to wordpresses terrible idea of using /wp-admin/admin-ajax.php to poll the shit out of the server for bad reasons 24/7 any time someone has a page open.

Also partially due to bbpress slowness.

That first large drop in cpu you see, and the subsequent large drop to the end of the graph is me completely blocking admin-ajax.php in nginx until I can figure out how to make it work smarter.

All the latest heartbeat plugins do no seem to work with the latest wordpress. Cannot slow down the heartbeat or turn it off, so I filtered it.

This is really bad, because I have a community website that allows people to post photos and videos (outside the forum with custom post types) and all of that is broken with admin-ajax.php being blocked.

Seems no one has successfully solved this issue well on the internet 🙁

As to performance
——————-
This same site used to run on vanilla forums on a 2 cpu box with 4 gigs of ram very FAST.

The wordpress/bbpress version runs on a 6 cpu, 12gig box which also includes php 7 upgrade.
PHP7 is a huge speed improvement over 5.6.

This new machine literally only had this one site on it.

The old box was somewhat shared with the vanilla forum.

So even with effectively double the power, if not more, this runs substantially slower on wordpress/bbpress *sigh*

I just have to accept I need to pay triple the price for half the performance if I want to stick to wordpress.

Unless bbpress some day decides to have its own tables, and re-architect specifically for forum performance, were stuck with this. That of course would break a ton of plugins with the whole “share everything via the posts table architecture”.

May be worth it though. There is a big opportunity here to take over the forum world because its frankly is disarray. All the forum software out there is in a state of suck or dying and there is no clear winner. The integration with wordpress, and its zillion plugins, are what makes this performance sacrifice barely worth it.

[5lions]

Some feedback on beta 2.

I run a forum with:
20K topics
216K replies
9200 users

I took the risk of running a beta in version in prod because performance was just killing me.

Here is a graph of overall system load after I installed beta2.

View post on imgur.com

I had to stretch the graph so you can see the difference.
It had a substantial effect. Wheeew. Really needed this.

Been very unhappy with the wordpress platform for running a forum. Wrong architecture.

I have come to realize Im just going to have to spend a lot more money to run a site on wordpress than forum software that was originally architected for forums. Frustrating how slow wordpress is and how bad their design is.

[Pascal Casier]

Hi,
That will need some programming probably. The starting point has nothing to see with bbPress, so you could refer to these examples as this is all about the WP admin bar: https://codex.wordpress.org/Function_Reference/add_node

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

[peppefark]

Hi, I want to migrate from xenForo bbPress, as wordpress settings – Forum – matter, I enter the xenForo databases but in the end gives me the seguante message:

Repair any missing information: Continue
Errore sul database di WordPress: [Table ‘clubcuor_xf.xfpost’ doesn’t exist]
SELECT convert(post.post_id USING “utf8mb4”) AS post_id,convert(post.thread_id USING “utf8mb4”) AS thread_id,convert(post.user_id USING “utf8mb4”) AS user_id,convert(thread.title USING “utf8mb4”) AS title,convert(post.message USING “utf8mb4”) AS message,convert(post.post_date USING “utf8mb4”) AS post_date FROM xfpost AS post LEFT JOIN xfthread AS thread USING (thread_id) WHERE thread.first_post_id != post.post_id LIMIT 0, 100

[Robin W]

given that wordpress uses bbpress, suspect loads more than 50 !

care to define what ‘the forum crashes’ actually means ?

[Pascal Casier]

Hi,
That’s all depending on the theme you use. The theme used here is not directly available as a theme to install, but if you are interested in the sources, you can find them here: https://meta.trac.wordpress.org/browser/sites/trunk/buddypress.org/public_html/wp-content/themes/bb-base
Pascal.

[vitalinfo]

WordPress 4.7.3 running Lana Blog theme.
BBpress Version 2.5.12
Link: bcompetitive.in

I am unable to make the sidebar work on my forum pages. It works if I use short-codes for forums, but you know it is not practical. I tried editing page.php with code if_bbpress. That gives me a sidebar below the forum.
I tried bbpress wp tweaks and nothing happened.
I copied pagewith sidebar template from the theme and renamed it as bbpress.php, nothing happened.
Can anyone help?
I am absolutely new to coding.
I wish to have same sidebar as that of blog.

[Robin W]

Perhaps this plugin will help

bbPress Moderation

Devs are busy with version 2.6 at the mo, so suspect any new requests are not being looked at.

[cbclark]

Hello! I really like the way this forum (bbPress support) allows users to manage their profile. Is it using a particular plugin? My website still displays the standard WordPress black bar across the top of the page for registered users who are logged in.

Thank you!

[jezza101]

It’s 98% done:
https://bbpress.trac.wordpress.org/roadmap

[Pascal Casier]

Hi @josnierop,

I know the basics and that has always been useful. Happy to see you’re fixed.

PS. Kom gerust op de Nederlandse chat voor verdere of algemene vragen, we zijn niet allemaal WordPress/bbPress nerds daar 🙂