| # |
Oct 1st 2016, 14:02 |
 ndm |
@thinkingmedia By creating the routes completely on your own, or by modifying the default resource map for `RouteBuilder::resources()` so that the path doesn't contain any ID route elements, like https://gist.github.com/ndm2/30c59b00326c4d5fd71a5237b9d73527 |
| # |
Oct 1st 2016, 13:48 |
sandeep_ |
Hi |
| # |
Oct 1st 2016, 13:29 |
thinkingmedia |
How can I create a REST resource that can `update` and `delete` without an `ID`? |
| # |
Oct 1st 2016, 13:12 |
prophet |
'foreignKey' => 'user_id' that is wrong. It has to be 'association_id'. That fixed it. Thanks hmic. |
| # |
Oct 1st 2016, 13:11 |
prophet |
Oh wait. |
| # |
Oct 1st 2016, 13:10 |
prophet |
yes, that is what I did |
| # |
Oct 1st 2016, 13:08 |
hmic |
in the belongstomany one |
| # |
Oct 1st 2016, 13:08 |
prophet |
You mean: 'foreignKey' => 'user_id' ? Nothing changed |
| # |
Oct 1st 2016, 13:06 |
hmic |
so you need to add the corect association keys |
| # |
Oct 1st 2016, 13:03 |
prophet |
Column not found: 1054 Unknown column 'UserAssociation.member_id' in 'field list' |
| # |
Oct 1st 2016, 13:03 |
prophet |
Yes, it does. I called 'ManyUsers' 'Members'. I get a Database Error. |
| # |
Oct 1st 2016, 12:59 |
hmic |
makes sense, does it? |
| # |
Oct 1st 2016, 12:59 |
hmic |
and you do need to contain both, if you want both, so contain => ['Users', 'ManyUsers'] |
| # |
Oct 1st 2016, 12:59 |
hmic |
so : belongsTo('Users'), belongsToMany('ManyUsers') |
| # |
Oct 1st 2016, 12:58 |
hmic |
first you even need to call the associations differently |
| # |
Oct 1st 2016, 12:58 |
hmic |
prophet, you need to add a propertyName key to the belongsTo(Many) definitions(s) |
| # |
Oct 1st 2016, 12:48 |
prophet |
My AssociationsTable is linked to Users via belongsTo and belongsToMany. But only the belongsToMany relation is loaded when I get the association with 'contain' => ['Users']. http://pastebin.com/7QPkKRiQ What should I check to get it working? |
| # |
Oct 1st 2016, 12:30 |
cakephp861 |
Friends help |
| # |
Oct 1st 2016, 12:24 |
cakephp861 |
I mean what kind of table association i have to use: 1) course and student or 2)course and users |
| # |
Oct 1st 2016, 12:23 |
cakephp861 |
Hi, I need help in setup Many to many relation. I have two kind of users(admin, student), Student can opt for courses. So for Many to many relation we should courses_students or courses_users. As using auth we can get user_id easyly |
| # |
Oct 1st 2016, 12:14 |
hmic |
welcome |
| # |
Oct 1st 2016, 12:11 |
maikh |
dumbass |
| # |
Oct 1st 2016, 12:11 |
maikh |
it needed the plurals 'S' |
| # |
Oct 1st 2016, 12:11 |
maikh |
it was a naming problem. :slightly_smiling_face: |
| # |
Oct 1st 2016, 12:11 |
maikh |
oh... now it works. |
| # |
Oct 1st 2016, 12:09 |
maikh |
hm, i dont understand. i have some more n:m associations that works. but only this one not... |
| # |
Oct 1st 2016, 12:02 |
hmic |
i'd suggest naming the jointable manually in those relations |
| # |
Oct 1st 2016, 11:58 |
maikh |
hm, i think there is something more wrong. |
| # |
Oct 1st 2016, 11:55 |
maikh |
http://pastebin.com/VNnBXsAF |
| # |
Oct 1st 2016, 11:54 |
hmic |
what did solve it? |
| # |
Oct 1st 2016, 11:54 |
maikh |
yes, sorry. this is solved. :slightly_smiling_face: |
| # |
Oct 1st 2016, 11:50 |
hmic |
you asked about a table not beeing found |
| # |
Oct 1st 2016, 11:50 |
hmic |
this is not the problem you asked for in the beginning |
| # |
Oct 1st 2016, 11:49 |
maikh |
yes, they are. and in ```$this->request->data['floors'], ['floorsmovein'] there are the selected ids. but nothing goes into my databasetables. ```$this->Forms->patchEntity($form, $this->request->data, [ 'associated' => [ 'Rooms','Floors','Floorsmovein','Specialremovals', 'Dismantles', 'Assembles' ] ]);``` |
| # |
Oct 1st 2016, 11:46 |
hmic |
you tell me! |
| # |
Oct 1st 2016, 11:45 |
maikh |
@hmic hm... floors_forms and floorsmovein_forms are my joinTables arent they? |
| # |
Oct 1st 2016, 11:44 |
hmic |
!tell maikh about gist |
| # |
Oct 1st 2016, 11:43 |
hmic |
show the schema, show the code, explain from there |
| # |
Oct 1st 2016, 11:43 |
hmic |
still your text example does not reveal your current database setup or actual problem. |
| # |
Oct 1st 2016, 11:43 |
hmic |
you need a jointable for belongsToMany to work. even if its a self-relation (afaiu) |
| # |
Oct 1st 2016, 11:39 |
slackebot |
i think, but nothing is saved in floorsmovein_forms. |