# SQLite3::SQLException: id may not be null

**URL:** <https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400>\
**Category:** Rails\
**Created:** [September 30, 2009, 4:34am UTC](https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400 "2009-09-30T04:34:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [September 30, 2009, 4:34am UTC](https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400/1 "2009-09-30T04:34:15Z")

</div>

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:in`execute’  
./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:in`execute’  
./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:in`create\_without\_callbacks’

---

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [September 30, 2009, 9:16pm UTC](https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400/2 "2009-09-30T21:16:16Z")

</div>

bump

---

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [September 30, 2009, 9:23pm UTC](https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400/3 "2009-09-30T21:23:46Z")

</div>

On Wed, Sep 30, 2009 at 2:16 PM, John M.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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/](http://destiney.com/)

---

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [October 1, 2009, 7:25pm UTC](https://www.ruby-forum.com/t/sqlite3-id-may-not-be-null/176400/4 "2009-10-01T19:25:02Z")

</div>

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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)