# |
Jan 23rd 2020, 15:34 |
k4t |
Hi |
# |
Jan 23rd 2020, 15:34 |
val |
@ndm, ah, foreign key must be selected :) |
# |
Jan 23rd 2020, 15:30 |
spriz |
like /foo/bar/baz/action would be hitting the controller in this path `/plugins/Foo/src/Controller/Bar/Baz/ActionController`? |
# |
Jan 23rd 2020, 15:30 |
val |
@ndm any idea why 'select' strategy would not generate a query? |
# |
Jan 23rd 2020, 15:29 |
spriz |
is there a sneaky way to make more nested levels of prefix controllers available in cake 3.x ? :P |
# |
Jan 23rd 2020, 15:13 |
ndm |
https://book.cakephp.org/4/en/orm/retrieving-data-and-resultsets.html#changing-fetching-strategies |
# |
Jan 23rd 2020, 15:13 |
ndm |
Should work via the `strategy` option for the containment I think |
# |
Jan 23rd 2020, 15:11 |
val |
@ndm is there a way to change the association strategy 'join' to 'select' on the fly? |
# |
Jan 23rd 2020, 15:09 |
val |
@ndm it looks like the mapper closure is not invoked |
# |
Jan 23rd 2020, 15:02 |
val |
@ndm indeed, beforeFind is invoked but the mapper does not work as expected |
# |
Jan 23rd 2020, 15:00 |
ndm |
That's only for delete operations if I'm not mistaken |
# |
Jan 23rd 2020, 14:59 |
neon1024 |
If it’s a bulk operation and it’s not set true, the callback would be skipped right |
# |
Jan 23rd 2020, 14:58 |
neon1024 |
@ndm Could it be to do with cascadeCallbacks in the association? |
# |
Jan 23rd 2020, 14:58 |
ndm |
@val Have you checked that the method really isn't being invoked (as opposed to the mapper maybe not working as expected)? |
# |
Jan 23rd 2020, 14:53 |
jotpe |
I did `bin/cake cache clear_all` and `bin/cake orm_cache clear` |
# |
Jan 23rd 2020, 14:52 |
val |
@ndm. hmmm... doesn't happen in my case |
# |
Jan 23rd 2020, 14:51 |
neon1024 |
@jotpe Local model cache? |
# |
Jan 23rd 2020, 14:49 |
jotpe |
Even weirder: The code in production does work o.O |
# |
Jan 23rd 2020, 14:48 |
ndm |
@val That should happen automatically. |
# |
Jan 23rd 2020, 14:47 |
jotpe |
so should be correct |
# |
Jan 23rd 2020, 14:47 |
jotpe |
my table name for that is: ```invoice_itemgroups``` |
# |
Jan 23rd 2020, 14:46 |
neon1024 |
Shouldn’t that be InvoiceItemGroups? |
# |
Jan 23rd 2020, 14:46 |
neon1024 |
Might be this one? InvoiceItemgroups |
# |
Jan 23rd 2020, 14:45 |
slackebot |
<jotpe> |
# |
Jan 23rd 2020, 14:45 |
jotpe |
Hm. Yeah, @neon1024 I saved this nested. For some reason The query does not fail, if I comment out this part (of one method in RegistrationsTable): |
# |
Jan 23rd 2020, 14:41 |
slackebot |
<jotpe> |
# |
Jan 23rd 2020, 14:41 |
neon1024 |
I wonder if the query is containing other tables then? Perhaps you’ve typo’d one of those |
# |
Jan 23rd 2020, 14:41 |
slackebot |
<jotpe> |
# |
Jan 23rd 2020, 14:41 |
neon1024 |
Items belongsToMany Registrations? |
# |
Jan 23rd 2020, 14:41 |
jotpe |
The jointable is defined here: |
# |
Jan 23rd 2020, 14:40 |
jotpe |
Ah yeah, it's just a typo. My table is named items_registrations |
# |
Jan 23rd 2020, 14:40 |
neon1024 |
`items_registrations` perhaps |
# |
Jan 23rd 2020, 14:40 |
neon1024 |
Lower case `i` ? |
# |
Jan 23rd 2020, 14:39 |
jotpe |
Cake outputs this: Please try correcting the issue for the following table aliases: • *ItemsRegistrations* |
# |
Jan 23rd 2020, 14:38 |
jotpe |
My table is named: Items_registrations. |
# |
Jan 23rd 2020, 14:38 |
jotpe |
Hmmmm |
# |
Jan 23rd 2020, 14:38 |
neon1024 |
Which would mean you’re using SQL for a table which isn’t there, causing an SQL error I would guess |
# |
Jan 23rd 2020, 14:37 |
neon1024 |
Sounds like Cake cannot find your join table, and so is making an instance for you |
# |
Jan 23rd 2020, 14:36 |
jotpe |
`Could this be caused by using Auto-Tables?` `Some of the Table objects in your application were created by instantiating "*Cake\ORM\Table*" instead of any other specific subclass.` |
# |
Jan 23rd 2020, 14:35 |
jotpe |
What could cause an *Error:* SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; for a join table? |
# |
Jan 23rd 2020, 14:34 |
val |
@dereuromark? |