'Issues' TAB giving internal error

Added by priyadarshee kumar over 8 years ago

I have redmine installed on Suse . Before some days everything was working fine. Now the 'issues' TAB under some projects gives internal error.

I am not getting any way to resolve this ..

Replies (25)

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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)

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

Have you upgraded recently?

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

Yes to 1.0.1 ,1 months back.

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

priyadarshee kumar wrote:

Yes to 1.0.1 ,1 month back.

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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?

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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.

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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?

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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.

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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.

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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 ?

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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 ?

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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?

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by Vincent Terol over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

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?

RE: 'Issues' TAB giving internal error - Added by Felix Schäfer over 8 years ago

Vincent Terol wrote:

Can anyone help me ?

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

RE: 'Issues' TAB giving internal error - Added by priyadarshee kumar over 8 years ago

Thanks a lot Felix,you saved me.

RE: 'Issues' TAB giving internal error - Added by Vincent Terol over 8 years ago

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

RE: 'Issues' TAB giving internal error - Added by Daniel Macedo over 8 years ago

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;

RE: 'Issues' TAB giving internal error - Added by Balázs Benedek over 8 years ago

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 %>

(1-25/25)