Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users'

Added by baozhong wang almost 8 years ago

Dear all,
When I intalled redmine-2.1.0 on windows xp sp3, some error appearred.

*
C:\redmine-2.1.0>rake db:migrate RAILS_ENV="production"
rake aborted!
Mysql::Error: query: not connected: SHOW TABLES LIKE 'users'

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)*

I need help.

Replies (7)

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Etienne Massip almost 8 years ago

rake db:migrate RAILS_ENV="production"

is not a Windows legal syntax.

Use separate subsequent commands instead:

set RAILS_ENV="production" 
rake db:migrate

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Rohan Alexander almost 8 years ago

I too am having the same issue.

I used the following commands :

set RAILS_ENV=production
rake db:migrate

Then I get the same error.

Thanks

Rohan

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Etienne Massip over 7 years ago

Your production database configuration in database.yml is not correct.

Try running rake db:migrate --trace as suggested to get the full error message.

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Rohan Alexander over 7 years ago

Details of trace shown below.

Hope you can help.

Thanks.

I have also attached details of my database.yml file.

Thanks.

Rohan

C:\webserver\redmine-2.1.2>rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Mysql::Error: query: not connected: SHOW TABLES LIKE 'users'
    C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
    C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute

C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute

C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute_and_free

C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:383:in `tables'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:400:in `table_e
ists?'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/connection_adapters/schema_cache.rb:30:in `table_exists?'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/model_schema.rb:223:in `table_exists?'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_methods/primary_key.rb:75:in `get_primary_key'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_methods/primary_key.rb:60:in `reset_primary_key'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_methods/primary_key.rb:49:in `primary_key'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_methods/primary_key.rb:62:in `reset_primary_key'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_methods/primary_key.rb:49:in `primary_key'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/attribute_assignment.rb:13:in `attributes_protected_by_defaul
'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:216:in `protected_attributes_config
'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:188:in `call'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:188:in `default'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:188:in `[]'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:188:in `protected_attributes'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:118:in `attr_protected'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:117:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/mass_assignment_security.rb:117:in `attr_protected'
C:/webserver/redmine-2.1.2/app/models/user.rb:63
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:236:in `load_dependency'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:359:in `require_or_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:502:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:514:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/redmine-2.1.2/app/models/project.rb:31
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:236:in `load_dependency'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:359:in `require_or_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:502:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:514:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/redmine-2.1.2/app/models/attachment.rb:38
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:236:in `load_dependency'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:359:in `require_or_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:502:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:514:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:514:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/redmine-2.1.2/lib/plugins/acts_as_attachable/lib/acts_as_attachable.rb:33:in `acts_as_attachable'
C:/webserver/redmine-2.1.2/app/models/message.rb:23
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:236:in `load_dependency'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:251:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:359:in `require_or_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:502:in `load_missing_constant'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:192:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/dependencies.rb:190:in `const_missing'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/inflector/methods.rb:219:in `constantize'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/inflector/methods.rb:218:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/inflector/methods.rb:218:in `constantize'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/core_ext/string/inflections.rb:54:in `constantize'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:210:in `observed_class'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:203:in `observed_classes'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:223:in `observed_classes'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/observer.rb:96:in `observed_classes'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:219:in `initialize'
C:/webserver/Ruby/lib/ruby/1.8/singleton.rb:94:in `new'
C:/webserver/Ruby/lib/ruby/1.8/singleton.rb:94:in `instance'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:86:in `instantiate_observer'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:59:in `instantiate_observers'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:59:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activemodel-3.2.8/lib/active_model/observing.rb:59:in `instantiate_observers'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/railtie.rb:117
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:26:in `on_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:25:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:25:in `on_load'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activerecord-3.2.8/lib/active_record/railtie.rb:116
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:34:in `call'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:34:in `execute_hook'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:43:in `run_load_hooks'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:42:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/activesupport-3.2.8/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/application/finisher.rb:59
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/initializable.rb:30:in `instance_exec'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/initializable.rb:30:in `run'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/initializable.rb:55:in `run_initializers'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/initializable.rb:54:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/initializable.rb:54:in `run_initializers'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/application.rb:136:in `initialize!'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/railtie/configurable.rb:30:in `send'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/railtie/configurable.rb:30:in `method_missing'
C:/webserver/redmine-2.1.2/config/environment.rb:14
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/application.rb:103:in `require'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/application.rb:103:in `require_environment!'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/railties-3.2.8/lib/rails/application.rb:295:in `initialize_tasks'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `invoke_with_call_chain'
C:/webserver/Ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:176:in `invoke_prerequisites'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `invoke_prerequisites'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:157:in `invoke_with_call_chain'
C:/webserver/Ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
C:/webserver/Ruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
C:/webserver/Ruby/bin/rake:23:in `load'
C:/webserver/Ruby/bin/rake:23
Tasks: TOP => db:migrate => environment

database.yml Magnifier - Database.yml File (662 Bytes)

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Brandon Bonds over 7 years ago

I get the same error (Redmine 2.1.2) on a Windows 7 machine. My database.yml and trace are similar to the ones above.

I also tried using the command line mysql, and when I query "SHOW TABLES LIKE 'users'", I simply get a response of "Empty set (0.00 sec)".

RE: Install redmine-2.1.0, Mysql::Error: query: not connected: SHOW TABLES LIKE 'users' - Added by Brandon Bonds over 7 years ago

Ok, I got it working. I downloaded an older libmysql.dll and put it in my ruby\bin folder (based on the instructions at the bottom here: http://www.warden.pl/2010/09/03/mysqlerror-query-not-connected-with-rails-activerecord/). Then I simply ran

rake db:migrate

again, and it worked.

My setup is Redmine 2.1.2, MySQL 5.5.28, Rails 3.2.8, on Windows 7.

(1-7/7)