Troubles with PostgreSQL during install process.
Added by Tyler Durden about 15 years ago
Hi guys!
I've encountered the problem on the 6th step described here http://www.redmine.org/wiki/redmine/RedmineInstall
My Postgre database is available and config file is OK.
My gems list is:
C:\ruby\apps\redmine-0.8.5>gem li *** LOCAL GEMS *** fxri (0.3.6) fxruby (1.6.12) hpricot (0.6) log4r (1.0.5) pg (0.8.0) rake (0.8.7, 0.7.3) sources (0.0.1) win32-api (1.0.4) win32-clipboard (0.4.3) win32-dir (0.3.2) win32-eventlog (0.4.6) win32-file (0.5.4) win32-file-stat (1.2.7) win32-process (0.5.3) win32-sapi (0.1.4) win32-sound (0.4.1) windows-api (0.2.0) windows-pr (0.7.2)
So here is the quite strange error:
C:\ruby\apps\redmine-0.8.5>rake db:migrate RAILS_ENV="production" --trace (in C:/ruby/apps/redmine-0.8.5) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate == 52 AddChangesRevision: migrating =========================================== -- add_column(:changes, :revision, :string) rake aborted! PGError: ERROR: relation "changes" does not exist : ALTER TABLE "changes" ADD COLUMN "revision" character varying(255) C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:484:in `execute' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:735:in `add_column' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:346:in `send' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:346:in `method_missing' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:326:in `say_with_time' c:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:326:in `say_with_time' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:342:in `method_missing' ./db/migrate//052_add_changes_revision.rb:3:in `up_without_benchmarks' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `send' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate' c:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:455:in `migrate' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `each' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `migrate' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:373:in `up' C:/ruby/apps/redmine-0.8.5/vendor/rails/activerecord/lib/active_record/migration.rb:356:in `migrate' C:/ruby/apps/redmine-0.8.5/vendor/rails/railties/lib/tasks/databases.rake:99 c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' c:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 c:/ruby/bin/rake:19:in `load' c:/ruby/bin/rake:19
Thanks a lot for any advices!