Search code examples
mysqlruby-on-railsmysql-workbenchmysql-error-1064

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

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.

Solution

  • 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.