For help : Can't login to redmine on Windows Server 2003

Added by xiaoyu yin over 10 years ago

BitNami Redmine stacks on Windows Server 2003 of redmine 0.9.4.

It can show the login interface to me, but after putting in username and password I point the login , I can't login to redmine. It shows as below:

ActiveRecord::StatementInvalid in AccountController#login
Mysql::Error: Unknown column 'position' in 'order clause': SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
RAILS_ROOT: E:/SCM/BitNami Redmine Stack/apps/redmine

Application Trace | Framework Trace | Full Trace
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in `select'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:661:in `find_by_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:1548:in `find_every'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:615:in `find'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:49:in `available_custom_fields'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:62:in `custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:75:in `save_custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `evaluate_method'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:344:in `callback'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:251:in `create_or_update'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2538:in `save_without_validation'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/validations.rb:1078:in `save_without_dirty'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2622:in `update_attribute'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/models/user.rb:123:in `try_to_login'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/controllers/account_controller.rb:144:in `password_authentication'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/controllers/account_controller.rb:34:in `login'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in `select'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:661:in `find_by_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:1548:in `find_every'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:615:in `find'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:49:in `available_custom_fields'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:62:in `custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:75:in `save_custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `evaluate_method'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:344:in `callback'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:251:in `create_or_update'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2538:in `save_without_validation'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/validations.rb:1078:in `save_without_dirty'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2622:in `update_attribute'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action_without_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/1.8/benchmark.rb:308:in `realtime'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:93:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `synchronize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:44:in `dispatch_cgi'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:101:in `dispatch_cgi'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:27:in `dispatch'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:76:in `process'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:74:in `synchronize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:74:in `process'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:159:in `process_client'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `each'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `process_client'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `initialize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `new'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `initialize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `new'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:282:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:281:in `each'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:281:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:128:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/command.rb:212:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:281
E:/SCM/BitNami Redmine Stack/ruby/bin/mongrel_rails:19:in `load'
E:/SCM/BitNami Redmine Stack/ruby/bin/mongrel_rails:19
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in `select'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:661:in `find_by_sql'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:1548:in `find_every'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:615:in `find'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:49:in `available_custom_fields'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:62:in `custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/plugins/acts_as_customizable/lib/acts_as_customizable.rb:75:in `save_custom_field_values'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:178:in `evaluate_method'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:166:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:93:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `each'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:92:in `run'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/callbacks.rb:276:in `run_callbacks'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:344:in `callback'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:251:in `create_or_update'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2538:in `save_without_validation'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/validations.rb:1078:in `save_without_dirty'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2622:in `update_attribute'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/models/user.rb:123:in `try_to_login'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/controllers/account_controller.rb:144:in `password_authentication'
E:/SCM/BitNami Redmine Stack/apps/redmine/app/controllers/account_controller.rb:34:in `login'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action_without_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/1.8/benchmark.rb:308:in `realtime'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:93:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `synchronize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/cgi_process.rb:44:in `dispatch_cgi'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:101:in `dispatch_cgi'
E:/SCM/BitNami Redmine Stack/apps/redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:27:in `dispatch'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:76:in `process'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:74:in `synchronize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/rails.rb:74:in `process'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:159:in `process_client'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `each'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `process_client'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `initialize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `new'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `initialize'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `new'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:282:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:281:in `each'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/configurator.rb:281:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:128:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel/command.rb:212:in `run'
E:/SCM/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:281
E:/SCM/BitNami Redmine Stack/ruby/bin/mongrel_rails:19:in `load'
E:/SCM/BitNami Redmine Stack/ruby/bin/mongrel_rails:19
Request
Parameters:

{"back_url"=>"http%3A%2F%2Flocalhost%3A8080%2Fredmine%2F",
"authenticity_token"=>"fKIPzWv8ejlYmBZ69mJ3+6Uvbv51riiDJPHrKfAIUW0=",
"username"=>"root",
"password"=>"admin",
"login"=>"登录 \302\273"}

Show session dump


Response
Headers:

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

note.txt Magnifier (28.3 KB)

Replies (13)

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Felix Schäfer over 10 years ago

Please make sure your database migrations ran fine.

If that doesn't solve the problem, please provide the output of ruby script/about RAILS_ENV=production run in your Redmine directory and post the error you get in the redmine log (in logs/production in you Redmine directory).

RE: For help : Can't login to redmine on Windows Server 2003 - Added by xiaoyu yin over 10 years ago

Oh, forgive me for my absence on database. Can you tell me how to check it?

By the way , the bitnami redmine stack runs ok on windows xp, I did nothing different on both, but it doesn't work on Server 2003. So I wondered it.

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Felix Schäfer over 10 years ago

I'm not sure how the Bitnami stack works, so I can't really tell you anything specific. Make sure the MySQL database is running, check the database config in REDMINE_DIR/config/database.yml, there should be a section in there called production: that tells redmine what database to use, and lastly, check in the MySQL database if there is a database with the name defined in the redmine configuration file.

RE: For help : Can't login to redmine on Windows Server 2003 - Added by xiaoyu yin over 10 years ago

I have checked it and made sure that:
1. the MySQL database is running
2. the database name(bitnami_redmine) is correct with datebase.yml; and the FORM 'custom_fields' is in the database(bitnami_redmine)

3. Now another Situation caused by the same reason happened. I can get to the 127.0.0.1,but when I tend to get to the Bitnami redmine stack , the Mysql database return error as below:

Mysql::Error: Unknown column 'updated_on' in 'field list': SELECT max(updated_on) AS max_updated_on FROM `settings`

Details are in the annex

migrate.rar - ruby script in redmine (46.1 KB)

production.log - redmine log (11.9 KB)

Action_Controller_Exception_caught.htm Magnifier - the user interface (23.5 KB)

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Felix Schäfer over 10 years ago

Please post the output of ruby script/about RAILS_ENV=production run in your Redmine directory. Somehow the rails stack cannot communicate with the MySQL database correctly.

RE: For help : Can't login to redmine on Windows Server 2003 - Added by xiaoyu yin over 10 years ago

I can't run this command in my redmine directory. See as the annex

RE: For help : Can't login to redmine on Windows Server 2003 - Added by xiaoyu yin over 10 years ago

ruby.exe is in
dierectory : e:\scm\BitNami Redmine Stack\ruby\bin

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Toshi MARUYAMA over 10 years ago

> e:\scm\BitNami Redmine Stack\ruby\bin\ruby.exe script/about RAILS_ENV=production

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Toshi MARUYAMA over 10 years ago

> "e:\scm\BitNami Redmine Stack\ruby\bin\ruby.exe" script/about RAILS_ENV=production

RE: For help : Can't login to redmine on Windows Server 2003 - Added by Toshi MARUYAMA over 10 years ago


S:\REDMINE\somewhere>set RAILS_ENV=production
S:\REDMINE\somewhere>r:\ruby\bin\ruby.exe script/about
About your application's environment
Ruby version              1.8.6 (i386-mingw32)
RubyGems version          1.3.5
Rack version              1.0
Rails version             2.3.5
Active Record version     2.3.5
Active Resource version   2.3.5
Action Mailer version     2.3.5
Active Support version    2.3.5
Application root          R:/REDMINE/somewhere
Environment               production
Database adapter          sqlite3
Database schema version   20100221100219

RE: For help : Can't login to redmine on Windows Server 2003 - Added by xiaoyu yin over 10 years ago

This problem have been solved by carlos in bitnami just now.
Thanks all!

(1-13/13)