Log message #4152510

# At Username Text
# Jun 19th 2018, 15:58 rquadling Yes,.
# Jun 19th 2018, 15:58 admad @rquadling coding standard?
# Jun 19th 2018, 15:54 rquadling What c/s should be applied to the Phinx code base? Or is this not really a concern?
# Jun 19th 2018, 15:14 mdunham https://imgur.com/a/5zIF9I3
# Jun 19th 2018, 15:14 mdunham howdy
# Jun 19th 2018, 15:07 mari_ however i am lost from now on what do i have to adjust regarding the "table / model"
# Jun 19th 2018, 15:07 mari_ and updated the app.default.php with this: 'Session' => [ 'defaults' => 'database' ]
# Jun 19th 2018, 15:06 mari_ i created the database table liuke this: CREATE TABLE `sessions` ( `id` char(40) CHARACTER SET ascii COLLATE ascii_bin PRIMARY KEY, `created` datetime DEFAULT CURRENT_TIMESTAMP, -- Optional `modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Optional `data` blob DEFAULT NULL, -- for PostgreSQL use bytea instead of blob `expires` int(10) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Jun 19th 2018, 15:06 mari_ i have troubles understanding the chapter with database sessions on cakephp 3.6
# Jun 19th 2018, 15:05 mari_ hi all!
# Jun 19th 2018, 14:40 birdy247 If saving to a join table, that is using "cake magic", whats the best way to validate at least 1 is selected
# Jun 19th 2018, 14:29 kaliel ok, what's important is that i get my results, i'll dig into it to try the same with a single query
# Jun 19th 2018, 14:28 kaliel erro :slightly_smiling_face:
# Jun 19th 2018, 14:27 neon1024 Just call `->first()` after the `->where()` I think
# Jun 19th 2018, 14:27 kaliel but is there a way for "contain" to return a single entity instead of array ?
# Jun 19th 2018, 14:27 neon1024 :thumbsup:
# Jun 19th 2018, 14:26 kaliel File uploaded https://cakesf.slack.com/files/U38NH0S01/FB9ULC4AG/-.php / https://slack-files.com/T053DPNCM-FB9ULC4AG-80c5c7a040 - <@U1BT622HW> thanks to your advices, now get it working like this :
# Jun 19th 2018, 14:19 neon1024 Bad times yo
# Jun 19th 2018, 14:19 neon1024 Just don’t use a custom header like I did
# Jun 19th 2018, 14:18 LubosR mikesmoniker use https://github.com/ADmad/cakephp-jwt-auth
# Jun 19th 2018, 14:18 neon1024 I wrote my own for our web service
# Jun 19th 2018, 14:18 neon1024 I would recommend using Bearer token auth and your own Auth adapter
# Jun 19th 2018, 14:17 mikesmoniker Is it possible to use Cake’s build in basic auth functionality w/ just a username or password (i.e. an “api token”) through configuration or would I need to write my own version of the auth component?
# Jun 19th 2018, 14:12 neon1024 Perhaps it just needs `return $query->where(['Bids.prix' => $query->func()->max('Bids.prix')]);` ?
# Jun 19th 2018, 14:11 kaliel @neon1024 Thanks, but it didn't do the trick :S
# Jun 19th 2018, 14:11 neon1024 Why is it that when I post to my method, which has `$this->getRequest()->allowMethod('post');` I get a Method Not Allowed exception?! I’m using the correct method
# Jun 19th 2018, 14:08 LubosR Was thinking that problem could be with foreign keys and/or indexes, but checked and I did not set offer_type_id as foreign key neither index
# Jun 19th 2018, 14:07 LubosR I am messy when trying to quickly solve :) but good piont :)
# Jun 19th 2018, 14:06 neon1024 That’s my excuse anyway :P
# Jun 19th 2018, 14:06 neon1024 Ah well, no idea. Your code is pretty messy, so it’s hard to follow
# Jun 19th 2018, 14:05 neon1024 Unless you use it’s original value elsewhere of course
# Jun 19th 2018, 14:05 neon1024 Btw you can replace all that offerType combine with just find(‘list’)
# Jun 19th 2018, 14:05 LubosR With this migration script I am trying to avoid associations
# Jun 19th 2018, 14:04 neon1024 In your database
# Jun 19th 2018, 14:04 neon1024 So you have offers.offer_type_id right?
# Jun 19th 2018, 14:04 neon1024 You’re in Offers
# Jun 19th 2018, 14:04 LubosR And value = 4 which is never saved :(
# Jun 19th 2018, 14:04 LubosR Checked DB field type and it is integer, same what I am passing into entity
# Jun 19th 2018, 14:03 LubosR Nope, as you might see at the image, there is 'offer_type_id' => (int) 4
# Jun 19th 2018, 14:03 neon1024 Could just be that the value you’re trying to write is empty
# Jun 19th 2018, 14:02 LubosR In case anyone else want to help me to solve this puzzle, here is my debugging screenshot https://pasteboard.co/HqCHmKh.png (code, debug output, sql output = with no offer_type_id!!)