Log message #4222934

# At Username Text
# Jan 18th 2020, 21:14 ndm *Until
# Jan 18th 2020, 21:14 ndm Unless it's actually removed, sure
# Jan 18th 2020, 21:12 wizardfix @ndm I didn't realise display width was deprecated - I see now it's deprecated for integer types from 8.0.17 - but that raises the question of - will `TINYINT(1)` still be interpreted as `BOOLEAN` ...
# Jan 18th 2020, 21:06 jimbo2150 @ndm so it is.. I rarely ever use them outside of floats and strings anyway.
# Jan 18th 2020, 21:06 wizardfix @ndm iI
# Jan 18th 2020, 21:04 ndm Well, it is what it is :) Display width is deprecated anyways, and there's no reason to use it unless the application that reads the data uses it for a specific purpose, like CakePHP does, to identify possible boolean types. Since boolean is a synonym, you'll receive tinyint(1) when reading the column details, ie there's no other way for CakePHP to "emulate" boolean types
# Jan 18th 2020, 20:59 wizardfix Afaik, in all other cases changing the integer in parentheses just changes the display width. In this case changing it from any integer `>1` to `1` changes its type and its inherent nature. :thinking_face:
# Jan 18th 2020, 20:57 wizardfix Ha! Was looking at that page before... Yeah I see the reference: > `BOOL`, `BOOLEAN` > These types are synonyms for `TINYINT(1)`. A value of zero is considered false. Nonzero values are considered true: but I find it unintuitive.
# Jan 18th 2020, 20:49 ndm boolean is a synonym for tinyint(1)
# Jan 18th 2020, 20:49 ndm https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
# Jan 18th 2020, 20:45 wizardfix @jimbo2150 @admad I can find *nothing at all* in the MySQL docs saying `TINTINT(1)` is treated as a Boolean. And in my phpMyAdmin, it lets me change a field to Boolean, and generates this SQL statement: ```ALTER TABLE `results` CHANGE `status` `status` BOOLEAN UNSIGNED NULL DEFAULT TRUE;``` thus seeming to support Booleans... I'm trying to understand this! :)
# Jan 18th 2020, 20:01 wizardfix so logically I expected `TINYINT(1)` to be able to store any integer in `[0, 1, 2, ... ,8, 9]`...
# Jan 18th 2020, 19:57 ndm Ackchyually the number in parentheses _is_ the display width. The number of bytes an integer type can store is defined by the type of the integer, ie tinyint, smallint, mediumint, int, bigint
# Jan 18th 2020, 19:52 wizardfix Ha! The :bug: was in my understanding of MySQL! x) So I've learnt something and got my method working. Win-win! :)
# Jan 18th 2020, 19:51 jimbo2150 The number in the parentheses is the maximum number of bytes stored in the field, not the number of characters.
# Jan 18th 2020, 19:49 admad tinyint(1) is the only way to emulate boolean in mysql since it's lacks "real" boolean type like other dbs
# Jan 18th 2020, 19:36 wizardfix @jimbo2150 thanks but u=is
# Jan 18th 2020, 19:34 jimbo2150 @wizardfix In MySQL, `BOOLEAN` is a synonym for `TINYINT(1)`. Your options are to set it to `TINYINT(2)` or overwrite the column type in CakePHP 3+: https://stackoverflow.com/questions/10801632/cakephp-and-tinyint-as-boolean
# Jan 18th 2020, 19:17 lpj145 what your think about repository pattern on cakephp ?
# Jan 18th 2020, 19:16 lpj145 guy's, i hope your are so fine...
# Jan 18th 2020, 19:16 wizardfix Is this a bug? Spent hours with my brain frying wondering why Cake 3.8 refused to update a row in my database. Eventually realised it was treating my `TINYINT(1) UNSIGNED DEFAULT 1` field as a Boolean. The moment I changed it to `TINYINT(2)` everything worked. :thinking_face:
# Jan 18th 2020, 02:24 markstory @neon1024 I’m actually working on making debug() better, and enable better formatting for CLI and HTML output. JSON is tricky though as you can’t really output more than one ‘thing’
# Jan 17th 2020, 13:40 storkovo and the hell of loop errors is gone
# Jan 17th 2020, 13:34 admad you will get json response for exceptions, not for errors
# Jan 17th 2020, 13:29 neon1024 I thought Exception Renderer too, guess I need to build one
# Jan 17th 2020, 13:28 neon1024 So what the content-type is becomes irrelevant
# Jan 17th 2020, 13:28 neon1024 I think the error handler is spitting this out before the response is composed
# Jan 17th 2020, 13:28 neon1024 As the response type is correct
# Jan 17th 2020, 13:28 neon1024 I think there is an issue with the api
# Jan 17th 2020, 13:28 spriz Yeah but it looks good now, doesn't it? ;P
# Jan 17th 2020, 13:27 neon1024 @spriz Preview shows HTML as well
# Jan 17th 2020, 13:18 spriz but I've done it with an exceptionRenderer
# Jan 17th 2020, 13:17 spriz @neon1024 Change the tab to `preview` and it's good ;P
# Jan 17th 2020, 12:18 neon1024 …so that errors are more readable than this
# Jan 17th 2020, 12:18 neon1024 Anyone know if there is a simple way to have requests sent as application/json throw errors as json?
# Jan 17th 2020, 12:04 challgren Well first is your flash even working?
# Jan 17th 2020, 11:57 challgren like bootstrap-ui?
# Jan 17th 2020, 11:56 challgren Do you have anything override the flashhelper?
# Jan 17th 2020, 11:56 alexdd55976 nope... no changes.
# Jan 17th 2020, 11:54 dereuromark ctp => php as well for cake4
# Jan 17th 2020, 11:53 alexdd55976 @challgren this is what i looked into