After downloading the cs: database dump and importing it to my local
MediaWiki installation, I played a little with the database and I have
found some problems. We have already known about some of them, some
others were quite surprising. We would like to clean the database, but
I don't know if this is the right place to ask.
The problems are:
Article named "kniha_nahrávek" in Wikipedia namespace -- note the
first lowercase letter, which makes the article inaccessible. This was
a badly named entry in LanguageCs.php corresponding to the "Upload
log". Because of that, there are many duplicate copies of the article,
cur_ids: 237, 238, 365, 367, 457, 459, 461, 463, 487, 528, 529, 538,
643, 654, 656, 689, 691, 693, 698, 700, 702, 704, 708, 710, 712, 714.
We would like to get them all deleted.
Article named "kniha_nahrávek_" in Wikipedia namespace -- in addition
to the lowercase letter, there is a space at the end. cur_id = 836,
the article should also be deleted.
" Psaní_dat" in Wikipedia namespace -- beginning with a space, which
makes it also inaccessible (automatic redirection to "Psaní dat"),
cur_id = 1265. The article should be also deleted.
Duplicate "Sirotčí_stránky" in Wikipedia namespace, cur_ids 716, 733.
One or both of them should be deleted.
Duplicate "26._října" in the main namespace, cur_ids 3326, 3327. One
of them should be deleted (or both, it is a simple redirect that could
be simply recreated).
"Wikipedie:Co_je_článek" in the main namespace (cur_id = 49) -- note
that the czech name of Wikipedia namespace is "Wikipedie". So that its
name collides with the namespace name (it was probably created when
the namespace name was not yet translated), and its name is invalid.
The article has been deleted by a sysop, but without real success, it
still appears in e.g. Special:Uncategorizedpages etc. The article
should be deleted.
"" (empty name) in Media namespace (cur_id = 3614) -- it should
obviously be removed.
Could someone with database access please fix those problems? Or, if
there is a better place to ask these requests, just tell me.
[[cs:User:Mormegil|Petr Kadlec]] (sysop/bureaucrat on cs: Wikipedia)