Page MenuHomePhabricator

500: Internal Server Error at the articleinfo tool of Wikimedia DE
Closed, ResolvedPublic

Description

/var/www/app/Resources/views/articleInfo/result.html.twig: 45 - An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT IF(term_type = 'label', 'label', 'description') AS term, term_text                FROM wikidatawiki_p.wb_entity_per_page                JOIN wikidatawiki_p.page ON epp_page_id = page_id                JOIN wikidatawiki_p.wb_terms ON term_entity_id = epp_entity_id                    AND term_language = :lang                    AND term_type IN ('label', 'description')                WHERE epp_entity_id = :wikidataId                UNION                SELECT pl_title AS term, wb_terms.term_text                FROM wikidatawiki_p.pagelinks                JOIN wikidatawiki_p.wb_terms ON term_entity_id = SUBSTRING(pl_title, 2)                    AND term_entity_type = (IF(SUBSTRING(pl_title, 1, 1) = 'Q', 'item', 'property'))                    AND term_language = :lang                    AND term_type = 'label'                WHERE pl_namespace IN (0, 120)                    AND pl_from = (                        SELECT page_id FROM wikidatawiki_p.page                        WHERE page_namespace = 0                            AND page_title = 'Q:wikidataId'                    )' with params ["de", "421072"]:SQLSTATE[HY000]: General error: 1356 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").

URL: http://xtools.wmflabs.org/articleinfo/de.wikipedia.org/Pyrimethamin

Please provide any further details here

XTools version: 3.1.15-d5225bb

Event Timeline

Further description: when changing the default setting from en.wikipedia to de.wikipedia and then adding a search word (in this case "Pyrimethamin") I get this error.

MusikAnimal triaged this task as High priority.
MusikAnimal moved this task from Backlog to Working on the XTools board.
MusikAnimal removed a project: Community-Tech.

This was because of T95685. I have commented out the code that used that table, so ArticleInfo should work now. This means we're no longer reporting wikidata "errors" (such as a missing description). Investigation pending.

MusikAnimal moved this task from Working to Complete on the XTools board.

Fixed with 76fbeb1 and deployed, but again this means Wikidata errors are no longer being reported. I've created T179313 to find a new way to do this.