Page MenuHomePhabricator

SQL returns additional hit?
Closed, InvalidPublic

Description

Author: D.U.Thibault

Description:
Not sure what causes this, but since about two weeks ago the French Wiktionary has a major category with a "parasite" SQL hit at its end. If you go to http://fr.wiktionary.org/w/index.php?title=Cat%C3%A9gorie:fran%C3%A7ais&until=%EF%BF%AE#mw-pages you will see an extra entry (''Aastais'') after what should have been the last one (''zzz''), categorised under some strange leading character (not a space, which would have put that entry before the top of the category). It is surmised the SQL query that builds the category page has some garbage-related bug that returns the extra entry. That extra entry has not changed since it first appeared, and moving or editing the article has failed to remove it.


Version: unspecified
Severity: normal

Details

Reference
bz16565

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:29 PM
bzimport set Reference to bz16565.
bzimport added a subscriber: Unknown Object (MLST).

D.U.Thibault wrote:

I should add that the extra entry (''Aastais'') is a duplicate of a legitimate entry, which appears where it should (http://fr.wiktionary.org/w/index.php?title=Cat%E9gorie:fran%E7ais&from=aas).

You have two different articles (or had, it looks like one has been redirected). But one of the articles has a [[w:byte order mark]] in the beginning of the name: [[wikt:fr:%EF%BB%BFAastais]]. That article was probably created by mistake, maybe by someone copying the title from a text file starting with a byte order mark. It is not a bug that both articles were in the same category and sorted differently. The byte order mark is sorted after "zzz" and is not visible in web browsers.