Multiple m:n fields in one form about yii2-relation-trait HOT 5 CLOSED

Could you give me your schema / mysql dump?? I've tried on sakila db and it's fine..

Sorry, I don't really get you issue.. What is the error and what it should be?

I'm currently doing this relation-trait by the way..

from yii2-relation-trait.

Sorry, my english is not at best... However as you can see I attached a test database. There are 5 tables:
persons, country, countries, language, languages and several relations. Basically the countries and languages tables are the m:n raltion tables.

Now...everything works fine, as you can see, I created some persons with related data as countries and languages. The problem is, that if I try to update a person and remove for example all the related countries, than try to save it, nothing happens. I mean...everything seems to be ok, no error message, redirecting to the view page, etc. but when I reload the page all the countries are still there. If I remove only one item, everything is fine, the problem occurs only if I remove all the items of one related table.

Also, everything works fine when I remove all the items of both related tables and even if one of the realted tables is already empty. However you can reproduce the issue by creating a person in my attached example. Then relate two countries and two languages. Next, save it. Everything should work. Now try to remove both related countries for example and try to save. As you can see, saving seems to be successfully but the removed countries are still there (no error message).

All the models, controller and views I created with IO Generator of gii

About the "fields" array mentioned in my first post here: in my opinion this should be automatically fixed at the moment when you implement the "composite primary key" as discussed in my other post, so don't care about that.
Thank you for your support and your great work!

test.sql.zip

from yii2-relation-trait.

Thanks!

from yii2-relation-trait.

Hello mootensai

I unfortunately think I found another mistake. In the attached example I have 4 tables: main (the main table), sub1 (first n:m relation), sub2 (second n:m relation), persons (the target table of the n:m relations).
All the models, controller and views I created with IO Generator of gii and leaved them untouched.

Now if you try to go the main view in yii2 everything works fine, as long as I put in values for only one subquery. At the moment I try to put in values for subquery1 and subquery2 it fails with this error message:

SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 3 column(s)
The SQL being executed was: DELETE FROM sub2 WHERE (mainid=1) AND ((mainid, personsid, somevalue) NOT IN (('1','1'), ('1','2'), ('1','3'), ('1','2','23')))

example.sql.zip

Greez

from yii2-relation-trait.

What function do you use?
Please create another issue because it seems like another problem

from yii2-relation-trait.