Log message #3880540

# At Username Text
# May 26th 2016, 10:07 unorthodox Atm SUBSTRING() applies to [original].
# May 26th 2016, 10:06 unorthodox Hm. Does anyone have a clue about using sql SUBTRING() on a translated field?
# May 26th 2016, 10:03 Neon1024x D
# May 26th 2016, 09:58 frzrr ah, well _getCreated($created); worked wonders, thanks Neon1024x hard to access the correct solutions sometimes :)
# May 26th 2016, 09:56 Neon1024x If it's datetime, I think you can configure the defalt datetime format in your bootstrap
# May 26th 2016, 09:53 frzrr yeah sounds like a better solution for the problem since the dates returned should be the same in the entire application
# May 26th 2016, 09:53 frzrr or no, afterfind is no entity my bad :)
# May 26th 2016, 09:52 frzrr if thats still available in Cakephp3 ?
# May 26th 2016, 09:52 frzrr but yea, could do this is like afterFind
# May 26th 2016, 09:52 frzrr autoFields was the solution :)
# May 26th 2016, 09:47 Neon1024x $this->Users->find()->select(['id', 'first_name', 'last_name']);
# May 26th 2016, 09:47 Neon1024x Especially as ->select() for a query is for fields rather than model names
# May 26th 2016, 09:47 Neon1024x frzrr, Sounds to me like you need an entity mutator method, if I've understood properly
# May 26th 2016, 09:46 Neon1024x phpcoder, Well that looks like a contained association to me, I think the 1=1 just applies to the queries global conditions, but I'm not 100% certain of that
# May 26th 2016, 09:42 frzrr issue is that i need to format the created dates for the main table and dont want to have to add all the other tables in the select.
# May 26th 2016, 09:41 frzrr other than passing in ->select([$this->Model, $this->OtherModel]) a thousand times ?
# May 26th 2016, 09:40 frzrr is there some way i could add to the ->select() function without altering the already generated select
# May 26th 2016, 09:37 phpcoder Neon1024x, yes ok but it should add https://gist.github.com/anonymous/7ff67a7838792aeb584bc70e78b66329#file-test-sql-L72 there no ?
# May 26th 2016, 09:33 Neon1024x It allows the query build to easily append conditions
# May 26th 2016, 09:33 Neon1024x phpcoder, The 1=1 is added to the query for when there are no WHERE conditions
# May 26th 2016, 09:32 birdy247 1st day
# May 26th 2016, 09:32 birdy247 lol
# May 26th 2016, 09:31 phpcoder guys cake returns this query https://gist.github.com/anonymous/7ff67a7838792aeb584bc70e78b66329 it works but why does it use 1 = 1 here https://gist.github.com/anonymous/7ff67a7838792aeb584bc70e78b66329#file-test-sql-L67 it does not look very well
# May 26th 2016, 09:30 neon1024 Had 2 crashes as well
# May 26th 2016, 09:30 neon1024 Dunno really birdy247 all I've done so far is update my laptop / os / packages / code
# May 26th 2016, 09:30 Eax Ey folks! Cake3 question: I have this LoginController: https://gist.github.com/eaxexe/64442df2e6465a67fe7a0fcd98ad27f7 (It uses Facebook to auth the login, hence no password checking) - My question is: Can anyone see why the cookie simply dissapears after being set and the user being redirected? Thanks! ð???
# May 26th 2016, 09:29 birdy247 @neon1024: How is cake fest
# May 26th 2016, 09:29 marlinc Anyone here going to Amsterdam's train stations by any chance on Saturday?
# May 26th 2016, 09:27 neon1024 :+1::skin-tone-2:
# May 26th 2016, 09:27 birdy247 bernat1 thanks also
# May 26th 2016, 09:27 birdy247 @neon1024: thanks!
# May 26th 2016, 09:26 birdy247 got there :slightly_smiling_face:
# May 26th 2016, 09:26 birdy247 phew
# May 26th 2016, 09:23 birdy247 so I simply need to return $entities;
# May 26th 2016, 09:23 birdy247 ok
# May 26th 2016, 09:23 neon1024 Beyond that, my brain has imploded :(
# May 26th 2016, 09:22 neon1024 Specifically where $alteredData is set
# May 26th 2016, 09:22 neon1024 Yep, now read the code above that
# May 26th 2016, 09:21 birdy247 // Another listener callback public function doSomethingElse($event) { // ... $event->result['order'] = $alteredData; }
# May 26th 2016, 09:21 bernat1 @birdy247, my guess is that $event->result is an Event object.
# May 26th 2016, 09:21 neon1024 I agree that the code visually is misleading