You do not have sufficient permissions after update to 3.4.2

here is what I’ve tried thus far:

clean install via ftp
disabled all plugins (changed name of plugins folder, also via php admin)
changed name of theme folder (won’t adopt twentyeleven theme either)

It’s looking increasing like the database that’s running 2 sit4s may have been damaged during the upgrade. You mentioned one authentication for two sites? Could you elaborate on that? Perhaps it’s the authentication that’s gone pear-shaped.

What we have is three blogs, each has its own table prefix, wp_, ag_, ai_. We also have the following in the config:

define('CUSTOM_USER_TABLE', 'wp_users');
define('CUSTOM_USER_META_TABLE', 'wp_usermeta');
define('CUSTOM_CAPABILITIES_PREFIX', 'wp_');

This causes the authentication for all three sites to use the same authentication database. The only blog that is functional on the back end is the one that uses wp_ for the table prefix (the only one that doesn’t have the custom code for the user_table, etc.

I found the issue:
This posting is the solution.

Specifically, for those in the same mess:

Then you have to find in wp-includes/capabilities.php the line:

$this->cap_key = $wpdb->prefix . ‘capabilities’;

and replace it with

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

That’ s all! Good luck!

The way this works, is that it checks if there is a custom prefix and if so appends it to the cap_key property. If not, it uses the default.

Hope this helps.