Extension talk:Semantic Compound Queries

SMW 1.5.1.1 breaks SCQ in MW 1.13.4

SMW 1.5.1.1 does not fully opperate correctly with MW 1.13.4. The only thing that I have found breaks is Semantic Compound Queries. It works great with MW 1.14

--Dgennaro

Hi - what's the error message you get? Yaron Koren 18:20, 29 June 2010 (UTC)

It will not show the results of any part of the query except for the final query. Hard to explain. Simple example below.

{{#compound_query: [[Category:Music Events]][[Has Date::{{#calendarstartdate:}}]][[Has Date::{{#calendarenddate:}}]]
;?Has Date;color=red;limit=500
|[[Category:Corporate Meetings]][[Has Date::{{#calendarstartdate:}}]][[Has Date::{{#calendarenddate:}}]]
;?Has Date;color=blue;limit=500
|[[Category:Marketing Events]][[Has Date::{{#calendarstartdate:}}]][[Has Date::{{#calendarenddate:}}]]
;?Has Date;color=green;limit=500
|format=calendar
}}

In this example the output would only show the Marketing Events. Also, "color" do not work, but I have been using a template to get around that.

--Dgennaro

Oh. Well, I'm guessing that this will be hard to debug - I should probably just change the SCQ documentation to say that it requires version 1.14 or later of MW. Yaron Koren 22:02, 29 June 2010 (UTC)

It is not the relationship between MW 1.13.4 and SCQ...it is between MW 1.13.4 and SMW 1.5.1.1. SCQ is the only thing that I have found that breaks. When I rolled back to SMW 1.4.3 it worked fine again. So, the SMW page needs to be changed to be compatible with MW 1.14.x and newer. --Dgennaro 13:37, 30 June 2010 (UTC)

But the latest SMW, by itself, works correctly with MW 1.13, no? Yaron Koren 15:50, 30 June 2010 (UTC)

Yes, SCQ is the only thing that I have found so far that fails. --Dgennaro 15:51, 30 June 2010 (UTC)

Similar Problem to above, only final query showing

I have found a similar problem within my wiki I have the following code:

{{#compound_query:[[Category:Band]] [[Postcode::{{PAGENAME}}]]; ?Bandroom Location; icon=Tuba Small.png;
|[[Category:Venue]] [[Venue Postcode::{{PAGENAME}}]]; ?Venue Location; icon=Venue.png;
|height=600
|format=googlemaps
|types=normal,satellite,hybrid}}

All it is displaying is the final query.

I have the following setup

• MediaWiki 1.16.0
• PHP 5.2.13 (cgi)
• MySQL 4.1.22-standard-log

• Semantic Compound Queries (Version 0.2.6)
• Semantic Forms (Version 2.0.1)
• Semantic Maps (Version 0.6.6)
• Semantic MediaWiki (Version 1.5.2)
• Admin Links (Version 0.1.3)
• Header Tabs (Version 0.7)
• Hide Empty Sections (Version 1.0)
• Maps (Version 0.6.6)
• ParserFunctions (Version 1.3.0)
• FCKeditor (Version fckeditor/mw-extension $Rev$ 2008)
• Semantic Forms Input Types (Version 0.2)
• Semantic Result Formats (Version 1.5.0)
• Validator (Version 0.3.6 rc1)

Well, you only have two queries - are you sure that the first one works, by itself? And what happens if you change to a simpler format, like "table"? Yaron Koren 15:15, 30 September 2010 (UTC)

Many thanks. They both worked by themselves. But changing it to table shown me that the co-ordinates weren't showing up for one of them and it pushed me in the right direction. Thanks again Yaron !!

Undefined Property

Notice: Undefined property: SMWQueryResult::$display_options in /var/www/pcwiki/extensions/SemanticCompoundQueries/SCQ_QueryResult.php on line 27 any clue why this would be outputting like this? --Willjermuk 20:12, 10 September 2010 (UTC)

Cannot count pages with specific values

Hi, I want to count the associated pages where a specific value is set and show them in a piechart. In detail:

{{#vardefine:gruen| [[aktueller Status::Grün]] [[-Hat Teil::{{SUBJECTPAGENAME}}]] 
; mainlabel=Teile
; ?Aktueller Status
; format=count
;}} 

{{#vardefine:gelb| [[aktueller Status::Gelb]] [[-Hat Teil::{{SUBJECTPAGENAME}}]] 
; mainlabel=Teile
; ?Aktueller Status
; format=count
;}} 

{{#vardefine:rot| [[aktueller Status::Rot]] [[-Hat Teil::{{SUBJECTPAGENAME}}]] 
; mainlabel=Teile
; ?Aktueller Status
; format=count
;}} 

{{#compound_query:{{#var:rot}} | {{#var:gelb}} | {{#var:gruen}} | format=table}}

And the following error occurs:

Warning: Attempt to assign property of non-object in C:\<wikipath>\mediawiki\extensions\SemanticCompoundQueries\SCQ_QueryProcessor.php on line 131

Warning: Attempt to assign property of non-object in C:\<wikipath>\mediawiki\extensions\SemanticCompoundQueries\SCQ_QueryProcessor.php on line 131

Fatal error: Call to a member function getPrintRequests() on a non-object in C:\<wikipath>\mediawiki\extensions\SemanticCompoundQueries\SCQ_QueryProcessor.php on line 62

BTW: without the parser-functions #var and #vardefine in an all-in-one-query it doesn't work, too. Each single one of the 3 queries work fine! But I want the result in only one table or pie-chart... Hmm, or is there any other possibility to run such a query?!

Semantic Compound Queries with timeline

Hi, (first of all, sorry for my english) Can I use a a timeline as format of a query?

I can make an #ask query only for a category, but I like to print in a single timeline all the events which are related to different categories.

Something like this:

{{#compound_query: [[RiguardaProgettoCantiere::{{PAGENAME}}]] ; ?HaDataInizioCantiere ; ?HaFineCantiere   
|  [[HaOggettorifFonte::{{PAGENAME}}]]; ?HaDataFonte
| format=timeline}}

--Feedmyego 18:42, 18 November 2010 (UTC)

Hi - I think that should work, but I've never tried it with timeline, so I don't know for sure. Feel free to try it out. Yaron Koren 21:34, 18 November 2010 (UTC)

It doesn't work, but i'm not a master in mediawiki coding, so I don't know if it's a SRF problem, or an error in my query. If anyone succeeds, let me know :) --Feedmyego 16:48, 21 November 2010 (UTC)

Problem with more than one compound query

When I create more than one compound query on a page, the maps stops working

http://www.wikirio.com.br/Sandbox:Ipanema

Right now there's only one, to show that works ok. But stops if you duplicate:

{{#compound_query: Categoria:Restaurantes Bairro::Ipanema; ?LatLong;

   | format=googlemaps
   | height=250
   | width=100%
   | autozoom=off

}}

Hi, I don't understand - where's an example of a compound query that's not working? Yaron Koren 15:40, 2 March 2011 (UTC)

Hi Yaron, http://www.wikirio.com.br/Sandbox:Ipanema

It works fine if I use compound_query only once on the artile.

Okay, I see the problem - I'm guessing that this is an issue with Semantic Maps. Yaron Koren 18:50, 2 March 2011 (UTC)

incomplet result w/ [SCQ] in comparison to regular #ask ?

hi i have this query compared to each other with two different result. the compound query has less result compared to the the regular ask syntax query. Even after a property updates the result still unchanged

{{#compound_query:[[Category:WO]][[WO status::closed]];?WO due date
|format=table
|limit=1000
}}

VS

{{#ask:[[Category:WO]][[WO status::closed]]|?WO due date
|format=table
|limit=1000
}}

any thoughts?

--Msevero 09:04, 31 March 2011 (UTC)

No idea. Yaron Koren 12:05, 31 March 2011 (UTC)

thanks for the reply, --Msevero 23:00, 1 April 2011 (UTC)

Searchlabel

I just noticed that the combination "limit=0" and "searchlabel=foo", as used sometimes in regular inline queries, does not work in SCQ. I think that would be worth considering as an option in future releases. Cavila 11:43, 19 May 2011 (UTC)

sorting of result format broadtable

Hi, is it possible to sort the queried results somehow? So far it shows the results are printed in ascending order but to have this in a descending order would be cool too. The regular printout statements do not seem to work.

| headers=show
| format=broadtable
| sort=property name
| order=descending

Hmm ... Cheers --[[kgh]] 13:56, 15 August 2011 (UTC)

sql error after update

i have updated semantic compound queries from 0.2.7 to 0.2.8 and my query crashed. {{#compound_query: Kategoria:Wydarzenia; [[Rozpoczęcie::>{{#calendarstartdate:}}]]; [[Rozpoczęcie::<{{#calendarenddate:}}]]; ? Rozpoczęcie; color=#dd0000; limit=1500 |format=calendar}}

error: SMWSQLStore2::getSMWPageIDandSort”. database error „1054: Unknown column 'smw_subobject' in 'where clause' (localhost)”.

What version of SMW are you using? Yaron Koren 15:11, 17 August 2011 (UTC)

smw 1.6, semantic result formats 1.6, validator 0.4.9

Ah - you should comment out the other SMW-based extensions in LocalSettings.php (other than SMW), then go to Special:SMWAdmin and click the "initialise/upgrade DB" button, then uncomment the extensions. Yaron Koren 16:28, 18 August 2011 (UTC)

works now,thank you

v0.2.10

Heiya, there may I download the new version? Cheers --[[kgh]] 18:06, 4 October 2011 (UTC)

I actually wanted to skip to the next version, since 0.2.10 had problems with the latest SMW. Thanks for the reminder - I just released the latest version, 0.3, where hopefully all the problems are fixed. Yaron Koren 19:41, 4 October 2011 (UTC)

Ah, I see. I just stumbled over this for another reason. The new version makes me curious regarding the sorting issue I discovered. This one sounds like a fix for it which should be very cool then. Cheers --[[kgh]] 19:48, 4 October 2011 (UTC)

Error

http://www.wikirio.com.br/Sandbox:Ipanema2

I get: Fatal error: Cannot call method self::compareQueryResults() or method does not exist in /home/wikirio/public_html/extensions/SemanticCompoundQueries/SCQ_QueryProcessor.php on line 77 I had to return to the previous version

I was updating to see if the new version is fixing this old issue. The compound queries doesnt work when you select 2 in the same page:

http://www.wikirio.com.br/Sandbox:Ipanema2

Edgard

Hi - this might be an issue due to your PHP version. Could you try restoring SCQ back to the newest version, then changing line 77 from

                uasort( $results, 'self::compareQueryResults' );

to

                uasort( $results, array( 'SCQQueryProcessor', 'compareQueryResults' ) );

...and see if that fixes it? Yaron Koren 18:56, 13 November 2011 (UTC)

Yaron, works fine now. Thanks! Do you know what might be the issue I have when I use two Coumpound Queries on the same page? Regards, Edgard

Cool. I don't know - it looks like the issue is coming from Semantic Maps. Yaron Koren 20:21, 13 November 2011 (UTC)

Awn... Works fine when I use ASK two times. Doesnt work only for Compound Query :(

Yeah, but what if you use two non-map compound queries? Yaron Koren 20:44, 13 November 2011 (UTC)

Did you guys ever get to the bottom of the error message above? I have working SMW/SM maps all over my site and downloaded 0.3 to try and get maps with different icons. Trying to recreate a (working) #ask function as a compound gave the same exception as the above. Any clues as to what I can check? I am pretty happy that all my ordinary #ask queries are fine. Thanks - and kudos for some great tools, Tim D

BTW the fix above instantly fixed the issue for me - but are there any side effects of the edit to that code? - Tim D

Cool - no, I doubt there are any side effects to it; it's just syntax that seems to work across more versions of PHP. Yaron Koren 20:20, 28 November 2011 (UTC)