Last modified: 2011-03-13 18:05:06 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 T21083, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 19083 - list=exturlusage does not show all links if there are someone with an empty el_index in db externallinks
list=exturlusage does not show all links if there are someone with an empty e...
Status: RESOLVED WONTFIX
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
unspecified
All All
: Lowest major (vote)
: ---
Assigned To: Roan Kattouw
http://en.wikipedia.org/w/api.php?act...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-06-05 01:38 UTC by merl
Modified: 2011-03-13 18:05 UTC (History)
4 users (show)

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


Attachments

Description merl 2009-06-05 01:38:20 UTC
http://en.wikipedia.org/w/api.php?action=query&list=exturlusage&euquery=www.cia.gov/cia/publications/factbook/geos&eunamespace=10&euprotocol=https does not show all links as expected. e.g. http://en.wikipedia.org/w/api.php?action=query&prop=extlinks&titles=Template:Economy_of_Austria_table contains that a link that should match.
I think its because ApiQueryExtLinksUsage uses el_index to find these links. But as i can see on toolserverdb, in the missing cases el_index on db externallinks is empty. I think el_to should be used in the query instead.

sql query to show the missing result on enwiki_p: select page_namespace, page_title, e.* from page p inner join externallinks e on p.page_id = e.el_from where el_to like 'https://www.cia.gov/cia/publications/factbook/geos%' and page_namespace=10;
Comment 1 Roan Kattouw 2009-06-05 15:44:34 UTC
Closing this as WONTFIX.

The query needs to use the el_index field in order to be remotely efficient; using el_to is not an option. Also, the real bug here is that the database is corrupt: empty el_index fields simply shouldn't happen, the fact that they do is a separate bug.

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


Navigation
Links