Problem of SQLite3::SQLException: SQL logic error or missing database

Question

SQLite3::SQLException: SQL logic error or missing database

error when do insert, update and delete operation to tables from browser( that means the create, update and destroy action is failed but the show action is fine ), the same operation in console is OK. I googled this problem and found most of the solutions is to remove duplication in the fixtures, so I removed all the test data from the fixture and restart the server, and it failed again:(
Any advise is appreciated.

Answer 1

It turned out that I forget use "sudo script/server" to get write permission to the database :)