[gardenfl]

I eventually wish to use BuddyPress on a site, but feel I need to do this is stages.

At the moment this site consists of WordPress on one database and BBPress on a different database using the most recent versions of both scripts.

I started integration but stopped because I saw a potential problem.

I have about 70 registered users on BBPress

I have about 10 users on WordPress, these are mostly Authors.

I gave the users the same rank on both, making the WordPress Authors, Moderators on BBPress

Still, I suspect that I could be making a huge mistake if I don’t merge the User tables before integrating, and of course I would want everything setup correctly for interrogation before playing around with MU and BuddyPress.

Now if I understand this correctly the User table for an integrated site should be WordPress, not BBPress?

Is there such a thing as a script that would allow me to make all BBPress users WordPress users?

Or am I looking at this all wrong?

Or is it possible to set up MU/BuddyPress and merge all users onto that?

[apbai]

I have installed the latest wp and bbpress with cookie integration enabled. But it seems not working. If log in from wp, bbpress account is automatically logged out. Same thing the other way around. What could be wrong? I believe I set all the keys correctly.

[usera]

nevermind. seems the objects are overly generic. i’ll have some patch it up to work.

[usera]

I think you may be confused _ck_. memcache has it’s uses like php op_code. It does not take alot for it to have a benefit and the same applies to memcache. However I am not asking for a suggestion on avoiding memcache. I would like to see a better handling of objects in the same way you create a prefix for a database. If you set a large pool for memcache say 1gb. The idea of setting another instance and monitoring it with startup script gets a little bothersome especially when an array can be used to mitigate the possibility of one failed instance to drive your site down. In short I should say you don’t usually start another mysql to house a database nor would it be useful to do that with memcache.

Thanks samhaurs again. I just want to be sure there weren’t objects that are generically named that can be seen across bbpress installations like administrative or personal details that should be separate that some are improperly written to cache much like wordpress mu does at the moment.

[_ck_]

Because of mysql replication, using the mysql cache is probably impossible on wp.com

Once you move beyond a single mysql server, things get complicated fast.

But that’s specifically the environment memcache was written for, not single server systems.

(by the way, how large is the wp.com memcache pool? I bet it’s massive)

However I find the MySQL cache has not been turned on for many VPS/dedicated servers. That’s a performance showstopper and makes a huge difference when the same queries are being done over and over on a typical bbPress install. A PHP opcode cache is the next largest performance improvement.

Here is the typical breakdown for MySQL vs Memcached performance:

Cache Type 	 Cache Gets/sec  (higher is better)

Array Cache  		365000              (this is local memory, fastest possible)

APC Cache 	 	98000                        (this is common memory via apc/eaccelertor/xcache)

File Cache  		27000                        (this is using the local disk cache)

Memcached Cache (TCP/IP) 	12200     <<<<====---

MySQL Query Cache (TCP/IP) 	 9900

MySQL Query Cache (Unix Socket)  13500    <<<<===---   (local mysql server, with cache)

Selecting from table (TCP/IP)	 5100             (remote mysql server, no cache)

Selecting from table (Unix Socket)  7400     (local mysql server, no cache)

[Sam Bauers]

“[WordPress.com] uses several dozen queries per page load.”

Thanks to memcache the average blog front page on WordPress.com uses only a handful of queries, sometimes as few as one.

“It absolutely cannot just rely on the mysql cache, even with dedicated mysql servers.”

From memory, WordPress.com doesn’t use MySQL query cache at all as it would need to be invalidated many times every second. We also would need to invalidate all slaves as well as the masters.

I think it’s important to say that you should only setup and enable any caching if you actually need it. Most people don’t and shouldn’t, all you do is add another potential point of failure into your site.

[_ck_]

Let’s review this from scratch.

WordPress and bbPress 1.0 has what we call an object cache. That is simply a pool of users, forums,topics, and posts and meta as they are passed between mysql and the application (wordpress/bbpress). It’s just another layer between mysql and bbpress.

Typically these “objects” are lost after every page load because they are no longer in regular short-term computer memory and have to be fetched again from mysql.

On a single computer system with a fast mysql server and fast disk cache, this typically is not a big problem. As a site has to scale this does become a problem because there is only one mysql source and everything has to be fetched from it.

Using a poorly configured WordPress or bbPress system with badly written or improperly running plugins, if each page load requires 30-40 queries, and you have 1000 users connected simultaneously at once, that’s a huge problem.

Memcache is a common pool of memory that doesn’t go away after each page load. It’s centralized on one server so multiple servers can all find it easily. It was invented by LiveJournal after they hit a growth limit with mysql.

The Memcache to Object Cache interface plugin for WordPress/bbPress 1.0 allows the fetching from mysql to be skipped IF the user/forum/topic/posts happen to be in the previously accessed pool in that centralized memory. Every time a query is made, the resulting data is saved in the collective memory which is retained inbetween page loads. It’s a common, shared memory.

However Memcache was written to talk over tcp/ip between MULTIPLE servers. For a single server setup it’s pointless and stupid and way too much overhead.

Now, on a single server, you could still use a persistent object cache with one of the other lesser known plugins that mimic what the memcache interface does. There is one for Eaccelerator, one for APC and one for Xcache.

However, all of these caches do almost the same thing as MySQL’s cache. They are all tied to the particular kind of query that is done and if it matches the previous set of data. The object cache still has to de-serialize data if it’s serialized.

MySQL on a single server system does not use tcp/ip to communicate with bbPress if it’s properly configured (and most are unless your host is greedy and stupid and uses a central mysql server separate from your regular server). So MySQL with a properly configured cache is almost as fast on a single server setup than a persistent object cache (unless MySql is overloaded in the first place).

So in conclusion, if you are on a shared host, object caching is not a viable solution for you because you can’t get any of the persistant memory options installed anyway. If you are on a single server setup but not dealing with a large number of connections, the mysql cache is probably going to be near the performance of a persistent object cache, and the real memcache would never be used in the first place.

Memcache was meant for large, inefficient installs like WordPress.com

WP.com serves many thousands of people simultaneously from many different servers. It uses several dozen queries per page load. It absolutely cannot just rely on the mysql cache, even with dedicated mysql servers. The average wordpress/bbpress user does not face these problems typically.

If you have your own VPS or dedicated server you should be installing an opcode cache like Eaccelerator, APC or Xcache and turning on the shared memory pool option (typically during compile). Then you should make sure your mysql cache is ON and setup properly. Then you should make sure your pages are not using too many queries. If you’ve done all that and you have so many simultaneous visitors that your mysql is running too high a load and your pages are still too slow, then you can look at one of the persistent object cache modules for wordpress and port them to bbpress.

None of the bbPress installs in the Top 10, are using memcache or any kind of object cache for that matter (including wp.org which is using bbPress 0.9). So I sincerely question the need of anyone else using an object cache just yet unless they have made their install extremely inefficient somehow or have a horrible host.

[m3i zero]

good news,have a try

[Ryan Hellyer]

Hmm, showing my total ignorance of caching here …

I assumed memcaching was the best way to improve the performance of bbPress and WordPress on a server even if it was only on a single server. So if I have a VPS, what specifications should I request to make sure it runs at maximum efficiency?

I”ve been contemplating moving to a 512 MB VPS and requesting they install mem cache on it for me. But juding by _ck_’s comments above that would be a stupid thing to do.

Any opinions?

[Sam Bauers]

@usera

You can setup a new memcached instance to avoid clashes with wordpress, but if you are sharing user tables then it shouldn’t matter.

If you add another memcached instance on a different port you can point bbPress to it by adding this to bb-config.php (default IP and port shown here)…

$memcached_servers = array( 'default' => array( '127.0.0.1:11211' ) );

[_ck_]

Memcache is only useful for multi-server installations otherwise it has too much overhead.

Eaccelerator, APC and Xcache have shared memory solutions that are significantly faster than memcache on a single server setup. But on a single server, it’s also been demonstrated a proper mysql cache can be faster than an object cache in some cases.

Eaccelerator, APC and Xcache can already store server session data in shared memory, you just have to compile with the option and turn it on in PHP.

There are plugins for wordpress that could be ported to bbPress 1.0 for the object cache but IMHO it’s a waste of time unless you have a very slow or overwhelmed mysql server.

[Olaf Lederer]

right no session at all

@rareexample, just use the cookies created by bbpress (using firefox it’s easy to discover the cookies)

[usera]

you are a lifesaver sambauers. I am using object cache but it’s not deeply integrated . The only other question is do you happen to know if you have to set a key (if you can set a key) to prevent object sharing. I know this is a problem with wordpress mu. I wish this was documented somewhere.

[Vannak Eng]

Hi,

I modified the default theme of bbpress and it worked fine at first but lately it shows the number like “6d53″ on the top of header. when i view the source code i see it is ‘<body id=”front-page”>6d53’. Please help to advise on that.

Regards,

Vannak

[willscootforfood]

@chrishajer I was converting a PHPBB 3.04 install to a bbPress 1.0 install. I am using the original script in the first post of this topic. Should I be using a different script?

Sorry for the lack of details in my first post. I was trying to keep my 17 month old girl alive another day LOL.

[chrishajer]

@willscootforfood – looks like the apostrophe (single quote) was not escaped before trying to insert. Can you explain what you’re trying to convert and what script you’re using? And what version of bbPress are you going to use?

[usera]

I seem to have made a terrible booboo. I installed a clean wordpress mu 2.84a and than tried to install bbpress 1.0.2 with integration… I went to the last step and entered the same admin password for wordpress mu and I got Key Master could not be created! At this point it was completed but I went back to try to correct with a proper forum account and I get the “bbpress already installed ” message…

Anyone know a simple fix besides reinstalling bbpress?

[willscootforfood]

I am getting the following error:

SQL ERROR [ mysql4 ]

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 ‘s bike’, ‘5’, ‘8’, ‘0’, ‘0’)’ at line 1 [1064]

SQL

INSERT INTO bb_forums (forum_id , forum_name, forum_desc, forum_parent, forum_order, topics, posts) VALUES (‘6’, ‘Bike of the Month’, ‘Each month we will showcase a different member’s bike’, ‘5’, ‘8’, ‘0’, ‘0’)

BACKTRACE

FILE: includes/db/mysql.php

LINE: 174

CALL: dbal_mysql->sql_error()

FILE: phpbb3tobbpress.php

LINE: 201

CALL: dbal_mysql->sql_query()

[Sam Bauers]

“bbPress Live” plugin used to do this before WordPress 2.8 broke it. It’s on my todo list to fix it.

[chrishajer]

You can change the autoincrement value for a field in phpMyAdmin. If you’re modifying the ID you will be using something like phpMyAdmin. I think there is a top menu item “Operations” then on the next page find the “table options” section and find the auto-increment value and just change it to whatever you want your next one to be.

For changing the existing topic_ids, I think there is also a reference to topic_id in the _posts table (if not, how would bbPress know what topic a post belonged to?) I think it also might be referenced for tags too. I didn’t check, but I think tags are attached to topics, so the tag would have to reference the topic id somehow as well.

This is all just thinking out loud. You should probably back up the database first then make your changes and see what does not work. Might want to recount afterward.

[johnhiler]

The instructions in the readme file should mention the settings?

* Until an admin menu is created, edit read-only-forums.php and change settings near the top as desired

* Add the read-only-forums.php file to bbPress’ my-plugins/ directory and activate.

https://bbpress.org/plugins/topic/read-only-forums/installation/

[johnhiler]

What version of bbPress are you using? The plugin may not be compatible with version 1.0…

Also – what edits did you make to the settings section of the admin?

[gerikg]

It depends on the theme. Go into your theme folder in BBpress and open header.php. Figure out where the links are being created. Then just insert an html tag (no need for php) `<a href=””> blah</a> etc etc Just make sure you have the correct surrounding tags. Sometimes they use

<li> </li>

and throw in class=""..

An easy way to do it on WPMU is create a page the same as the directory. If it’s in http://www.website.com/forums then create a page call forums.

[nataliya1977]

Hello!

I create e social network on WordPress MU+Buddypress+bbpress.

I want to create a button “Home” in header of bbpress to unite my social network and forum. And in header of Buddypress create a button “Forums”. How can I do it?

I’m not a programmer and I don’t know php-code veru well.

Help me!

[gerikg]

I made a solution!

Okay this is the fix I came up with. I created a new group in BP profile called signature and the field name signature too.

In BBpress in the post.php I inserted (note I don’t know PHP, if anyone can shorten this would be appreciated):

<?php if ( bp_has_profile(‘user_id=’.get_post_author_id().’&profile_group_id=XXX’) ) : ?>

<?php while ( bp_profile_groups() ) : bp_the_profile_group(); ?>

<?php if ( bp_profile_group_has_fields() ) : ?>

<?php while ( bp_profile_fields() ) : bp_the_profile_field(); ?>

<?php if ( bp_field_has_data() ) : ?>

<?php bp_the_profile_field_value() ?>

<?php endif; ?>

<?php endwhile; ?>

<?php endif; ?>

<?php endwhile; ?>

<?php else: ?>

<?php endif;?>

Just replace XXX with your group id #, mine was 3.

Still not the ideal _CK_ type plugin but it will do for now.