Log message #4125462

# At Username Text
# Mar 16th 2018, 07:35 bravo-kernel May I ask one more time why we are not able to watch the CakeFest talks on youtube/whatever right away? I am already looking at the full Ember video right now on youtube
# Mar 16th 2018, 07:12 rudy1976s morning question: can I use a cell inside another cell ?
# Mar 16th 2018, 07:11 rudy1976s good morning !
# Mar 16th 2018, 07:05 savant @cookieguru if that was for submitting a talk to the conference, please reach out to @megan who can help facilitate :slightly_smiling_face:
# Mar 16th 2018, 07:04 savant hope that helps (sorry for not responding earlier, was submitting talks to cakefest :P )
# Mar 16th 2018, 07:02 savant In regards to performance, that really depends upon the view itself and how its constructed for your particular datastore
# Mar 16th 2018, 07:01 savant newer versions handle complex joins and subqueries in a much more performant manner
# Mar 16th 2018, 07:00 savant @vwpoit I would definitely try to ensure you are using a newer version of MySQL
# Mar 16th 2018, 07:00 savant james_fr: You need to `use` the class path
# Mar 16th 2018, 06:49 james_fr i installed Piwik lib https://packagist.org/packages/piwik/device-detector in cakephp using composer and i can see its in vendor folder... not i want to use it in controller.. how can i do ..
# Mar 16th 2018, 06:47 james_fr hi admad
# Mar 16th 2018, 05:47 vwpoit It combines data from lots of different places and I'm trying to find out if creating a MySQL view directly into my database will help or not.
# Mar 16th 2018, 05:46 vwpoit I ask because I keep getting very poor performance on one particular screen on my app.
# Mar 16th 2018, 05:46 vwpoit Hello, everyone! I came here because I haven't found solid information on how CakePHP handles MySQL views in terms of performance. Does it cache them like it does with regular MySQL tables? If so, does that mean results are more readily available than traditional CakePHP find methods and/or queries?
# Mar 16th 2018, 01:53 dereuromark We should make all magic strings auto-completeable..
# Mar 16th 2018, 01:53 dereuromark I added autocomplete for element() template calls: https://github.com/dereuromark/cakephp-ide-helper/pull/77 Can someone with PHPStorm maybe test and give feedback here?
# Mar 16th 2018, 00:58 bez hi! i have a question about CakePHP 3 password hashing with DefaultPasswordHasher: does it uses the Security.salt for something? is it possible to change Security.salt in controller before hashing the password, for say, creating an account for another CakePHP application with a distinct Security.salt?
# Mar 15th 2018, 22:27 obinoob It's hard to get some basic help around! I've to drop this... unfortunately php communities are extremely toxic
# Mar 15th 2018, 22:23 obinoob ok thanks I've found it $this->paginate = [ 'order' => ['Users.id' => 'desc']
# Mar 15th 2018, 22:16 obinoob is it possible to sort after order?
# Mar 15th 2018, 22:12 obinoob I can't sort asc or desc with query such as $this->Table->find()->where([...])->orderAsc();
# Mar 15th 2018, 20:39 phpnut will have it checked out
# Mar 15th 2018, 20:36 lorenzo @phpnut ^
# Mar 15th 2018, 20:33 cookieguru I tried several different usernames, including gibberish, and every time I try and sign up at https://my.cakephp.org/join it says `This username is already in use.`
# Mar 15th 2018, 19:23 inoas ok
# Mar 15th 2018, 19:23 dereuromark because it doesnt need to, the main where() logic happens which is the obvious exception of the current behavior
# Mar 15th 2018, 19:23 inoas no test case for false
# Mar 15th 2018, 19:22 inoas https://github.com/cakephp/cakephp/pull/11782/files
# Mar 15th 2018, 19:22 inoas I do
# Mar 15th 2018, 19:22 dereuromark you should look into the core pr
# Mar 15th 2018, 19:22 inoas ok
# Mar 15th 2018, 19:22 inoas don't have a test suite around, but I tried the SQL and it is invalid
# Mar 15th 2018, 19:22 dereuromark you are welcome to see what happens, ionas
# Mar 15th 2018, 19:22 dereuromark try it
# Mar 15th 2018, 19:22 conehead Still the same :S
# Mar 15th 2018, 19:21 inoas latter is invalid syntax...
# Mar 15th 2018, 19:21 inoas @dereuromark wouldn't $query->whereInList('id', [], ['allowEmpty' => false]); generate something similar to SELECT * FROM order WHERE id IN ();
# Mar 15th 2018, 19:09 conehead I will check. It was all auto generated. So I thought it should work this way. Will add the 's' everywhere
# Mar 15th 2018, 19:08 conehead you mean the 's'
# Mar 15th 2018, 19:07 dereuromark you dont see my point?
# Mar 15th 2018, 19:06 conehead https://pastebin.com/CejCBhLp