Rails Rake db:migrate aborting (sqlite3)

Question

Similar questions have been asked but none of the recommendations have worked for me. I'm trying to migrate a db in rails development on my computer and I keep getting this error message:

 rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

undefined local variable or method `total' for #<CreateProfessors:0x007f8ce3ca4e60>/Users/tfantina/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:664:in `block in method_missing'
   /Users/tfantina/.rvm/gems/ruby-2.2.1/gems/activerecord-   4.2.5.1/lib/active_record/migration.rb:634:in `block in say_with_time'
/Users/tfantina/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:634:in `say_with_time'
/Users/tfantina/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5.1/lib/active_record/migration.rb:654:in `method_missing'

It continues on for a hundred lines or so.
One of the posts here recommended removing

null: false

from

  t.timestamps null:false

which I did.

Another recommendation I have tried is running db:drop:all then db:create:all then db:migrate.

To make sure sqlite3 was on my OSX I ran a sqlite3 query in terminal and was returned: SQLite version 3.8.10.2 so I assume that's working properly.

Failing migration:

    class CreateProfessors < ActiveRecord::Migration
  def change
    create_table :professors do |t|
      t.string :fname
      t.string :lname
      t.decimal :rating-total
      t.decimal :rating-hw
      t.decimal :rating-test
      t.decimal :rating-interest
      t.text :comments
      t.string :ease

      t.timestamps 
    end
  end
end

I have added the failing migration, it's the only one I've done yet. — tfantina
– tfantina, Commented Feb 4, 2016 at 17:08

Hieu Pham · Accepted Answer · 2016-02-04 17:54:14Z

1

These column names are illegal:

t.decimal :rating-total
t.decimal :rating-hw
t.decimal :rating-test
t.decimal :rating-interest

It should be: (use _ instead of -)

t.decimal :rating_total
t.decimal :rating_hw
t.decimal :rating_test
t.decimal :rating_interest

answered Feb 4, 2016 at 17:54

Hieu Pham

6,6922 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tfantina Over a year ago

Hey hey! That's it. Thanks, I'm super new to Rails so this is pretty basic but I appreciate it I was really stuck.

Collectives™ on Stack Overflow

Rails Rake db:migrate aborting (sqlite3)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related