[01:05:05] (CR) Yaron Koren: "Thank you for looking into this. It appears that I set the wrong tag for SMW in the "externals" file - 1.9.1.1 instead of 1.9.2. If I chan" [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129058 (owner: Yaron Koren) [01:15:14] Hi all, I'm looking to upgrade to SMW 1.9 from 1.8.0.5 to 1.9 soon but first I'll be upgrading MW 1.20.8 to 1.22.5. However, I have 4 load-balanced web servers hosting 4 separate wikis that use SMW so I'm not sure how to adapt the upgrade procedure to that design. [01:16:08] Is there any documentation that I must be missing about how to upgrade under that kind of design? [01:17:27] FWIW, I've never used Composer. [03:12:25] [SemanticExtraSpecialProperties] mwjames pushed 1 new commit to master: http://git.io/egS45g [03:12:25] SemanticExtraSpecialProperties/master c57b30d Translation updater bot: Update i18n shim... [03:37:03] [SemanticMediaWiki] mwjames created property-registry (+1 new commit): http://git.io/9HsvwA [03:37:03] SemanticMediaWiki/property-registry 17c544b mwjames: [WIP] Introduce PropertyRegistry / ease scope creep... [03:38:58] [SemanticMediaWiki] mwjames opened pull request #284: [WIP] Introduce PropertyRegistry / ease scope creep (master...property-registry) http://git.io/POEJpw [03:45:04] [SemanticExtraSpecialProperties] mwjames pushed 1 new commit to master: http://git.io/OB5jrA [03:45:05] SemanticExtraSpecialProperties/master 0c57dcb mwjames: Release 1.2.0 [11:45:24] Hello o/ I've got the _cdat and i wanted to query all the the pages that have been created the last 7 days [11:45:33] How should I proceed to do this easily ? [13:08:54] (PS1) Nikerabbit: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 [13:12:07] (PS2) Nikerabbit: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 [13:12:42] (PS3) Nikerabbit: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 [14:04:14] (PS4) Nikerabbit: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 [14:27:55] hello there:) [14:28:19] any ideas how I can pass input from a form fied into #set function? [14:29:08] Hello Yaron [14:29:15] Hi! [14:29:17] you helped me once :) [14:29:35] and i again need help :D [14:29:59] Alright... [14:30:30] im trying to pass input values from a form field into #set function as a property value [14:31:02] Sure - that's the standard thing to do. [14:35:39] (CR) Yaron Koren: "nikerabbit - these changes look great! Is this ready to be merged yet, or are you still working on it?" [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 (owner: Nikerabbit) [14:37:19] Yaron: let me self-review it quickly [14:40:38] (PS5) Nikerabbit: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 [14:41:07] Yaron: PS5 is ready [14:41:20] Is this "the one"? [14:41:31] Yaron: what do you refer to with "the one"? [14:41:43] The final version, that should be merged. [14:41:45] The Ultimate Patch Fixing All Bugs once and Forever [14:41:48] Yes! [14:41:49] ah [14:41:55] yes [14:42:41] I guess I still have to wait for "the ultimate patch", then. :) [14:47:50] (CR) Yaron Koren: [C: 2 V: 1] "These changes look good - thanks for the general cleanup!" [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 (owner: Nikerabbit) [14:47:52] (Merged) jenkins-bot: Fix broken forms at tieteentermipankki.fi [extensions/SemanticForms] - https://gerrit.wikimedia.org/r/129165 (owner: Nikerabbit) [15:21:51] Hello o/ I've got the _cdat and i wanted to query all the the pages that have been created the last 7 days [15:21:51] How should I proceed to do this easily ? [15:26:19] (PS1) Yaron Koren: Changed SMW and SESP versions, removed ST (currently doesn't work with SMW 1.9) [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 [15:28:06] maijin: you need to use some of these to generate the date of a week ago: https://www.mediawiki.org/wiki/Help:Magic_words#Date_and_time [15:29:28] Oh, actually, I'm not sure how to get one week ago - there's #expr, which will let you reduce the day of the month by 7, but that won't work if it's the 7th of the month or earlier. [15:30:06] maijin: never mind, this is what you want: https://www.mediawiki.org/wiki/Help:Extension:ParserFunctions#.23time [15:35:43] mmh [15:35:57] maybe using the current Week-1 [15:36:03] or just Week [15:37:09] Yaron: bt [15:37:16] but how do you use that :O [15:37:45] I've got my ask :[[Type::I]] [[_CDAT::]] [15:38:11] You need something like "{{#ask:[[Creation date::>{{#time:...1 week ago...}}]]}}". [15:41:19] but just {{#time:Y}} doesn't print anything [15:41:51] Ah ok extension [15:52:23] Yaron: perfect [15:52:30] this is just so easy with this extension [15:55:58] Yaron: I know how to perform an AND query [[]] [[]] and what about a or ? like [[]] [[]] OR [[]] [[]] ? [15:56:30] is it just OR? [15:57:17] nop it doesn't work [15:59:43] my bad it works [16:07:01] maijin: see here: http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Unions_of_query_results:_disjunctions [16:10:30] Yaron: yep I suceed [16:10:31] *c [16:10:38] Yaron: thank you very much :D [16:10:47] Cool, you're welcome. [16:28:45] (CR) Mwjames: Changed SMW and SESP versions, removed ST (currently doesn't work with SMW 1.9) (1 comment) [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 (owner: Yaron Koren) [16:35:59] Yaron: Another question. I've got a property on my Category which is a string that can take several value let's say aaa,bbb,ccc. I wanted to do a small array which would do something like : In all these category there is aaa : 3, bbb : 5, ccc :5 [16:36:32] A naive way would be to create an array and do a ask for each cell [16:38:01] If there are only three, I would just make separate template/form fields for aaa, bbb, ccc. [16:38:12] No need for a property to hold that string. [16:38:34] No it can take more [16:38:43] something like 10 values [16:40:38] ah maybe it's not clear [16:40:53] it's ONE property [16:40:58] which have different value [16:41:25] And i want to show a small array that count : ok there is 10 document with the value set to aaa [16:41:33] 5 document with the value set to bbb [16:42:38] (CR) Mwjames: Changed SMW and SESP versions, removed ST (currently doesn't work with SMW 1.9) (1 comment) [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 (owner: Yaron Koren) [16:43:19] Well, it doesn't have to be one property. [16:43:36] But if you want to do it that way, you shoud use subobjects, or the Semantic Internal Objects extension. [16:44:03] Hum maybe it's not clear x) [16:44:22] i just want to do a simple count [16:46:08] Yaron: http://piratepad.net/4pXj2dimOJ [16:46:25] here is a quick pad [16:46:49] maybe more clear? [16:49:31] maijin: oh... now I get it. [16:49:41] :) [16:49:59] Pictionnary :D [16:50:50] Well, you can do a chart of the distribution, if you do "format=jqplotchart|distribution=on", or something like that. [16:51:05] For the chart ok I've done that [16:51:21] Unfortunately, the "table" result format doesn't support "distribution=on". Hopefully it will at some point. [16:51:28] oki [16:51:38] so i need to do a small hack so [16:51:59] Creating the array and putting the ASK with the different value [16:52:02] in all the cell [16:52:09] it would do the trick [17:03:48] ok it works [17:39:31] (PS2) Yaron Koren: Updated versions for SMW, SESP etc., removed ST (currently doesn't work w/ SMW 1.9) [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 [17:42:16] (PS3) Yaron Koren: Updated versions for SMW, SESP etc., removed ST (currently doesn't work w/ SMW 1.9) [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 [17:44:11] (CR) Yaron Koren: "Mwjames - thanks for all the notes; hopefully the set of version numbers looks better now." [extensions/SemanticBundle] - https://gerrit.wikimedia.org/r/129190 (owner: Yaron Koren) [18:44:03] hi guys, i need help. in the 2nd episode of fargo, a guy says to a deaf man LEPTON. what does it mean? [18:53:37] pipposs left before we could answer... [22:16:43] Hi there, I'm looking for SMW upgrade advice when upgrading four wikis each load balanced across four servers? We currently run SMW 1.8.0.5 on MW 1.20.8 but will be upgrading to MW 1.22.6 and SMW 1.9.0.latest. I've never used Composer. [22:24:08] jcl: do all the wikis use the same code base? [22:24:56] they use the same version but different copies, which is a pain. i have 5 wikis total (only 4 of which use smw though) across 4 servers, so 20 copies of the MW code. [22:27:55] i thought i recognized your name...i have your book. :) [22:32:51] jcl: oh, great! [22:33:03] Wow... 20 copies of the code... man. [22:33:47] yeah, it's painful. i'd like to either manage all of that with puppet and/or simplify down to one copy per server and use symlinks or add logic to LocalSettings.php for per-wiki settings. [22:33:59] but i have a lot to do to get to that point [22:34:08] for now i'm just working on the mw/smw upgrade plan [22:34:09] Yes, I would recommend at least the latter. [22:34:30] But you don't need any special advice for upgrading SMW... just follow the instructions. [22:35:19] well normally i'd just replace the version in the extensions directory and run an update script but i was seeing how composer is the recommended method and i wasn't sure how that would play with multiple servers hosting each wiki [22:35:19] Yaron: oh you're book has been upgraded [22:35:23] *your [22:35:31] Yes, a few weeks ago. [22:37:17] my plan was to create a new mw 1.22.6 directory with the latest versions of all our extensions, except smw initially, and run the update script to update the schema. and then go replace the smw version(s) (drilldown, maps, etc.) and do that update script. [22:38:18] i'm going to set up a new wiki/database stack in parallel from a backup, do all of the work there, and then switch apache vhosts to the new docroots [22:40:31] Yaron: so do i not need to worry about using Composer, even after upgrading to MW 1.22? [22:41:10] I don't think so... it takes a little getting used to at first, but if you follow the instructions it's all straightforward. [22:41:40] should i be using it for all MW extensions? [22:44:26] I guess what confuses me about it though is how to manage extensions with it when multiple load-balanced servers would all need to have extensions upgraded? I can do them one at a time by removing from the LB config, upgrading, and re-adding to the LB... [22:46:32] jcl: you can't use it for all MW extensions - only the ones that are configured for Composer. [22:46:51] Which is SMW, SRF, Semantic Maps, Maps... [22:47:03] Those are the main ones. [22:47:33] The load-balancing, I don't know.... but shouldn't it work the same regardless of how each extension's code is called? [22:50:51] Ok, about Composer-supported extensions. As for load balancing, I probably wouldn't want to have mixed versions of an extension, esp something as complex as SMW, across the 4 servers, especially due to the need for database schema updates. [22:52:28] That's why this upgrade is a complex operation: major MW and SMW upgrades across multiple servers to a single master-replica database pair. Better to build a new app stack in parallel that no one is using while locking the live database after a backup so i can restore to a new copy and do all of the updates there. [22:52:52] I really need to streamline that process. :) [23:02:37] jcl: yes... I don't know if it's possible, but ideally you would have everything running on just one set of code. [23:03:47] Yaron: Running off to a meeting, I'll be back shortly.