Project

General

Profile

Actions

Defect #5092

closed

Error in upgrading from 0.8.7 to 0.9.3 : "column members.role_id does not exist"

Added by Jean Maynier over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
2010-03-16
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

When upgrading from 0.8.7 to 0.9.3 I followed the steps decsribed in http://www.redmine.org/wiki/redmine/RedmineUpgrade

I had some problems with "rake db:migrate RAILS_ENV=production" and "rake db:migrate_plugins RAILS_ENV=production" due to old plugins and pg missing gem.
I then removed my 0.8.7 plugins and just let the embedded plugins with 0.9.3, and the update passed.

When I restarted Apache (I use passenger) and tried to connect to redmine, I had the internal error page. Everything was ok in the apache and redmine logs.
The only problems is in postgres logs, where I have this error everytime I try to access a redmine page:
"ERROR: column members.role_id does not exist"

Looks like the database is not updated.

My config :

Postgres 8.1
ruby 1.8.6 (2007-09-24 patchlevel 111) [i686-linux]
gem 1.3.6

  • LOCAL GEMS ***

actionmailer (2.3.5, 2.3.2)
actionpack (2.3.5, 2.3.2)
activerecord (2.3.5, 2.3.2)
activeresource (2.3.5, 2.3.2)
activesupport (2.3.5, 2.3.2)
fastthread (1.0.7)
googlecharts (1.5.3)
passenger (2.2.11, 2.2.8)
pg (0.9.0)
rack (1.1.0, 1.0.1)
rails (2.3.5, 2.3.2)
rake (0.8.7, 0.8.3)
ruby-postgres (0.7.1.2006.04.06)
rubygems-update (1.3.6)

Actions

Also available in: Atom PDF