MYSQL query error when adding new record to related entity

[aagency]

Hi

I need to link 2 separate entities.
I need a one-to-many connection.

I've setup the two entities.
Then I add an "entity" field with dropdown and multiselect.

If I link existing entities there is no problem, and I also can add new record.
If instead I need to create a new record when no other record is connected I got a Mysql error showing

Here you can see a short video where I replicate the issue

https://www.loom.com/share/efb76f01a69f ... b1e6a4de09

[p.dimitrov]

Same issue happening to me in 3.4.2 . It happens only with multiselect dropdown. I suspect it has something to do with the new 'edit record' functionality. Any solution to this?

[support]

File from archive replace to includes\classes\fieldstypes\
Let me know if it works ok now.

[p.dimitrov]

Thanks, it is fixed. Similar thing is happening for entity-drop down list(ajax). If new record is added with the plus icon, it is not automatically selected in list after creation, you must select it manually from the list.