Defect #900

Calendar does not display for scrum 0.7.1 & 0.7.0--500 internal error

Added by an li about 8 years ago. Updated almost 8 years ago.

Target version:
Detected on version:


scrum 0.7.1+0.7.0 are both tested with this error.Can there is a fixing for scrum 0.7.1? For we can not use scrum 0.8.0 now, our projects are all using scrum 0.7.x.

Test Env.

  Redmine version                2.3.2.stable
  Ruby version                   1.9.3-p231 (2012-05-25) [i386-mingw32]
  Rails version                  3.2.13
  Environment                    production
  Database adapter               Mysql2
Redmine plugins:
  clipboard_image_paste          1.8
  copy_parent_issue_id           1.0.0
  fields_permissions             1.0.0
  localizable                    0.3.0
  progressive_projects_list      1.0.0
  redmine_agile                  1.3.5
  redmine_all_files              0.0.3
  redmine_app__space             1.0.3
  redmine_banner                 0.0.9
  redmine_better_gantt_chart     0.9.0
  redmine_changelog              0.0.1
  redmine_checkbox_wiki          0.0.1
  redmine_checklists             3.0.1
  redmine_close_button           0.0.8
  redmine_code_review            0.6.3
  redmine_custom_reports         0.1.4
  redmine_daily_scrum            0.0.1
  redmine_dashboard              2.3.3
  redmine_didyoumean             1.2.0
  redmine_documents_short        0.3.0
  redmine_issue_statistics       0.0.1
  redmine_issue_templates        0.0.8
  redmine_knowledgebase          3.0.4
  redmine_lightbox               0.0.1
  redmine_login_audit            0.1.5
  redmine_logs                   0.0.5
  redmine_message_issues         0.1.0
  redmine_monitoring_controlling 0.1.1
  redmine_my_page_queries        2.1.6
  redmine_new_user_notification  0.0.1
  redmine_parking_lot_chart      0.0.7
  redmine_pdf_export_backports   0.0.1
  redmine_plugin_views_revisions 0.0.1
  redmine_recent_wiki_pages      0.0.1
  redmine_release_notes          1.3.1
  redmine_reminder               0.3.1
  redmine_theme_changer          0.1.0
  redmine_time_entry_limit       0.0.2
  redmine_touch                  0.0.2
  redmine_wiki_backlinks         0.0.2
  redmine_wiki_notes             0.0.2
  redmine_wiki_templates         0.1.1
  redmine_xls_export             0.2.1.t6
  redmine_xlsx_format_issue_exporter 0.1.0
  scrum                          0.7.0
  sidebar_hide                   0.0.6
  wiking                         1.0.0b


An error occurred while executing the query and has been logged. Please report this error to your Redmine administrator.

Started GET "/redmine/projects/xxx/issues/calendar" for xxat 2014-11-17 14:35:31 +0800
Processing by CalendarsController#show as HTML
  Parameters: {"project_id"=>"xx}
  Current user: xx(id=28)
Creating scope :system. Overwriting existing method Enumeration.system.
Query::StatementInvalid: Mysql2::Error: Column 'start_date' in where 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, `issues`.`closed_on` AS t0_r23, `issues`.`sprint_id` AS t0_r24, `issues`.`position` AS t0_r25, `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, `projects`.`inherit_members` AS t1_r12, `projects`.`product_backlog_id` AS t1_r13, `projects`.`enforce_issue_id` AS t1_r14, `issue_statuses`.`id` AS t2_r0, `issue_statuses`.`name` AS t2_r1, `issue_statuses`.`is_closed` AS t2_r2, `issue_statuses`.`is_default` AS t2_r3, `issue_statuses`.`position` AS t2_r4, `issue_statuses`.`default_done_ratio` AS t2_r5, `trackers`.`id` AS t3_r0, `trackers`.`name` AS t3_r1, `trackers`.`is_in_chlog` AS t3_r2, `trackers`.`position` AS t3_r3, `trackers`.`is_in_roadmap` AS t3_r4, `trackers`.`fields_bits` AS t3_r5, `users`.`id` AS t4_r0, `users`.`login` AS t4_r1, `users`.`hashed_password` AS t4_r2, `users`.`firstname` AS t4_r3, `users`.`lastname` AS t4_r4, `users`.`mail` AS t4_r5, `users`.`admin` AS t4_r6, `users`.`status` AS t4_r7, `users`.`last_login_on` AS t4_r8, `users`.`language` AS t4_r9, `users`.`auth_source_id` AS t4_r10, `users`.`created_on` AS t4_r11, `users`.`updated_on` AS t4_r12, `users`.`type` AS t4_r13, `users`.`identity_url` AS t4_r14, `users`.`mail_notification` AS t4_r15, `users`.`salt` AS t4_r16, `users`.`apps` AS t4_r17, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`type` AS t5_r4, `enumerations`.`active` AS t5_r5, `enumerations`.`project_id` AS t5_r6, `enumerations`.`parent_id` AS t5_r7, `enumerations`.`position_name` AS t5_r8, `sprints`.`id` AS t6_r0, `sprints`.`name` AS t6_r1, `sprints`.`description` AS t6_r2, `sprints`.`start_date` AS t6_r3, `sprints`.`end_date` AS t6_r4, `sprints`.`user_id` AS t6_r5, `sprints`.`project_id` AS t6_r6, `sprints`.`created_on` AS t6_r7, `sprints`.`updated_on` AS t6_r8, `sprints`.`is_product_backlog` AS t6_r9 FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` LEFT OUTER JOIN `trackers` ON `trackers`.`id` = `issues`.`tracker_id` LEFT OUTER JOIN `users` ON `users`.`id` = `issues`.`assigned_to_id` LEFT OUTER JOIN `enumerations` ON `enumerations`.`id` = `issues`.`priority_id` AND `enumerations`.`type` IN ('IssuePriority') LEFT OUTER JOIN `sprints` ON `sprints`.`id` = `issues`.`sprint_id` WHERE (((projects.status <> 9 AND IN (SELECT em.project_id FROM enabled_modules em WHERE'issue_tracking')) AND (( IN (30) AND ((issues.is_private = 0 OR issues.author_id = 28 OR issues.assigned_to_id IN (28,24,69,239)))) OR ( IN (30) AND ((issues.is_private = 0 OR issues.author_id = 28 OR issues.assigned_to_id IN (28,24,69,239)))) OR ( IN (26) AND ((issues.is_private = 0 OR issues.author_id = 28 OR issues.assigned_to_id IN (28,24,69,239))))))) AND (((start_date BETWEEN '2014-10-26' AND '2014-12-06') OR (due_date BETWEEN '2014-10-26' AND '2014-12-06'))) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=0)) AND = 30)
  Rendered common/error.html.erb within layouts/base (0.0ms)
  Rendered plugins/redmine__select2/app/views/redmine__select2/_includes.html.erb (0.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_html_header.html.erb (0.0ms)
  Rendered plugins/redmine_create_wiki_page/app/views/create_wiki_page/_init_create_wiki_page.erb (0.0ms)
  Rendered inline template (15.6ms)
  Rendered plugins/scrum/app/views/scrum_hooks/_head.html.erb (0.0ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_headers.html.erb (0.0ms)
  Rendered plugins/redmine_simple/app/views/hooks/redmine_simple/_includes.html.erb (0.0ms)
Starting Application Space plugin for Redmine
  Rendered plugins/progressive_projects_list/app/views/application/_progressive_sidebar.html.erb (0.0ms)
Creating scope :sorted. Overwriting existing method User.sorted.
  Rendered plugins/progressive_projects_list/app/views/application/_progressive_recent_projects.html.erb (0.0ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (0.0ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (15.6ms)
  Rendered plugins/redmine_banner/app/views/banner/_body_bottom.html.erb (0.0ms)
  Rendered plugins/redmine_banner/app/views/banner/_after_top_menu.html.erb (0.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_body_bottom.html.erb (0.0ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_add_form.html.erb (0.0ms)
Completed 500 Internal Server Error in 796ms (Views: 421.2ms | ActiveRecord: 93.6ms)


Related issues

Has duplicate Scrum - Defect #847: Calendar shows 500 after installResolvedActions

Also available in: Atom PDF