| Multichill added subscribers: Lydia_Pintscher, Sjoerddebruin, Multichill. Multichill triaged this task as "High" priority. Multichill added a comment. |
So wb_entity_per_page was killed:
MariaDB [wikidatawiki_p]> SELECT * FROM wb_entity_per_page LIMIT 1;
ERROR 1356 (HY000): View 'wikidatawiki_p.wb_entity_per_page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
The wb_terms table offers a good alternative to change queries to:
MariaDB [wikidatawiki_p]> SELECT * FROM wb_terms LIMIT 1;
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| term_row_id | term_entity_id | term_full_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| 363474 | 50445 | Q50445 | item | en-gb | label | Jungwon-gu | jungwon-gu | 0 |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
1 row in set (0.00 sec)
The wb_items_per_site offers no such option:
MariaDB [wikidatawiki_p]> SELECT * FROM wb_items_per_site LIMIT 1;
+------------+-------------+-------------+------------------+
| ips_row_id | ips_item_id | ips_site_id | ips_site_page |
+------------+-------------+-------------+------------------+
| 55 | 3596065 | abwiki | Џьгьарда |
+------------+-------------+-------------+------------------+
1 row in set (0.01 sec)
The killing of wb_entity_per_page broke all sorts of tools with no alternative available.
Cc: Multichill, Sjoerddebruin, Lydia_Pintscher, Pasleim, Ricordisamoa, hoo, daniel, Aklapper, Lahi, GoranSMilovanovic, QZanden, Marostegui, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
