Hello,
I have a fresh install of wikimedia and having issues with giving sysop rights to users.
Following the Documentation, I recieve errors when trying to run the following command.
mysql> update user set user_rights='sysop' where user_name='jblain'; ERROR 1054: Unknown column 'user_rights' in 'field list'
Any help would be appreciated.
Debian unstable MediaWiki 1.4beta3 MySQL 4.0.23
Thanks, Jeff
That "Documentation" is for an older version, as the database schema changed for 1.4. Try the ready-made page Special:Makesysop.
-- Zigger
On Wed, 29 Dec 2004 19:39:17 -0800, Jeff Blain wrote:
... I have a fresh install of wikimedia and having issues with giving sysop rights to users.
Following the Documentation, I recieve errors when trying to run the following command.
mysql> update user set user_rights='sysop' where user_name='jblain'; ERROR 1054: Unknown column 'user_rights' in 'field list' ...
On Dec 30, 2004, at 5:59 AM, Zigger wrote:
That "Documentation" is for an older version, as the database schema changed for 1.4. Try the ready-made page Special:Makesysop.
-- Zigger
I tried this and got an error page that says...
Sysop access required The action you have requested can only be performed by users with "sysop" status. See SiteName:Administrators
When I go to the Administrators page, nothing is listed.
On Wed, 29 Dec 2004 19:39:17 -0800, Jeff Blain wrote:
... I have a fresh install of wikimedia and having issues with giving sysop rights to users.
Following the Documentation, I recieve errors when trying to run the following command.
mysql> update user set user_rights='sysop' where user_name='jblain'; ERROR 1054: Unknown column 'user_rights' in 'field list' ...
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Try: UPDATE user_rights SET ur_rights='sysop,bureaucrat' WHERE ur_user=1;
1 is the id of the administrator created during initial configuration. That account can then use Special:Makesysop as it will have bureaucrat rights.
To find the id of a different user: SELECT user_id FROM user WHERE user_name='jblain';
-- Zigger
On Thu, 30 Dec 2004 06:56:28 -0600, Jeff Blain wrote:
... I tried this and got an error page that says...
Sysop access required The action you have requested can only be performed by users with "sysop" status. See SiteName:Administrators
When I go to the Administrators page, nothing is listed. ...
Thanks Zigger. Everything works.
Jeff
On Dec 30, 2004, at 7:35 AM, Zigger wrote:
Try: UPDATE user_rights SET ur_rights='sysop,bureaucrat' WHERE ur_user=1;
1 is the id of the administrator created during initial configuration. That account can then use Special:Makesysop as it will have bureaucrat rights.
To find the id of a different user: SELECT user_id FROM user WHERE user_name='jblain';
-- Zigger
On Thu, 30 Dec 2004 06:56:28 -0600, Jeff Blain wrote:
... I tried this and got an error page that says...
Sysop access required The action you have requested can only be performed by users with "sysop" status. See SiteName:Administrators
When I go to the Administrators page, nothing is listed.
mediawiki-l@lists.wikimedia.org