You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When creating a report for a standard user, selected group by project and filter by tracker, we get the error:
Started POST "/timesheet/report" for XX.X.X.X at 2016-10-26 21:56:13 +0300 Processing by TimesheetController#report as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"XXXX....XXXXXXXX", "timesheet"=>{"period_type"=>"1", "period"=>"all", "date_from"=>"2016-10-26", "date_to"=>"2016-10-26", "sort"=>"project", "projects"=>["28", "184", "211", "213", "212", "185", "210", "147", "141", "1", "9", "123", "125", "139", "156", "16", "91", "53", "92", "90", "194", "169", "181", "177", "176", "173"], "activities"=>["16", "11", "8", "12", "9", "10", "14", "15", "18", "17"], "users"=>["3"], "groups"=>["288"], "trackers"=>["2", "5", "6", "7", "8", "1", "3", "13", "11", "12", "14"]}, "commit"=>"Применить"} Current user: username (id=163) Completed 500 Internal Server Error in 495ms (ActiveRecord: 197.2ms)
ActiveRecord::StatementInvalid (PG::UndefinedColumn: ОШИБКА: колонка "tracker_id" не существует LINE 1: ...1,8,12,9,10,14,15,18,17) AND user_id IN (163) AND tracker_id...
^ : SELECT "time_entries".* FROM "time_entries" WHERE "time_entries"."project_id" = $1 AND (time_entries.project_id IN(28,184,213,211,212,185,210,1,9,91,123,139,156,125,16,169,92,90,194,173,147,141,181,177,176,53) AND activity_id IN (16,11,8,12,9,10,14,15,18,17) AND user_id IN (163) AND tracker_id IN (2,5,6,7,8,1,3,13,11,12,14)) ORDER BY spent_on ASC): plugins/redmine_timesheet_plugin/app/models/timesheet.rb:368:inblock in fetch_time_entries_by_project' plugins/redmine_timesheet_plugin/app/models/timesheet.rb:354:in each' plugins/redmine_timesheet_plugin/app/models/timesheet.rb:354:infetch_time_entries_by_project' plugins/redmine_timesheet_plugin/app/models/timesheet.rb:101:infetch_time_entries' plugins/redmine_timesheet_plugin/app/controllers/timesheet_controller.rb:59:inreport' lib/redmine/sudo_mode.rb:63:insudo_mode'
The text was updated successfully, but these errors were encountered:
When creating a report for a standard user, selected group by project and filter by tracker, we get the error:
Started POST "/timesheet/report" for XX.X.X.X at 2016-10-26 21:56:13 +0300 Processing by TimesheetController#report as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"XXXX....XXXXXXXX", "timesheet"=>{"period_type"=>"1", "period"=>"all", "date_from"=>"2016-10-26", "date_to"=>"2016-10-26", "sort"=>"project", "projects"=>["28", "184", "211", "213", "212", "185", "210", "147", "141", "1", "9", "123", "125", "139", "156", "16", "91", "53", "92", "90", "194", "169", "181", "177", "176", "173"], "activities"=>["16", "11", "8", "12", "9", "10", "14", "15", "18", "17"], "users"=>["3"], "groups"=>["288"], "trackers"=>["2", "5", "6", "7", "8", "1", "3", "13", "11", "12", "14"]}, "commit"=>"Применить"} Current user: username (id=163) Completed 500 Internal Server Error in 495ms (ActiveRecord: 197.2ms)
ActiveRecord::StatementInvalid (PG::UndefinedColumn: ОШИБКА: колонка "tracker_id" не существует LINE 1: ...1,8,12,9,10,14,15,18,17) AND user_id IN (163) AND tracker_id...
^
: SELECT "time_entries".* FROM "time_entries" WHERE "time_entries"."project_id" = $1 AND (time_entries.project_id IN
(28,184,213,211,212,185,210,1,9,91,123,139,156,125,16,169,92,90,194,173,147,141,181,177,176,53) AND activity_id IN (16,11,8,12,9,10,14,15,18,17) AND user_id IN (163) AND tracker_id IN (2,5,6,7,8,1,3,13,11,12,14)) ORDER BY spent_on ASC):
plugins/redmine_timesheet_plugin/app/models/timesheet.rb:368:in
block in fetch_time_entries_by_project' plugins/redmine_timesheet_plugin/app/models/timesheet.rb:354:in
each'plugins/redmine_timesheet_plugin/app/models/timesheet.rb:354:in
fetch_time_entries_by_project' plugins/redmine_timesheet_plugin/app/models/timesheet.rb:101:in
fetch_time_entries'
plugins/redmine_timesheet_plugin/app/controllers/timesheet_controller.rb:59:in
report'
lib/redmine/sudo_mode.rb:63:in
sudo_mode'
The text was updated successfully, but these errors were encountered: