Last modified: 2014-10-05 18:33:15 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T73670, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 71670 - checkLocalNames.php maintenance script uses non-existent SQL columns
checkLocalNames.php maintenance script uses non-existent SQL columns
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
CentralAuth (Other open bugs)
REL1_23-branch
All All
: Unprioritized normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-10-05 16:14 UTC by Southparkfan
Modified: 2014-10-05 18:33 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Southparkfan 2014-10-05 16:14:21 UTC
The CentralAuth checkLocalNames.php script in the REL1_19 - REL1_23 (the 1.25wmf1 and master branches are unaffected as they are already patched) branches uses the ln_wiki and ln_user of the localuser table to fetch data, but the ln_user tables does not exist, ln_wiki and ln_name are the only tables. When running the maintenance script (REL1_23 branch), people get errors like: 

Checking localnames for dewiki ...
         ... querying from ''
A database query error has occurred.
Query: SELECT  ln_user  FROM `localnames`   WHERE ln_wiki = 'dewiki' AND (ln_user > '')  ORDER BY ln_name ASC LIMIT 1000
Function: execute
Error: 1054 Unknown column 'ln_user' in 'field list' (localhost)

Legoktm fixed this bug in https://gerrit.wikimedia.org/r/#/c/142304/ - but that fix seems only to be used in the 1.25wmf1 and master branches. The fix has never been backported to the stable branches.

Is it possible to fix this bug also in the current stable branches?
Comment 1 Kunal Mehta (Legoktm) 2014-10-05 18:33:15 UTC
Backported in https://gerrit.wikimedia.org/r/#/c/164781/

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links