Post again,that one I've post probably was not clearly

Added by weiwei lei about 8 years ago

I update my redmine from a low version to 0.8.5,but I meet the problems below,I search the anwsers through google but can't find the answer to solve my problem.So I post here.Hope someone can help me.
The errors are below
h2. ActiveRecord::StatementInvalid in WelcomeController#index

Mysql::Error: Unknown 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))

I am waiting!!!

Replies (3)

RE: Post again,that one I've post probably was not clearly - Added by Nicklas Holm almost 8 years ago

I get the same error (see attached file). Upgraded from trunk (r2847) to 0.8.5. Since I'm not able to perform all db migrations from from a "Release Version" I first pulled latest trunk to do that. Then I unzipped 0.8.5 and pointed it to my newly migrated db.

RE: Post again,that one I've post probably was not clearly - Added by Nicklas Holm almost 8 years ago

I just tested 0.8.6 with same result.

RE: Post again,that one I've post probably was not clearly - Added by Yuval Hager almost 8 years ago

I have r2982 and it is working. I tried upgrading to latest dev but 'rake db:migrate' failed on 'test:plugins'. Then I tried latest 0.8-stable, and db:migrate passed, but I got the above error.

I switched back to r2982 and restored the db from backup. I don't know if this is an error in HEAD that dragged itself onto stable in my case, or some other kind of error in migration - fact is I can't upgrade at the moment.

(1-3/3)