Mysql2::Error: Table doesn't exist: SHOW FULL FIELDS FROM `sessions`

mysql ruby-on-rails mysql-workbench mysql-error-1064
ttinggggg picture ttinggggg · Mar 20, 2015 · Viewed 12.8k times · Source

I just cloned an application from my developer and I want to set it up on my computer. I get this error when I go to localhost:3000, and I don't really understand what it means.

Error: 

ActiveRecord::StatementInvalid - Mysql2::Error: Table 
'goacquire_development.sessions' doesn't exist: SHOW FULL FIELDS FROM `sessions`:

I think it could be my installation process, I'll appreciate if someone could explain this error to me.

Answer

Drenmi picture Drenmi · Mar 20, 2015

A few ideas:

  1. Make sure MySQL is running on your local machine.
  2. Make sure you have run rake db:create and rake db:migrate.
  3. Make sure you have a database.yml file configured with MySQL settings.

Hope this helps.

Related questions

Error installing mysql2: Failed to build gem native extension

I am having some problems when trying to install mysql2 gem for Rails. When I try to install it by running bundle install or gem install mysql2 it gives me the following error: Error installing mysql2: ERROR: Failed to build …

Read More
Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this?

Read More
Create a new Ruby on Rails application using MySQL instead of SQLite

I want to create my Rails application with MySQL, because I like it so much. How can I do that in the latest version of Rails instead of the default SQLite?

Read More