[03:32:04] New patchset: Yaron Koren; "Fix for uploading of files with non-Latin characters in their names, at least for browsers other than IE" [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/16596 [03:35:52] New review: Yaron Koren; "Forgot to mention in the commit description that this fix was suggested by user Pastakhov." [mediawiki/extensions/SemanticForms] (master); V: 1 C: 2; - https://gerrit.wikimedia.org/r/16596 [03:35:52] Change merged: Yaron Koren; [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/16596 [06:54:44] hrm, the DB layer could benefit from a cache to store the last n results - I'm seeing lots of duplicate queries in the traces of a single page generation [06:54:55] ... and 1480 queries is definitely not a good idea [07:36:30] Hi, [07:36:42] Does someone has acces to the SMWplus documentation? [07:40:03] The Company behind SMW+ went bankrupt, so now their websites are down, along with all the documentation. [08:11:03] bonsaikitten: Hey, what queries were there? [08:11:26] nischayn22: enough to make me cry [08:11:52] bonsaikitten: could you paste some of them and link them?? [08:12:04] bonsaikitten: and are they smw queries? [08:12:30] yes, for a good part [08:13:00] SMW 1.8 will have very fewer queries :) [08:13:08] nischayn22: on a "normal" page the mediawiki debug bar shows me ~1500 queries, on larger pages it goes up far more [08:13:19] oh, good, at last someone used their brain [08:13:52] bonsaikitten: what were you doing? creating a new page or editing existing one? [08:13:55] nischayn22: "SELECT smw_id,smw_iw,smw_sortkey FROM `smw_ids` WHERE smw_title='P078268' AND smw_namespace='0' AND (smw_iw='' OR smw_iw=':smw-redi') AND smw_subobject='' LIMIT 1 " [08:14:01] nischayn22: viewing pages [08:14:20] yes. *viewing*. it's a performance disaster :D [08:14:23] viewing? didn't you enable MW caching? [08:15:25] bonsaikitten: try http://www.mediawiki.org/wiki/Manual:Cache and http://www.mediawiki.org/wiki/Memcache [08:15:47] I thought you were whining about SMW's ill queries :P [08:15:59] nischayn22: memcache pessimizes performance, apc improves performance quite a bit [08:16:14] *with* APC enabled I get down to around 3.5 seconds for a page view [08:16:35] without it's 10-20 seconds (and sometimes worse) [08:16:59] the "worst" page I have has best case a render time of 38 seconds [08:17:04] bonsaikitten: Caching is provided by MW so you need to enable it, otherwise there will be too many queries [08:17:30] also would be nice if you could show some *smw* queries that were duplicated [08:17:39] that would be something we can improve [08:17:53] well, I'll have to try to get a dump of the queries somehow [08:17:56] then I can dissect it [08:18:13] and, again, this is WITH caching [08:18:21] yes, you can dump [08:18:30] some people do use nontrivial things :) [08:18:50] with caching enabled there shouldn't be any smw queries for page views [08:19:26] $wgDebugLogFile = "smwdebug.log"; [08:19:26] $wgShowSQLErrors = true; [08:19:26] $wgDebugDumpSql = true; [08:19:26] $wgDebugToolbar = true; [08:19:37] I use these to have a log [08:25:08] mmh, spam. well, let's see what I can extract from a 2k line log :) [08:32:55] 197 DISTINCT t1.smw_id AS id,t1.smw_title AS t,t1.smw_namespace AS ns,t1.smw_iw AS iw,t1.smw_subobject AS so,t1.smw_sortkey AS sortkey FROM `smw_ids` AS t1 WHERE t1.smw_id='39056' ORDER BY t1.smw_sortkey ASC LIMIT 51 [08:33:17] ^^ that looks like quite a bit of repetition :) [08:34:07] 12 DISTINCT p.smw_title as prop,value_xsd AS v0,value_num AS v1 FROM `smw_atts2` INNER JOIN `smw_ids` AS p ON p_id=p.smw_id WHERE s_id='79' [08:34:20] * bonsaikitten should use better shell snipping to mangle the logs [08:49:43] hello [08:50:13] I'm doing some inline queries and I want to put a different text on the first column links [08:50:30] I used the format=template for that but I get some trouble [08:51:49] I also get an error in PHP when I open the page: PHP Warning: htmlspecialchars() expects parameter 1 to be string, array given in /var/www/html/wiki/extensions/SemanticMediaWiki/specials/AskSpecial/SMW_SpecialAsk.php on line 465 [08:52:11] do you know how could I make the query to send the result as string? [08:52:19] or any way around this? [09:15:38] got it, parameter "link = none" ;) [09:44:12] New review: Nikerabbit; "As far as I can see $basename is never escaped for JavaScript. You can do that with Xml::encodeJsVar..." [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/16596 [09:59:12] New review: Jeroen De Dauw; "wheee!" [mediawiki/extensions/SemanticMediaWiki] (master); V: 1 C: 2; - https://gerrit.wikimedia.org/r/16242 [09:59:12] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16242 [10:00:38] New review: Jeroen De Dauw; "Nice :)" [mediawiki/extensions/SemanticMediaWiki] (master); V: 1 C: 2; - https://gerrit.wikimedia.org/r/16245 [10:00:39] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16245 [10:21:44] New review: Nikerabbit; "Seems to lack html escaping. Why it was split into two separate messages? Message documentation shou..." [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16562 [10:24:29] nischayn22|Away: in case you're out of work: looks like geocoords are no longer stored correctly or at least not retrieved - have not really debugged this myself [10:28:26] New patchset: Jeroen De Dauw; "Follow up to c2e6b4c1117f6b22221300e32d415bf79004ebff: escaping" [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [10:29:02] New review: Jeroen De Dauw; "Escaping in https://gerrit.wikimedia.org/r/#/c/16613/" [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16562 [10:36:46] New review: Nikerabbit; "Gerrit not opening diff for me." [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/16540 [10:54:50] New review: Nikerabbit; "I think this needs to be reverted." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16511 [10:57:51] New patchset: Jeroen De Dauw; "Revert "Minor modifications to the file"" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16617 [10:57:57] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16617 [10:59:04] New review: Jeroen De Dauw; "Good catch, that's a rather unexpected breaking change :)" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16511 [11:17:13] nischayn22|Away: please ignore my earlier brambling - I just broke my install [11:27:21] New patchset: Jeroen De Dauw; "up docs" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16618 [11:27:21] New patchset: Jeroen De Dauw; "Fix listing of format specific params on special:ask" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16619 [11:27:22] New patchset: Jeroen De Dauw; "Fix parsing in " [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16620 [11:27:36] New patchset: Jeroen De Dauw; "Fix getting of params and type hinting" [mediawiki/extensions/Validator] (master) - https://gerrit.wikimedia.org/r/16621 [11:29:16] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16619 [11:29:16] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16618 [11:29:29] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16620 [11:31:04] Change merged: Jeroen De Dauw; [mediawiki/extensions/Validator] (master) - https://gerrit.wikimedia.org/r/16621 [11:47:16] JeroenDeDauw: so they were working right? [12:19:18] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [12:20:53] New patchset: Kghbln; "Minor modifications" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16624 [12:23:11] New review: Kghbln; "vim messed up formating" [mediawiki/extensions/SemanticMediaWiki] (master) C: -1; - https://gerrit.wikimedia.org/r/16624 [12:31:01] New patchset: Kghbln; "Minor modifications" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16624 [12:35:31] New review: Kghbln; "This looks fluffy now. Hopefully it is possible to have tabs instead of spaces within" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16624 [12:39:49] New review: Kghbln; "This looks fluffy now. Hopefully it is possible to have tabs instead of spaces within" [mediawiki/extensions/SemanticMediaWiki] (master) C: 1; - https://gerrit.wikimedia.org/r/16624 [12:40:58] New review: Nikerabbit; "Message documentation was not added." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16242 [12:47:27] New review: Mwjames; "Gets added with the next change related to this topic in the meantime, please l18n team have some pa..." [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16242 [13:31:12] New review: Yaron Koren; "Thanks for fixing the escaping, though I don't understand the comment you added "FIXME: cannot acces..." [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [15:18:42] New review: Jeroen De Dauw; "protected function createPropertyText( $propertyType, $allowedValues ) {" [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [15:20:15] Change merged: Jeroen De Dauw; [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16624 [15:20:53] nischayn22: yes [15:30:15] New review: Yaron Koren; "Hi, oops, you're right - I was looking at an older version of the code. It looks like you made that ..." [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [15:45:47] New review: Jeroen De Dauw; "Sorry for that, I probably did not consider that you would be calling it from another extension like..." [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [16:05:10] New patchset: Mwjames; "Special:Ask add user preference" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16634 [16:09:11] New patchset: Mwjames; "Special:Ask add user preference" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16634 [16:19:46] New review: Yaron Koren; "Hi, sure, if you could fix it, that would be great. Although if you think there's a better way to st..." [mediawiki/extensions/SemanticInternalObjects] (master) - https://gerrit.wikimedia.org/r/16613 [17:03:28] New review: Mwjames; "Not sure which of the commits caused the problem but when having parameters are defined by (see clas..." [mediawiki/extensions/Validator] (master) - https://gerrit.wikimedia.org/r/16621 [17:51:20] New patchset: Mwjames; "Add JSON class for better public access" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16644 [19:06:38] New patchset: Mwjames; "Special:Ask add user preference" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/16634 [20:20:17] is there away to redefine the location of the Extensions directory ? [21:08:48] OrenBo: you're prolly better off asking in #mediawiki [21:09:18] done