Moved Redmine to new server, projects gets redMine 500 error

I backup redmine mysql and "/files"'s files. I set up new redmine on new server and import sql.

When I try to reach project page in redmine, gives this error
" redMine 500 error
Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your redMine administrator for assistance.
"
where the error could have made?
versions:
mysql 5.1.49
ruby 1.8.7
rails 2.3.5

Replies (2)

RE: Moved Redmine to new server, projects gets redMine 500 error - Added by Ali Ata over 13 years ago

ruby script/server webrick -e production

=> Booting WEBrick
=> Rails 2.3.5 application starting on http://0.0.0.0:3000
./script/../config/../vendor/rails/railties/lib/rails/gem_dependency.rb:119:Warning: Gem::Dependency#version_requirements is deprecated and will be removed on or after August 2010.  Use #requirement
=> Call with -d to detach
=> Ctrl-C to shutdown server
[2010-11-27 13:51:45] INFO  WEBrick 1.3.1
[2010-11-27 13:51:45] INFO  ruby 1.8.7 (2010-06-23) [x86_64-linux]
[2010-11-27 13:51:50] INFO  WEBrick::HTTPServer#start: pid=8033 port=3000
The {{key}} interpolation syntax in I18n messages is deprecated. Please use %{key} instead.
tr - 0 open / {{total}}

Processing ProjectsController#show (for 192.168.0.106 at 2010-11-27 13:51:54) [GET]
  Parameters: {"action"=>"show", "id"=>"android", "controller"=>"projects"}
Rendering template within layouts/base
Rendering projects/show

ActionView::TemplateError (Mysql::Error: Unknown column 'versions.sharing' in 'where clause': SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions`  LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 22 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy')))) ) on line #45 of app/views/layouts/base.rhtml:
42:     
43:     <% if display_main_menu?(@project) %>
44:     <div id="main-menu">
45:         <%= render_main_menu(@project) %>
46:     </div>
47:     <% end %>
48: </div>

    lib/redmine.rb:146
    lib/redmine/menu_manager.rb:282:in `call'
    lib/redmine/menu_manager.rb:282:in `allowed_node?'
    lib/redmine/menu_manager.rb:252:in `menu_items_for'
    lib/redmine/menu_manager.rb:251:in `each'
    lib/redmine/menu_manager.rb:251:in `menu_items_for'
    lib/redmine/menu_manager.rb:176:in `render_menu'
    lib/redmine/menu_manager.rb:166:in `render_main_menu'
    app/views/layouts/base.rhtml:45:in `_run_rhtml_app47views47layouts47base46rhtml'
    /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
    /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
    /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
    /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
    /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
    /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
    /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
    /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
    /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
    /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /var/www/redmine/public/500.html (500 Internal Server Error)

RE: Moved Redmine to new server, projects gets redMine 500 error - Added by Felix Schäfer over 13 years ago

Have you upgraded your database schema/contents to match the redmine version?

(1-2/2)

Project

General

Profile

Redmine