Install error"Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB"
Added by sunlanan wong over 12 years ago
Hi, when I install redmine it always show the error:
"Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version`
varchar(255) NOT NULL) ENGINE=InnoDB"
my redmine version is :v1.3.0
ruby installed by v1.3.0.
gem list information is:
C:\Sites\redmine>gem list *** LOCAL GEMS *** abstract (1.0.0) actionmailer (3.0.9, 2.3.11) actionpack (3.0.9, 2.3.11) activemodel (3.0.9) activerecord (3.0.9, 2.3.11) activerecord-sqlserver-adapter (3.0.15) activeresource (3.0.9, 2.3.11) activesupport (3.0.9, 2.3.11) arel (2.0.10) builder (2.1.2) bundler (1.0.15) cgi_multipart_eof_fix (2.5.0) erubis (2.6.6) gem_plugin (0.2.3) i18n (0.5.0, 0.4.2) mail (2.2.19) mime-types (1.16) mongrel (1.1.5 x86-mingw32) mysql (2.8.1 x86-mingw32) open4 (1.1.0) pg (0.11.0 x86-mingw32) Platform (0.4.0) polyglot (0.3.1) POpen4 (0.1.4) rack (1.2.3, 1.1.3, 1.1.1) rack-mount (0.6.14) rack-test (0.5.7) rails (3.0.9, 2.3.11) railties (3.0.9) rake (0.8.7) rb-readline (0.4.0) rdoc (3.8) rubyzip2 (2.0.1) sqlite3 (1.3.3 x86-mingw32) sqlite3-ruby (1.3.3) thor (0.14.6) tiny_tds (0.4.5 x86-mingw32) treetop (1.4.9) tzinfo (0.3.29) win32-open3 (0.3.2 x86-mingw32)
mysql version is: 5.1.19
os is: windows XP
and when I excute the "rake db:migrate", it always show an error as:
C:\Sites\redmine>set RAILS_ENV=production C:\Sites\redmine>rake db:migrate (in C:/Sites/redmine) NOTE: SourceIndex.new(hash) is deprecated; From C:/Sites/redmine/config/../vendo r/rails/railties/lib/rails/vendor_gem_source_index.rb:100:in `new'. rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB (See full trace by running task with --trace)
when i excute rake db:migrate, it shows:
C:\Sites\redmine>rake db:migrate --trace (in C:/Sites/redmine) NOTE: SourceIndex.new(hash) is deprecated; From C:/Sites/redmine/config/../vendo r/rails/railties/lib/rails/vendor_gem_source_index.rb:100:in `new'. ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters /abstract_adapter.rb:227:in `log' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters /mysql_adapter.rb:324:in `execute' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters /abstract/schema_statements.rb:109:in `create_table' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters /mysql_adapter.rb:478:in `create_table' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters /abstract/schema_statements.rb:371:in `initialize_schema_migrations_table' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/migration.rb:441:in `initialize' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/migration.rb:401:in `new' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/migration.rb:401:in `up' C:/Sites/redmine/vendor/rails/activerecord/lib/active_record/migration.rb:383:in `migrate' C:/Sites/redmine/vendor/rails/railties/lib/tasks/databases.rake:112 C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' C:/RailsInstaller/Ruby1.8.7/lib/ruby/1.8/monitor.rb:242:in `synchronize' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:i n `invoke_task' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:i n `top_level' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:i n `each' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:i n `top_level' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:i n `standard_exception_handling' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:i n `top_level' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:i n `run' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:i n `standard_exception_handling' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:i n `run' C:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 C:/RailsInstaller/Ruby1.8.7/bin/rake:19:in `load' C:/RailsInstaller/Ruby1.8.7/bin/rake:19