New CI 1.7 session class database error

[eluser]Unknown[/eluser]
The problem is that MySQL is running in Strict mode (http://dev.mysql.com/doc/refman/5.0/en/s...-mode.html). Under strict mode, MySQL doesn't allow not null fields to be left empty. You have 3 options: 1) Disable strict mode in MySQL. I wouldn't recommend this if you are writing an application to redistribute. You never know what settings the other systems have. 2) Setting a default value for fields that are set as not null. For numeric fields you can set the value to 0. For text field, you can't set a default value so you will need to set it to null. 3) When inserting values to the database what you can do is insert an empty string for text fields.

INSERT INTO test
(varaible, value, empty_field)
VALUES ('test', 'hello', ''),
('text2', '', '');

Hope this helps.