https://bugzilla.wikimedia.org/show_bug.cgi?id=26622
Summary: error in #ask query caused by a large offset value Product: MediaWiki extensions Version: any Platform: All URL: http://www.species-id.net OS/Version: All Status: NEW Severity: critical Priority: Normal Component: Semantic MediaWiki AssignedTo: mar...@semantic-mediawiki.org ReportedBy: andreas.pl...@web.de CC: g.m.haged...@gmail.com, jeroen_ded...@yahoo.com Dear Mr. Krötzsch, using the #ask parser function with a large offset results in a SQL error. On our OpenMedia Wiki http://www.species-id.net we have 15089 images in the category "Dryades Plant Images". If I try the following wiki code on the page http://www.species-id.net/openmedia/Special:ExpandTemplates {{#ask: [[Category:Dryades Plant Images]] | offset=5000 }} it throws the following error: -----8<----- A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT DISTINCT t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_sortkey AS sortkey FROM `smw_ids` AS t2 INNER JOIN `smw_inst2` AS t0 ON t2.smw_id=t0.s_id WHERE (t0.o_id='XXXX') ORDER BY t2.smw_sortkey ASC LIMIT 5000,-2999 from within function "SMW::getQueryResult". Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2999' at line 1 (localhost:PORT)". -----8<----- This error message starts at offset=2002 because the SQL LIMIT 5000,-2999 is composed in a wrong way. We would be glad to have this fixed soon. Thanks in advance. BTW the Special:Ask page works fine instead see http://www.species-id.net/o/index.php?title=Special:Ask&offset=5000&limit=50&q=%5B%5BCategory%3ADryades+Plant+Images%5D%5D&p=format%3Dlist%2Fcolumns%3D1 We are using the Semantic MediaWiki Version 1.5.5 alpha with the svn revision number r79596. Regards Anreas Plank -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- 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