Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Group by Project and filter by tracker doesn't work #69

Open
ZhdanovaMaria opened this issue Nov 1, 2016 · 1 comment
Open

Group by Project and filter by tracker doesn't work #69

ZhdanovaMaria opened this issue Nov 1, 2016 · 1 comment

Comments

@ZhdanovaMaria
Copy link

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'

@VVD
Copy link

VVD commented Nov 1, 2016

AFAIU, SashaH fixed it in #63

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants