[wp-hackers] Share user tables, "You do not have sufficient permissions to access this page."

[Doug Stewart]

On Fri, Mar 27, 2009 at 7:27 AM, Alex Hempton-Smith <
hempsworth at googlemail.com> wrote:

> Hi all,
>
> Doing something pretty basic but its not working...
>
> I have WP installed as usual, with a 'wp_' table prefix. I've just
> installed
> WP again into the same db, with a different prefix, and added the following
> to its wp-config.php:
>
> define('CUSTOM_USER_TABLE', 'wp_users');
> define('CUSTOM_USER_META_TABLE', 'wp_usermeta');
>
> However, when I try to log in I get the infamous message:
> "You do not have sufficient permissions to access this page."
> I've seen a few discussions about this in wp-hackers archives...but no
> solutions! Any ideas guys?
> Cheers,
> Alex


It's usually because the user doesn't actually have a defined role on the
second blog.  Use phpMyAdmin or the suchlike and take a careful look at the
[prefix]_usermeta table and the [prefix]_ capabilities records.  See how
they differ to the [prefix2]_capabilities entries.


-- 
-Doug