Rob Church wrote:
On 06/07/07, Tim Starling tstarling@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