Sqlite problem

I have a simple table in a sqlite database called Unit with three fields: id, name and description.

When I try to execute any writable operation within the classess generated by the CRUD option in shell - like UPDATE or INSERT (DELETE works like a charm) - it gives me an internal server error with message:


SQL: SQLSTATE[23000]: Integrity constraint violation: 19 unit.name may not be NULL

sql log from profiler:

system.db.CDbCommand.execute(INSERT INTO 'unit' ("id") VALUES (NULL))

system.db.CDbCommand.query(PRAGMA table_info('unit'))

system.db.CDbCommand.query(PRAGMA foreign_key_list('unit'))

it looks like some sort of a bug, anyone? :unsure:

any1 ? :(