Last modified: 2014-04-29 03:00:29 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 T66396, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 64396 - Titles with non-breaking spaces aren't converted to underscores in upgrades
Titles with non-breaking spaces aren't converted to underscores in upgrades
Status: NEW
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
unspecified
All All
: Low normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-04-24 21:34 UTC by Mark A. Hershberger
Modified: 2014-04-29 03:00 UTC (History)
0 users

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


Attachments

Description Mark A. Hershberger 2014-04-24 21:34:50 UTC
I have a database that contains several titles with unicode non-breaking spaces.  The following query shows 13 rows:

mysql> select page_id, page_title from page where page_title like CONCAT('%', convert(unhex('c2a0') using utf8), '%');

CKEditor used to be used on this wiki and I suspect it is to blame.  These pages aren't accessible in the wiki, but they do turn up search results.

Converting the rows so that the character is replaced with "_" makes the page accessible.

A conversion should probably be performed by upgrade.php.
Comment 1 Andre Klapper 2014-04-28 07:07:15 UTC
Where is upgrade.php in the codebase?
Comment 2 Mark A. Hershberger 2014-04-28 17:45:26 UTC
I should have written "update.php".

And I discovered maintenance/cleanupTitles.php which fixes the problem.  Adding a notice to update.php that the user should run cleanupTitles.php would help.

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


Navigation
Links