Hi,
To disable the error when inserting a row without specifying all columns you can disable the strict mode in mysql.
To check if strict mode is enabled you can run the following query:
SELECT @@SQL_MODE
Please check if any of these values is present:
TRADITIONAL, STRICT_TRANS_TABLES, STRICT_ALL_TABLES
If any of them is present please try changing the sql mode without including it.
To change this option you can edit the configuration file (my.cnf) and set the variable:
sql-mode=""
Hope this helps!
Best regards,
Natalia