thr3ads.net - Rails - rake aborted! Could not find table ... [Jul 2008]

If this information is useful, please help other people find it:
Share via:

anteaya

2008-Jul-01 17:34 UTC

rake aborted! Could not find table ...

I am getting a rake aborted error and I suspect that I am missing a
package on my system since the app works for a friend on this
computer.

Here is the terminal output of the error:

anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
(in /home/anita/sandbox/shovell)
rake aborted!
Could not find table ''stories''

(See full trace by running task with --trace)
anita@anitas-computer:~/sandbox/shovell$


Here is the contents of the migration file:

anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
20080701040248_create_stories.rb
class CreateStories < ActiveRecord::Migration
  def self.up
    create_table :stories do |t|
      t.text :name
      t.text :link

      t.timestamps
    end
  end

  def self.down
    drop_table :stories
  end
end
anita@anitas-computer:~/sandbox/shovell/db/migrate$

Here is the stack trace:

anita@anitas-computer:~/sandbox/shovell$ rake db:migrate --trace
(in /home/anita/sandbox/shovell)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump
rake aborted!
Could not find table ''stories''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
connection_adapters/sqlite3_adapter.rb:29:in `table_structure''
/usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/
core_ext/object/misc.rb:28:in `returning''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
connection_adapters/sqlite3_adapter.rb:28:in `table_structure''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
connection_adapters/sqlite_adapter.rb:189:in `columns''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:75:in `table''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:70:in `tables''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:61:in `each''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:61:in `tables''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:23:in `dump''
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
schema_dumper.rb:17:in `dump''
/usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:219
/usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:
218:in `open''
/usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:218
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
`invoke_with_call_chain''
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
`invoke_with_call_chain''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke''
/usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:100
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
`invoke_with_call_chain''
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
`invoke_with_call_chain''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in
`invoke_task''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
`standard_exception_handling''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
`standard_exception_handling''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run''
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31
/usr/bin/rake:19:in `load''
/usr/bin/rake:19
anita@anitas-computer:~/sandbox/shovell$

Any thoughts about what file or package is missing to cause this
situation, are gratefully received.  Thank you,
Anita.
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

\"Wolas!\"

2008-Jul-01 20:58 UTC

head link

Re: rake aborted! Could not find table ...

an you put the database.yml file too?

the migrations seems fine, and as you said it works on someone else''s
computer.

On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> I am getting a rake aborted error and I suspect that I am missing a
> package on my system since the app works for a friend on this
> computer.
>
> Here is the terminal output of the error:
>
> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
> (in /home/anita/sandbox/shovell)
> rake aborted!
> Could not find table ''stories''
>
> (See full trace by running task with --trace)
> anita@anitas-computer:~/sandbox/shovell$
>
> Here is the contents of the migration file:
>
> anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
> 20080701040248_create_stories.rb
> class CreateStories < ActiveRecord::Migration
>   def self.up
>     create_table :stories do |t|
>       t.text :name
>       t.text :link
>
>       t.timestamps
>     end
>   end
>
>   def self.down
>     drop_table :stories
>   end
> end
> anita@anitas-computer:~/sandbox/shovell/db/migrate$
>
> Here is the stack trace:
>
> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate --trace
> (in /home/anita/sandbox/shovell)
> ** Invoke db:migrate (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Execute db:migrate
> ** Invoke db:schema:dump (first_time)
> ** Invoke environment
> ** Execute db:schema:dump
> rake aborted!
> Could not find table ''stories''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> connection_adapters/sqlite3_adapter.rb:29:in `table_structure''
> /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/
> core_ext/object/misc.rb:28:in `returning''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> connection_adapters/sqlite3_adapter.rb:28:in `table_structure''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> connection_adapters/sqlite_adapter.rb:189:in `columns''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:75:in `table''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:70:in `tables''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:61:in `each''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:61:in `tables''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:23:in `dump''
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
> schema_dumper.rb:17:in `dump''
> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:219
> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:
> 218:in `open''
> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:218
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`execute''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`execute''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
> `invoke_with_call_chain''
> /usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
> `invoke_with_call_chain''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke''
> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:100
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`execute''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`execute''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
> `invoke_with_call_chain''
> /usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
> `invoke_with_call_chain''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in
> `invoke_task''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_level''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_level''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
> `standard_exception_handling''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in
`top_level''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
> `standard_exception_handling''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run''
> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31
> /usr/bin/rake:19:in `load''
> /usr/bin/rake:19
> anita@anitas-computer:~/sandbox/shovell$
>
> Any thoughts about what file or package is missing to cause this
> situation, are gratefully received.  Thank you,
> Anita.--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---

Anita Kuno

2008-Jul-02 02:09 UTC

head link

Re: rake aborted! Could not find table ...

Wolas!:

Thanks for the reply.  As requested, database.yml:

anita@anitas-computer:~/sandbox/shovell/config$ cat database.yml
# SQLite version 3.x
#   gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
  adapter: sqlite3
  database: db/development.sqlite3
  timeout: 5000

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: sqlite3
  database: db/test.sqlite3
  timeout: 5000

production:
  adapter: sqlite3
  database: db/production.sqlite3
  timeout: 5000
anita@anitas-computer:~/sandbox/shovell/config$



On Tue, Jul 1, 2008 at 4:58 PM, Wolas!
<jcpenche-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:>
> an you put the database.yml file too?
>
> the migrations seems fine, and as you said it works on someone
else''s
> computer.
>
> On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> I am getting a rake aborted error and I suspect that I am missing a
>> package on my system since the app works for a friend on this
>> computer.
>>
>> Here is the terminal output of the error:
>>
>> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
>> (in /home/anita/sandbox/shovell)
>> rake aborted!
>> Could not find table ''stories''
>>
>> (See full trace by running task with --trace)
>> anita@anitas-computer:~/sandbox/shovell$
>>
>> Here is the contents of the migration file:
>>
>> anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
>> 20080701040248_create_stories.rb
>> class CreateStories < ActiveRecord::Migration
>>   def self.up
>>     create_table :stories do |t|
>>       t.text :name
>>       t.text :link
>>
>>       t.timestamps
>>     end
>>   end
>>
>>   def self.down
>>     drop_table :stories
>>   end
>> end
>> anita@anitas-computer:~/sandbox/shovell/db/migrate$
>>
>> Here is the stack trace:
>>
>> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate --trace
>> (in /home/anita/sandbox/shovell)
>> ** Invoke db:migrate (first_time)
>> ** Invoke environment (first_time)
>> ** Execute environment
>> ** Execute db:migrate
>> ** Invoke db:schema:dump (first_time)
>> ** Invoke environment
>> ** Execute db:schema:dump
>> rake aborted!
>> Could not find table ''stories''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> connection_adapters/sqlite3_adapter.rb:29:in `table_structure''
>> /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/
>> core_ext/object/misc.rb:28:in `returning''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> connection_adapters/sqlite3_adapter.rb:28:in `table_structure''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> connection_adapters/sqlite_adapter.rb:189:in `columns''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:75:in `table''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:70:in `tables''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:61:in `each''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:61:in `tables''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:23:in `dump''
>> /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/
>> schema_dumper.rb:17:in `dump''
>> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:219
>> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:
>> 218:in `open''
>> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:218
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`call''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`execute''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`each''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`execute''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
>> `invoke_with_call_chain''
>> /usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
>> `invoke_with_call_chain''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in
`invoke''
>> /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:100
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`call''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`execute''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`each''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`execute''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
>> `invoke_with_call_chain''
>> /usr/lib/ruby/1.8/thread.rb:135:in `synchronize''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
>> `invoke_with_call_chain''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in
`invoke''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in
>> `invoke_task''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_level''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`each''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_level''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
>> `standard_exception_handling''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in
`top_level''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in
`run''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
>> `standard_exception_handling''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in
`run''
>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31
>> /usr/bin/rake:19:in `load''
>> /usr/bin/rake:19
>> anita@anitas-computer:~/sandbox/shovell$
>>
>> Any thoughts about what file or package is missing to cause this
>> situation, are gratefully received.  Thank you,
>> Anita.
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails Terrorist

2008-Jul-02 04:07 UTC

head link

Re: rake aborted! Could not find table ...

Your migration asked to create new table that is stories but the error 
said like it were wanting to modify table stories. please check your 
schema.rb or previous migration files. Is there any syntax that want to 
modify stories table? and check also your migration version in schema.rb 
and in your table.

Reinhart
http://teapoci.blogspot.com
-- 
Posted via http://www.ruby-forum.com/.

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

Frederick Cheung

2008-Jul-02 06:55 UTC

head link

Re: rake aborted! Could not find table ...

On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> I am getting a rake aborted error and I suspect that I am missing a
> package on my system since the app works for a friend on this
> computer.
>
> Here is the terminal output of the error:
>
> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
> (in /home/anita/sandbox/shovell)
> rake aborted!
> Could not find table ''stories''
>
> (See full trace by running task with --trace)
> anita@anitas-computer:~/sandbox/shovell$
>
> Here is the contents of the migration file:
>
> anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
> 20080701040248_create_stories.rb
What makes you think that this migration is the problem? Do any other
migrations reference stories?

Fred

--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---

\"Wolas!\"

2008-Jul-02 09:02 UTC

head link

Re: rake aborted! Could not find table ...

The migration is fine. if the tabls stories was already there it would
have complained about it. bu the error is the opposite:

Could not find table ''stories''

it defenitely seems like youre modifying the table before you have
created it.

My only suggestion here is make sure you have the development packages
for sqlite3 as well as the client ones.


I ran out of ideas at this point.

j

On Jul 2, 7:55 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
>
>
> > I am getting a rake aborted error and I suspect that I am missing a
> > package on my system since the app works for a friend on this
> > computer.
>
> > Here is the terminal output of the error:
>
> > anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
> > (in /home/anita/sandbox/shovell)
> > rake aborted!
> > Could not find table ''stories''
>
> > (See full trace by running task with --trace)
> > anita@anitas-computer:~/sandbox/shovell$
>
> > Here is the contents of the migration file:
>
> > anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
> > 20080701040248_create_stories.rb
>
> What makes you think that this migration is the problem? Do any other
> migrations reference stories?
>
> Fred--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---

Russell Norris

2008-Jul-02 11:19 UTC

head link

Re: rake aborted! Could not find table ...

you might also want to check config/environment.rb for anything that might
be preloading or reading from the stories. I tried some cleverness like this
once and it burped a similar error when migrating up from zero.

RSL

On Wed, Jul 2, 2008 at 5:02 AM, Wolas!
<jcpenche-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> The migration is fine. if the tabls stories was already there it would
> have complained about it. bu the error is the opposite:
>
> Could not find table ''stories''
>
> it defenitely seems like youre modifying the table before you have
> created it.
>
> My only suggestion here is make sure you have the development packages
> for sqlite3 as well as the client ones.
>
>
> I ran out of ideas at this point.
>
> j
>
> On Jul 2, 7:55 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> wrote:
> > On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> >
> >
> >
> > > I am getting a rake aborted error and I suspect that I am missing
a
> > > package on my system since the app works for a friend on this
> > > computer.
> >
> > > Here is the terminal output of the error:
> >
> > > anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
> > > (in /home/anita/sandbox/shovell)
> > > rake aborted!
> > > Could not find table ''stories''
> >
> > > (See full trace by running task with --trace)
> > > anita@anitas-computer:~/sandbox/shovell$
> >
> > > Here is the contents of the migration file:
> >
> > > anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
> > > 20080701040248_create_stories.rb
> >
> > What makes you think that this migration is the problem? Do any other
> > migrations reference stories?
> >
> > Fred
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Mojca Miklavec

2008-Jul-02 17:30 UTC

head link

Re: rake aborted! Could not find table ...

I experience exactly the same problem. It works on my computer (using 
MySQL), but fails on another one (using sqlite3).

database.yml:

 development:
  adapter: sqlite3
  database: db/development.sqlite3
  timeout: 5000

I have two migration files:
 20080701141405_create_commands.rb
 20080701142511_add_content_to_database.rb

First one:

  def self.up
    create_table :commands do |t|
      t.string :name
      t.text :xml
      t.timestamps
    end
  end

  def self.down
    drop_table :commands
  end

Second one:

  def self.up
    # here is a loop that fetches external data
        Command.create(
          :name => name,
          :xml => xml_string
        )
    # end of loop
  end

  def self.down
    Command.delete_all
  end

The first one works OK, but the second migration fails with
 rake aborted!
 Could not find table ''commands''

If I try to create another "create table" statement, then it complains
with

 rake aborted!
 SQLite3::SQLException: table "commands" already exists: CREATE TABLE 
"commands" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"name"
varchar(255) DEFAULT NULL NULL, "xml" text DEFAULT NULL NULL, 
"created_at" datetime DEFAULT NULL NULL, "updated_at"
datetime DEFAULT
NULL NULL)

I''m clueless. I don''t set anything in environment.rb by
myself.

I had some problems installing rails

Thanks a lot,
   Mojca

If that matters, I had some problems installing latest version of gems, 
but that got resolved:
> gem update --systemUpdating RubyGems...
Bulk updating Gem source index for: http://gems.rubyforge.org
Attempting remote update of rubygems-update
ERROR:  While executing gem ... (Gem::GemNotFoundException)
    Could not find rubygems-update (> 0) in any repository
> gem envRubyGems Environment:
  - VERSION: 0.9.2 (0.9.2)
  - INSTALLATION DIRECTORY: /usr/lib/ruby/gems/1.8
  - GEM PATH:
     - /usr/lib/ruby/gems/1.8
  - REMOTE SOURCES:
     - http://gems.rubyforge.org
> sudo mv /usr/lib/ruby/gems/1.8/source_cache /tmp
> sudo gem update --systemUpdating RubyGems...
Bulk updating Gem source index for: http://gems.rubyforge.org
Attempting remote update of rubygems-update
ERROR:  While executing gem ... (Gem::GemNotFoundException)
    Could not find rubygems-update (> 0) in any repository
> sudo gem install rubygems-updateBulk updating Gem source index for: http://gems.rubyforge.org
Successfully installed rubygems-update-1.2.0
> sudo gem update --systemUpdating RubyGems...
Attempting remote update of rubygems-update
Successfully installed rubygems-update-1.2.0
Updating version of RubyGems to 1.2.0
Installing RubyGems 1.2.0
mkdir -p /usr/lib/ruby/site_ruby/1.8
mkdir -p /usr/bin
install -c -m 0644 rubygems.rb /usr/lib/ruby/site_ruby/1.8/rubygems.rb
...
[success]
-- 
Posted via http://www.ruby-forum.com/.

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

Anita Kuno

2008-Jul-03 03:42 UTC

head link

Re: rake aborted! Could not find table ...

Thank you all for your suggestions and input.

This is the first migration of the application or in other words migration zero.

I will take a look at the other comments and see what develops.

Thank you,
Anita.

On Wed, Jul 2, 2008 at 1:30 PM, Mojca Miklavec
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
> I experience exactly the same problem. It works on my computer (using
> MySQL), but fails on another one (using sqlite3).
>
> database.yml:
>
>  development:
>  adapter: sqlite3
>  database: db/development.sqlite3
>  timeout: 5000
>
> I have two migration files:
>  20080701141405_create_commands.rb
>  20080701142511_add_content_to_database.rb
>
> First one:
>
>  def self.up
>    create_table :commands do |t|
>      t.string :name
>      t.text :xml
>      t.timestamps
>    end
>  end
>
>  def self.down
>    drop_table :commands
>  end
>
> Second one:
>
>  def self.up
>    # here is a loop that fetches external data
>        Command.create(
>          :name => name,
>          :xml => xml_string
>        )
>    # end of loop
>  end
>
>  def self.down
>    Command.delete_all
>  end
>
> The first one works OK, but the second migration fails with
>  rake aborted!
>  Could not find table ''commands''
>
> If I try to create another "create table" statement, then it
complains
> with
>
>  rake aborted!
>  SQLite3::SQLException: table "commands" already exists: CREATE
TABLE
> "commands" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT
NULL, "name"
> varchar(255) DEFAULT NULL NULL, "xml" text DEFAULT NULL NULL,
> "created_at" datetime DEFAULT NULL NULL, "updated_at"
datetime DEFAULT
> NULL NULL)
>
> I''m clueless. I don''t set anything in environment.rb by
myself.
>
> I had some problems installing rails
>
> Thanks a lot,
>   Mojca
>
> If that matters, I had some problems installing latest version of gems,
> but that got resolved:
>
>> gem update --system
> Updating RubyGems...
> Bulk updating Gem source index for: http://gems.rubyforge.org
> Attempting remote update of rubygems-update
> ERROR:  While executing gem ... (Gem::GemNotFoundException)
>    Could not find rubygems-update (> 0) in any repository
>
>> gem env
> RubyGems Environment:
>  - VERSION: 0.9.2 (0.9.2)
>  - INSTALLATION DIRECTORY: /usr/lib/ruby/gems/1.8
>  - GEM PATH:
>     - /usr/lib/ruby/gems/1.8
>  - REMOTE SOURCES:
>     - http://gems.rubyforge.org
>
>> sudo mv /usr/lib/ruby/gems/1.8/source_cache /tmp
>
>> sudo gem update --system
> Updating RubyGems...
> Bulk updating Gem source index for: http://gems.rubyforge.org
> Attempting remote update of rubygems-update
> ERROR:  While executing gem ... (Gem::GemNotFoundException)
>    Could not find rubygems-update (> 0) in any repository
>
>> sudo gem install rubygems-update
> Bulk updating Gem source index for: http://gems.rubyforge.org
> Successfully installed rubygems-update-1.2.0
>
>> sudo gem update --system
> Updating RubyGems...
> Attempting remote update of rubygems-update
> Successfully installed rubygems-update-1.2.0
> Updating version of RubyGems to 1.2.0
> Installing RubyGems 1.2.0
> mkdir -p /usr/lib/ruby/site_ruby/1.8
> mkdir -p /usr/bin
> install -c -m 0644 rubygems.rb /usr/lib/ruby/site_ruby/1.8/rubygems.rb
> ...
> [success]
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Anita Kuno

2008-Jul-03 06:24 UTC

head link

Re: rake aborted! Could not find table ...

As suggested here is the schema.rb:

anita@anitas-computer:~/sandbox/shovell/db$ cat schema.rb
# This file is auto-generated from the current state of the database.
Instead of editing this file,
# please use the migrations feature of Active Record to incrementally
modify your database, and
# then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for
your database schema. If you need
# to create the application database on another system, you should be
using db:schema:load, not running
# all the migrations from scratch. The latter is a flawed and
unsustainable approach (the more migrations
# you''ll amass, the slower it''ll run and the greater
likelihood for issues).
#
# It''s strongly recommended to check this file into your version
control system.

ActiveRecord::Schema.define(:version => 20080701040248) do

anita@anitas-computer:~/sandbox/shovell/db$

Now this is the first time that I have looked at schema.rb,  is the
define -> do -> nothing format normal?  it seems to be missing an end
to at least close the block.  If there has been no "end" generated
then perhaps the generator is not working properly.  Why would it
start a block and not finish it?  Or have I latched onto a red herring
here?

Thanks, still looking,
Anita.

On Wed, Jul 2, 2008 at 11:42 PM, Anita Kuno
<ay.kuno-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Thank you all for your suggestions and input.
>
> This is the first migration of the application or in other words migration
zero.
>
> I will take a look at the other comments and see what develops.
>
> Thank you,
> Anita.
>
> On Wed, Jul 2, 2008 at 1:30 PM, Mojca Miklavec
> <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
>>
>> I experience exactly the same problem. It works on my computer (using
>> MySQL), but fails on another one (using sqlite3).
>>
>> database.yml:
>>
>>  development:
>>  adapter: sqlite3
>>  database: db/development.sqlite3
>>  timeout: 5000
>>
>> I have two migration files:
>>  20080701141405_create_commands.rb
>>  20080701142511_add_content_to_database.rb
>>
>> First one:
>>
>>  def self.up
>>    create_table :commands do |t|
>>      t.string :name
>>      t.text :xml
>>      t.timestamps
>>    end
>>  end
>>
>>  def self.down
>>    drop_table :commands
>>  end
>>
>> Second one:
>>
>>  def self.up
>>    # here is a loop that fetches external data
>>        Command.create(
>>          :name => name,
>>          :xml => xml_string
>>        )
>>    # end of loop
>>  end
>>
>>  def self.down
>>    Command.delete_all
>>  end
>>
>> The first one works OK, but the second migration fails with
>>  rake aborted!
>>  Could not find table ''commands''
>>
>> If I try to create another "create table" statement, then it
complains
>> with
>>
>>  rake aborted!
>>  SQLite3::SQLException: table "commands" already exists:
CREATE TABLE
>> "commands" ("id" INTEGER PRIMARY KEY AUTOINCREMENT
NOT NULL, "name"
>> varchar(255) DEFAULT NULL NULL, "xml" text DEFAULT NULL NULL,
>> "created_at" datetime DEFAULT NULL NULL,
"updated_at" datetime DEFAULT
>> NULL NULL)
>>
>> I''m clueless. I don''t set anything in environment.rb
by myself.
>>
>> I had some problems installing rails
>>
>> Thanks a lot,
>>   Mojca
>>
>> If that matters, I had some problems installing latest version of gems,
>> but that got resolved:
>>
>>> gem update --system
>> Updating RubyGems...
>> Bulk updating Gem source index for: http://gems.rubyforge.org
>> Attempting remote update of rubygems-update
>> ERROR:  While executing gem ... (Gem::GemNotFoundException)
>>    Could not find rubygems-update (> 0) in any repository
>>
>>> gem env
>> RubyGems Environment:
>>  - VERSION: 0.9.2 (0.9.2)
>>  - INSTALLATION DIRECTORY: /usr/lib/ruby/gems/1.8
>>  - GEM PATH:
>>     - /usr/lib/ruby/gems/1.8
>>  - REMOTE SOURCES:
>>     - http://gems.rubyforge.org
>>
>>> sudo mv /usr/lib/ruby/gems/1.8/source_cache /tmp
>>
>>> sudo gem update --system
>> Updating RubyGems...
>> Bulk updating Gem source index for: http://gems.rubyforge.org
>> Attempting remote update of rubygems-update
>> ERROR:  While executing gem ... (Gem::GemNotFoundException)
>>    Could not find rubygems-update (> 0) in any repository
>>
>>> sudo gem install rubygems-update
>> Bulk updating Gem source index for: http://gems.rubyforge.org
>> Successfully installed rubygems-update-1.2.0
>>
>>> sudo gem update --system
>> Updating RubyGems...
>> Attempting remote update of rubygems-update
>> Successfully installed rubygems-update-1.2.0
>> Updating version of RubyGems to 1.2.0
>> Installing RubyGems 1.2.0
>> mkdir -p /usr/lib/ruby/site_ruby/1.8
>> mkdir -p /usr/bin
>> install -c -m 0644 rubygems.rb /usr/lib/ruby/site_ruby/1.8/rubygems.rb
>> ...
>> [success]
>> --
>> Posted via http://www.ruby-forum.com/.
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Anita Kuno

2008-Jul-03 06:25 UTC

head link

Re: rake aborted! Could not find table ...

What makes you think that this migration is the problem? Do any other
 migrations reference stories?

This is the first migration in the application.

Anita.


On Wed, Jul 2, 2008 at 2:55 AM, Frederick Cheung
<frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:>
>
>
> On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> I am getting a rake aborted error and I suspect that I am missing a
>> package on my system since the app works for a friend on this
>> computer.
>>
>> Here is the terminal output of the error:
>>
>> anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
>> (in /home/anita/sandbox/shovell)
>> rake aborted!
>> Could not find table ''stories''
>>
>> (See full trace by running task with --trace)
>> anita@anitas-computer:~/sandbox/shovell$
>>
>> Here is the contents of the migration file:
>>
>> anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
>> 20080701040248_create_stories.rb
>
> What makes you think that this migration is the problem? Do any other
> migrations reference stories?
>
> Fred
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Anita Kuno

2008-Jul-03 06:30 UTC

head link

Re: rake aborted! Could not find table ...

Here is config/environment.rb:

anita@anitas-computer:~/sandbox/shovell/config$ cat environment.rb
# Be sure to restart your server when you modify this file

# Uncomment below to force Rails into production mode when
# you don''t control web/app server and can''t set it the proper
way
# ENV[''RAILS_ENV''] ||= ''production''

# Specifies gem version of Rails to use when vendor/rails is not present
RAILS_GEM_VERSION = ''2.1.0'' unless defined? RAILS_GEM_VERSION

# Bootstrap the Rails environment, frameworks, and default configuration
require File.join(File.dirname(__FILE__), ''boot'')

Rails::Initializer.run do |config|
  # Settings in config/environments/* take precedence over those specified here.
  # Application configuration should go into files in config/initializers
  # -- all .rb files in that directory are automatically loaded.
  # See Rails::Configuration for more options.

  # Skip frameworks you''re not going to use. To use Rails without a
database
  # you must remove the Active Record framework.
  # config.frameworks -= [ :active_record, :active_resource, :action_mailer ]

  # Specify gems that this application depends on.
  # They can then be installed with "rake gems:install" on new
installations.
  # config.gem "bj"
  # config.gem "hpricot", :version => ''0.6'',
:source =>
"http://code.whytheluckystiff.net"
  # config.gem "aws-s3", :lib => "aws/s3"

  # Only load the plugins named here, in the order given. By default,
all plugins
  # in vendor/plugins are loaded in alphabetical order.
  # :all can be used as a placeholder for all plugins not explicitly named
  # config.plugins = [ :exception_notification, :ssl_requirement, :all ]

  # Add additional load paths for your own custom dirs
  # config.load_paths += %W( #{RAILS_ROOT}/extras )

  # Force all environments to use the same logger level
  # (by default production uses :info, the others :debug)
  # config.log_level = :debug

  # Make Time.zone default to the specified zone, and make Active
Record store time values
  # in the database in UTC, and return them converted to the specified
local zone.
  # Run "rake -D time" for a list of tasks for finding time zone
names. Uncomment to use default local time.
  config.time_zone = ''UTC''

  # Your secret key for verifying cookie session data integrity.
  # If you change this key, all old sessions will become invalid!
  # Make sure the secret is at least 30 characters and all random,
  # no regular words or you''ll be exposed to dictionary attacks.
  config.action_controller.session = {
    :session_key => ''_shovell_session'',
    :secret      =>
''xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx''
 #hidden for the purpose of this email
  }

  # Use the database for sessions instead of the cookie-based default,
  # which shouldn''t be used to store highly confidential information
  # (create the session table with "rake db:sessions:create")
  # config.action_controller.session_store = :active_record_store

  # Use SQL instead of Active Record''s schema dumper when creating the
test database.
  # This is necessary if your schema can''t be completely dumped by the
schema dumper,
  # like if you have constraints or database-specific column types
  # config.active_record.schema_format = :sql

  # Activate observers that should always be running
  # config.active_record.observers = :cacher, :garbage_collector
end
anita@anitas-computer:~/sandbox/shovell/config$



On Wed, Jul 2, 2008 at 7:19 AM, Russell Norris
<rsl-ftMzyaTR+bHNyFkoKTPOtdi2O/JbrIOy@public.gmane.org>
wrote:> you might also want to check config/environment.rb for anything that might
> be preloading or reading from the stories. I tried some cleverness like
this
> once and it burped a similar error when migrating up from zero.
>
> RSL
>
> On Wed, Jul 2, 2008 at 5:02 AM, Wolas!
<jcpenche-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>>
>> The migration is fine. if the tabls stories was already there it would
>> have complained about it. bu the error is the opposite:
>>
>> Could not find table ''stories''
>>
>> it defenitely seems like youre modifying the table before you have
>> created it.
>>
>> My only suggestion here is make sure you have the development packages
>> for sqlite3 as well as the client ones.
>>
>>
>> I ran out of ideas at this point.
>>
>> j
>>
>> On Jul 2, 7:55 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
>> wrote:
>> > On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> >
>> >
>> >
>> > > I am getting a rake aborted error and I suspect that I am
missing a
>> > > package on my system since the app works for a friend on this
>> > > computer.
>> >
>> > > Here is the terminal output of the error:
>> >
>> > > anita@anitas-computer:~/sandbox/shovell$ rake db:migrate
>> > > (in /home/anita/sandbox/shovell)
>> > > rake aborted!
>> > > Could not find table ''stories''
>> >
>> > > (See full trace by running task with --trace)
>> > > anita@anitas-computer:~/sandbox/shovell$
>> >
>> > > Here is the contents of the migration file:
>> >
>> > > anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
>> > > 20080701040248_create_stories.rb
>> >
>> > What makes you think that this migration is the problem? Do any
other
>> > migrations reference stories?
>> >
>> > Fred
>>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Kristian

2008-Jul-19 23:44 UTC

head link

Re: rake aborted! Could not find table ...

I have the exact same problem on my Debian server.
Has anybody found a solution?

kristian

On Jul 3, 8:30 am, "Anita Kuno"
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Here is config/environment.rb:
>
> anita@anitas-computer:~/sandbox/shovell/config$ cat environment.rb
> # Be sure to restart your server when you modify this file
>
> # Uncomment below to force Rails into production mode when
> # you don''t control web/app server and can''t set it the
proper way
> # ENV[''RAILS_ENV''] ||= ''production''
>
> # Specifies gem version of Rails to use when vendor/rails isnotpresent
> RAILS_GEM_VERSION = ''2.1.0'' unless defined?
RAILS_GEM_VERSION
>
> # Bootstrap the Rails environment, frameworks, and default configuration
> require File.join(File.dirname(__FILE__), ''boot'')
>
> Rails::Initializer.run do |config|
>   # Settings in config/environments/* take precedence over those specified
here.
>   # Application configuration should go into files in config/initializers
>   # -- all .rb files in that directory are automatically loaded.
>   # See Rails::Configuration for more options.
>
>   # Skip frameworks you''renotgoing to use. To use Rails without a
database
>   # you must remove the Active Record framework.
>   # config.frameworks -= [ :active_record, :active_resource, :action_mailer
]
>
>   # Specify gems that this application depends on.
>   # They can then be installed with "rakegems:install" on new
installations.
>   # config.gem "bj"
>   # config.gem "hpricot", :version => ''0.6'',
:source =>
> "http://code.whytheluckystiff.net"
>   # config.gem "aws-s3", :lib => "aws/s3"
>
>   # Only load the plugins named here, in the order given. By default,
> all plugins
>   # in vendor/plugins are loaded in alphabetical order.
>   # :all can be used as a placeholder for all pluginsnotexplicitly named
>   # config.plugins = [ :exception_notification, :ssl_requirement, :all ]
>
>   # Add additional load paths for your own custom dirs
>   # config.load_paths += %W( #{RAILS_ROOT}/extras )
>
>   # Force all environments to use the same logger level
>   # (by default production uses :info, the others :debug)
>   # config.log_level = :debug
>
>   # Make Time.zone default to the specified zone, and make Active
> Record store time values
>   # in the database in UTC, and return them converted to the specified
> local zone.
>   # Run "rake-D time" for a list of tasks for finding time zone
> names. Uncomment to use default local time.
>   config.time_zone = ''UTC''
>
>   # Your secret key for verifying cookie session data integrity.
>   # If you change this key, all old sessions will become invalid!
>   # Make sure the secret is at least 30 characters and all random,
>   # no regular words or you''ll be exposed to dictionary attacks.
>   config.action_controller.session = {
>     :session_key => ''_shovell_session'',
>     :secret      =>
>
''xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx''
>  #hidden for the purpose of this email
>   }
>
>   # Use the database for sessions instead of the cookie-based default,
>   # which shouldn''t be used to store highly confidential
information
>   # (create the sessiontablewith "rakedb:sessions:create")
>   # config.action_controller.session_store = :active_record_store
>
>   # Use SQL instead of Active Record''s schema dumper when creating
the
> test database.
>   # This is necessary if your schema can''t be completely dumped by
the
> schema dumper,
>   # like if you have constraints or database-specific column types
>   # config.active_record.schema_format = :sql
>
>   # Activate observers that should always be running
>   # config.active_record.observers = :cacher, :garbage_collector
> end
> anita@anitas-computer:~/sandbox/shovell/config$
>
> On Wed, Jul 2, 2008 at 7:19 AM, Russell Norris
<r...-ftMzyaTR+bHNyFkoKTPOtdi2O/JbrIOy@public.gmane.org> wrote:
> > you might also want to check config/environment.rb for anything that
might
> > be preloading or reading from the stories. I tried some cleverness
like this
> > once and it burped a similar error when migrating up from zero.
>
> > RSL
>
> > On Wed, Jul 2, 2008 at 5:02 AM, Wolas!
<jcpen...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> >> The migration is fine. if the tabls stories was already there it
would
> >> have complained about it. bu the error is the opposite:
>
> >>Couldnotfindtable''stories''
>
> >> it defenitely seems like youre modifying thetablebefore you have
> >> created it.
>
> >> My only suggestion here is make sure you have the development
packages
> >> for sqlite3 as well as the client ones.
>
> >> I ran out of ideas at this point.
>
> >> j
>
> >> On Jul 2, 7:55 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> >> wrote:
> >> > On Jul 1, 6:34 pm, anteaya
<ay.k...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> >> > > I am getting arakeabortederror and I suspect that I am
missing a
> >> > > package on my system since the app works for a friend on
this
> >> > > computer.
>
> >> > > Here is the terminal output of the error:
>
> >> > > anita@anitas-computer:~/sandbox/shovell$rakedb:migrate
> >> > > (in /home/anita/sandbox/shovell)
> >> > >rakeaborted!
> >> > >Couldnotfindtable''stories''
>
> >> > > (See full trace by running task with --trace)
> >> > > anita@anitas-computer:~/sandbox/shovell$
>
> >> > > Here is the contents of the migration file:
>
> >> > > anita@anitas-computer:~/sandbox/shovell/db/migrate$ cat
> >> > > 20080701040248_create_stories.rb
>
> >> > What makes you think that this migration is the problem? Do
any other
> >> > migrations reference stories?
>
> >> > Fred
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---

Mojca Miklavec

2008-Jul-21 11:19 UTC

head link

Re: rake aborted! Could not find table ...

Kristian wrote:> I have the exact same problem on my Debian server.
> Has anybody found a solution?
Take a look at
    http://www.ruby-forum.com/topic/144703

It might be the same problem - buggy sqlite3(-ruby) interface. The 
suggested solution is to downgrade the gem. I gave up using sqlite3 and 
switched to mysql instead.

Mojca
-- 
Posted via http://www.ruby-forum.com/.

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

Eduardo Malpeli

2009-Mar-12 06:31 UTC

head link

Re: rake aborted! Could not find table ...

Hi anita,

You just have to migrate the production too... or you can duplicate your 
development db and rename to production.sqlite3... unusual but solve the 
problem.

Best regards

Eduardo
-- 
Posted via http://www.ruby-forum.com/.

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

Possibly Parallel Threads

Search for more possibly parallel threads

Rails - Jul 2008 - rake aborted! Could not find table ...

rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Re: rake aborted! Could not find table ...

Possibly Parallel Threads