Technical debt #1621
Error 500 (Internal error) - In Calendar
Blocked:
No
Milestones:
Sprint:
Description
Hi,
When accessing the calendar with the plugin activated in the project, a 500 error occurs.
The log shows:
I, [2023-07-06T19:03:18.359573 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Started GET "/projects/XXXXX/issues/calendar" for 192.X.X.X at 2023-07-06 19:03:18 +0200
I, [2023-07-06T19:03:18.360221 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Processing by CalendarsController#show as HTML
I, [2023-07-06T19:03:18.360273 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Parameters: {"project_id"=>"XXXXX"}
I, [2023-07-06T19:03:18.365483 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Current user: user (id=X)
I, [2023-07-06T19:03:18.437762 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Rendered calendars/show.html.erb within layouts/base (Duration: 34.7ms | Allocations: 12945)
I, [2023-07-06T19:03:18.442169 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Rendered inline template (Duration: 0.3ms | Allocations: 212)
I, [2023-07-06T19:03:18.466608 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Rendered layout layouts/base.html.erb (Duration: 63.6ms | Allocations: 29184)
I, [2023-07-06T19:03:18.468756 #11300] INFO -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545] Completed 500 Internal Server Error in 108ms (Views: 48.5ms | ActiveRecord: 44.0ms | Allocations: 42979)
F, [2023-07-06T19:03:18.469276 #11300] FATAL -- : [c566dc21-4e84-44b9-ad51-f1f8fa23d545]
[c566dc21-4e84-44b9-ad51-f1f8fa23d545] ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'issues.id' in 'IN/ALL/ANY subquery'):
[c566dc21-4e84-44b9-ad51-f1f8fa23d545]
[c566dc21-4e84-44b9-ad51-f1f8fa23d545] plugins/scrum/lib/scrum/calendars_controller_patch.rb:32:in `query_sprints'
[c566dc21-4e84-44b9-ad51-f1f8fa23d545] plugins/scrum/lib/scrum/calendars_controller_patch.rb:21:in `add_sprints'
[c566dc21-4e84-44b9-ad51-f1f8fa23d545] lib/redmine/sudo_mode.rb:61:in `sudo_mode'
No data to display