Last modified: 2010-05-15 15:41:08 UTC
I have an install of 1.7.1 that I have setup using mysql-server-5.0.22-1.FC5.1. I ran into a bug while adding users and checking my /wiki/Special:Listusers URL where the usernames and therefore links were not showing up in the list. I tracked down the issue to be what I feel is a problem in the query. I have patched the issue and want you to verify my patch and let me know if this is correct. I couldn't figure out where the 'value' was being used in reference to the query. Thanks. plynch@somedesk> diff -u mediawiki-1.7.1/includes/SpecialListusers.php mediawiki-1.7.1patch/includes/SpecialListusers.php --- mediawiki-1.7.1/includes/SpecialListusers.php 2006-07-08 22:45:27.000000000 -0700 +++ mediawiki-1.7.1patch/includes/SpecialListusers.php 2006-09-19 18:44:43.000000000 -0700 @@ -128,7 +128,7 @@ $userspace = NS_USER; $sql = "SELECT 'Listusers' as type, $userspace AS namespace, user_name AS title, " . - "user_name as value, user_id, COUNT(ug_group) as numgroups " . + "user_real_name as value, user_id, COUNT(ug_group) as numgroups " . "FROM $user ". "LEFT JOIN $user_groups ON user_id=ug_user " . $this->userQueryWhere( $dbr ) .
Ok.. scratch that. Turns out to be a bug in the returned results from mysql version I am running. Maybe I need to look into what is going one with mysql.
Closed the bug, reopen it if you see that it *is* a problem in MediaWiki.