Project

General

Profile

Forums » Open discussion »

Error redmine 2.0

Added by Gabriel Vasquez almost 12 years ago

Greetings

I have an issue with redmine 2.0, i did copy my files and bzr directories to redmine and restore the bd mysql but when I try to access to some of my projects I get a screen with the following 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.

If you are the Redmine administrator, check your log files for details about the error.

I checked the log and this is what it shows:

ActionView::Template::Error (Mysql::Error: Unknown column 'is_default' in 'where clause': SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 8 AND (is_default = 1) 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___1907414176_70203695936440'
app/controllers/projects_controller.rb:168:in `show'

Im trying to upgrade my redmine from 1.4 to 2.0 and I don't want to lose all my proyects and tickets.

I would appreciate any help


Replies (3)

RE: Error redmine 2.0 - Added by Planet Master almost 12 years ago

Means your database wasnt updated properly as 2.0x adds the is_default row in the repositories table.

2.0x removes 'created_with_scm' row and adds

You can add them manually via phpMyAdmin or via ssh
`identifier` varchar(255) DEFAULT NULL,
`is_default` tinyint(1) DEFAULT '0',

RE: Error redmine 2.0 - Added by William Roush almost 12 years ago

From here:

http://www.redmine.org/projects/redmine/wiki/RedmineUpgrade

Run this:

rake db:migrate RAILS_ENV=production

DO NOT go rolling face on the MySQL database unless you really know what you're doing, you may leave yourself in a partially upgraded state and chasing errors for months. (Though I'm not familiar with 1.4's vs 2.0's DB schema, it COULD be only the above change).

RE: Error redmine 2.0 - Added by Gabriel Vasquez almost 12 years ago

Thank you guys that really help!

Now I can watch all my proyects and tickets.

Thank you so much again!

    (1-3/3)