Hi Tim,
Thanks for the reply. I got the sysop problem solved. The problem came because the wiki directory had no writing permission. I enabled writing and got admin added. But now I have one more problem...:( After installation I got all the pages blank... And admin rights are also seen only as a 4 new additions to special pages link. Is that only what u get after logging as an admin? And why I am getting blank pages. Can help me out with this problem... Again thanks a lot for replying..
Regards
Umesh Dhekane
On 7/9/07, Tim Starling tstarling@wikimedia.org wrote:
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
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l