[00:23:38] New patchset: Mwjames; "SRF add common library and re-use functions" [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15696 [00:27:49] New patchset: Mwjames; "SRF add common library and re-use functions" [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15696 [00:41:53] during php runJobs.php I get ... from within function "SMW::updateDatasmw_spec2". Database returned error "1054: Unknown column 'o_id' in 'field list' (my.dbhost.com)" [02:36:05] Running from a fresh git clone, I'm getting 2 probably related problems. runJobs dies with [02:36:25] A database query syntax error has occurred. The last attempted database query was: "INSERT INTO `dna1_smw_spec2` (s_id,p_id,o_id) VALUES ('71','20','16122')" from within function "SMW::updateDatasmw_spec2". Database returned error "1054: Unknown column 'o_id' in 'field list' [02:36:57] while runJobs, and many other operation throw these warning into the log [02:37:10] PHP Notice: Constant SMW_SQL2_SMWIW_OUTDATED already defined in /var/www/html/extensions/SemanticMediaWiki/includes/storage/compatSQLStore/SMW_SQLStore2.php on line 14 [02:37:43] as well as for SMW_SQL2_SMWREDIIW, and 4 other similar variables all defined at the same location [02:38:53] however I now see a 1_19 branch in the git repo [02:39:01] and imagine switching to that may help [02:39:09] still getting used to git [07:56:53] New patchset: Nischayn22; "Fixed tables for special properties" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15699 [08:05:35] New patchset: Nischayn22; "Cleanup" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15700 [10:20:56] New patchset: Nischayn22; "removing objectfields from Storetable object" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15703 [10:56:46] hello [10:57:22] I need some help implementing some form of property arrays [10:57:55] does anybody know if that's possible? [11:07:07] zet_013: property arrays? [11:27:08] uhm, yes, if they exist [11:28:04] the idea is to create project pages and on each project page to have a number of tasks (with various properties for each task) [11:28:20] I've seen SMW+ does one page per task but that's not ok for us [11:28:49] and I'm trying to handle the tasks on a project page with some kind of array if possible [11:29:13] I've just set the same property, projecttask with various values on the same page and that seems to create a set [11:29:28] but I can't seem to be able to query that set properly [13:07:01] New review: Markus Kroetzsch; "Just a very small suggestion to simplify the code. The rest is looking good." [mediawiki/extensions/SemanticMediaWiki] (master); V: 0 C: -1; - https://gerrit.wikimedia.org/r/15703 [13:24:28] New review: Markus Kroetzsch; "Something seems to be broken in SQLStore3, see first comment there." [mediawiki/extensions/SemanticMediaWiki] (master); V: 0 C: -1; - https://gerrit.wikimedia.org/r/15699 [13:32:15] New patchset: Nischayn22; "removing objectfields from Storetable object" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15703 [13:35:18] New patchset: Mwjames; "SRF add common library and re-use functions" [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15696 [14:01:46] New patchset: Mwjames; "SRF add common library and re-use functions" [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15696 [14:44:56] Change merged: Markus Kroetzsch; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15703 [14:45:29] Change merged: Markus Kroetzsch; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15700 [14:51:30] Change merged: Markus Kroetzsch; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15699 [16:24:11] New review: Jeroen De Dauw; "Some minor remarks, but nothing blocking" [mediawiki/extensions/SemanticResultFormats] (master); V: 1 C: 2; - https://gerrit.wikimedia.org/r/15696 [16:24:13] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15696 [16:32:03] nischayn22|Afk: heh - how did you rage Markus into that CR? :P [17:25:42] New patchset: Nischayn22; "sanity for getPropertiesSpecial" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15721 [17:35:35] nischayn22|Afk: great commit message :D [17:36:22] JeroenDeDauw: learning from MW guys :) [17:37:34] JeroenDeDauw: I think today Markus is really into merging stuff [17:38:25] nischayn22: yeah [17:38:59] nischayn22: he's the developer with occasional winter sleep - most of the time is idle but then wakes up and does a lot of stuff [17:40:11] JeroenDeDauw: Now I feel like the storerewrite is mostly done, except some optimization in the db fields [17:40:33] nischayn22: I guess so yes :) [17:41:38] JeroenDeDauw: I am still overwhelmed by the SMW code he has written :) [17:41:56] nischayn22: lots of other performance stuff to be done still tho [17:42:00] nischayn22: how so? [17:42:00] ok so gerrit-wm doesn't alert of comments [17:42:06] huh [17:42:08] yeah [17:42:21] Only does if you actually +1/-1 [17:42:22] JeroenDeDauw: uri is still not stored efficiently [17:45:09] nischayn22: I don't know about that stuff [17:45:28] JeroenDeDauw: those things are now very easy to modify [17:45:52] JeroenDeDauw: just modify the specific handler file [17:46:32] nischayn22: are you referring to this stuff? http://semantic-mediawiki.org/wiki/Help:Special_property_Equivalent_URI [17:46:32] I did not know we had that actually :d [17:47:26] JeroenDeDauw: no, I meant storing general URI DI objects [17:49:04] JeroenDeDauw: Hey did you look at that bug I had assigned for you? [17:49:15] regarding param formats [17:51:47] nischayn22: don't think so - can you link? [17:52:25] bug 37780 [17:52:32] !bug 37780 [17:52:51] damn how does this bot work [17:54:50] JeroenDeDauw: some help with the bug bot ? [17:57:26] @commands [17:57:26] Commands: channellist, trusted, trustadd, trustdel, info, configure, infobot-link, infobot-share-trust+, infobot-share-trust-, infobot-share-off, infobot-share-on, infobot-off, refresh, infobot-on, drop, whoami, add, reload, suppress-off, suppress-on, help, RC-, recentchanges-on, language, infobot-ignore+, infobot-ignore-, recentchanges-off, logon, logoff, recentchanges-, recentchanges+, RC+ [17:57:35] @info [17:57:35] http://bots.wmflabs.org/~wm-bot/dump/%23semantic-mediawiki.htm [17:57:58] !bug is https://bugzilla.wikimedia.org/show_bug.cgi?id=$1 [17:57:58] Key was added [17:58:05] !bug 37780 [17:58:05] https://bugzilla.wikimedia.org/show_bug.cgi?id=37780 [18:01:36] New patchset: Jeroen De Dauw; "Handling code expects an array, so use empty array rather then null" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15724 [18:02:45] nischayn22: you're taking up all the space now! https://github.com/JeroenDeDauw/SemanticMediaWiki/graphs/impact [18:04:14] JeroenDeDauw: I reused so much code :D [18:06:41] Yeah... [18:08:55] JeroenDeDauw: there is a problem:P [18:09:19] JeroenDeDauw: people are using smw's master branch without doing a setup and getting errors [18:20:41] New patchset: Nischayn22; "changingDefaultStoreBackToStore2" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15725 [18:25:10] nischayn22: yeah well, that's their problem [18:25:17] nischayn22: you have that for all extensions [18:25:29] nischayn22: if you run master, and you update, you might also need to run the updating script [18:25:45] JeroenDeDauw: how does phpunit test SpecialStatistics ? [18:28:30] Change merged: Markus Kroetzsch; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15725 [18:28:59] nischayn22: how? [18:29:23] !bug 38423 | JeroenDeDauw [18:29:23] JeroenDeDauw: https://bugzilla.wikimedia.org/show_bug.cgi?id=38423 [18:30:49] nischayn22: https://gerrit.wikimedia.org/r/#/c/15676/ [18:31:58] JeroenDeDauw: ok, that is clever [18:42:12] nischayn22: https://gerrit.wikimedia.org/r/#/c/15724/ [18:42:14] JeroenDeDauw: you wanted me to use $db->Select() right? you later gave suggestions about $db->query [18:42:55] nischayn22: ->select yes [18:46:23] JeroenDeDauw: then how to limit result? [18:47:22] New review: Nischayn22; "this doesn't fix the bug " [mediawiki/extensions/SemanticMediaWiki] (master) C: -1; - https://gerrit.wikimedia.org/r/15724 [18:49:02] nischayn22: use the $options param [18:49:41] You can pass it stuff such as [18:49:41] array( [18:49:42] 'LIMIT' => 42, [18:49:42] 'ORDER BY spam ASC' [18:49:42] ) [18:52:44] JeroenDeDauw: The bug reporter sent me a private mail :P [18:53:05] He doesn't know about stack traces unfortunately [18:53:59] nischayn22: ?? [19:19:00] New patchset: Nischayn22; "sanity for getPropertiesSpecial" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15721 [19:39:33] New patchset: Nischayn22; "Fixes the bug 38423" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15735 [19:44:12] New review: Markus Kroetzsch; "Looks good in general, but I wonder if we could completely fix the sorting in some way. As it curren..." [mediawiki/extensions/SemanticMediaWiki] (master); V: 0 C: 0; - https://gerrit.wikimedia.org/r/15721 [19:44:20] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15735 [19:51:04] New review: Nischayn22; "Yes, the result doesn't look nice. we should sort by the labels, but then this would happen in PHP a..." [mediawiki/extensions/SemanticMediaWiki] (master) C: 0; - https://gerrit.wikimedia.org/r/15721 [20:16:47] New patchset: Nischayn22; "Handling code expects an array, so use empty array rather then null" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/15724 [20:18:22] JeroenDeDauw: there's nobody to test that bug I guess [20:19:11] JeroenDeDauw: Okay, jan looks keen on testing it [22:33:50] stupid question, how do I get the values in this broadtable that aren't linked, linked, (eg, click on the value for Country to get all pages with that Country value): [22:33:59] http://wiki.creativecommons.org/User:Greg_Grossmeier/Sandbox [23:37:36] greg-g - change the "Country" property from type String to type Page. [23:38:55] Yaron: is it that simple? that won't destroy anything else? :) [23:39:19] No, your wiki is safe. :) [23:39:31] btw, really wanted to meet up at wikimania, but time got away from me :) [23:40:47] Oh - were you there? [23:41:43] yeah, presented on Thursday [23:41:55] 3 CC people were actually there [23:42:03] Oh. [23:42:47] Yeah, it was kind of a madhouse - lots of people all the time. [23:44:26] definitely. [23:44:52] Well, I'm off - talk to you later. [23:45:04] New patchset: Mwjames; "Fix timeline path after re-naming" [mediawiki/extensions/SemanticResultFormats] (master) - https://gerrit.wikimedia.org/r/15750