Rails - Apr 2011 - problem populating table using rake db:fixtures:load

I''m running Rails 3 and I''m trying to populate a table using
rake
db:fixtures:load, and I''m getting a "Could not find" file
error.

The table is called stores, and I''ve confirmed that it exists, and the
data is in stores.yml in my test/fixtures directory.  The command I''m
running is rake db:fixtures:load FIXTURES=stores.

The error message says that the file "st.yml" (i.e., not stores.yml)
can''t be found.  If I save the data as st.yml and rerun the command I
get a different error:

SQLite3::SQLException: no such table: st: DELETE FROM "st" WHERE 1=1

Thanks for any suggestions.

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I discovered that Rails 3 apparently needs the whole file name
specified, i.e., it should be FIXTURES=stores.yml

On Apr 26, 12:20 pm, jdq <d...-bLXs4TsB/m7ONtV85V9+QQ@public.gmane.org>
wrote:
> I''m running Rails 3 and I''m trying to populate a table
using rake
> db:fixtures:load, and I''m getting a "Could not find"
file error.
>
> The table is called stores, and I''ve confirmed that it exists, and
the
> data is in stores.yml in my test/fixtures directory.  The command
I''m
> running is rake db:fixtures:load FIXTURES=stores.
>
> The error message says that the file "st.yml" (i.e., not
stores.yml)
> can''t be found.  If I save the data as st.yml and rerun the
command I
> get a different error:
>
> SQLite3::SQLException: no such table: st: DELETE FROM "st" WHERE
1=1
>
> Thanks for any suggestions.
-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.