[wp-hackers] Sharing Users/authentication

Jamie Holly hovercrafter at earthlink.net
Sat Aug 25 16:33:16 GMT 2007

The prefixes are used in MU. For example user X might have different
capabilities on one blog than the other. The capabilities are stored as
{tableprefix}_{blogid}_capabilities, so it would be something like

Jamie Holly
1.513.252.2919 | Skype:intoxination

>-----Original Message-----
>From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
>bounces at lists.automattic.com] On Behalf Of Stephen Rider
>Sent: Saturday, August 25, 2007 12:27 PM
>To: wp-hackers at lists.automattic.com
>Subject: Re: [wp-hackers] Sharing Users/authentication
>They aren't field names:  They are data in the "meta_key" field.
>Nonetheless my question stands:
>IS there any legitimate use for the table-prefix to be repeated
>here?  Would WordPress lose anything by removing the table prefixes
>from these two fields?
>On Aug 25, 2007, at 11:20 AM, Stephen Rider wrote:
>> The problem appears to be the "wp_capabilities" and "wp_user_level"
>> fields in the wp_usermeta table.  WordPress needs these field names
>> to match the active table prefix.
>> So, when I use the define()s to point to the other blog's user and
>> usermeta tables, it sees the wrong prefix in this field and hits an
>> error.
>> ALSO:  Should it be considered a bug that the field names have the
>> prefix hard-coded into them?  This seems like unnecessary
>> duplication of information to me, which is a database design no-no.
>wp-hackers mailing list
>wp-hackers at lists.automattic.com

More information about the wp-hackers mailing list