[joyking]

hi
i have now tried to install bbpress in 3 different places and not one works
one is my main site im working on and one for my friend and tried on localhost and all 3 gives me the same error when i click on forums tab on the admin dashboard.

here is debug from the localhost. i get the same error on the other 2

Fatal error: Uncaught Error: [] operator not supported for strings in C:\xampp\htdocs\wordpress\wp-content\plugins\bbpress\includes\forums\functions.php:1800 Stack trace: #0 C:\xampp\htdocs\wordpress\wp-includes\class-wp-hook.php(298): bbp_pre_get_posts_normalize_forum_visibility(Object(WP_Query)) #1 C:\xampp\htdocs\wordpress\wp-includes\class-wp-hook.php(323): WP_Hook->apply_filters(”, Array) #2 C:\xampp\htdocs\wordpress\wp-includes\plugin.php(515): WP_Hook->do_action(Array) #3 C:\xampp\htdocs\wordpress\wp-includes\class-wp-query.php(1681): do_action_ref_array(‘pre_get_posts’, Array) #4 C:\xampp\htdocs\wordpress\wp-includes\class-wp-query.php(3238): WP_Query->get_posts() #5 C:\xampp\htdocs\wordpress\wp-includes\class-wp.php(617): WP_Query->query(Array) #6 C:\xampp\htdocs\wordpress\wp-includes\class-wp.php(735): WP->query_posts() #7 C:\xampp\htdocs\wordpress\wp-includes\functions.php(955): WP->main(Array) #8 C:\xampp\htdocs\wordpress\wp-admin\includes\post.php(1072): wp(Array) #9 C:\xampp\htdocs\wordpress\wp-admin\includ in C:\xampp\htdocs\wordpress\wp-content\plugins\bbpress\includes\forums\functions.php on line 1800

[Robin W]

bbPress Moderation

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

[ico33]

Hi, in my site I noticed a strange issue after last WordPress update. It seems to have problem with “cache”.

For example, if I log-in through the Home Page, after click in sign-in, the page refresh but it seems that the log-in didn’t work. If I press F5 to refresh the page, here I can now see the log-in effectuated.

I thought about my caching plugin, and I wrote to the assistance of my provider. They exclude the problem is in caching plugin, they found this:

The issue appears to be caused from the latest WordPress upgrade that was automatically applied within your website.

Code:

sitename@esm9 [~/public_html]# wp core version
4.7.4

There seems to be conflict between a plugin of yours that is creating this strange behavior within the website.

To find which is the responsible plugin, you may start deactivating them one by one and after that checking the functions that were not working as expected. Once they work this will indicate which plugin caused the issue.

I did what they suggest, and when I deactivate BBPRESS, everything works! So, what to do??

[forums1234]

bbPress – Version 2.5.12
Wordpress – Version 4.7.4

My friends have been joining my forums. They get an email stating they’ve joined from MailChimp. They return to the site and their user name and password are requested.

I get a message stating they’ve joined.

Here’s the problem. They never get an email to activate their Username and Password.
A. Does bbPress have that feature?
B. Does MailChimp not forward that sort of email?
C. Is there a way to add Username and Password during signup in bbPress?

Thank you in advance.

[cjerrells]

Hi,

I’ve been having difficulties setting up a private BuddyPress group with associated forum:

1. If the forum is set as “private” then I get the error “This group does not currently have a forum.” on the group’s Forum page.

2. If the forum is set as “public” then the forum does appear there, and the group’s access controls seem to stop non-members accessing it. However new topics and replies generate BuddyPress activities which are visible to non-members.

WordPress 4.7.4
BuddyPress 2.8.2
bbPress 2.5.12

I was advised on trac ticket #2752 (here) to try the fix on trac ticket #2599 which updates forum privacy when the group is saved. I tried this, but it just set the forum as private, triggering problem #1.

As mentioned on the trac ticket linked above, I have tried the Repair tools and various changes to group/forum privacy.

I can’t seem to find a setup that gives me a private group with a private forum. Can anyone please advise me on how to debug this?

[newz12]

Hi Pascal,

Here are the requested info:

MySQL: 5.5.54-0+deb8u1
PHP: 5.6.30-0+deb8u1
WordPress: 4.7.4

[rhj4]

I sent a message to all members of a forum group. The message showed up as being from “wordpress@connexions.world” where “connexions.world” is the name of my domain.

How do I change the “from” value from “wordpress” to my own name or the name of the message sender?

[benmess65]

Hi,
I amusing WordPress 4.6.5 with bbPress 2.5.10. Just recently I am starting to get 50 or 60 users a day registering when I had only a handful for many months previously. None of these ‘new’ users are activating their account. I know that activation emails are going out because I registered myself with a gmail account, received the activation email and applied a password. My admin email account (not the gmail one) received a message telling me that the user had changed the password, thus telling me that that user had activated. None of the over 200 spam email accounts have followed that process, so I want to remove them from my list.
I was under the impression that bbPress automatically removed registered users that did not activate, but I still have over 200 sitting there and I cannot see which ones should be active and which ones are not, because they all just have “Subscriber” role against them.\
How can I tell which users have activated so I don’t remove valid users and only remove the spam ones.

[Pascal Casier]

Hi @newz12,
Could you also post your WordPress, PHP and MySQL version ?
Thanks, Pascal.

[horsmanzach]

Hello, I am running WordPress 4.7.4 and bbPress 2.5.12.

My forum can be found on https://thehulkpress.com/forum . The page looks exactly how I want it to there, but when I click on the forum channel the page background changes to white. I’ve tried a variety of different css codes to change the rest of the pages to black, but can’t seem to find the correct block of code. Can someone suggest a way to change not only the first page, but the rest of the pages’ background to black? Thank you

– Zach

[Robin W]

presume you’ve tried it ?

If it doesn’t work, then the latest activity widget in my style pack plugin does exactly that

bbp style pack

[magnaweb]

Hello, I have a bbPress forum on my website. I am running WordPress 4.7.4 and bbPress 2.5.12.

The way I want the entire forum to look can be found on https://thehulkpress.com/forum. However, you’ll notice when you click on the one channel available that the background of the page goes to white instead of staying black. I’ve searched numerous posts and have attempted to change all css fields that make sense to a black background. I have a feeling that the Divi theme that I am running is perhaps overriding this and I may need to change something in the php files, however I am not sure where to look for that. Would anyone be able to point me in the right direction? Thanks for your time,

– Zach

[softgenic]

Hi Robin, Your plugin is great but I just need a simple PHP code to loop through this just like we loop through wordpress posts using wp query., is there any way I can run a simple code to get the data of last three recent posts and then I can easily render the information in my created HTML

[Robin W]

if you are happy with code, download my style pack plugin

bbp style pack

if you look in includes/shortcodes

you’ll find a shortcode for bsp_display_topic_index

around line 40 you’ll find the output that you could modify and then style.

[Stephen Edgar]

Please post a job on https://jobs.wordpress.net

(I’ve removed your email address from the original post)

[Saravanan]

Hi,

I want import MyBB Forum Data to BuddyPress.

I Tried Many time i can’t to this.

if anyone is there to do this. I will Paid you.

Please contact me [redacted]

[Stephen Edgar]

There are quite a few performance improvements coming in bbPress 2.6 (to be released soon)

Many of these improvements have been made to support the implementation of bbPress 2.6 here on the WordPress.org support forums.

You can read more about this here https://bbpress.org/forums/topic/bbpress-2-6-beta/

If you have a test site, or could set one help, testing 2.6 would help us help you 🙂

[aevers14]

Hi my site is rightfootflat.com and basically in my forum once you register for an account you get sent to the admin login for WordPress and I would like it to redirect to the forum front page. I filezilla sftp but I am not very knowledgeable with css/HTML any help would be great thanks 🙂

[shlauncha]

I feel as though I’m losing my mind. There’s an option to enable the full TinyCME editor correct?

I’m looking at this: https://codex.bbpress.org/enable-visual-editor/

But when I do that, all I’m seeing is this:

I’ve tried the code in the codex on a base WordPress theme and all plugins disabled.

Is it possible to enable a more robust editor?

Thanks

[sourfew]

The whole wordpress site is slow for logged out users and I not sure if it’s related to bbpress or buddypress. Every page take about 4 sec and 0.5 sec for logged in users

Wordpress: 4.7.3
Buddypress: 2.8.2
bbpress: 2.6b2
25000 users

With QueryMonitor I can see the following
SELECT wp_users.ID,wp_users.user_login,wp_users.user_pass,wp_users.user_nicename,wp_users.user_email,wp_users.user_url,wp_users.user_registered,wp_users.user_activation_key,wp_users.user_status,wp_users.display_name
FROM wp_users
WHERE 1=1
AND wp_users.ID IN (40269,32606,34524,34322,40331,40334,36153,25677… and all user id’s

Caller is WP_User_Query->query()
wp-includes/class-wp-user-query.php:600

Component:
Plugin buddypress

The funny thing is if I disable bbpress and rtMedia with (bbpress plugin) that big query is not taking place.

[pluplik]

Hi .
I have .tube theme on wordpress
I need to hide the header of the forum it makes a double text .
double text on header

I don’t know if its a theme problem or the forum page. or bbpress.
thanks for the help.

[Pascal Casier]

Hi @panda666uk,

Kunena3 is in the list of forums that can be imported. Just go to /wp-admin/tools.php?page=bbp-converter after having installed WordPress and bbPress.

Pascal.

[Robin W]

bbpress uses wordpress registration.

wordpress assumes that you will need a role, so requires all users to have one.

The wordpress toolbar is frankly horrible.

so simplest solution is to hide the toolbar for all but non admins

there are several plugins available to do this

eg https://wordpress.org/plugins/hide-admin-bar-from-non-admins/

[panda666uk]

Are there any free tools/files/code out there to migrate a Kunena forum on a joomla site over to bbpress on a wordpress site ?

Thanks