<!-- Some styling for better description lists --><style type='text/css'>dt { font-weight: bold;float: left;display:inline;margin-right: 1em} dd { display:block; margin-left: 2em}</style>

   Tiki|bot: New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - https://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58305
   <br> New Forum Posts: FW: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[57478] trunk - https://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58296
   <br> New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58309
   <br> New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58305
   <br> New Forum Posts: FW: [Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[57478] trunk - http://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58296
   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
   amette_: left #tikiwiki
   Tiki-KGB: 03ameoba32 r57481 10branches/14.x/lib/core/Services/Tracker/Controller.php
   <br> [bp/r57480][FIX] Tracker "one item per person" permission, https://dev.tiki.org/item5792
   <br> 03ameoba32 r57482 10(70 files in 60 dirs) * [MRG] Automatic merge, branches/15.x 57464 to 57480
   <br> 03ameoba32 r57483 10trunk/doc/devtools/svntools.php * [FIX] Revert mistakely commit on tools
   nelsonko: joined #tikiwiki
   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&amp;comments_parentId=58310
   fabricius_tux: joined #tikiwiki
   Bsfez: joined #tikiwiki
   <br> joined #tikiwiki
   <br> joined #tikiwiki
   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&amp;comments_parentId=58310
   <br> New Forum Posts: Issue with two tiki sites on one IIS server - http://suite.tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58309
   <br> New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://suite.tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58305
   refizul: joined #tikiwiki
   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&amp;comments_parentId=58310
   <br> New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58309
   <br> New Forum Posts: Some 'map' issues in Tiki15/trunk (and Tiki14) - http://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58305
   nelsonko: joined #tikiwiki
   Tiki|bot: New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58311
   fabricius: joined #tikiwiki
   redflo: joined #tikiwiki
   jonnyb: joined #tikiwiki
   Tiki|bot: New Forum Posts: Turning features off errors? - https://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58311
   <br> 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&amp;comments_parentId=58310
   <br> New Forum Posts: Issue with two tiki sites on one IIS server - https://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58309
   <br> New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58311
   <br> 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&amp;comments_parentId=58310
   <br> New Forum Posts: Issue with two tiki sites on one IIS server - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58309
   Telesight: joined #tikiwiki
   Jyhem_laptop: joined #tikiwiki
   chibaguy: joined #tikiwiki
   Tiki-KGB: 03xavidp r57484 10branches/15.x/lib/wiki-plugins/wikiplugin_trackerstat.php
   <br> [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).
   <br> 03xavidp r57485 10branches/14.x/lib/wiki-plugins/wikiplugin_trackerstat.php
   <br> [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).
   <br> 03xavidp r57486 10branches/12.x/lib/wiki-plugins/wikiplugin_trackerstat.php
   <br> [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).
   olinuxx: joined #tikiwiki
   Bsfez: joined #tikiwiki
   amette_: joined #tikiwiki
   <br> left #tikiwiki
   <br> joined #tikiwiki
   nelsonko: joined #tikiwiki
   Tiki|bot: Recent Bug:  - http://dev.tiki.org/item5810
   amette_: polom
   jonnyb: hi amette_
   amette_: heya jonnyb :)
   PuppyKun: joined #tikiwiki
   Bsfez: (Bsfez is out for birthday celebration !) cu guys
   Jyhem_laptop: joined #tikiwiki
   olinuxx: joined #tikiwiki
   chibaguy: polom
   amette_: moloq chibaguy
   chibaguy: hi amette_ . How are things?
   amette_: Fine, thanks, how are you?
   xiaolin: joined #tikiwiki
   <br> hi
   <br> can you help me to create a form please ?
   amette_: Depends on what exactly you want to do. What do you mean by "form"?
   xiaolin: formulaire
   <br> a questionnaire
   <br> in our site
   amette_: You mean form like an HTML form?
   xiaolin: yes
   amette_: And where should it post to?
   <br> Where should the input data be saved?
   <br> Are you familiar with Trackers?
   xiaolin: to our site http://www.chairedelimmateriel.u-psud.fr/tiki-index.php
   <br> no I want to know how to use tracker
   <br> Do you speak chinese?
   nelsonko: joined #tikiwiki
   amette_: No, sadly I don't.
   <br> And I wouldn't know of anyone else in here speaking Chinese...?!
   xiaolin: english oK
   amette_: Have you read https://doc.tiki.org/Trackers &lt;- there is the complete step-by-step process to work with trackers.
   nelsonko: joined #tikiwiki
   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
   <br> just a form, i think it's the same function
   amette_: You need to activate the feature.
   jonnyb: joined #tikiwiki
   xiaolin: I have done
   amette_: So then it's there.
   xiaolin: but I create, but I can't see the manuel
   <br> HI
   <br> you are there
   <br> Check the box to re-import in this tracker and change the fields.
   <br> I think it is the problem
   <br> Because each time when I add a field, it mentioned 'Check the box to re-import in this tracker and change the fields.'
   Xiaolin: joined #tikiwiki
   <br> Hi, I have a problem with tracler
   <br> tracker
   <br> it mentioned 'Check the box to re-import in this tracker and change the fields'
   <br> I don't know how to do with that
   <br> Bonjour
   olinuxx: joined #tikiwiki
   Xiaolin: Bonjour
   <br> je suis en train de utiliser le formulaire
   <br> mais après la définition des champs, je ne sais pas comment afficher
   chibaguy_: joined #tikiwiki
   chibaguy__: joined #tikiwiki
   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-&gt;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?
   <br> As a matter of fact... it _should_ work. A zero length string should be empty?! :O
   <br> Ah... no, it does evaluate correctly... line numbers are hard to get right... :P
   <br> 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?
   <br> jonnyb : still there? Please see my last line here in the channel --^
   jonnyb: hi amette_ yes, still here...
   amette_: Cool, then we'll get this fixed quickly, I suppose. ;)
   jonnyb: you cleared caches? prefs should get reset when you do that
   <br> if they're properly written that is...
   amette_: Yes, I did, but it's apparantly not about the pref at all.
   <br> The built SQL query ends like this: order by `score` desc limit '10' offset '0';
   jonnyb: there were a bunch of errors that aarrived with that new score stuff :(
   amette_: If I change it to: order by `score` desc limit 10 offset 0; &lt;- without the quotes, it works
   <br> note the missing single quotes around the values for limit and offset
   <br> I tried the queries directly in MySQL to figure that out.
   jonnyb: is the code using the proper db access stuff, of just manually assembled sql?
   amette_: But how to tell fetchAll to do it properly?
   jonnyb: it does usually
   amette_: well, it uses fetchAll... looks kinda proper to me, but I'm not sure what the proper way nowadays would be.
   jonnyb: ok, i'll have a quick look...
   <br> try $this-&gt;fetchAll($query, array((int) $limit, (int) $start));
   amette_: I tried, didn't do any good. But let me try again.
   <br> yep, my code still had that in it, doesn't help
   Tiki|bot: Recent Bug:  - http://dev.tiki.org/item5811
   jonnyb: on both lines? 1330 as well just in case?
   <br> forcing the bindvars to be ints should mean it doesn't add the quotes i thought
   amette_: nope, doesn't change anything
   <br> I also typecast it before the queries, no luck
   jonnyb: btw, a zero-length string counts as empty for php
   amette_: yep, I figured that one out, too - which then led me to find the proper error
   jonnyb: weird - making them ints should work
   amette_: (I was wondering how that could not count as empty, but it felt like the problem at first - jumping to conclusions too fast)
   jonnyb: srry, can't do more now, in the middle of other stuff (localhost not working currently)
   amette_: Well, I typecast them before and var_dumped them, they are being shown as int, but the error persists.
   <br> alright, no worries, but thanks for having a look!
   <br> In case you want to reproduce: it's enough to activate feature Score and try to assign the Most active Users module
   jonnyb: looks like it might be related to http://sourceforge.net/p/tikiwiki/code/56999
   amette_: That's the one that added the non-working queries.
   <br> Not sure it is the actual bug though... that "limit ? offset ?" should work imho.
   <br> or maybe not... it's the only place in the whole of tiki that tries to use it in this way
   Tiki|bot: New Forum Posts: Questions about Fullscreen view - http://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58321
   fabricius: joined #tikiwiki
   Tiki-KGB: 03gezzzan r57487 10branches/15.x/templates/tracker_filter.tpl
   <br> [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
   nelsonko: joined #tikiwiki
   Tiki-KGB: 03amette r57488 10branches/15.x/lib/tikilib.php * [FIX] Proper use of LIMIT in MySQL query
   amette_: :)
   jonnyb: well done amette_ for r 57488
   <br> should have rmembered that :)
   amette_: Thanks, jonnyb :)
   <br> Yeah, but it was fun to figure out. ;)
   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)
   amette_: Ok, good to know, I was actually wondering about that earlier.
   Tiki-KGB: 03gezzzan r57489 10branches/15.x/lib/core/Services/Tracker/Controller.php
   <br> [FIX] a bit more description so it does not sound like an error but more like it is a setting
   fabricius: joined #tikiwiki
   jonnyb: joined #tikiwiki
   Tiki|bot: New Forum Posts: Questions about Fullscreen view - https://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58321
   <br> New Forum Posts: Turning features off errors? - https://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58311
   <br> 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&amp;comments_parentId=58310
   <br> New Forum Posts: Questions about Fullscreen view - http://tiki.org/tiki-view_forum_thread.php?forumId=26&amp;comments_parentId=58321
   <br> New Forum Posts: Turning features off errors? - http://tiki.org/tiki-view_forum_thread.php?forumId=6&amp;comments_parentId=58311
   <br> 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&amp;comments_parentId=58310
   j0n3: joined #tikiwiki
   Jyhem_laptop: joined #tikiwiki
   <br> joined #tikiwiki
   Tiki-KGB: 03patrick-proulx r57490 10trunk/lib/ 10wiki-plugins/wikiplugin_addon.php 03smarty_tiki/block.addonview.php
   <br> [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
   Jyhem: joined #tikiwiki
   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. ;(