[08:24:31] New review: Kghbln; "Well of course patchwork messages should be avoided if possible and useful. I guess it depends on th..." [mediawiki/extensions/SemanticMediaWiki] (master) C: 1; - https://gerrit.wikimedia.org/r/69330 [14:02:19] New review: Nischayn22; "Okay. This already needs some more work, specifically in the UI part." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69306 [14:11:05] Milossh: what's going on? [14:17:15] New patchset: Jeroen De Dauw; "Allow fail on php 5.5 build" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69490 [14:24:50] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69490 [14:31:53] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#14 (master - 04c7ddc : jeroendedauw): The build passed. [14:31:53] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/c462eb4870eb...04c7ddcb253c [14:31:53] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/8239324 [14:43:07] Okay, one last attempt to troubleshoot before i duct tape the hell out of this and call it a day. Is anyone here familiar with querying via SMW API module? Like, really familiar? [14:48:31] Talk about being persistent. [14:49:11] Ulfr_: I am [14:49:15] what you looking to do? [14:49:39] thingles: You ready for a mind grenade? [14:49:49] :-) [14:49:57] thingles: I've got an AJAX query running against the smw Ask API [14:50:44] uh huh [14:50:46] It's querying based on Exam Type, Main Category, and Sub Category. The last two are supposed to be n length [14:50:56] and it works perfectly with exam type one [14:51:09] can you paste your query url? [14:51:14] But exam types two and three just return empty sets, unless I only ask for one Main Category [14:51:14] Sure [14:52:07] thingles: http://pastebin.com/uN9VaKYm [14:52:18] thingles: When I run it through Special:Ask it executes perfectly as well [14:53:17] is the api public? can I execute the request? [14:53:52] thingles: Uh. Maybe? You've got to be authenticated for certain parts but it's worth a shot [14:54:00] thingles: http://www.wikidoc.org/api.php [14:54:46] thingles: I can tell you right now if you copy/paste it it will work perfectly [14:55:04] this will sound odd... but I've found extra spaces in the Ask API cause problems [14:55:33] I will blow a head gasket if this is being caused by white space [14:55:37] related: is this http://wikiapiary.com/wiki/Wikidoc_(en) this site? [14:55:58] I would remove all the psaces between the pipes and VERY importantly between the ]] [[ [14:56:20] I have had queries not work for "[[a]] [[b]]" but work for "[[a]][[b]]" [14:56:41] suggestion: when you build your query use an array join to make it still readable. That is what I do. [14:58:01] thingles: All of this is already jibberish, but I'll give it a shot :) [14:58:27] thingles: Uh, no idea. Is that where I report semantic stuff to when I announce? [14:59:22] thingles: No dice. Still exhibiting odd behavior [14:59:35] Ulfr_: actually, WikiApiary has your wiki already http://wikiapiary.com/wiki/Wikidoc.org [14:59:44] can you see the raw API call that is being made? [14:59:46] what is the URL? [15:00:08] thingles: One moment [15:00:19] the call to api.php?action=ask .... [15:00:43] thingles: http://wikidoc.org/api.php?action=ask&format=json&query=%5B%5BExamType%3A%3AUSMLE+Step+2+CK%5D%5D%5B%5BMainCategory%3A%3AInternal+medicine%26%23124%3B%26%23124%3BSurgery%26%23124%3B%26%23124%3BOB%2FGYN%26%23124%3B%26%23124%3BPediatrics%26%23124%3B%26%23124%3BPsychiatry%5D%5D%5B%5BSubCategory%3A%3AAllergy%2FImmunology%26%23124%3B%26%23124%3BCardiovascular%26%23124%3B%26%23124%3BDermatology%26%23124%3B%26%23124%3BE [15:01:47] It gets trimmed, I'll pastebin [15:01:48] thingles: ^ [15:01:57] ok [15:02:41] thingles: http://pastebin.com/ZkFzxL4q [15:03:46] thingles: That one returns empty set. This one works fine: http://pastebin.com/hVar0zRk [15:07:09] do you have any working queries through your API? [15:07:24] also, you have no print requests in that query [15:07:42] thingles: Yuh. In which? i'm not trying to print anything, I just want to count the results [15:07:50] you can't do that [15:08:06] thingles: But it works fine for one exam type and in Special:Ask [15:08:12] the ask interface just returns the records [15:08:24] That's all I need, i'm counting the records [15:08:26] I don't need anything printed [15:08:31] MWJames added a fix per a bug I filed to add count in SMW 1.9 [15:08:43] if you pugrade to 1.9a you should be able to do it [15:09:07] https://bugzilla.wikimedia.org/show_bug.cgi?id=46458 [15:09:16] thingles: So how much of my stuff is going to break if I upgrade? [15:09:55] according to this http://wikiapiary.com/wiki/Wikidoc.org#tab=Extensions your on 1.7 [15:09:59] 1.7.1 [15:10:21] if your depending on SMW, you need to move to 1.8 and SqlStore3 at some point.. sooner the better [15:10:31] in the meantime... your count issue is hard to address [15:10:55] Tell me about it. Okay, I'm just really leary about upgrading things that are in production [15:10:55] one hacky solution is to put the ask query and the format count in a wiki page and query that using the render action [15:11:32] Ulfr_: if you see what I do here http://wikiapiary.com/wiki/WikiApiary:SMWExtInfo [15:11:41] that is one workaround to still be able to query things like this [15:11:43] but it's hacky [15:12:05] you could make a page like that that you call back to with your AJAX call [15:12:09] * thingles shrug [15:12:20] but, you def cant count via API without 1.9a [15:12:33] thingles: Naw, I'm trying to do all of this above board. I'm not using the API to count, I'm counting with jQuery [15:12:59] well, you would have to since the API will only return an array of results. [15:13:02] I'm trying to get the API to execute a properly formatted query that works only in arbitrary circumstances [15:13:31] I can't get the API to respond to even a simple query on your site: http://wikidoc.org/api.php?action=ask&format=json&query=%5B%5BExamType%3A%3AUSMLE%2BStep%2B1%5D%5D%7C%3FExamType [15:14:23] okay, there is one that works: http://wikidoc.org/api.php?action=ask&format=json&query=%5B%5BExamType%3A%3A%2B%5D%5D%7C%3FExamType [15:14:42] thingles: The dataset that programs operating off of is extremely incomplete [15:15:00] thingles: Here's the function being called, maybe this will clarify stuff. I'm going to upgrade very soon and see if that helps [15:15:00] http://pastebin.com/Wzdf0uwk [15:15:03] heh [15:15:16] Okay, here is osmething, this works: http://wikidoc.org/api.php?action=ask&format=json&query=%5B%5BExamType%3A%3AUSMLE_Step_1%5D%5D%7C%3FExamType [15:16:44] thingles: btw, not sure if you saw or not but this whole call works swimmingly [15:16:44] This one works fine: http://pastebin.com/hVar0zRk [15:17:44] dunno... I think you have some encoding problem in there [15:17:50] that is likely triggering some bug in an older SMW [15:18:00] I changed + to _ and then the query worked for my simple test [15:18:16] ... [15:18:24] One sec. [15:22:36] thingles: Yeah, just going to upgrade I think. Thank you very much for your time! [15:23:06] sorry couldn't provide simple fix [15:23:25] thingles: *shrug* I wouldn't even care if this wasn't so insanely arbitrary [15:23:32] thingles: How angry will this update make my database? [15:23:47] thingles: I can look up the changelog if you don't know off the top of your head [15:24:02] you need ot manage your migration to SqlStore3 [15:24:05] which you should do [15:24:12] but you have to rebuild SMW data [15:24:21] you can run 1.8 in SqlStore2 mode if you wish [15:24:32] but 1.9 only works with SqlStore3... so you'll want to do it... [15:24:33] I did that last week, took me about a week and a half [15:24:34] it wasn't bad for me [15:25:12] you can pareallelize SMW_rebuild by running multiple copies [15:25:12] thingles: The problem I have is my site's hosted on a cluster with a database that's in a master/slave config, so if there's huge changes everything just starts to suck [15:25:18] you'll need to be careful then. :-) [15:25:41] thingles: Oh, yeah. Tell me about it. DDoS attacks always just wait for me to do something like this on production [15:26:15] normal traffic's about 400k hits a day, as soon as I run a db heavy update it spikes and I get that many in an hour ;; [15:27:34] thingles: is SqlStore3 supported in 1.7? [15:28:07] no [15:34:11] Thanks man :) [19:29:29] New patchset: Mwjames; "Travis + sqlite + PHP 5.4" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69525 [19:30:03] Change merged: Mwjames; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69525 [19:52:52] New patchset: Mwjames; "i18n and patchwork messages !!!" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69330 [19:53:47] New review: Mwjames; "Thanks Karsten for the swift and responsive review." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69330 [19:56:49] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69330 [19:57:49] New patchset: Mwjames; "Replace is_array/is_string with a more performant approach" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/68944 [20:02:40] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/68944 [20:18:43] New patchset: Mwjames; "(Bug 33181) Special:Concepts to list available concepts" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/67396 [20:21:05] New review: Mwjames; "Karsten, doing {{PLURAL:$1|concept|$1 concepts}} now as proposed." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/67396 [20:24:40] New review: Mwjames; "Going to merge this now (rebase drives me nuts) and surely the mediawiki "God" will crucify me for t..." [mediawiki/extensions/SemanticMediaWiki] (master) C: 2; - https://gerrit.wikimedia.org/r/67396 [20:26:08] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/67396 [20:48:02] New patchset: Mwjames; "Travis WikiPage::doEditContent" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69582 [20:48:41] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#19 (master - 0a19c89 : Translation updater bot): The build was fixed. [20:48:41] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/a949f04e5ee6...0a19c892243a [20:48:41] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/8253325 [20:54:25] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69582 [20:58:53] New patchset: Mwjames; "SMW\Profiler encapsulates MediaWiki's (wfProfileIn/wfProfileOut)" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69292 [21:21:39] Change abandoned: Mwjames; "(no reason)" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/65006 [21:26:00] New patchset: Mwjames; "SMW\Profiler encapsulates MediaWiki's (wfProfileIn/wfProfileOut)" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69292 [21:30:57] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69292 [22:39:03] New patchset: Mwjames; "SMWDIProperty class alias" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69598 [22:43:19] Change merged: jenkins-bot; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69598 [23:25:18] New patchset: Mwjames; "SMW\SQLStore\WantedPropertiesCollector" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/66052