Project

General

Profile

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!