[dorulk]

Hi,  I'm having a little problem with the n_n relation, when I add a new register to the app, this don't save the "products", (all other  information yes), but if I update this register I can save succesufully the "products"

 

this is the model:

 

[sharedmedia=core:attachments:865]

 

and this is my code:

 

 $crud = new grocery_CRUD();
 
        $crud->set_table('requisicion');
             
        $crud->set_subject('Requisición');
        
        $crud->set_relation_n_n('productos', 'requisicion_has_producto', 'producto', 'requisicion_id_requisicion', 'producto_id_producto','nom_producto','desc_productoxreq');
              
        $crud->set_relation('id_prioridad','prioridad','nom_prioridad');
          
        $crud->set_field_upload('adjunto','assets/uploads/files');
        
        $crud->fields('id_requisicion','id_prioridad','productos','des_requisicion','adjunto');
 
        $output = $crud->render();
 
        $this->_example_output($output);

Can anyone help me with this problem?

 

 

Best Regards!

 

[Amit Shah]

what are you trying to achieve in here? Are you trying to create new product or you saying you trying to add products to requisition? What is not getting saved ? ? products in relation table .. or details in product table... Sorry need to make stuff more clearer in order to reach to solution.!!

[dorulk]

Hi Amit, well 

 

 First I try to add a new requisition with two products (but this not work well), but when I edit this new requisition this work fine and new products are stored into the requisiton. I'm sending more pictures for explain, because my english vocabulary it's not good.

 

1.- New requisition and I try to add two products

[attachment=869:1_add.JPG]

 

2.- I can´t store products in a new requisition

[attachment=868:2_dontsaveproducts.JPG]

 

3.- If i edit the same requisition and add again the products

[attachment=867:3-edit.JPG]

 

4.- ...the products was storing fine in the requisition

[attachment=866:4_edit-save.JPG]

 

Thanks for your help

[dorulk]

Solved: It's a problem with the restriction in my db model, I deleted this and voila, all work fine!, thanks!

[flip]

Solved: It's a problem with the restriction in my db model, I deleted this and voila, all work fine!, thanks!

Dorulk I have the same problem, what restriction in db model, how do you solved it?

[voghDev]

I have the same problem. I have Article that has 1..N Categories, and I can't store Categories when adding, but yes when editing.

 

Please post details about the solution you found. (DB restriction, etc).

 

Thanks

[flip]

I deleted the constraint (key and foreign key) but when adding insert '0' in foreign key

[voghDev]

I deleted the constraint (key and foreign key) but when adding insert '0' in foreign key

 

Same here. I'm getting a 0 when adding, and correct value when editing.

[voghDev]

Hi again, still having the same issue after some research.

 

Can anyone post working code for table creation (SQL) + CRUD ?

 

Just like the one on the example:

 

http://www.grocerycrud.com/examples/set_a_relation_n_n

 

which seems to work adding/editing the 1..N field