Project

General

Profile

Internal server error on show issues » RedmineErrorC.txt

Constantin Manea, 2014-04-10 15:36

 
1
Started GET "/redmine/projects/project-name/issues" for xxx.xxx.xxx.xxx at 2014-03-17 11:45:21 +0200
2
Processing by IssuesController#index as HTML
3
  Parameters: {"project_id"=>"project-name"}
4
  Current user: user.name (id=3)
5
  Rendered queries/_filters.html.erb (56.4ms)
6
  Rendered queries/_columns.html.erb (2.0ms)
7
  Rendered plugins/extended_fields/app/views/issues/_list.html.erb (12.5ms)
8
  Rendered plugins/redmine_loader/app/views/loader/_other_formats_builder.html.erb (1.4ms)
9
  Rendered plugins/redmine_contacts/app/views/issues/_contacts.html.erb (1.2ms)
10
  Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_template_link.html.erb (0.1ms)
11
  Rendered issues/_sidebar.html.erb (13.8ms)
12
  Rendered issues/index.html.erb within layouts/cms (96.6ms)
13
Completed 500 Internal Server Error in 287.7ms
14
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_request.text.erb (0.3ms)
15
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
16
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_session.text.erb (1.5ms)
17
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.0ms)
18
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_environment.text.erb (23.4ms)
19
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
20
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_backtrace.text.erb (0.1ms)
21
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
22
  Rendered plugins/redmine_exception_handler/vendor/plugins/exception_notification/lib/exception_notifier/views/exception_notifier/exception_notification.text.erb (33.6ms)
23

    
24
ActionView::Template::Error (Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  OR issues.id IN (182,183,193,223,277,284,316,391,420,436,437,441,442,443,444,' at line 1: SELECT COUNT(DISTINCT `issues`.`id`) FROM `issues` INNER JOIN `watchers` ON `watchers`.`watchable_id` = `issues`.`id` AND `watchers`.`watchable_type` = 'Issue' LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (( ((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.id IN (38,21,20,24,37,16,13,33,19,18,2,15,1,3,28,4,5) OR projects.id IN (24,25) OR (projects.id IN (24) AND ((issues.is_private = 0 OR issues.author_id = 3 OR issues.assigned_to_id IN (3,,)  OR issues.id IN (182,183,193,223,277,284,316,391,420,436,437,441,442,443,444,446,447,448,455,459,460,461,464,467,474,500,501,502,503,505,506,507,508,509,510,574,576,578,579,580,581,582,585,586,587,588,589,590,591,592,593,594,595,596,597,598,601,603,912,1014,1040,1043,1065,1103,1112,1119,1120,1121,1127,1128,1129,1130,1133,1134,1141,1142,1143,1144,1145,1160,1163,1164,1165,1061,1171,217,243,426,1183,1184,1188,1187,1192,1193,1203,1205,1206,1214,1215,1220,1221,1227,1234,1237,1240,1243,1244,1247,1250,1251,1253,1254,1256,1257,1259,1271,1272,1273,1275,1276,1277,1278)))) OR (projects.id IN (24) AND ((issues.is_private = 0 OR issues.author_id = 3 OR issues.assigned_to_id IN (3,,)  OR issues.id IN (182,183,193,223,277,284,316,391,420,436,437,441,442,443,444,446,447,448,455,459,460,461,464,467,474,500,501,502,503,505,506,507,508,509,510,574,576,578,579,580,581,582,585,586,587,588,589,590,591,592,593,594,595,596,597,598,601,603,912,1014,1040,1043,1065,1103,1112,1119,1120,1121,1127,1128,1129,1130,1133,1134,1141,1142,1143,1144,1145,1160,1163,1164,1165,1061,1171,217,243,426,1183,1184,1188,1187,1192,1193,1203,1205,1206,1214,1215,1220,1221,1227,1234,1237,1240,1243,1244,1247,1250,1251,1253,1254,1256,1257,1259,1271,1272,1273,1275,1276,1277,1278)))) OR (projects.id IN (24) AND ((issues.author_id = 3 OR issues.assigned_to_id IN (3,,)  OR issues.id IN (182,183,193,223,277,284,316,391,420,436,437,441,442,443,444,446,447,448,455,459,460,461,464,467,474,500,501,502,503,505,506,507,508,509,510,574,576,578,579,580,581,582,585,586,587,588,589,590,591,592,593,594,595,596,597,598,601,603,912,1014,1040,1043,1065,1103,1112,1119,1120,1121,1127,1128,1129,1130,1133,1134,1141,1142,1143,1144,1145,1160,1163,1164,1165,1061,1171,217,243,426,1183,1184,1188,1187,1192,1193,1203,1205,1206,1214,1215,1220,1221,1227,1234,1237,1240,1243,1244,1247,1250,1251,1253,1254,1256,1257,1259,1271,1272,1273,1275,1276,1277,1278)))))) OR issues.id IN (182,183,193,223,277,284,316,391,420,436,437,441,442,443,444,446,447,448,455,459,460,461,464,467,474,500,501,502,503,505,506,507,508,509,510,574,576,578,579,580,581,582,585,586,587,588,589,590,591,592,593,594,595,596,597,598,601,603,912,1014,1040,1043,1065,1103,1112,1119,1120,1121,1127,1128,1129,1130,1133,1134,1141,1142,1143,1144,1145,1160,1163,1164,1165,1061,1171,217,243,426,1183,1184,1188,1187,1192,1193,1203,1205,1206,1214,1215,1220,1221,1227,1234,1237,1240,1243,1244,1247,1250,1251,1253,1254,1256,1257,1259,1271,1272,1273,1275,1276,1277,1278)) ) AND (watchers.user_id = 3)):
25
    41:                 <%= hidden_field_tag(controller.default_search_scope, 1, :id => nil) if controller.default_search_scope %>
26
    42:                 <%= text_field_tag 'q', @question, :size => 20, :class => 'small', :accesskey => accesskey(:quick_search), :placeholder => l(:label_search) %>
27
    43:             <% end %>
28
    44:         </div>
29
    45:         <% end %>
30
    46:         <h1><%= page_header_title %></h1>
31
    47:
32
  app/models/project.rb:92:in `block in <class:Project>'
33
  app/helpers/application_helper.rb:437:in `page_header_title'
34
  app/controllers/issues_controller.rb:83:in `block (2 levels) in index'
35
  app/controllers/issues_controller.rb:82:in `index'
(1-1/2)