[Blacklight-development] ActiveRecord::StatementInvalid in CatalogController#index

[Levy, Michael]

I'm completely new to Ruby, Rails, and of course Blacklight.  I think I have most of the parts in place, running the standard install with Jetty (which is working with the SolrMarc demo data) and sqlite3.

Now I'm seeing the app home screen in the browser, and when I attempt a search, I see the error message on the web page:

ActiveRecord::StatementInvalid in CatalogController#index
SQLite3::CantOpenException: unable to open database file: INSERT INTO "searches" ("created_at", "updated_at", "user_id", "query_params") VALUES('2010-08-24 19:54:39', '2010-08-24 19:54:39', NULL, '---
:search_field: all_fields
:action: index
:q: book
:controller: catalog
')

I see there is a database file set up:

sqlite3 /var/www/html/dc/foo/db/development.sqlite3 "select * from sqlite_master"
table|schema_migrations|schema_migrations|2|CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
index|unique_schema_migrations|schema_migrations|3|CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
table|sqlite_sequence|sqlite_sequence|5|CREATE TABLE sqlite_sequence(name,seq)
table|bookmarks|bookmarks|6|CREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "url" text, "document_id" varchar(255), "title" varchar(255), "notes" text, "created_at" datetime, "updated_at" datetime)
table|tags|tags|7|CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))
table|taggings|taggings|9|CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "created_at" datetime)
index|index_taggings_on_tag_id|taggings|11|CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")
index|index_taggings_on_taggable_id_and_taggable_type|taggings|12|CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type" ON "taggings" ("taggable_id", "taggable_type")
table|searches|searches|13|CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "created_at" datetime, "updated_at" datetime)
index|index_searches_on_user_id|searches|14|CREATE INDEX "index_searches_on_user_id" ON "searches" ("user_id")
table|users|users|4|CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255) NOT NULL, "email" varchar(255), "crypted_password" varchar(255), "last_search_url" text, "last_login_at" datetime, "created_at" datetime, "updated_at" datetime, "password_salt" varchar(255), "persistence_token" varchar(255), "current_login_at" datetime)

I don't know much about rails, for example, how the development/test/production models work -- maybe that is related.  Anyhow .. any help appreciated  Thanks!