What redmine version? Please also post the error trace from log/production.log.

I am using redmine version 1.0.1 and the productionlog in ~/redmine is empty.

OK I got the wrong the log file ,

Processing IssuesController#index (for 192.168.0.100 at 2010-10-31 05:14:50) [GET]
Parameters: {"project_id"=>"cair-vr", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/index.rhtml

ActionView::TemplateError (undefined method `-' for nil:NilClass) on line #16 of app/views/issues/_list.rhtml:
13: </tr></thead>
14: <% previous_group = false >
15: <tbody>
16: < issue_list(issues) do |issue, level| ->
17: < if @query.grouped? && (group = @query.group_by_column.value(issue)) != previous_group >
18: < reset_cycle %>
19: <tr class="group open">

app/helpers/issues_helper.rb:28:in `issue_list'
app/helpers/issues_helper.rb:23:in `issue_list'
app/views/issues/_list.rhtml:16:in `_run_rhtml_app47views47issues47_list46rhtml_locals_issues_list_object_query'
app/views/issues/_list.rhtml:1:in `_run_rhtml_app47views47issues47_list46rhtml_locals_issues_list_object_query'
app/views/issues/index.rhtml:62:in `_run_rhtml_app47views47issues47index46rhtml'
app/controllers/issues_controller.rb:85:in `index'
app/controllers/issues_controller.rb:84:in `index'
/usr/lib64/ruby/1.8/thread.rb:135:in `synchronize'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib64/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:23:in `start'
/usr/lib64/ruby/1.8/webrick/server.rb:82:in `start'

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

Can anyone help me ?

Have you upgraded recently?

Yes to 1.0.1 ,1 months back.

priyadarshee kumar wrote:

Yes to 1.0.1 ,1 month back.

Have you had any problems upgrading the database? Have you had the subtasks plugin installed at any point on this redmine? What plugins do you have installed now?

I upgraded using the link:

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

and I faced no problem during the database upgrade. And I am a new Sysadmin here and asked to upgrade to newer version and I just upgrade as the above link and I dont install any plugin after upgradation. I checked and there is no plugin installed under the plugin button under administration.

priyadarshee kumar wrote:

and I faced no problem during the database upgrade.

Ok, you still have inconsistent data. Any rows in the issues table in the DB with empty lft, rgt or root columns?

In the issues table in the redmine DB ,in the lft column the first 40 rows are NULL and rest 548 rows are 1 and in the rgt column the first 40 rows are NULL and rest 548 rows are 2

Are you more comfortable with the DB or the rails console? I think I have a solution for you, but it can be applied from both places.

Yes I am comfortable with the DB but not with rails, but that will not be a problem. Please suggest the solution.

Set all empty lft fields to 1, all empty rgt fields to 2 and all empty root_id fields to the same as the id of the row.

I will change the NULL fields of lft and rgt to 1 and 2 ,but in case of root_id upto 20 rows value is NULL and then it starts with 1 upto 558 incremented, the last. So what value will I put in the NULL of root_id ?

priyadarshee kumar wrote:

I will change the NULL fields of lft and rgt to 1 and 2 ,but in case of root_id upto 20 rows value is NULL and then it starts with 1 upto 558 incremented, the last. So what value will I put in the NULL of root_id ?

Ok, will I update the root_id as the value in id ?

priyadarshee kumar wrote:

priyadarshee kumar wrote:

I will change the NULL fields of lft and rgt to 1 and 2 ,but in case of root_id upto 20 rows value is NULL and then it starts with 1 upto 558 incremented, the last. So what value will I put in the NULL of root_id ?

Ok, will I update the root_id as the value in id ?

Mmh, that's very odd too… 1. Make sure you have backups, 2. judging from everything you have told me, you haven't used subtasks yet, right? If so, set all root_id to the same value as id in the issues table. Do you have any process that bypasses redmine and just writes to the DB?

okkkk I will backup first the redmine DB and then apply the changes. Where is subtask ? And there is no process in the processlist .

Hi,

I got the same problem, internal error with issues and new issue tabs after an upgrade from 1.0 to 1.03 version of my redmine installation. My redmine are running with 2.3.5 Rails version and 1.8.7 Ruby version.

Here an extract of the production log file :
Processing IssuesController#index (for 137.129.13.178 at 2010-11-05 10:23:19) [GET]
Parameters: {"project_id"=>"tice", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/index.rhtml

ActionView::TemplateError (undefined local variable or method `issues_context_menu_path' for #<ActionView::Base:0xb662832c>) on line #85 of app/views/issues/index.rhtml:
82: <%= auto_discovery_link_tag(:atom, {:controller => 'journals', :action => 'index', :query_id => @query, :format => 'atom', :page => nil, :key => User.current.rss_key}, :title => l(:label_changes_details)) >
83: < end >
84:
85: <= context_menu issues_context_menu_path %>

app/views/issues/index.rhtml:85:in `_run_rhtml_app47views47issues47index46rhtml'
    app/controllers/issues_controller.rb:84:in `index'
    app/controllers/issues_controller.rb:83:in `index'
    passenger (2.2.13) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.13) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

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

Processing IssuesController#index (for 137.129.13.178 at 2010-11-05 10:23:20) [GET]
Parameters: {"project_id"=>"tice", "action"=>"index", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/index.rhtml

ActionView::TemplateError (undefined local variable or method `issues_context_menu_path' for #<ActionView::Base:0xb66c4e98>) on line #85 of app/views/issues/index.rhtml:
82: <%= auto_discovery_link_tag(:atom, {:controller => 'journals', :action => 'index', :query_id => @query, :format => 'atom', :page => nil, :key => User.current.rss_key}, :title => l(:label_changes_details)) >
83: < end >
84:
85: <= context_menu issues_context_menu_path %>

app/views/issues/index.rhtml:85:in `_run_rhtml_app47views47issues47index46rhtml'
    app/controllers/issues_controller.rb:84:in `index'
    app/controllers/issues_controller.rb:83:in `index'
    passenger (2.2.13) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.13) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.13) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.13) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.13) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.13) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

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

Can anyone help me ?

Vincent

priyadarshee kumar wrote:

okkkk I will backup first the redmine DB and then apply the changes. Where is subtask ? And there is no process in the processlist .

Subtaks was a plugin to install subtasks, and the question about another process was to know if redmine is the only application using the redmine DB, or do other applications use it?

Vincent Terol wrote:

Can anyone help me ?

Probably, but you shouldn't hijack another unrelated thread. Please open a new one.

Thanks a lot Felix,you saved me.

Felix Schäfer wrote:

Vincent Terol wrote:

Can anyone help me ?

Probably, but you shouldn't hijack another unrelated thread. Please open a new one.

Thanks for your answer,

I just found that there was an error in my routes.rb file. I copied this from my old 1.0 installation instead to modify the config file contained in the 1.03 version.

Vincent

priyadarshee kumar wrote:

I will change the NULL fields of lft and rgt to 1 and 2 ,but in case of root_id upto 20 rows value is NULL and then it starts with 1 upto 558 incremented, the last. So what value will I put in the NULL of root_id ?

#### BACKUP FIRST ####¶

This worked for me, I'm not responsible if you mess up your db!

UPDATE `issues` SET `lft` = '1' WHERE `lft` IS NULL;
UPDATE `issues` SET `rgt` = '1' WHERE `rgt` IS NULL;
UPDATE `issues` SET `root_id` = `id` WHERE `root_id` IS NULL;

a quick fix, maybe a great help to others as well (thx Bence)

@_list.rhtml:30:

-<% query.columns.each do |column| ><= content_tag 'td', column_content(column, issue), :class => column.name >< end >
</tr>
+< query.columns.each do |column| ><= content_tag 'td', (column_content(column, issue) rescue 'n/a'), :class => column.name >< end %>