2 sites 1 database = You do not have sufficient permissions to access.

Hi Kevin,

I run several sites from a single database without problems.
I do so without changing ‘wp-settings.php’.
Each site sits in it’s own directory or a subdomain. The directory contains a full WP install. Even the ‘wp-config.php is identical, except for the database prefix. wp_; wp1_; …etc.
Works faultless.
Try undoing the changes to the ‘wp-settings.php’ and see if that’ll do the trick.

BTW, I noticed the link you are referring to is 8 years old. Since then things have evolved…;-)

I done that already, I need the sites to share everything except for themes and options. I need everything synced, users, usermeta, buddypress and all buddypress features like groups, forums, activity and buddypress media.

They are on separate domain names but on the same server.
They are same the same database settings but the prefix is wp_ and wp2_.

Stock install everything works but the two sites share nothing. When ever I try connecting the 2 I get “You do not have sufficient permissions to access.”

So I tried this, added

define('CUSTOM_CAPABILITIES_PREFIX', 'wp_');
define('CUSTOM_USER_TABLE', 'wp_users');
define('CUSTOM_USER_META_TABLE', 'wp_usermeta');
define('COOKIE_DOMAIN', '.domain.com'); //replace with your domain
define('COOKIEPATH', '/');

to wp-config.php

then I changed

$this->cap_key = $wpdb->prefix . 'capabilities';

to

if (defined ('CUSTOM_CAPABILITIES_PREFIX')) {
	$this->cap_key = CUSTOM_CAPABILITIES_PREFIX . 'capabilities';
	}
	else {	$this->cap_key = $wpdb->prefix . 'capabilities';
	}

in wp-includes/capabilities.php

I added these lines of code I am writing this and it worked. I can now login with the same user credentials as the first site.

Now I need to sync buddypress and all its tables. Is there any advice on that?

Thanks in advance.

Ok I got it to work, so whatever you want to sync between sites, just change add this line into wp-config of the 2nd site.

define(‘BP_ACTIVITY’, ‘wp_bp_activity’);
define(‘BP_ACTIVITY_META’, ‘wp_bp_activity_meta’);

Then change these settings in the loader files.

In buddypress/activity/bp-activity-loader.php

find the line…

// Global tables for activity component
$global_tables = array(
‘table_name’ => $bp->table_prefix . ‘bp_activity’,
‘table_name_meta’ => $bp->table_prefix . ‘bp_activity_meta’,
);

and change it to your prefix like this…

// Global tables for activity component
$global_tables = array(
‘table_name’ => ‘wp_bp_activity’,
‘table_name_meta’ => ‘wp_bp_activity_meta’,
);

then save and upload.
It should work on any plugin or table you want to sync.

Anyone know how to do this with the avatars?

DON’T DO IT!!!

Check out Oauth Provider or OpenID instead, its safer and easier.