Project

General

Profile

Redmine 3.3.3 - missing issue table at project overview, wrong spent time

Added by Martin K almost 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


    (1-2/2)