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.