Tutorial: Manage relational tables get error: Field 'ItemGenreID' doesn't have a default value

I've followed the tutorial: Manage relational tables (http://www.webassist.com/community/tutorials/view_tutorial.php?tutorial=Manage-relational-tables) several times now, exactly as it says each time. But get error message: "Field 'ItemGenreID' doesn't have a default value" when I press the insert button.
Why so?

This means you have a column named ItemGenreID in your database that doesn't allow null and doesn't have a default value set in the database and you aren't setting a value when you do the insert. You would either have to update the database to allow null for that column, give it a default value, or set a value when you do the insert.

If so, can you please update the tutorial - because, as I told you before - I have followed the tutorial and used the database included.

The tutorial .sql file for creating the database has a default set for the ItemGenreID column in the table:

CREATE TABLE `itemgenres` (
`ItemGenreID` int(10) NOT NULL auto_increment,

For some reason your table import didn't take the auto_increment setting when you ran the .sql file to create the database tables. Update that column to be an auto_increment in your database like the tutorial should have done and it should fix this issue.

Unfortunately, I do not get it to work. Insert does not work, but update works. ItemGenreItemID is not written for any reason.
I have struggle with this for a couple of days now, and I want it to work.

Your server behaviors are in the wrong order on the insert page. The single insert has to be above the multiple insert since the multiple insert uses the Session variable saved when the insert takes place.

Move lines 33-49 up above line 3 on the insert page and that should correct that problem.

Oh well, beginner mistake! Now that's more like it. But one problem remains. How do I delete everything that is connected? When I now delete an Item - this is deleted from the Item table, but not the links in the itemgenres table.

Apply a second delete server behavior to delete the items from the second table.