Topic on Project:Support desk

Some page_title entries in database have space instead of underscore. How to fix?

5
Summary by Tenzel Kim

Running cleanupTitles.php fixed the missing underscores and everything now works fine. Pages that were recreated as new pages before running the script were moved to Broken/"page_title" so it was easy to compare and delete afterwards

Tenzel Kim (talkcontribs)

I have some pages in my wiki in the Orphaned Pages list that show up as if the linked page doesn't exist.

If I search for the page in the search bar I get a result. But rather than going to the page itself it just shows the page in the Page title matches, where they appear to be active links, but if you click them you don't go to the page., but a create page instead.

When hovering over the page in the Page title matches I see that instead of underscore it sometimes has %C2%A0 or %A0 in the link.

This made me look up the page in the database where I can see that instead of underscore those particular pages have a blank space instead of the underscore it is supposed to have.

How do I fix that so that the space is changed to an underscore in the database?

MediaWiki version 1.26.3

PHP version 5.6.39 (cgi-fcgi)

MySQL version ? - Not sure where to check for the version number

Btw, this problem has existed throughout the last many updates of the wiki. Only just figured out the problem in the database names.

Ciencia Al Poder (talkcontribs)
Microstep-developer (talkcontribs)

Any updates here?

Run maintenance script is not the solution. Broken page titles are still creating.

My temporary quick fix: run maintenance script onPageContentSaveComplete hook...

Ciencia Al Poder (talkcontribs)

If those pages are still being created, you have a faulty extension creating this mess, or you're using some hack to create pages...

Tenzel Kim (talkcontribs)

That worked. Thought I'd tried that before but apparently not. Thanks.