Odd error with sqlite3 adaptor

Rails
1

Any idea what would cause this?

icps = Icp.find(:all)
ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported file
format:
SELECT * FROM icps
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
d/connection_adapters/abstract_adapter.rb:120:in log' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/connection_adapters/sqlite_adapter.rb:137:inexecute’
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
d/connection_adapters/sqlite_adapter.rb:329:in catch_schema_changes' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/connection_adapters/sqlite_adapter.rb:137:inexecute’
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
d/connection_adapters/sqlite_adapter.rb:157:in select_all' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/base.rb:390:infind_by_sql’
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
d/base.rb:924:in find_every' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/base.rb:381:infind’
from (irb):2

Thanks,
Mike

2

does the sqlite3 command line successfully open the db?

-faisal

3

Faisal N Jawdat wrote:

does the sqlite3 command line successfully open the db?

Yes, it does. No problems at all in querying the schemas, selecting
rows, etc.

4

I found the issue.

I created the db with sqlite3 3.3.8, and the gem was built against
3.3.10. Apparently sqlite’s backwards compatability isn’t what it
claims to be.

Mike