Addshore added a comment.
Expanding what I am looking at slightly with the following query (no longer
just looking at labels):
SELECT * FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON
wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON
wbxl_text_id = wbx_id WHERE wbx_text IS NULL ORDER BY wbpt_property_id;
There appears to be a large number of labels and aliases that are incorrect /
NULL.
There don't appear to be any NULL descriptions, but there are some rows where
wby_name (the term type) is NULL, maybe they were descriptions?
The results of this query show data is wrong at multiple different levels.
So wbt_property_terms refers to multiple rows in these following tables, for
rows that do not exist.
- wbt_term_in_lang
- wbt_text_in_lang
- wbt_text
I can't help but stare at DatabaseTermIdCleaner::cleanTermIds and read the
doc that says..
> It is the caller’s responsibility ensure that the term_in_lang rows are no
longer referenced anywhere;
TASK DETAIL
https://phabricator.wikimedia.org/T237984
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: abian, JAnD, Ash_Crow, Addshore, PKM, Moebeus, alaa_wmde, VIGNERON,
Aklapper, Lydia_Pintscher, Ladsgroup, Lea_Lacroix_WMDE, Iflorez, darthmon_wmde,
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen,
rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
