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(a)wikimedia.org> wrote:
Rob Church wrote:
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
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l