https://bugzilla.wikimedia.org/show_bug.cgi?id=60274
Web browser: ---
Bug ID: 60274
Summary: "{{#ask:" fails with database error when querying
categories with subcategories
Product: MediaWiki extensions
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Semantic MediaWiki
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: t...@tim-landscheidt.de
CC: abog...@wikimedia.org, jamesin.hongkon...@gmail.com,
jeroen_ded...@yahoo.com,
mar...@semantic-mediawiki.org, nischay...@gmail.com,
rlan...@gmail.com
Classification: Unclassified
Mobile Platform: ---
https://wikitech.wikimedia.org/w/index.php?title=Incident_documentation&oldid=89337
yields "Database error: A database query error has occurred. This may indicate
a bug in the software." The error log says: "PHP Notice: Uncommitted DB writes
(transaction from DatabaseBase::query (WikiPage::pageData)). in
/srv/org/wikimedia/controller/wikis/slot0/includes/db/Database.php on line
4104".
Bisecting shows that this started with the addition of "{{#ask:
[[Category:Events reports]] | format=ul }}" to the page, but must have been
worked in the past.
Playing around with some queries shows that #ask'ing for categories with only
plain pages works (Category:Tools Access Requests), but for categories with
subcategories (Category:Events reports, Category:Linode) fails.
Currently, wikitech is running 1.8.0.5.
"format=debug" says (not failing):
| Debug Output by SMWSQLStore3
| Generated Wiki-Query
| [[Category:Events reports]]
| Query Metrics
| Query-Size:1
| Query-Depth:0
| SQL Query
| SELECT DISTINCT t2.smw_title AS t,t2.smw_namespace AS ns FROM
`smw_object_ids` AS t2 INNER JOIN `smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN `t1` AS t1 ON t0.o_id=t1.id ORDER BY t2.smw_sortkey ASC LIMIT 51
OFFSET 0;
| Auxilliary Tables Used
| Temporary table t1
| Recursively computed hierarchy for element(s) ('3544').
| Errors and Warnings
| None
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
