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:
error:
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'))