Page MenuHomePhabricator

wikidata-todo throws uncaught exception ToolforgeCommon::getSQL
Closed, ResolvedPublicBUG REPORT

Description

When opening https://wikidata-todo.toolforge.org/, I see this:

wikidata-todo broken.png (523×1 px, 34 KB)

I'm pretty sure none of that PHP/SQL code is intended to show up.

Similar things happen when clicking on the suggested tasks.

Event Timeline

1234qwer1234qwer4 changed the subtype of this task from "Task" to "Bug Report".Jun 5 2021, 5:44 PM

Getting the same error when opening https://wikidata-todo.toolforge.org/dupe_finder.php?site=eowiki&run=Do+it now:

Found 15,455 items unique to eowiki.
string(487) "select DISTINCT term_full_entity_id from wb_terms where term_type IN ('label','alias') AND term_text='Matthew McLauchlin' AND term_full_entity_id!='Q55986' AND NOT EXISTS (SELECT * FROM pagelinks,page WHERE page_namespace=0 AND term_full_entity_id=page_title and page_id=pl_from AND pl_namespace=0 AND pl_title IN ('Q4167410','Q13406463','Q4167836','Q11266439')) AND NOT EXISTS (SELECT * FROM wb_items_per_site WHERE concat('Q',ips_item_id)=term_full_entity_id AND ips_site_id='eowiki')" string(248) "#0 /data/project/magnustools/public_html/php/common.php(38): ToolforgeCommon->getSQL(Object(mysqli), 'select DISTINCT...', 0, '') #1 /data/project/wikidata-todo/public_html/dupe_finder.php(74): getSQL(Object(mysqli), 'select DISTINCT...') #2 {main}"
Fatal error: Uncaught Exception: ToolforgeCommon::getSQL: Table 'wikidatawiki_p.wb_terms' doesn't exist/1146 : select DISTINCT term_full_entity_id from wb_terms where term_type IN ('label','alias') AND term_text='Matthew McLauchlin' AND term_full_entity_id!='Q55986' AND NOT EXISTS (SELECT * FROM pagelinks,page WHERE page_namespace=0 AND term_full_entity_id=page_title and page_id=pl_from AND pl_namespace=0 AND pl_title IN ('Q4167410','Q13406463','Q4167836','Q11266439')) AND NOT EXISTS (SELECT * FROM wb_items_per_site WHERE concat('Q',ips_item_id)=term_full_entity_id AND ips_site_id='eowiki') in /data/project/magnustools/public_html/php/ToolforgeCommon.php:233 Stack trace: #0 /data/project/magnustools/public_html/php/common.php(38): ToolforgeCommon->getSQL(Object(mysqli), 'select DISTINCT...', 0, '') #1 /data/project/wikidata-todo/public_html/dupe_finder.php(74): getSQL(Object(mysqli), 'select DISTINCT...') #2 {main} thrown in /data/project/magnustools/public_html/php/ToolforgeCommon.php on line 233

Different bug though. Fixed now.