Log message #4217360

# At Username Text
# Dec 4th 2019, 20:51 dereuromark ;)
# Dec 4th 2019, 20:19 ndm OMG this stupid editor, I hope the people at Slack step on a bunch of legos and catch koala AIDS...
# Dec 4th 2019, 20:18 ndm The docs should probably use the `login` action as an example for allowing unauthenticated requests, not `view` and `index`.
# Dec 4th 2019, 20:06 rochasmarcelo Also you could use https://packagist.org/packages/cakedc/users#dev-9.next
# Dec 4th 2019, 20:05 rochasmarcelo ?
# Dec 4th 2019, 20:05 rochasmarcelo Have you followed the documentation pages https://book.cakephp.org/authentication/2/en/index.html%20https://book.cakephp.org/authorization/2/en/index.html
# Dec 4th 2019, 19:59 luizcmarin any suggestions please? I am researching some guidance, but I am a layman ....
# Dec 4th 2019, 19:46 luizcmarin authz = "No identity found. You can skip this check by configuring require Identity to be false." :triumph::,(
# Dec 4th 2019, 19:16 luizcmarin Hmmm ... installed. Thank you
# Dec 4th 2019, 19:14 admad You need to use 2.x-dev
# Dec 4th 2019, 19:13 admad There's no 2.0 release yet for authz lib.
# Dec 4th 2019, 19:13 luizcmarin Simple question (in theory): what do we have to use in cakephp 4.x (updated) for authentication (login / logout)?
# Dec 4th 2019, 19:06 slackebot2 <luizcmarin>
# Dec 4th 2019, 19:06 luizcmarin but.....
# Dec 4th 2019, 19:05 luizcmarin thanks you
# Dec 4th 2019, 18:53 waspinator use https://book.cakephp.org/4/en/tutorials-and-examples/blog-auth-example/auth.html
# Dec 4th 2019, 18:53 waspinator @luizcmarin it should still work, but it's deprecated
# Dec 4th 2019, 18:45 luizcmarin https://book.cakephp.org/4/en/tutorials-and-examples/blog-auth-example/auth.html
# Dec 4th 2019, 18:44 slackebot2 <luizcmarin>
# Dec 4th 2019, 18:44 luizcmarin please, this is OK for cake4? (RC2 et all)
# Dec 4th 2019, 17:29 devito Rules show, but validation errors do not although they are set in the entity
# Dec 4th 2019, 17:28 devito how do i get nested validation errors to appear on the form?
# Dec 4th 2019, 17:06 gianmarxgagliardi :it:
# Dec 4th 2019, 17:04 dereuromark :slightly_smiling_face:
# Dec 4th 2019, 16:59 gianmarxgagliardi wroooooooooooooooooooooooooo
# Dec 4th 2019, 16:59 ndm And when you use distinct/group to remove possible duplicates, you might come back to join @dereuromark’s "group by handling" trauma support group :)
# Dec 4th 2019, 16:54 ndm :tongue:
# Dec 4th 2019, 16:54 neon1024 Beaten to it! ;)
# Dec 4th 2019, 16:54 neon1024 I’d use the `notMatching()`..
# Dec 4th 2019, 16:54 ndm `$this->DogsCats->Dogs->find('list')->notMatching('DogsCats')` or `$this->DogsCats->Dogs->find('list')->notMatching('Cats')` https://book.cakephp.org/3/en/orm/retrieving-data-and-resultsets.html#using-notmatching
# Dec 4th 2019, 16:39 gianmarxgagliardi a question: with this method `$this->set('Dogs', $this->DogsCats->Dogs->find('list'));` I take the list of dogs, but if I wanted to take all the dogs except those that were NOT associated with cats in the dogs_cats table, how could I do? here you find the DB ->https://stackoverflow.com/questions/59141547/cakephp-displays-the-id-display-table-name-from-two-different-tables-with-relati
# Dec 4th 2019, 16:27 dereuromark thats a cool trick @ndm
# Dec 4th 2019, 16:26 ndm @dereuromark If what you want is a list of distinct summaries ordered by their latest occurrence, then ordering by `MAX(id)` will give you exactly that.
# Dec 4th 2019, 16:16 k4t is it known problem?
# Dec 4th 2019, 16:16 k4t Record not found in table "requests"
# Dec 4th 2019, 16:16 k4t I have problem with debuggit which throws follwoign error:
# Dec 4th 2019, 16:16 k4t Hello
# Dec 4th 2019, 16:12 dereuromark true. it is still somewhat fuzzy. But most cases it seemed to work this easy way. Well, maybe just dropping the order then - and done with it. thx
# Dec 4th 2019, 15:24 val some queries may return unexpected results when only_full_group_by is disabled, f.ex. `SELECT email, DATE(created) FROM users GROUP BY DATE(created);` - it is not really clear what `email` value is expected - the first user created at the given date? the last user? Often MySQL will pick one user email on Linux but a different email on Windows even when the data in users table is the same.
# Dec 4th 2019, 15:12 val F.ex. if you take a set [1, 'apples'], [2, 'oranges'], [3, 'oranges'], [4, 'apples'] and then group by name you will get ['apples', 'oranges'] and it makes no sense to order by id because 'apples' have ids 1 and 4, 'oranges' have ids 2 and 3. The result of ordering by id can be 'apples', 'oranges' or 'oranges', 'apples' - both correct
# Dec 4th 2019, 15:09 val "but how do you explain it working then for mysql here?" - MySQL chooses any value according to the docs