Project

General

Profile

Error after upgrading 1.2.1 to 2.0.0

Added by Sridher Jakku almost 12 years ago

I am getting this error after Upgrading to 2.0.0
env : Ubuntu 12.04 server
db :Postgresql 9.1 (i tested on 9.0 same error; then upgraded)

Started GET "/projects/ems-ac" for 192.168.1.104 at Thu May 17 19:31:36 +0530 2012
Processing by ProjectsController#show as HTML
Parameters: {"id"=>"ems-ac"}
[1m[36m (0.7ms)[0m [1mSELECT MAX AS max_id FROM "settings" [0m
[1m[35mUser Load (0.5ms)[0m SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = $1 AND (users.status = 1) LIMIT 1 "id", 4
[1m[36mProject Load (0.6ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."identifier" = 'ems-ac' LIMIT 1[0m
[1m[35mEnabledModule Load (0.9ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 52
[1m[36mSQL (2.3ms)[0m [1mSELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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"."created_on" AS t1_r6, "projects"."updated_on" AS t1_r7, "projects"."identifier" AS t1_r8, "projects"."status" AS t1_r9, "projects"."lft" AS t1_r10, "projects"."rgt" AS t1_r11, "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, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 4 AND (projects.status=1) ORDER BY projects.name[0m
[1m[35mSQL (2.2ms)[0m SELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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"."admin" AS t1_r6, "users"."status" AS t1_r7, "users"."last_login_on" AS t1_r8, "users"."language" AS t1_r9, "users"."auth_source_id" AS t1_r10, "users"."created_on" AS t1_r11, "users"."updated_on" AS t1_r12, "users"."type" AS t1_r13, "users"."identity_url" AS t1_r14, "users"."mail_notification" AS t1_r15, "users"."salt" AS t1_r16, "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, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "users" ON "users"."id" = "members"."user_id" AND "users"."type" IN ('User', 'AnonymousUser') LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."project_id" = 52 AND (users.type='User' AND users.status=1)
[1m[36mRole Load (0.7ms)[0m [1mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1[0m
[1m[35mProject Load (0.7ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = 52 AND (((projects.status=1) AND (projects.is_public = 't' OR projects.id IN (52,39,38,37,50,34,33,49,45,32,47,46,48,51,53,35,43,42,40,44,41)))) ORDER BY lft
[1m[36mNews Load (1.3ms)[0m [1mSELECT "news".* FROM "news" WHERE "news"."project_id" = 52 ORDER BY news.created_on DESC LIMIT 5[0m
[1m[35mTracker Load (1.8ms)[0m SELECT DISTINCT trackers.* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" WHERE (projects.lft >= 54 AND projects.rgt <= 55 AND projects.status = 1) ORDER BY trackers.position
[1m[36mSetting Load (0.6ms)[0m [1mSELECT "settings".* FROM "settings" WHERE "settings"."name" = 'display_subprojects_issues' LIMIT 1[0m
[1m[35mCACHE (0.0ms)[0m SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1
[1m[36mGroup Load (1.0ms)[0m [1mSELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group') AND "groups_users"."user_id" = 4[0m
[1m[35m (0.4ms)[0m SHOW max_identifier_length
[1m[36m (4.0ms)[0m [1mSELECT COUNT AS count_id, tracker_id AS tracker_id FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" LEFT OUTER JOIN "trackers" ON "trackers"."id" = "issues"."tracker_id" WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 't' AND ((issues.is_private = 'f' OR issues.author_id = 4 OR issues.assigned_to_id IN (4)))) OR (projects.id IN (52,39,38,37,50,34,33,49,45,32,47,46,48,51,53,35,43,42,40,44,41) AND ((issues.is_private = 'f' OR issues.author_id = 4 OR issues.assigned_to_id IN (4))))))) AND (((projects.id = 52 OR (projects.lft > 54 AND projects.rgt < 55))) AND issue_statuses.is_closed='f') GROUP BY tracker_id[0m
[1m[35mTracker Load (0.8ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = $1 LIMIT 1 "id", "5"
[1m[36mCACHE (0.0ms)[0m [1mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1[0m
[1m[35m (2.5ms)[0m SELECT COUNT AS count_id, tracker_id AS tracker_id FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" LEFT OUTER JOIN "trackers" ON "trackers"."id" = "issues"."tracker_id" WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 't' AND ((issues.is_private = 'f' OR issues.author_id = 4 OR issues.assigned_to_id IN (4)))) OR (projects.id IN (52,39,38,37,50,34,33,49,45,32,47,46,48,51,53,35,43,42,40,44,41) AND ((issues.is_private = 'f' OR issues.author_id = 4 OR issues.assigned_to_id IN (4))))))) AND ((projects.id = 52 OR (projects.lft > 54 AND projects.rgt < 55))) GROUP BY tracker_id
[1m[36mCACHE (0.0ms)[0m [1mSELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = $1 LIMIT 1[0m "id", "5"
[1m[35mCACHE (0.0ms)[0m SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1
[1m[36m (2.5ms)[0m [1mSELECT SUM AS sum_id FROM "time_entries" LEFT OUTER JOIN "projects" ON "projects"."id" = "time_entries"."project_id" WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) AND (projects.is_public = 't' OR projects.id IN (52,39,38,37,50,34,33,49,45,32,47,46,48,51,53,35,43,42,40,44,41)))) AND ((projects.id = 52 OR (projects.lft > 54 AND projects.rgt < 55)))[0m
[1m[35mToken Load (0.7ms)[0m SELECT "tokens".* FROM "tokens" WHERE "tokens"."user_id" = 4 AND (action='feeds') LIMIT 1
[1m[36mCustomField Load (1.0ms)[0m [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY position[0m
[1m[35mSetting Load (0.7ms)[0m SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'user_format' LIMIT 1
Rendered projects/_members_box.html.erb (4.7ms)
Rendered projects/show.html.erb within layouts/base (34.6ms)
[1m[36mUserPreference Load (0.6ms)[0m [1mSELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 4 LIMIT 1[0m
[1m[35mCACHE (0.0ms)[0m SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1
[1m[36mProject Load (1.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE ("projects"."lft" <= 54 AND "projects"."rgt" >= 55) AND ("projects".id != 52) AND (((projects.status=1) AND (projects.is_public = 't' OR projects.id IN (52,39,38,37,50,34,33,49,45,32,47,46,48,51,53,35,43,42,40,44,41)))) ORDER BY "projects"."lft"[0m
[1m[35mProject Load (0.7ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" IS NULL AND ("projects"."lft" <= 54 AND "projects"."rgt" >= 55) ORDER BY "projects"."lft" LIMIT 1
[1m[36m (1.5ms)[0m [1mSELECT COUNT FROM "versions" LEFT OUTER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 52 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 53 AND projects.rgt <= 84 AND versions.sharing = 'tree') OR (projects.lft < 54 AND projects.rgt > 55 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 54 AND projects.rgt < 55 AND versions.sharing = 'hierarchy'))))[0m
[1m[35mWiki Load (0.9ms)[0m SELECT "wikis".* FROM "wikis" WHERE "wikis"."project_id" = 52 LIMIT 1
[1m[36m (0.8ms)[0m [1mSELECT COUNT() FROM "boards" WHERE "boards"."project_id" = 52[0m
[1m[35mRepository Load (1.0ms)[0m SELECT "repositories".
FROM "repositories" WHERE "repositories"."project_id" = 52 AND (is_default = 't') LIMIT 1
PG::Error: ERROR: column "is_default" does not exist
LINE 1: ...ies" WHERE "repositories"."project_id" = 52 AND (is_default...
^
: SELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = 52 AND (is_default = 't') LIMIT 1
Completed 500 Internal Server Error in 454ms

ActionView::Template::Error (PG::Error: ERROR: column "is_default" does not exist
LINE 1: ...ies" WHERE "repositories"."project_id" = 52 AND (is_default...
^
: SELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = 52 AND (is_default = 't') LIMIT 1):
48: <% end >
49:
50: <h1><
= page_header_title ></h1>
51:
52: <
if display_main_menu?(Herve Harster) >
53: <div id="main-menu">
54: <
= render_main_menu(Herve Harster) %>
lib/redmine.rb:209
lib/redmine/menu_manager.rb:196:in `call'
lib/redmine/menu_manager.rb:196:in `allowed_node?'
lib/redmine/menu_manager.rb:166:in `menu_items_for'
lib/redmine/menu_manager.rb:165:in `each'
lib/redmine/menu_manager.rb:165:in `menu_items_for'
lib/redmine/menu_manager.rb:90:in `render_menu'
lib/redmine/menu_manager.rb:80:in `render_main_menu'
app/views/layouts/base.html.erb:51:in `_app_views_layouts_base_html_erb___335552369_70106505428140'
app/controllers/projects_controller.rb:168:in `show'


Replies (2)

RE: Error after upgrading 1.2.1 to 2.0.0 - Added by Etienne Massip almost 12 years ago

Guess you forgot to run your database migration, please check RedmineUpgrade.

RE: Error after upgrading 1.2.1 to 2.0.0 - Added by Sridher Jakku almost 12 years ago

Hi Etienne Massip,

Oops ... !
 I didn't noticed the migration command error(it's typo error).
I re-run the migration(this time without typo error :) ) it's fixed.

Thanks

    (1-2/2)