SQLite3::SQLException: id may not be null

Rails
1

I am getting the following error using sqlite3. If I ran the same query
directly in sqlite3 client, the data is saved without error. Same is
happening for every table during inserts.

SQLite3::SQLException: sessions.id may not be NULL: INSERT INTO sessions
(“updated_at”, “session_id”, “data”) VALUES(‘2009-09-30 02:28:45’,
‘3461077be365d88468352a6172c27793’,
‘BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo
SGFzaHsABjoKQHVzZWR7AA==
‘)
./script/…/config/…/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:139:in
log' ./script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:154:inexecute’
./script/…/config/…/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:361:in
catch_schema_changes' ./script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:154:inexecute’
./script/…/config/…/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:169:in
insert' ./script/../config/../vendor/rails/activerecord/lib/active_record/base.rb:1862:increate_without_callbacks’

2

bump

3

On Wed, Sep 30, 2009 at 2:16 PM, John M.
[email protected] wrote:

bump

If you bump you should include the original question. Peeps reading
your post as list-serve email are clueless otherwise.

–
Greg D.
http://destiney.com/

4

I’d say there’s probably something wrong with your session table
schema - is id declared as an autoincrement field?

–Matt J.

On Sep 29, 10:34 pm, John M. [email protected]