| # |
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!!) |
| # |
Jun 19th 2018, 13:56 |
LubosR |
neon1024 thanks for discussion, i tried again with patchEntity and checking errors, isDirty and even when all looks good it is not saved. Have to leave it open for now, but what a mystery, right? :) |
| # |
Jun 19th 2018, 13:56 |
neon1024 |
File uploaded https://cakesf.slack.com/files/U1BT622HW/FB9JEFW3B/find_bids_by_maximum_price.php / https://slack-files.com/T053DPNCM-FB9JEFW3B-27d07b5c15 |
| # |
Jun 19th 2018, 13:55 |
neon1024 |
I don’t think this will work, but first attempt |
| # |
Jun 19th 2018, 13:55 |
tierrarara |
slackebot - cakebot3 thanks for your answer |
| # |
Jun 19th 2018, 13:45 |
kaliel |
I'm stuck from hours on the last part (subquery) |
| # |
Jun 19th 2018, 13:44 |
kaliel |
File uploaded https://cakesf.slack.com/files/U38NH0S01/FBA1SCJ1Z/-.sql / https://slack-files.com/T053DPNCM-FBA1SCJ1Z-62c9be32f5 |
| # |
Jun 19th 2018, 13:44 |
kaliel |
Hi everyone, i'm stuck in trying to make a query with cake's query builder, if anyone can help me :slightly_smiling_face: Here is what's working in sql : |
| # |
Jun 19th 2018, 13:40 |
neon1024 |
If it’s not any of those ideas, then unfortunatly, I’ve run out! |
| # |
Jun 19th 2018, 13:40 |
LubosR |
neon1024 thanks, trying again (feeling like I tried all of those) |
| # |
Jun 19th 2018, 13:39 |
LubosR |
just did $conn->logQueries(true) to find out how insert look like and offer_type_id is not there. |
| # |
Jun 19th 2018, 13:38 |
neon1024 |
..because it will assume you have an OfferTypes associated table class |
| # |
Jun 19th 2018, 13:38 |
neon1024 |
As Cake will bake a rule for that |
| # |
Jun 19th 2018, 13:38 |
neon1024 |
Also ensure that your save has `['checkRules' => false]` as you might have a rule if you have a baked table |
| # |
Jun 19th 2018, 13:37 |
neon1024 |
Or, use patchEntity, and check `$entity->getErrors()` |
| # |
Jun 19th 2018, 13:37 |
neon1024 |
You could check too `$entity->isDirty('offer_type_id')` I think the method is called |
| # |
Jun 19th 2018, 13:36 |
neon1024 |
As long as you set it with `$entity->set('offer_type_id', $offerId)`, it should be fine |
| # |
Jun 19th 2018, 13:36 |
neon1024 |
It shouldn’t exclude them unless there is a defined association |
| # |
Jun 19th 2018, 13:34 |
LubosR |
What a mystery :) |
| # |
Jun 19th 2018, 13:28 |
LubosR |
https://pasteboard.co/HqCtpZz.png here is method (it is shell which should read data from one connection and resave to other) |
| # |
Jun 19th 2018, 13:27 |
LubosR |
So wondering if ORM does exclude fields _id somehow |
| # |
Jun 19th 2018, 13:27 |
LubosR |
I did and no error, data are saved exclude this offer_type_id |
| # |
Jun 19th 2018, 13:26 |
tim |
Did you save the changed entity? |
| # |
Jun 19th 2018, 13:25 |
LubosR |
Firstly i did newEntity and then each field set by $entity->set(), now I am trying to pass $data as array to newEntity method |
| # |
Jun 19th 2018, 13:24 |
neon1024 |
How is your entity constructed? Are you using `patchEntity()` with an array, or setting properties directly? |
| # |
Jun 19th 2018, 13:20 |
LubosR |
And I can't add association because the model is not associated with OfferType (using generic cake table, not existing one) |
| # |
Jun 19th 2018, 13:19 |
LubosR |
That's what I thought, but records are there, just this field is not saved |
| # |
Jun 19th 2018, 13:18 |
neon1024 |
Perhaps you’re looking in the wrong database? |
| # |
Jun 19th 2018, 13:18 |
neon1024 |
It’s marked as dirty as well |
| # |
Jun 19th 2018, 13:18 |
neon1024 |
I don’t know why it wouldn’t save |
| # |
Jun 19th 2018, 13:17 |
neon1024 |
Hah, from your screenshot we do the same job! |
| # |
Jun 19th 2018, 13:16 |
neon1024 |
Well usually it would be expecting the associated property in the entity I would imagine |
| # |
Jun 19th 2018, 13:15 |
LubosR |
neon1024 but at this case i do not care about association, i simply want to save offer_type_id no matter if association is contained. do i have to add association for fields ending _id? |
| # |
Jun 19th 2018, 13:13 |
neon1024 |
LubosR, Perhaps the association is not contained in the entity which is set to the form |
| # |
Jun 19th 2018, 13:11 |
LubosR |
anyone? |
| # |
Jun 19th 2018, 13:05 |
LubosR |
orm cache cleared |
| # |
Jun 19th 2018, 13:05 |
LubosR |
No error on save, it is in accessible list, all other fields are saved. |
| # |
Jun 19th 2018, 13:02 |
LubosR |
Hi all, any idea why one field (offer_type_id) is not saved? see image https://pasteboard.co/HqCiMf0.png |
