500 Internal Server Error on a new Redmine server

Added by Vano Egler over 9 years ago

Hello, I'm new to Redmine, I installed version 2.2 on Ubuntu 12.04 and PostgreSQL, first it seemed to be OK, but now I faced several problems.
I created a test project, but, for example, when I click "Activity", I got 500 Error.
Is it something wrong with my database?, here's the production.log:

Started GET "/projects/aaawww/activity" for x.x.x.x at Tue Jan 08 11:33:22 +0200 2013
Processing by ActivitiesController#index as HTML
Parameters: {"id"=>"aaawww"}
Current user: admin (id=1)
Completed 500 Internal Server Error in 34ms

ActiveRecord::StatementInvalid (PGError: ERROR: column journals.private_notes does not exist
LINE 1: ...odules em WHERE em.name='issue_tracking'))) AND ((journals.p...
^
: SELECT "journals"."id" AS t0_r0, "journals"."journalized_id" AS t0_r1, "journals"."journalized_type" AS t0_r2, "journals"."user_id" AS t0_r3, "journals"."notes" AS t0_r4, "journals"."created_on" AS t0_r5,$
lib/plugins/acts_as_activity_provider/lib/acts_as_activity_provider.rb:82:in `find_events'
lib/redmine/activity/fetcher.rb:76:in `events'
lib/redmine/activity/fetcher.rb:75:in `each'
lib/redmine/activity/fetcher.rb:75:in `events'
lib/redmine/activity/fetcher.rb:74:in `each'
lib/redmine/activity/fetcher.rb:74:in `events'
} app/controllers/activities_controller.rb:41:in `index'

Replies (2)

RE: 500 Internal Server Error on a new Redmine server - Added by Etienne Massip over 9 years ago

Did you run rake db:migrate RAILS_ENV=production?

RE: 500 Internal Server Error on a new Redmine server - Added by Vano Egler over 9 years ago

Yes, thanks for help, the problem was in old database format.

(1-2/2)