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
