https://bugzilla.wikimedia.org/show_bug.cgi?id=34795
Web browser: --- Bug #: 34795 Summary: commonswiki.globalimagelinks.gil_page_title contains page titles with underscores AND sometimes whitespaces (1.19 Bug?) Product: Wikimedia Version: unspecified Platform: All OS/Version: All Status: NEW Severity: blocker Priority: Unprioritized Component: Site requests AssignedTo: wikibugs-l@lists.wikimedia.org ReportedBy: bugrepor...@to.mabomuja.de Classification: Unclassified Mobile Platform: --- Field commonswiki.globalimagelinks.gil_page_title should normally contain page titles using underscores as all page tables do. But sometimes white spaces are used instead. This config should be changed because it makes querying this table difficult if regex instead of simple string compare must be used to match all cases. This behavior is new, so it may be related to 1.19 update of commonswiki. Example: dewiki with underscore; eswiki,frwiki with white spaces select gil_wiki, gil_page, gil_page_title, gil_to from commonswiki_p.globalimagelinks where gil_to='Castillo_de_Consuegra2.jpg'; +----------+----------+-----------------------+----------------------------+ | gil_wiki | gil_page | gil_page_title | gil_to | +----------+----------+-----------------------+----------------------------+ | dewiki | 6794830 | Castillo_de_Consuegra | Castillo_de_Consuegra2.jpg | | eswiki | 581556 | Castillo de la Muela | Castillo_de_Consuegra2.jpg | | frwiki | 5677515 | Château de la Muela | Castillo_de_Consuegra2.jpg | +----------+----------+-----------------------+----------------------------+ -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l