Rails Migration Error on Git Project

Question

I am learning Ruby on Rails, an am getting an error creating the database. I run the following command from console:

rake db:create db:migrate db:seed

And get:

== 20140328232600 AddAuthLevelToUser: migrating ===============================
-- add_column(:users, :auth_level, :Integer)
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedTable: ERROR:  relation "users" does not exist

I looked at the error message on the webpage, and tried running:

'bin/rake db:migrate RAILS_ENV=development'

As suggested, but had little luck.

The project I am working on had been started by another team of developers, so I pulled it off git... Any suggestions?

Cheers

Kirti Thorat · Accepted Answer · 2014-03-29 19:39:54Z

3

As per the error, you are running the migration AddAuthLevelToUser when you don't even have users table in database.

Firstly, verify if you have migration for users table, if not then create one.

If yes, then check that migration for users table has a VERSION NUMBER lower than that of AddAuthLevelToUser. Fix it and run the migrations.

answered Mar 29, 2014 at 19:39

Kirti Thorat♦

53.1k9 gold badges105 silver badges108 bronze badges

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

Comments

mcfinnigan · Accepted Answer · 2014-03-29 19:36:41Z

1

Try running just rake db:create at first. What database is your project using? Work this out and use the database client to connect to the database on your local system, and verify whether the users table exists on the database. It's possible that the db:create job is not correctly creating all the tables necessary for the database schema.

answered Mar 29, 2014 at 19:36

mcfinnigan

11.7k38 silver badges28 bronze badges

1 Comment

MrD Over a year ago

I've temporarily solved by destroying and re-creating the database, although this isn't ideal, thanks :)

Collectives™ on Stack Overflow

Rails Migration Error on Git Project

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related