Log message #4185197

# At Username Text
# May 1st 2019, 11:38 rudy1976s good morning! the cookbok id apparently down
# May 1st 2019, 10:46 neon1024 :thumbsup:
# May 1st 2019, 10:46 megan @neon1024 yup! Have let the team know - Mark did an optimisation thing last night, so could be related. In the meantime you can use https://book.cakephp.org/3.next/en/index.html :slightly_smiling_face:
# May 1st 2019, 10:42 fra.bdn Hi, the DebugKit stopped working, on the JS console I get a: 404 for http://localhost/debug-kit/toolbar/<a uuid> And the browser just shows a red square on the bottom right of the screen.
# May 1st 2019, 10:37 COOurb So it kind adoesn't touch 'entity' and all it's stuff
# May 1st 2019, 10:37 COOurb well, I'm using update() in query builder. Can it be reason why timestamp doesn't work?
# May 1st 2019, 10:35 COOurb ye
# May 1st 2019, 10:34 kiwi_73 is http://book.cakephp.org down?
# May 1st 2019, 10:24 COOurb nope. doesn't work
# May 1st 2019, 10:22 neon1024 Here is the documentation https://github.com/cakephp/docs/blob/3.0/en/orm/behaviors/timestamp.rst#using-and-configuring-the-behavior
# May 1st 2019, 10:21 COOurb ok
# May 1st 2019, 10:21 COOurb dunno
# May 1st 2019, 10:20 neon1024 Probably easier to update your schema
# May 1st 2019, 10:20 neon1024 ..and using MySQL of course
# May 1st 2019, 10:20 neon1024 That might be the root of your issue if you’re not escaping
# May 1st 2019, 10:20 neon1024 Yes, it is. https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-D
# May 1st 2019, 10:19 neon1024 Isn’t ‘date’ a reserved word?
# May 1st 2019, 10:17 COOurb $this->addBehavior('Timestamp',['events'=>['Model.beforeSave'=>['date'=>'always']]]);
# May 1st 2019, 10:16 neon1024 As you can see the behaviour foreach’s the config and updates those fields, https://github.com/cakephp/cakephp/blob/c15a2e9c1933fa5a874c33d2bcb6d63efacf8876/src/ORM/Behavior/TimestampBehavior.php#L101
# May 1st 2019, 10:15 neon1024 You can see here that the eventName is configured with specific fields, you overwrite these to use timestamp with your own fields
# May 1st 2019, 10:15 neon1024 https://github.com/cakephp/cakephp/blob/c15a2e9c1933fa5a874c33d2bcb6d63efacf8876/src/ORM/Behavior/TimestampBehavior.php#L53-L56
# May 1st 2019, 10:13 COOurb ?? sorry, didn't get it
# May 1st 2019, 10:13 neon1024 Well, anyway, you’ll want to pass an array of config to the bejhaviour to add your field
# May 1st 2019, 10:12 neon1024 https://downforeveryoneorjustme.com/book.cakephp.org
# May 1st 2019, 10:12 COOurb I have it offline
# May 1st 2019, 10:12 neon1024 @megan The cake book is 404 :(
# May 1st 2019, 10:12 COOurb copy it from the book
# May 1st 2019, 10:11 neon1024 @yannickfogang My first question would be why are you not using the ORM
# May 1st 2019, 10:11 COOurb $this->addBehavior('Timestamp', ...
# May 1st 2019, 10:11 COOurb yep.
# May 1st 2019, 10:11 neon1024 COOurb, Did you configure the behaviour in your Table class to use the new field?
# May 1st 2019, 10:04 COOurb type of date field it DATETIME
# May 1st 2019, 10:04 COOurb entiry is changing - timestamp aren't
# May 1st 2019, 10:04 COOurb hi, I can't assign timestamp behavior to custom field.
# May 1st 2019, 09:46 noel @yannickfogang I had something similar yesterday and it was because my data was corrupt – some of the records NOT NULL but had null values.
# May 1st 2019, 09:41 yannickfogang Hi everyone, I have a table with data, when i use the connectionManager to execute a prepared query with a limit of 15, my result array only contains 5 rows, yet the same query executing it with PDO or pgAdmin I get all the results. An idea about this problem?
# May 1st 2019, 09:37 neon1024 Morning all :wave:
# May 1st 2019, 09:23 martin hmm ok, that is dev book, but almost the same I think :P
# May 1st 2019, 09:19 noel https://book.cakephp.org/3.next/en/index.html
# May 1st 2019, 09:18 martin where did the book go?
# May 1st 2019, 09:11 noel but how is that structure you’ve shown a many-to-many? Looks like it’s just pointing at id in the categories table.