[SMW-devel] #ask for category pages not working in SMW 1.9 with Store 3

2013-05-29 Thread zehetner
Hi,

in a wiki which runs
MediaWiki   1.19.1
PHP 5.4.4 (apache2handler)
MySQL   5.5.0-m2-log
Semantic MediaWiki (Version 1.8)
SMW Store 2

I get a list of the pages in category Maps when I use the query:
{{#ask: [[Category:Maps]]}}

and format=debug shows as SQL somethin like
SELECT DISTINCT t2.smw_title AS t,t2.smw_namespace AS ns FROM `smw_ids` AS
t2 INNER JOIN `smw_inst2` AS t0 ON t2.smw_id=t0.s_id WHERE
(t0.o_id='1597134') ORDER BY t2.smw_sortkey ASC LIMIT 51 OFFSET 0;

however, when I use the same data in a wiki which runs
MediaWiki   1.20.0
PHP 5.4.4 (apache2handler)
MySQL   5.5.0-m2-log
Semantic MediaWiki (Version 1.9 alpha) (c61b465)
SMW Store 3

I get no result with the same query and format=debug shows: Empty result,
no SQL query created.

However looking in Special:Categories I see in both wikis the same number
of pages.

Is this a bug, a changed behaviour or just temporarily not supported? Or
is it a local problem with Store 3?
Is there maybe any alternative syntax for the #ask query which would
simulate the old behaviour?

Thanks
Guenther

--
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with 2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
___
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel


Re: [SMW-devel] #ask for category pages not working in SMW 1.9 with Store 3

2013-05-29 Thread Jamie Thingelstad
Just to make sure, did you refresh your data after moving to SqlStore3? You 
need to do that before any data will show up.
Jamie Thingelstad
ja...@thingelstad.com
mobile: 612-810-3699
find me on AIM Twitter Facebook LinkedIn

On May 29, 2013, at 7:02 AM, zehetner zehet...@molgen.mpg.de wrote:

 Hi,
 
 in a wiki which runs
 MediaWiki 1.19.1
 PHP   5.4.4 (apache2handler)
 MySQL 5.5.0-m2-log
 Semantic MediaWiki (Version 1.8)
 SMW Store 2
 
 I get a list of the pages in category Maps when I use the query:
 {{#ask: [[Category:Maps]]}}
 
 and format=debug shows as SQL somethin like
 SELECT DISTINCT t2.smw_title AS t,t2.smw_namespace AS ns FROM `smw_ids` AS
 t2 INNER JOIN `smw_inst2` AS t0 ON t2.smw_id=t0.s_id WHERE
 (t0.o_id='1597134') ORDER BY t2.smw_sortkey ASC LIMIT 51 OFFSET 0;
 
 however, when I use the same data in a wiki which runs
 MediaWiki 1.20.0
 PHP   5.4.4 (apache2handler)
 MySQL 5.5.0-m2-log
 Semantic MediaWiki (Version 1.9 alpha) (c61b465)
 SMW Store 3
 
 I get no result with the same query and format=debug shows: Empty result,
 no SQL query created.
 
 However looking in Special:Categories I see in both wikis the same number
 of pages.
 
 Is this a bug, a changed behaviour or just temporarily not supported? Or
 is it a local problem with Store 3?
 Is there maybe any alternative syntax for the #ask query which would
 simulate the old behaviour?
 
 Thanks
 Guenther
 
 --
 Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
 Get 100% visibility into your production application - at no cost.
 Code-level diagnostics for performance bottlenecks with 2% overhead
 Download for free and get started troubleshooting in minutes.
 http://p.sf.net/sfu/appdyn_d2d_ap1
 ___
 Semediawiki-devel mailing list
 Semediawiki-devel@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

--
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with 2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1___
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel