Redmine 3.3.3 - missing issue table at project overview, wrong spent time
Added by Martin K over 7 years ago
Hello,
I updated
RM 3.2.1
Environment: Redmine version 3.2.1.devel.15317 Ruby version 2.1.2-p95 (2014-05-08) [x86_64-linux] Rails version 4.2.5.2 Environment production Database adapter PostgreSQL SCM: Subversion 1.8.9 Git 2.12.2 Filesystem Redmine plugins: projects_table 0.0.4 redmine_wiki_index_tree_view 0.0.1
to RM 3.3.3
Environment: Redmine version 3.3.3.devel.16545 Ruby version 2.1.2-p95 (2014-05-08) [x86_64-linux] Rails version 4.2.8 Environment production Database adapter PostgreSQL SCM: Subversion 1.8.9 Git 2.12.2 Filesystem Redmine plugins: projects_table 0.0.4 redmine_impersonate 0.10.0 sidebar_hide 0.0.8
and now I am having this issues:
- when logged as admin, everything seems OK
- when logged as regular user (it seems that role doesn't matter):
- I cannot see issues table on the project overview at project which doesn't have child projects
- I can see issues table at project with child projects, but the numbers of issues are wrong
- spent time is wrong
- I cannot see quick navigation to parent projects on the top
this everything was working fine in 3.2.1
When I check the debug log, "Tracker Load" SQL for admin looks like:
SELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = 'issue_tracking' AND (projects.lft >= 36 AND projects.rgt <= 39) AND (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY "trackers"."position" ASC
but for user:
SELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = 'issue_tracking' AND (projects.lft >= 36 AND projects.rgt <= 39) AND (1=0) ORDER BY "trackers"."position" ASC
- there is (1=0) and this is always false, I found out, that this comes from line 213 in app/models/project.rb
Do you have any idea what can be wrong? (I tried to disable all plugins, that doesn't help)
I am attaching screenshots for RM 3.2.1 as user, RM 3.3.3 as admin and RM 3.3.3 as user for child project and parent project.
Thanks
Replies (2)
RE: Redmine 3.3.3 - missing issue table at project overview, wrong spent time
-
Added by Jan K. over 7 years ago
Probably the bug: Defect #25828
RE: Redmine 3.3.3 - missing issue table at project overview, wrong spent time
-
Added by Go MAEDA about 7 years ago
Maybe related to #26376?