[wp-hackers] Sharing Users/authentication

Knut-Olav Hoven hovenko at linpro.no
Sat Aug 25 16:31:00 GMT 2007


On Saturday 25 August 2007 18:26:40 Stephen Rider wrote:
> CORRECTION:
>
> 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?

I believe this was a (poor?) design decision regarding WordPress MU, to allow 
users have different capabilities on a per-blog basis.

>
> Stephen
>
> 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
> http://lists.automattic.com/mailman/listinfo/wp-hackers



-- 
Knut-Olav Hoven
Systemutvikler               mob: +47 986 71 700
Linpro AS                    http://www.linpro.no/


More information about the wp-hackers mailing list