Project

General

Profile

Actions

Defect #5366

closed

Missing columns after upgrade from 0.8.4 to 0.9.3

Added by Curtis Hall about 14 years ago. Updated about 14 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
2010-04-21
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I followed the instructions as listed here (http://www.redmine.org/wiki/redmine/RedmineUpgrade). I also did 'rake db:migrate RAILS_ENV=production'

ActiveRecord::StatementInvalid (Mysql::Error: Unknown column 'projects.projects_count' in 'field list': SELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`projects_count` AS t2_r6, `projects`.`created_on` AS t2_r7, `projects`.`updated_on` AS t2_r8, `projects`.`identifier` AS t2_r9, `projects`.`status` AS t2_r10 FROM `news`  LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND  (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' )  LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (1=0 OR projects.is_public = 1)))  ORDER BY news.created_on DESC LIMIT 5):

and

ActiveRecord::StatementInvalid (Mysql::Error: Unknown column 'members.role_id' in 'field list': SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`role_id` AS t0_r3, `members`.`created_on` AS t0_r4, `members`.`mail_notification` AS t0_r5, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`projects_count` AS t1_r6, `projects`.`created_on` AS t1_r7, `projects`.`updated_on` AS t1_r8, `projects`.`identifier` AS t1_r9, `projects`.`status` AS t1_r10, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members`  LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id  LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`)  LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 3 AND (projects.status=1))  ORDER BY projects.name):

I manually created a column for project_count. Shouldn't this have been done during the upgrade process? Did I miss a step? What should the column information be for these missing columns?

Actions #1

Updated by Curtis Hall about 14 years ago

  • Status changed from New to Resolved

Duplicate of #5092. I thought simply restarting apache would restart the passenger module, it did not.

Actions #2

Updated by Felix Schäfer about 14 years ago

Restarting apache restarts passenger, it might be that you didn't really stop all apache processes. We should probably update the upgrade guide to include mentions about the plugins, could you do that regarding your experience?

Actions #3

Updated by Jean-Philippe Lang about 14 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Invalid

OK, thanks for the feedback.

Actions

Also available in: Atom PDF