'Issues' TAB giving internal error
Added by priyadarshee kumar almost 14 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 almost 14 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 almost 14 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 almost 14 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.rhtmlActionView::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 priyadarshee kumar almost 14 years ago
Can anyone help me ?
RE: 'Issues' TAB giving internal error
-
Added by Felix Schäfer almost 14 years ago
Have you upgraded recently?
RE: 'Issues' TAB giving internal error
-
Added by priyadarshee kumar almost 14 years ago
Yes to 1.0.1 ,1 months back.
RE: 'Issues' TAB giving internal error
-
Added by priyadarshee kumar almost 14 years ago
priyadarshee kumar wrote:
Yes to 1.0.1 ,1 month back.
RE: 'Issues' TAB giving internal error
-
Added by Felix Schäfer almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 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 almost 14 years ago
Thanks a lot Felix,you saved me.
RE: 'Issues' TAB giving internal error
-
Added by Vincent Terol almost 14 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 almost 14 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 13 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 %>