Lucas_Werkmeister_WMDE added a comment.
Trying something slightly different. I think the Still Life with Pie and Silver Ewer <https://www.wikidata.org/w/index.php?title=Q17524323&diff=1672132901&oldid=1672058773>, inspected previously (T309445#8055711 <https://phabricator.wikimedia.org/T309445#8055711>), is too confusing to be of much further use in its broken state; therefore, I decided to purge it. An API purge with `forcelinkupdate` set successfully fixed all the terms of the item: MariaDB [wikidatawiki]> SELECT wbit_item_id, wbit_term_in_lang_id, wby_name, wbtl_text_in_lang_id, wbxl_id FROM wbt_item_terms LEFT JOIN wbt_term_in_lang ON wbit_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 wbit_item_id IN (17524323) AND wbxl_id IS NULL; Empty set (0.002 sec) And the partial rows from before seem to have been properly cleaned up as well, there is no trace left of either the term_in_lang IDs or the text_in_lang ID: MariaDB [wikidatawiki]> SELECT wbtl_id, wby_name, wbtl_text_in_lang_id, wbxl_id FROM wbt_term_in_lang 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 wbtl_id IN (906991069, 957282069); Empty set (0.001 sec) MariaDB [wikidatawiki]> SELECT * FROM wbt_term_in_lang WHERE wbtl_text_in_lang_id = 228497807; Empty set (0.001 sec) So I think one thing I //am// confident to say (for a change!) is that **a purge with links update fixes the issue**; and I extrapolate from this that **a subsequent edit probably fixes the issue as well**. (Note: on other wikis, a “purge with links update” is equivalent to a “null edit”, but you can’t null edit an item. Also, a “UI purge”, via `?action=purge` in the normal URL, does not include a links update, and will not fix the issue.) TASK DETAIL https://phabricator.wikimedia.org/T309445 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Werkmeister_WMDE Cc: Lydia_Pintscher, karapayneWMDE, Addshore, Manuel, Lucas_Werkmeister_WMDE, Aklapper, Moebeus, Astuthiodit_1, Invadibot, Universal_Omega, maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
