On May 9, 11:39 am, Frederick Cheung <[email protected]>
wrote:
> On May 9, 6:40 am, Brian <[email protected]> wrote:
>
> > SQLite3::SQLException: table caches has no column named structure:
> > INSERT INTO "
> > caches" ("structure", "capacity") VALUES (NULL, 1)
>
> when does this happen ? when running one of the previously mentionned
> commands, when running the units tests, at some other time ?
>

I get this when trying to load fixtures, or when trying to run a unit
test:
>ruby unit/cache_test.rb
Loaded suite unit/cache_test
Started
E
Finished in 0.305 seconds.

  1) Error:
test_the_truth(CacheTest):
ActiveRecord::StatementInvalid: SQLite3::SQLException: table caches
has no colum
n named structure: INSERT INTO "caches" ("structure", "capacity")
VALUES (NULL,
1)

> well first off, definitely worth checking if your test database has
> all the columns you expect.

That's a good idea.  I figured out where to pick up the SQLite console
today so that I could do just that:

>sqlite3.exe db/test.sqlite3
sqlite> .schema caches
CREATE TABLE "caches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT
NULL, "capacit
y" integer, "structure_id" integer, "created_at" datetime,
"updated_at" datetime
);

So no surprises here.  The structure_id column is there as I would
expect.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to