Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings`

Added by Jirka Borovec about 12 years ago

Good morning,
I ve installed RedMine 1.3 on Hostmonster.com
I ve follow this web-tutorial: http://www.rainman-soft.com/cms/node/278
but finally Ive received this error, that I do not understand... may you help me?

ActiveRecord::StatementInvalid in WelcomeController#index
Mysql::Error: Table 'redmine_dev.settings' doesn't exist: SHOW FIELDS FROM `settings`

RAILS_ROOT: /home3/rails/redmine
Application Trace | Framework Trace | Full Trace
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:471:in `columns'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/base.rb:1305:in `columns'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:300:in `column_for'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:129:in `calculate'
/home3/rails/redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:75:in `maximum'
/home3/rails/redmine/app/models/setting.rb:152:in `check_cache'
/home3/rails/redmine/app/controllers/application_controller.rb:62:in `user_setup'
Request

Parameters:
None

Show session dump
Response

Headers: {"Content-Type"=>"",
"Cache-Control"=>"no-cache"}

Replies (5)

RE: Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings` - Added by Ivan Cenov about 12 years ago

Redmine 1.3.0 works with rails 2.3.14.

This is suspicious: redmine_dev. Is it the name of your database (instead of usually used redmine)?

RE: Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings` - Added by Jirka Borovec about 12 years ago

this is the config file:

MySQL (default setup).

production:
adapter: mysql
database: redmine
host: localhost
username: redmine
password: **
encoding: utf8

development:
adapter: mysql
database: redmine_dev
host: localhost
username: redmine
password: **
encoding: utf8

RE: Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings` - Added by Ivan Cenov about 12 years ago

OK,

Your Redmine is started in development environment instead of production environment. You have to manage to start Redmine in production environment.

RE: Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings` - Added by Jirka Borovec about 12 years ago

Well it seem reasonable, but it could be stupid question, how can I do it (start in production mode)?
I have lite experiences with Redmine as a user but with administration I am just beginning...

RE: Mysql::Error: Table 'redmine_development.settings' doesn't exist: SHOW FIELDS FROM `settings` - Added by Ivan Cenov about 12 years ago

This depends on your installation.

Par example, I start Redmine in production mode at command line (for testing purposes only) this way on Windows machine:
ruby script\server -e production

(1-5/5)

Project

General

Profile

Redmine