SQLite3 Exception: SQL logic error or missing database

By vijay on June 25, 2008 — 1 min read

So this morning I was trying to update a testing machine with my shiny new Rails app.

  • Remove the sqlite database – CHECK
  • run rake db:migrate – CHECK
  • start the application

Now there were no errors anywhere. But I still get:

SQLite3::SQLException: SQL logic error or missing database

After usual googling around and trying to fix it I just saw what the problem with the Query is. The reason for the exception is putting a ‘NULL’ into non NULL column. And SQLite says “missing database”. Way to write the exceptions.

Note to Self: Always write meaningful or at least non-misleading exception messages.

Posted in: Programming

Leave a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.