Project

General

Profile

Actions

Defect #8906

closed

500 on ticket

Added by Jan Thurau almost 13 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-07-26
Due date:
% Done:

90%

Estimated time:
Resolution:
Invalid
Affected version:

Description

My Environment:

development:/home/redmine/site# RAILS_ENV=production ruby script/about
/home/redmine/site/vendor/plugins/rfpdf/lib/fpdf/chinese.rb:49: warning: already initialized constant Big5_widths
/home/redmine/site/vendor/plugins/rfpdf/lib/fpdf/chinese.rb:60: warning: already initialized constant GB_widths
/home/redmine/site/vendor/plugins/rfpdf/lib/fpdf/japanese.rb:49: warning: already initialized constant SJIS_widths
/home/redmine/site/vendor/plugins/rfpdf/lib/fpdf/korean.rb:49: warning: already initialized constant UHC_widths
About your application's environment
Ruby version              1.8.7 (x86_64-linux)
RubyGems version          1.4.1
Rack version              1.1.2
Rails version             2.3.11
Active Record version     2.3.11
Active Resource version   2.3.11
Action Mailer version     2.3.11
Active Support version    2.3.11
Edge Rails revision       unknown
Application root          /home/redmine/site
Environment               production
Database adapter          mysql
Database schema version   20110511000000

About your Redmine plugins
Mylyn Connector plugin   2.7.1.stable
development:/home/redmine/site# 

Log:
I updated form 1.1.0 to 1.2.1. Now I get this error on some tickets:


development:/home/redmine/site/log# tail -n 50 production.log 
Rendering template within layouts/base
Rendering issues/show.rhtml

ActionView::TemplateError (Mysql::Error: Column 'lft' in order clause is ambiguous: SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3, `issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5, `issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7, `issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9, `issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11, `issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13, `issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15, `issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17, `issues`.`parent_id` AS t0_r18, `issues`.`root_id` AS t0_r19, `issues`.`lft` AS t0_r20, `issues`.`rgt` AS t0_r21, `issues`.`is_private` AS t0_r22, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11 FROM `issues`  LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (issues.id != 1012)) AND ((issues.`lft` <= 2 AND issues.`rgt` >= 3) AND (`issues`.`root_id` = 1051)))  ORDER BY `lft`) on line #9 of app/views/issues/show.rhtml:
6:         <%= avatar(@issue.author, :size => "50") %>
7:       
8: <div class="subject">      
9: <%= render_issue_subject_with_tree(@issue) %>
10: </div>
11:         <p class="author">
12:         <%= authoring @issue.created_on, @issue.author %>.

    app/helpers/issues_helper.rb:64:in `render_issue_subject_with_tree'
    app/views/issues/show.rhtml:9:in `_run_rhtml_app47views47issues47show46rhtml'
    app/controllers/issues_controller.rb:122:in `show'
    app/controllers/issues_controller.rb:121:in `show'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/utils.rb:479:in `safe_fork'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:180:in `start'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
    /var/lib/gems/1.8/gems/passenger-3.0.0/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
    /var/lib/gems/1.8/gems/passenger-3.0.0/helper-scripts/passenger-spawn-server:99

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

Processing WelcomeController#index (for 87.237.120.133 at 2011-07-26 20:47:25) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
Redirected to http://redmine/login?back_url=http%3A%2F%2Fredmine%2F
Filter chain halted as [:check_if_login_required] rendered_or_redirected.
Completed in 4ms (DB: 1) | 302 Found [http://redmine/]
development:/home/redmine/site/log# 

Please tell me if you need additional information.

Best regards
Jan


Related issues

Has duplicate Redmine - Defect #9058: 500 error on issues (1.2.1)Closed2011-08-15

Actions
Actions

Also available in: Atom PDF