Last modified: 2009-09-07 20:30:56 UTC
For some time now, the special page Special:WantedCategories at http://pt.wiktionary.org lists the same unchanged categories, although changes have been made that would affect that list. The refresh date is updated though and is of today. Only the contents is not refreshed. Examples: "Category:Afaan Oromo" does not have any member (is not "wanted") but it keeps showing up. "Category:Substantivo (Baixo Saxão/Plattdütsch)" already exists but it keeps showing up.
Still no feedback on this? The problem still exists.
Raising prio/severity. It's getting difficult to work with the presence of this problem. Other wikis don't seem to be affected by this.
I have more information regarding this: as we have been moving categories around, I noticed some (new) missing categories are present on the Wanted Categories special page. This means the page is actually being updated. So, the problem is that it is somehow still considering that categories created long ago are still missing (like "Category:Baixo Saxão/Plattdütsch") and that some not wanted already for long time are still wanted (like "Category:Afaan Oromo", with no members for months). Thanks.
I managed to understand a bit more of this: some categories were still being linked to by the cached copy of some other categories. I did a null edit on those I could guess and the supposed number of members decreased. Others seem to be related to redirect in categories that were meanwhile deleted. The cached copy of the articles are still pointing to the redirect somehow, even if these categories do not show up in them. A null edit seems to solve as well. Another one, and this one is stranger, is related to "Category:Adjectivo_(Albanês)". I checked the category links DB dump and I see: (3676,'Adjectivo_(Albanês)','Portugalisht',20050430061544) (3676,'Gentílico_(Albanês)','Portugalisht',20050430061544) Nevertheless, there is no pageid 3676 in the page table. Unless I'm seeing it wrongly, there's some inconsistency here. This being the case, could someone please deleted the above category links? This does not solve the whole problem but it's one of the steps.
While discussing the above at #wikimedia-tech, RoanKattouw discovered the following in the "ptwikt" DB: select distinct cl_from from categorylinks left join page on page_id=cl_from where page_title is null; (snip) (see http://dpaste.org/NeJ3/ ) 34 rows in set (0.56 sec) There are 34 non-existing pages with links to categories. One of them is the one mentioned above. These should be deleted as they point to no page and are causing unwanted categories to appear in Special:WantedCategories. (Thanks, RoanKattouw!)
Done (for this wiki only).
Sorry: not done. In pt.WIKTionary.org Special:WantedCategories, the categories [[Category:Adjectivo_(Albanês)]] and [[Category:Contracção]] still appear. These were in the situation mentioned in comments #4 and #5. Unfortunately, there is still no current DB dump at download.wikimedia.org for me to check for these records.
(In reply to comment #7) > Sorry: not done. > > In pt.WIKTionary.org Special:WantedCategories, the categories > [[Category:Adjectivo_(Albanês)]] and [[Category:Contracção]] still appear. > These were in the situation mentioned in comments #4 and #5. > > Unfortunately, there is still no current DB dump at download.wikimedia.org for > me to check for these records. > I can confirm this on the toolserver: the query cited at http://dpaste.org/NeJ3/ still shows the exact same ghost entries.
Checked, found no entries. [andrew@zwinger ~]$ sql ptwiki Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1237837812 to server version: 4.0.40-wikimedia-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select distinct cl_from from categorylinks left join page on page_id=cl_from -> where page_title is null; Empty set (9.57 sec)
(In reply to comment #9) > Checked, found no entries. > > [andrew@zwinger ~]$ sql ptwiki The bug is filed against the Portugese *Wiktionary* (ptwiktionary), not Portugese *Wikipedia* (ptwiki).
Good catch, fixed.
Thank you, werdna!