使用开发人员权限打开项目的backlog会出现报错
用管理员权限打开是正常的,用开发权限就报错500
Redirected to http://sh04362pcw1.spreadtrum.com:81/redmine/product_backlog/6
Completed 302 Found in 29ms (ActiveRecord: 10.4ms)
Started GET "/redmine/product_backlog/6” for 127.0.0.1 at 2020-10-15 11:28:39 +0800
Processing by ProductBacklogController#show as HTML
Parameters: {“id"⇒“6”}
Current user: xiansong.zhang (id=8)
Completed 500 Internal Server Error in 19ms (ActiveRecord: 6.3ms)
ActiveRecord::StatementInvalid (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 ')))' at line 1: SELECT COUNT FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking’)) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (8,3))) AND ((issues.is_private = FALSE OR issues.author_id = 8 OR issues.assigned_to_id IN (8,9)))) OR (projects.id IN (8,9) AND ((issues.is_private = FALSE OR issues.author_id = 8 OR issues.assigned_to_id IN (8,9))))))) AND ((projects.id = 8 OR (projects.lft > 1 AND projects.rgt < 2)) AND (tracker_id IN ()))):
plugins/scrum/lib/scrum/project_patch.rb:102:in `pbis_count’
plugins/scrum/app/controllers/product_backlog_controller.rb:338:in `calculate_stats’
lib/redmine/sudo_mode.rb:65:in `sudo_mode’