Hi!
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.
Thanks, [[cs:User:Mormegil|Petr Kadlec]] (sysop/bureaucrat on cs: Wikipedia)
Done.
JeLuF
On Fri, Oct 29, 2004 at 09:15:02PM +0200, Petr Kadlec wrote:
Hi!
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.
Thanks, [[cs:User:Mormegil|Petr Kadlec]] (sysop/bureaucrat on cs: Wikipedia) _______________________________________________ Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
On Mon, 1 Nov 2004 06:42:53 +0100, Jens Frank jeluf@gmx.de wrote:
Done.
Thanks. [[cs:User:Mormegil|Petr Kadlec]]
wikitech-l@lists.wikimedia.org