Last modified: 2012-03-01 21:51:47 UTC
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 | +----------+----------+-----------------------+----------------------------+
Pushed into the extension component for the moment. Needs fixing before we look at trying to clean up post it...
r112687, merged in r112688 This code is the same as it was in 1.18wmf1, so I'm not sure it's at fault, as it's only used on a page move
Reproduced, I think... Created a page (with the image) on enwiki at User:Reedy/Sandbox, moved to User:Reedy/Sandbox 2, it had a space Deleted that page, recreated it from scratch, it had a _ Just the cleanup to do now...
Merged to 1.18wmf1 in r112689
Lowering severity as it's not going to get any worse Running a large database query to pull a list of titles we need to fix
Just under 55k to fix
SELECT * FROM globalimagelinks WHERE gil_page_title LIKE '% %'; All done and tidied up now