-
Notifications
You must be signed in to change notification settings - Fork 219
Open
Description
Hello,
I have the following many to many relationship in my code:
{
"name": "newsCategory",
"verbose": "Kategorie",
"control": {
"select": true,
"multiple": true
},
"manyToMany": {
"link": {
"table": "newsCategory",
"parentPk": "News_ID",
"childPk": "Category_ID"
},
"ref": {
"table": "category",
"pk": "ID",
"columns": [
"Name"
]
}
},
"type": "varchar(255)",
"allowNull": false,
"listview": {
"show": true
},
"editview": {
"show": true
}
}but when I try to add a new 'News' entry, I get the error:
ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect integer value: '' for column 'News_ID' at row 1.
The entry still gets saved but not the 'newsCategory'. When I get back to edit it again I can choses categories and also save them without error.
It seems like there is a problem creating an entry and simultaneously using its (auto generated) ID as a foreign key...
Any ideas?
Metadata
Metadata
Assignees
Labels
No labels