Last modified: 2010-05-15 14:36:27 UTC
After creating the page http://en.wikipedia.org/wiki/Singles_93-03 I received a "page does not exist, please create one", so I tried saved it again, which resulted in another "page does not exist". Probably because of db lag, the page had been saved anyway as I was looking for what went wrong. So that didn't seem to be buggy. However, in the mean time the page -- which had been saved twice because of db lag -- had put itself into its categories twice, see e.g. http://en.wikipedia.org/wiki/Category:The_Chemical_Brothers_albums http://en.wikipedia.org/wiki/Category:2003_albums ... Removing the categories from the page didn't help, as only one of two entries was removed from the category. Bringing the categopries back to the article, also brought the number of entries in the categories back to two. Thanks in advance, [[User:Aliekens]]
so we have an orphaned catagory entry and no easy way to remove it (the only way i can think of is probablly for a developer to use sql directly) i don't know how wikipedia stores pages so i don't know if we also have two page records in there for the same page name maybe the database could be made to enforce no duplicates on entrys in a catagory. i've marked this as major because its database curruption that isn't easy to undo
I removed the duplicate entry from the database.
*** Bug 1285 has been marked as a duplicate of this bug. ***
My duplicate bug is in regards to: http://en.wikipedia.org/wiki/Castlevania_DS which has been 5x categorized in both: http://en.wikipedia.org/wiki/Category:Castlevania_games http://en.wikipedia.org/wiki/Category:Nintendo_DS_games
Category "Антигипертензивные средства, влияющие на сосудодвигательные центры головного мозга" in ru.wikipedia.org (http://ru.wikipedia.org/wiki/Category:%D0%90%D0%BD%D1%82%D0%B8%D0%B3%D0%B8%D0%BF%D0%B5%D1%80%D1%82%D0%B5%D0%BD%D0%B7%D0%B8%D0%B2%D0%BD%D1%8B%D0%B5_%D1%81%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B2%D0%B0%2C_%D0%B2%D0%BB%D0%B8%D1%8F%D1%8E%D1%89%D0%B8%D0%B5_%D0%BD%D0%B0_%D1%81%D0%BE%D1%81%D1%83%D0%B4%D0%BE%D0%B4%D0%B2%D0%B8%D0%B3%D0%B0%D1%82%D0%B5%D0%BB%D1%8C%D0%BD%D1%8B%D0%B5_%D1%86%D0%B5%D0%BD%D1%82%D1%80%D1%8B_%D0%B3%D0%BE%D0%BB%D0%BE%D0%B2%D0%BD%D0%BE%D0%B3%D0%BE_%D0%BC%D0%BE%D0%B7%D0%B3%D0%B0 ) contains 4 exact same entries "Урапидил" (http://ru.wikipedia.org/wiki/%D0%A3%D1%80%D0%B0%D0%BF%D0%B8%D0%B4%D0%B8%D0%BB). Only one should be there.
Category "Логика" in ru.wikipedia.org (http://ru.wikipedia.org/wiki/Category:%D0%9B%D0%BE%D0%B3%D0%B8%D0%BA%D0%B0) contains 2 exact same entries "Парадокс" (http://ru.wikipedia.org/wiki/%D0%9F%D0%B0%D1%80%D0%B0%D0%B4%D0%BE%D0%BA%D1%81). Only one should be there.
Category "X86" in ru.wikipedia.org (http://ru.wikipedia.org/wiki/Category:X86) contains 2 exact same entries "Am486 SX2" (http://ru.wikipedia.org/wiki/Am486_SX2). Only one should be there.
Category "Программное обеспечение" in ru.wikipedia.org (http://ru.wikipedia.org/wiki/Category:%D0%9F%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%BD%D0%BE%D0%B5_%D0%BE%D0%B1%D0%B5%D1%81%D0%BF%D0%B5%D1%87%D0%B5%D0%BD%D0%B8%D0%B5) contains 2 exact same entries "Лексикон (программа)" (http://ru.wikipedia.org/wiki/%D0%9B%D0%B5%D0%BA%D1%81%D0%B8%D0%BA%D0%BE%D0%BD_%28%D0%BF%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B0%29). Only one should be there.
Do not save again when you see the page not there after creating it. If you didn't get a database error, the save worked. Wait 30 seconds, reload, and you'll probably see the new page. The database setup is being changed to use a unique index which will make it impossible to create duplicates. You'll get a database error on the second and later saves instead. Part of the process of creating that will remove all of the existing duplicates.
*** Bug 1320 has been marked as a duplicate of this bug. ***
*** Bug 2080 has been marked as a duplicate of this bug. ***
*** Bug 2179 has been marked as a duplicate of this bug. ***
see http://bugzilla.wikimedia.org/show_bug.cgi?id=2382#c1 bug 2382: "existence of duplicate records as a result of bug 1202" bug 2388: "handling: add a "purge" link to [[MediaWiki:Noarticletext]]"
1.5 quite firmly fixes this index on the conversion. We've already fixed most of the Wikimedia sites as well manually. Resolving FIXED again.
