Mysql - "column cannot be null"

Question

as you see in the header, even if I removed the non-null function from the associated field, it still does not allow me to insert a null value for this field, although the field is NULL!

Any help would be appreciated.

EDITED

Create:

CREATE TABLE `review` ( .. `RATING` int(11) DEFAULT NULL, .. (`CATALOG_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=31625 DEFAULT CHARSET=latin5 ROW_FORMAT=DYNAMIC 

Query:

 INSERT INTO review (RATING,..) VALUES (null,..); 

Error message:

 Error: Column 'RATING' cannot be null SQLState: 23000 ErrorCode: 1048 

I am also trying to insert without RATING into the insert request, even if this default field is null and nullable, it gives the same error message and never inserts the field.

Answer 1

Czech, thanks for watching. You are right, I realized that there is a trigger for the insert action that affects the related area. I turn off the trigger and the error goes away. Thanks.