Forums » Help »
Help Upgrading please
Added by Craig Efrein over 14 years ago
Hello all,
I am getting the following error from Redmine whenever I run rake migrate RAILS_ENV=production on a redmine database for version 0.8.4.devel.2815 to any other version. In this case 0.8.5.
ActionView::TemplateError (Mysql::Error: #42S22Unknown column 'members.role_id' in 'on clause': SELECT count(DISTINCT `members`.id) AS count_all FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `roles` ON `roles`.id = `members`.role_id WHERE (`members`.user_id = 2 AND (projects.status=1)) ) on line #37 of layouts/base.rhtml:
34: <%= link_to l(:label_search), {:controller => 'search', :action => 'index', :id => Herve Harster}, :accesskey => accesskey(:search) >:
35: <= text_field_tag 'q', @question, :size => 20, :class => 'small', :accesskey => accesskey(:quick_search) >
36: < end >
37: <= render :partial => 'layouts/project_selector' if User.current.memberships.any? >
38: </div>
39:
40: <h1><= h(Herve Harster && !@project.new_record? ? @project.name : Setting.app_title) %></h1>
If I don't run the migrate:db command, redmine appears to respond normally.
Thanks,
Craig
Sorry, small mistake. This is the command I'm running
rake db:migrate RAILS_ENV=production
The result from this command is simply the folder name
[root@localhost redmine-0.8.5]# rake db:migrate RAILS_ENV=production
(in /opt/redmine-0.8.5)
[root@localhost redmine-0.8.5]#
Ruby version 1.8.6 (i386-linux)
RubyGems version 1.0.1
Rails version 2.1.2
Active Record version 2.1.2
Action Pack version 2.1.2
Active Resource version 2.1.2
Action Mailer version 2.1.2
Active Support version 2.1.2
Edge Rails revision unknown
Application root /opt/redmine
Environment production
Database adapter mysql
Database schema version 20090614091200