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
