What version of the gem are you using? 1.2.4? I'm assuming you compiled ruby yourself based off of its location, did you compile sqlite as well or get it through your OS package manager? In either case, I've found you'll need the sqlite header files for the gem to work correctly. In your package manager they're probably called sqlite-devel or something like that.
Dave On Tue, Jun 9, 2009 at 8:26 AM, Eric Mill<kproject...@gmail.com> wrote: > Are the permissions on the file set right? What happens if you try to > access the file with rhe sqlite3 command line tool and run the query > yourself? > > -- Eric > > On Tue, Jun 9, 2009 at 6:35 AM, Dave Everitt<dever...@innotts.co.uk> wrote: >> Any feedback appreciated on the following. My most recent attempt to >> identify the issue is a minimal Ruby/SQLite/ActiveRecord script, Pastied >> here: http://pastie.textmate.org/492514 which brings up the following when >> run from the command line (an empty database file already exists): >> >> $ ./simple_db.rbx >> [SNIP]/active_record/connection_adapters/sqlite3_adapter.rb:29:in >> `table_structure': Could not find table 'users' >> (ActiveRecord::StatementInvalid) >> from >> /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_support/core_ext/object/misc.rb:39:in >> `returning' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in >> `table_structure' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:213:in >> `columns' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1276:in >> `columns' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:3008:in >> `attributes_from_column_definition_without_lock' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/locking/optimistic.rb:66:in >> `attributes_from_column_definition' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2435:in >> `initialize' >> from ./simple_db.rbx:10:in `new' >> from ./simple_db.rbx:10 >> >> The adapted blog example code I want to run for my students as an example is >> Pastied at: http://pastie.org/492517 so I'd appreciate the identification of >> any glaring errors (currently Camping 1.5 under plain CGI): >> >> The errors in the server log read: >> [SNIP]/activerecord-2.3.2/lib/active_record/connection_adapters/abstract_adapter.rb:212:in >> `log': SQLite3::SQLException: unable to open database file: CREATE TABLE >> "blogtiny_schema_infos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, >> "version" float) (ActiveRecord::StatementInvalid) >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in >> `execute' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:402:in >> `catch_schema_changes' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in >> `execute' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:114:in >> `create_table' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in >> `send' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in >> `method_missing' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in >> `say_with_time' >> from /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in >> `say_with_time' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:348:in >> `method_missing' >> from (eval):71:in `create_schema' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in >> `instance_eval' >> from >> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in >> `define' >> from (eval):70:in `create_schema' >> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:71:in >> `create' >> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:77 >> [Thu May 28 12:18:13 2009] [error] [client 127.0.0.1] malformed header from >> script. Bad header=-- create_table("blogtiny_sche: >> /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx >> >> Note the odd truncation of 'blogtiny_sche' in the final line. >> >> And one dumb question: >> I don't have to 'require sqlite3-ruby', right? >> >> Dave >> >> _______________________________________________ >> Camping-list mailing list >> Camping-list@rubyforge.org >> http://rubyforge.org/mailman/listinfo/camping-list >> > _______________________________________________ > Camping-list mailing list > Camping-list@rubyforge.org > http://rubyforge.org/mailman/listinfo/camping-list > -- Dave _______________________________________________ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
