DB migration error- Unable to migrate db in ruby on rails

Question

I am using sqlite3 as development db. I used this code to migrate db

rake db:migrate

Also tried this rails db:migrate However I got this error

*SyntaxError: /Users/kangkanlahkar/Desktop/Codes/Ruby/practice/db/migrate/20170721152949_create_users.rb:4: syntax error, unexpected '\n', expecting &. or :: or '[' or '.'
/Users/kangkanlahkar/Desktop/Codes/Ruby/practice/db/migrate/20170721152949_create_users.rb:5: syntax error, unexpected '\n', expecting &. or :: or '[' or '.'*

Any idea how to fix it. I am using mac.

But the command rails db:migrate:status works fine

Content of 20170721152949_create_users.rb file

class CreateUsers < ActiveRecord::Migration[5.1]
  def change
    create_table :users do |t|
      t.string, :name
      t.string, :email
      t.integer :phone
      t.timestamps
    end
  end
end

the problem from this migration file db\migrate\20170721152949_create_users.rb, can you upload the content — widjajayd
– widjajayd, Commented Jul 21, 2017 at 16:29

RAJ · Accepted Answer · 2017-07-21 16:39:46Z

1

You just need to remove extra commas after t.string that's causing the syntax error. Try the following:

class CreateUsers < ActiveRecord::Migration[5.1]
  def change
    create_table :users do |t|
      t.string :name
      t.string :email
      t.integer :phone
      t.timestamps
    end
  end
end

answered Jul 21, 2017 at 16:39

RAJ

9,7471 gold badge36 silver badges63 bronze badges

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

Comments

Pavan · Accepted Answer · 2017-07-21 16:40:04Z

1

syntax error, unexpected '\n', expecting &. or :: or '[' or '.'

You have to remove the commas(,) after t.string

class CreateUsers < ActiveRecord::Migration[5.1]
  def change
    create_table :users do |t|
      t.string :name
      t.string :email
      t.integer :phone
      t.timestamps
    end
  end
end

answered Jul 21, 2017 at 16:40

Pavan

33.6k8 gold badges53 silver badges78 bronze badges

Comments

Gerry · Accepted Answer · 2017-07-21 16:40:09Z

1

Remove the commas after t.string:

class CreateUsers < ActiveRecord::Migration[5.1]
  def change
    create_table :users do |t|
      t.string :name
      t.string :email
      t.integer :phone
      t.timestamps
    end
  end
end

answered Jul 21, 2017 at 16:40

Gerry

10.5k3 gold badges33 silver badges40 bronze badges

Collectives™ on Stack Overflow

DB migration error- Unable to migrate db in ruby on rails

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related