I found about ten occurences of duplicate article titles in the nl: cur db while processing dump. Two consecutive entries with exactly the same title field, both namespace 0. See three examples (article text omitted, was entirely different between the two versions).
Is there an explanation for this?
Erik Zachte
--------------------------------------------------
(71024,0,'Apollo_13','...Article..','',0,'217.120.200.115','20040708215420', '',0,0,0,1,0.114801676066,'79959291784579','20040708215420') (71025,0,'Apollo_13','...Article 2..','cat',97,'Ellywa','20040710183320','',0,0,1,0,0.641321313866,'799592898 16679','20040710183320')
(57077,0,'Tricolore','...Article..','',4164,'Maartentje','20040428161440','' ,0,0,0,1,0.799059053324,'79959571838559','20040706200656') (57078,0,'Tricolore','...Article 2..','',3503,'Känsterle','20040713135539','',0,0,1,0,0.464381295007,'7995928 6864460','20040713135539'),(57079,6,'Tricolore_image.png','Tricolore','Trico lore',4164,'Maartentje','20040428161536','',0,0,0,1,0,'79959571838463','2004 0713135540')
(57473,0,'Amiga','...Article..','Amiga OS',4198,'Linuxfan','20040429191859','',0,0,0,1,0.053266451719,'799595708081 40','20040429191859') (57474,0,'Amiga','...Article 2..','',0,'217.85.143.242','20040628194955','',0,0,0,0,0.354067844038,'79959 371805044','20040628194955')
Erik Zachte schrieb:
I found about ten occurences of duplicate article titles in the nl: cur db while processing dump. Two consecutive entries with exactly the same title field, both namespace 0. See three examples (article text omitted, was entirely different between the two versions).
Is there an explanation for this?
I've noticed that some time ago on the German Wikipedia, too. I discussed it with JeLuF on #de.wikipedia, and our explanation - IIRC - was the following: If someone is impatient and clicks several times on "save" while creating a new article, this article will be stored several times in the cur_table.
Henning.H --[[de:Benutzer:HenHei]]
Henning Heitkötter schrieb:
Erik Zachte schrieb:
I found about ten occurences of duplicate article titles in the nl: cur db while processing dump. Two consecutive entries with exactly the same title field, both namespace 0. See three examples (article text omitted, was entirely different between the two versions).
Is there an explanation for this?
I've noticed that some time ago on the German Wikipedia, too. I discussed it with JeLuF on #de.wikipedia, and our explanation - IIRC - was the following: If someone is impatient and clicks several times on "save" while creating a new article, this article will be stored several times in the cur_table.
Sorry, I forgot to add: "But that's not an explaination for duplicate articles with different text. At least, in my opinion..."
Henning Heitkötter wrote:
Henning Heitkötter schrieb:
Erik Zachte schrieb:
I found about ten occurences of duplicate article titles in the nl: cur db while processing dump. Two consecutive entries with exactly the same title field, both namespace 0. See three examples (article text omitted, was entirely different between the two versions).
Is there an explanation for this?
I've noticed that some time ago on the German Wikipedia, too. I discussed it with JeLuF on #de.wikipedia, and our explanation - IIRC
- was the following:
If someone is impatient and clicks several times on "save" while creating a new article, this article will be stored several times in the cur_table.
Sorry, I forgot to add: "But that's not an explaination for duplicate articles with different text. At least, in my opinion..."
If only one of these gets edited later on, or both are edited on a random basis, might explain it.
wikitech-l@lists.wikimedia.org