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