[01:07] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - https://suite.tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[01:07] Tiki|bot New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - https://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58305
[01:07] Tiki|bot New Forum Posts: FW: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[57478] trunk - https://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58296
[01:17] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[01:17] Tiki|bot New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58305
[01:17] Tiki|bot New Forum Posts: FW: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[57478] trunk - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58296
[01:30] Tiki-KGB 03ameoba32 r57480 10branches/15.x/lib/core/Services/Tracker/Controller.php * [FIX] Tracker "one item per person" permission, https://dev.tiki.org/item5792
[01:30]  amette_ left #tikiwiki
[01:36] Tiki-KGB 03ameoba32 r57481 10branches/14.x/lib/core/Services/Tracker/Controller.php
[01:36] Tiki-KGB [bp/r57480][FIX] Tracker "one item per person" permission, https://dev.tiki.org/item5792
[01:50] Tiki-KGB 03ameoba32 r57482 10(70 files in 60 dirs) * [MRG] Automatic merge, branches/15.x 57464 to 57480
[01:58] Tiki-KGB 03ameoba32 r57483 10trunk/doc/devtools/svntools.php * [FIX] Revert mistakely commit on tools
[02:38]  nelsonko joined #tikiwiki
[03:07] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[03:28]  fabricius_tux joined #tikiwiki
[05:34]  Bsfez joined #tikiwiki
[06:06]  Bsfez joined #tikiwiki
[06:55]  Bsfez joined #tikiwiki
[07:08] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - http://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[07:08] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - http://suite.tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[07:08] Tiki|bot New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58305
[07:16]  refizul joined #tikiwiki
[07:18] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[07:18] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[07:18] Tiki|bot New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58305
[07:47]  nelsonko joined #tikiwiki
[08:08] Tiki|bot New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58311
[08:30]  fabricius joined #tikiwiki
[09:43]  redflo joined #tikiwiki
[11:16]  jonnyb joined #tikiwiki
[11:18] Tiki|bot New Forum Posts: Turning features off errors? - https://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58311
[11:18] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - https://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[11:18] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - https://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[11:28] Tiki|bot New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58311
[11:28] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[11:28] Tiki|bot New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58309
[11:56]  Telesight joined #tikiwiki
[12:13]  Jyhem_laptop joined #tikiwiki
[12:22]  chibaguy joined #tikiwiki
[12:50] Tiki-KGB 03xavidp r57484 10branches/15.x/lib/wiki-plugins/wikiplugin_trackerstat.php
[12:50] Tiki-KGB [FIX]Usability. Do not force the user to set field Ids in the UI for the use cases in which the editor wants all fields of that tracker (and they may be hundreds!), and specially since the code can handle this use case as-is (all fields are displayed in that case).
[12:50] Tiki-KGB 03xavidp r57485 10branches/14.x/lib/wiki-plugins/wikiplugin_trackerstat.php
[12:50] Tiki-KGB [bp/r57484][FIX]Usability. Do not force the user to set field Ids in the UI for the use cases in which the editor wants all fields of that tracker (and they may be hundreds!), and specially since the code can handle this use case as-is (all fields are displayed in that case).
[12:50] Tiki-KGB 03xavidp r57486 10branches/12.x/lib/wiki-plugins/wikiplugin_trackerstat.php
[12:50] Tiki-KGB [bp/r57484][FIX]Usability. Do not force the user to set field Ids in the UI for the use cases in which the editor wants all fields of that tracker (and they may be hundreds!), and specially since the code can handle this use case as-is (all fields are displayed in that case).
[12:57]  olinuxx joined #tikiwiki
[12:57]  Bsfez joined #tikiwiki
[13:11]  amette_ joined #tikiwiki
[13:11]  amette_ left #tikiwiki
[13:12]  amette_ joined #tikiwiki
[13:17]  nelsonko joined #tikiwiki
[13:18] Tiki|bot Recent Bug:  - http://dev.tiki.org/item5810
[13:22] amette_ polom
[13:22] jonnyb hi amette_
[13:22] amette_ heya jonnyb :)
[13:30]  PuppyKun joined #tikiwiki
[13:51] Bsfez (Bsfez is out for birthday celebration !) cu guys
[14:42]  Jyhem_laptop joined #tikiwiki
[14:45]  olinuxx joined #tikiwiki
[14:53] chibaguy polom
[14:53] amette_ moloq chibaguy
[14:53] chibaguy hi amette_ . How are things?
[14:54] amette_ Fine, thanks, how are you?
[15:05]  xiaolin joined #tikiwiki
[15:05] xiaolin hi
[15:05] xiaolin can you help me to create a form please ?
[15:07] amette_ Depends on what exactly you want to do. What do you mean by "form"?
[15:08] xiaolin formulaire
[15:08] xiaolin a questionnaire
[15:09] xiaolin in our site
[15:09] amette_ You mean form like an HTML form?
[15:09] xiaolin yes
[15:09] amette_ And where should it post to?
[15:10] amette_ Where should the input data be saved?
[15:10] amette_ Are you familiar with Trackers?
[15:11] xiaolin to our site http://www.chairedelimmateriel.u-psud.fr/tiki-index.php
[15:11] xiaolin no I want to know how to use tracker
[15:11] xiaolin Do you speak chinese?
[15:11]  nelsonko joined #tikiwiki
[15:11] amette_ No, sadly I don't.
[15:11] amette_ And I wouldn't know of anyone else in here speaking Chinese...?!
[15:12] xiaolin english oK
[15:12] amette_ Have you read https://doc.tiki.org/Trackers <- there is the complete step-by-step process to work with trackers.
[15:14]  nelsonko joined #tikiwiki
[15:14] xiaolin Yes, I read, but I think the version of our site http://www.chairedelimmateriel.u-psud.fr/tiki-index.php is very old, I couldn't find tracker
[15:14] xiaolin just a form, i think it's the same function
[15:14] amette_ You need to activate the feature.
[15:14]  jonnyb joined #tikiwiki
[15:14] xiaolin I have done
[15:15] amette_ So then it's there.
[15:15] xiaolin but I create, but I can't see the manuel
[15:25] xiaolin HI
[15:25] xiaolin you are there
[15:25] xiaolin Check the box to re-import in this tracker and change the fields.
[15:26] xiaolin I think it is the problem
[15:26] xiaolin Because each time when I add a field, it mentioned 'Check the box to re-import in this tracker and change the fields.'
[15:40]  Xiaolin joined #tikiwiki
[15:41] Xiaolin Hi, I have a problem with tracler
[15:41] Xiaolin tracker
[15:41] Xiaolin it mentioned 'Check the box to re-import in this tracker and change the fields'
[15:41] Xiaolin I don't know how to do with that
[15:52] Xiaolin Bonjour
[15:55]  olinuxx joined #tikiwiki
[15:57] Xiaolin Bonjour
[15:57] Xiaolin je suis en train de utiliser le formulaire
[15:58] Xiaolin mais après la définition des champs, je ne sais pas comment afficher
[16:16]  chibaguy_ joined #tikiwiki
[16:31]  chibaguy__ joined #tikiwiki
[17:06] amette_ A fresh upgrade to 15.x with feature Score and the user ranking module gives a MySQL query error because it checks if $prefs['feature_score_expday'] is empty in tikilib->rank_users() and then uses the wrong query due to the pref not being empty, but a zero-length string. What is the right way to fix this?
[17:44] amette_ As a matter of fact... it _should_ work. A zero length string should be empty?! :O
[17:48] amette_ Ah... no, it does evaluate correctly... line numbers are hard to get right... :P
[18:23] amette_ ok, so, the values for "limit" and "offset" in the SQL-query are being quoted, which apparantly counts as a MySQL syntax error. Lines 1313 and 1328 in tikilib.php - how can I fix that?
[18:23] amette_ jonnyb : still there? Please see my last line here in the channel --^
[18:24] jonnyb hi amette_ yes, still here...
[18:24] amette_ Cool, then we'll get this fixed quickly, I suppose. ;)
[18:25] jonnyb you cleared caches? prefs should get reset when you do that
[18:25] jonnyb if they're properly written that is...
[18:25] amette_ Yes, I did, but it's apparantly not about the pref at all.
[18:25] amette_ The built SQL query ends like this: order by `score` desc limit '10' offset '0';
[18:25] jonnyb there were a bunch of errors that aarrived with that new score stuff :(
[18:26] amette_ If I change it to: order by `score` desc limit 10 offset 0; <- without the quotes, it works
[18:26] amette_ note the missing single quotes around the values for limit and offset
[18:26] amette_ I tried the queries directly in MySQL to figure that out.
[18:27] jonnyb is the code using the proper db access stuff, of just manually assembled sql?
[18:27] amette_ But how to tell fetchAll to do it properly?
[18:27] jonnyb it does usually
[18:27] amette_ well, it uses fetchAll... looks kinda proper to me, but I'm not sure what the proper way nowadays would be.
[18:28] jonnyb ok, i'll have a quick look...
[18:28] jonnyb try $this->fetchAll($query, array((int) $limit, (int) $start));
[18:29] amette_ I tried, didn't do any good. But let me try again.
[18:30] amette_ yep, my code still had that in it, doesn't help
[18:30] Tiki|bot Recent Bug:  - http://dev.tiki.org/item5811
[18:30] jonnyb on both lines? 1330 as well just in case?
[18:31] jonnyb forcing the bindvars to be ints should mean it doesn't add the quotes i thought
[18:31] amette_ nope, doesn't change anything
[18:32] amette_ I also typecast it before the queries, no luck
[18:32] jonnyb btw, a zero-length string counts as empty for php
[18:32] amette_ yep, I figured that one out, too - which then led me to find the proper error
[18:33] jonnyb weird - making them ints should work
[18:33] amette_ (I was wondering how that could not count as empty, but it felt like the problem at first - jumping to conclusions too fast)
[18:33] jonnyb srry, can't do more now, in the middle of other stuff (localhost not working currently)
[18:34] amette_ Well, I typecast them before and var_dumped them, they are being shown as int, but the error persists.
[18:34] amette_ alright, no worries, but thanks for having a look!
[18:34] amette_ In case you want to reproduce: it's enough to activate feature Score and try to assign the Most active Users module
[18:34] jonnyb looks like it might be related to http://sourceforge.net/p/tikiwiki/code/56999
[18:35] amette_ That's the one that added the non-working queries.
[18:36] amette_ Not sure it is the actual bug though... that "limit ? offset ?" should work imho.
[18:38] amette_ or maybe not... it's the only place in the whole of tiki that tries to use it in this way
[18:40] Tiki|bot New Forum Posts: Questions about Fullscreen view - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58321
[18:45]  fabricius joined #tikiwiki
[18:58] Tiki-KGB 03gezzzan r57487 10branches/15.x/templates/tracker_filter.tpl
[18:58] Tiki-KGB [FIX] radio filter on tracker items should use foreach instead of section as it can be associative array too, hopefully fixees https://dev.tiki.org/item5810
[19:01]  nelsonko joined #tikiwiki
[19:02] Tiki-KGB 03amette r57488 10branches/15.x/lib/tikilib.php * [FIX] Proper use of LIMIT in MySQL query
[19:02] amette_ :)
[19:13] jonnyb well done amette_ for r 57488
[19:13] jonnyb should have rmembered that :)
[19:13] amette_ Thanks, jonnyb :)
[19:14] amette_ Yeah, but it was fun to figure out. ;)
[19:18] nelsonko amette_; re xiaolin's question I do speak a bit of chinese, but I don't think I can type it (at least on this computer, don't have the right software)
[19:19] amette_ Ok, good to know, I was actually wondering about that earlier.
[19:24] Tiki-KGB 03gezzzan r57489 10branches/15.x/lib/core/Services/Tracker/Controller.php
[19:24] Tiki-KGB [FIX] a bit more description so it does not sound like an error but more like it is a setting
[19:41]  fabricius joined #tikiwiki
[20:03]  jonnyb joined #tikiwiki
[20:10] Tiki|bot New Forum Posts: Questions about Fullscreen view - https://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58321
[20:10] Tiki|bot New Forum Posts: Turning features off errors? - https://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58311
[20:10] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - https://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[20:20] Tiki|bot New Forum Posts: Questions about Fullscreen view - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58321
[20:20] Tiki|bot New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=58311
[20:20] Tiki|bot New Forum Posts: R script to test Tiki Profiles in batch for suported branches: first results - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=58310
[20:28]  j0n3 joined #tikiwiki
[20:33]  Jyhem_laptop joined #tikiwiki
[20:34]  Jyhem_laptop joined #tikiwiki
[20:42] Tiki-KGB 03patrick-proulx r57490 10trunk/lib/ 10wiki-plugins/wikiplugin_addon.php 03smarty_tiki/block.addonview.php
[20:42] Tiki-KGB [ENH] Made the addon wikiplugin into a smarty block, for better functionality when used in smarty. Also added the ability to store the returned addon value in a smarty variable rather than displaying
[20:43]  Jyhem joined #tikiwiki
[22:20] amette_ Admin Toolbars is absolutely unnerving. Things keep jumping to the right, don't show in the wiki page edit in the same order as on the admin page - and the right align of items isn't available in the wiki edit at all. ;(