Incorrect data on Issues assigned to me on MyPage
Redmine version 2.4.1.stable
Ruby version 1.9.3-p231 (2012-05-25) [i386-mingw32]
Rails version 3.2.16
Database adapter Mysql2
no plugin installed
#1 Updated by Giorgos Vythoulkas over 4 years ago
On MyPage there is incorrect data on the block "Issues assigned to me".
Total issue count is 23 (instead of 3) and the 23 displayed issues are not actually assigned to the logged on user.
Moreover, when redesigning the mypage layout and after removing the "issues assigned to me" block and re-inserting it:
- if it is allocated on the top section it shows correct data: 3 issues
- if it is allocated on the right section it shows incorrect data: 23 issues
After profiling it in MySql, there is a related strange query where clause: WHERE `issues`.`assigned_to_id` IN (4, 3)
Logged On user has an id = 4, belongs to a group with id = 5 and is an administrator.
The user with id = 3 belongs to the same group with id = 5