Page MenuHomePhabricator

recountCategories.php doesn't always work
Open, Needs TriagePublic

Description

https://de.wikipedia.org/w/index.php?title=Kategorie:Crurotarsi has one subcat, but in it's parent category, https://de.wikipedia.org/wiki/Kategorie:Sauropsida, none is shown, just as inn category table. However, categorylinks has the entry that should match.

Any tips?

wikiadmin@10.64.0.163(dewiki)> select * from category where cat_title="Crurotarsi";
+--------+------------+-----------+-------------+-----------+
| cat_id | cat_title  | cat_pages | cat_subcats | cat_files |
+--------+------------+-----------+-------------+-----------+
| 984830 | Crurotarsi |        21 |           0 |         0 |
+--------+------------+-----------+-------------+-----------+
1 row in set (0.00 sec)

wikiadmin@10.64.0.163(dewiki)> select * from categorylinks where cl_from=6568210 and cl_type="subcat";
+---------+------------+------------+---------------------+-------------------+--------------+---------+
| cl_from | cl_to      | cl_sortkey | cl_timestamp        | cl_sortkey_prefix | cl_collation | cl_type |
+---------+------------+------------+---------------------+-------------------+--------------+---------+
| 6568210 | Sauropsida | CRUROTARSI | 2014-10-15 07:21:41 |                   | uppercase    | subcat  |
+---------+------------+------------+---------------------+-------------------+--------------+---------+
1 row in set (0.00 sec)

Event Timeline

Urbanecm created this task.Nov 19 2019, 9:00 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 19 2019, 9:00 AM
doctaxon added a subscriber: doctaxon.
This comment was removed by doctaxon.

Meaning: the subcategory 'Crocodylomorpha' is not counted as subcat of 'Crurotarsi'.

Please note, this query gives no result:

use dewiki_p; 
select * from categorylinks where cl_from=8310542 and cl_type="subcat";

But the category 'Crocodylomorpha', whose cl_from 8310542 is, is the subcat of 'Crocodylia', so there must be a sql query result.

Thgoiter removed a subscriber: Thgoiter.Nov 19 2019, 5:36 PM
doctaxon added a subscriber: TTO.Nov 20 2019, 7:57 AM