On 06/07/07, Tim Starling
<tstarling(a)wikimedia.org> wrote:
You probably chose the "MySQL 5 binary"
schema. Ha ha, tricked you. If so,
it should be fixed in 1.11.
Yes...
Anyway, to sort out the problem for now, create a new user in the
normal method, check the user's identifier in Special:Preferences, and
then insert a couple of rows into the `user_groups` table in the
database, like so:
INSERT INTO `user_groups` ( `ug_user`, `ug_group` ) VALUES ( 1,
"sysop" ), ( 1, "bureaucrat" );
In the MySQL 5 binary schema in 1.10.0, the ug_group column will be
zero-padded, so "sysop" becomes "sysop\0\0\0\0\0\0...". This causes it
to
not match the sysop group in the configuration. The way to fix this is to
reinstall the wiki with the MySQL 5 UTF-8 schema if possible, or the 4.0.x
compat schema if not.
If there is a need to preserve data in the broken wiki, you can create a
new fixed wiki in a separate DB, drop the old broken user_groups table,
and rename the new one into the old one's place.
-- Tim Starling