Re: [SMW-devel] #ask for category pages not working in SMW 1.9 with Store 3
Yes I did refresh and other values are returned by ask queries but it seem the majority of data haven't reached store 3 yet and I forgot that SMW doesn't use the MW info for categories but it's own. Will take much, much longer to finish the SMWUpdate jobs. Thanks. On Wed, 29 May 2013 08:01:53 -0500, Jamie Thingelstad ja...@thingelstad.com wrote: 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 MediaWiki1.19.1 PHP 5.4.4 (apache2handler) MySQL5.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 MediaWiki1.20.0 PHP 5.4.4 (apache2handler) MySQL5.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
Re: [SMW-devel] #ask for category pages not working in SMW 1.9 with Store 3
Yes, that is true. SMW uses a pre-defined property to represent categorical relations. On Thu, May 30, 2013 at 11:58 AM, zehetner zehet...@molgen.mpg.de wrote: Yes I did refresh and other values are returned by ask queries but it seem the majority of data haven't reached store 3 yet and I forgot that SMW doesn't use the MW info for categories but it's own. Will take much, much longer to finish the SMWUpdate jobs. Thanks. On Wed, 29 May 2013 08:01:53 -0500, Jamie Thingelstad ja...@thingelstad.com wrote: 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 MediaWiki1.19.1 PHP 5.4.4 (apache2handler) MySQL5.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 MediaWiki1.20.0 PHP 5.4.4 (apache2handler) MySQL5.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 -- Cheers, Nischay Nahata nischayn22.wordpress.com -- 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
[SMW-devel] #ask for category pages not working in SMW 1.9 with Store 3
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
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