Sqlite3.3.7 gives "SQL logic error or missing database"


I ported a working project to a new hard drive, and had such a pleasant
afternoon with this issue:


The bug report says the problem is pilot error.

However, I get the bug before querying anything. I get it especially
annoyingly from test_dummy with nothing in it. The bug refers to the
below setup():

SQLite3::SQLException: SQL logic error or missing database
check' /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:76:incheck’
commence' /var/lib/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:61:ininitialize’

I think I have this bug:


Here’s the potential cause:

"I got the same message. The problem was there were files in test/unit
models that had been deleted. You’ll get the same message if you run a
single test, e.g. if you have a file test/unit/foo_test.rb but no table
foos typing the shell command

% ruby test/unit/foo_test.rb

will give the same error."

So when I move all my non-Model unit tests out of the unit test folder,
put them into the functional folder, and everything works.

So that doesn’t appear to be pilot error, huh, if all these tests work
with MySQL for the test database, and if all these tests worked fine
slightly older version ticks.

Some version dumps:

rails (1.2.3)
sqlite3-ruby ( (This is _why’s sensibility repack.)
ZenTest (3.6.0)

Using the latest sqlite3-ruby, and the one that came with my Fiesty
also didn’t help.

Should we open a bug ticket for this?

“Test Driven Ajax (on Rails)”
assert_xpath, assert_javascript, & assert_ajax

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs