Defect #20282: Error message when editing a child project without add project/subprojects permissions - Redmine

Custom queries

Documentation issues
Open defects
Open features
Patch queue
Plugin issues
Translation patches

Actions

Copy link

Defect #20282

closed

Error message when editing a child project without add project/subprojects permissions

Added by James H almost 9 years ago. Updated over 8 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Jean-Philippe Lang

Category:

Project settings

Target version:

3.0.6

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Affected version:

3.0.3

Description

If a user whose role permissions excludes the ability to "create subprojects" tries to edit the project settings of a project that is a sub-project of another project, it does not allow you to make any changes and states that "Subproject of is invalid"

Files

subprojecterror.png (24.4 KB) subprojecterror.png

James H, 2015-07-09 20:59

Related issues

Has duplicate Redmine - Defect #21168: Cannot save project when associated with a parent project.

Closed

Actions

Has duplicate Redmine - Defect #25146: Issue while modifying subproject configuration without the permission to create a subproject

Closed

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Mischa The Evil almost 9 years ago

Status changed from New to Confirmed

Summary¶

Table of contents
Summary
Details

I have been able to replicate the display of the error message using source:/trunk@14420, but I should also note that the changes made are actually being saved to the DB, despite the error message.
The error message can be triggered only by editing of and saving from "/projects/child-20282/settings" and "/projects/child-20282/settings/info".

Details¶

Project setup¶

/--------------\
| Parent-20282 |                    <<-- private root project on which role "20282" has no roles/permissions
\--------------/                         (project does not have any members)
       ||
       ||
       \\        /-------------\
         == >>>  | Child-20282 |    <<-- private sub project on which user "tester1" has role "20282" 
                 \-------------/         (no further members)

User setup¶

Login: "tester1"
Made sure that this user is not an "Administrator"

Role setup¶

Name: "20282"
Created by copying the default "Reporter" role
Added all project management permissions:
- "Edit project"
- "Select project modules"
- "Manage members"
- "Manage versions"
- "Manage forums"
- "Manage issue categories"
- "Manage repository"
- "Manage project activities"
- "Manage wiki"
Made sure that the role does not have the "Create subprojects" permission

Steps to replicate the error message¶

login as "tester1"
browse to project settings of "Child-20282" ("/projects/child-20282/settings")
1. notice that "tester1" can browse further directly to any of the sub tabs:
  - Modules, Members, Versions, Issue categories, Wiki, Repositories, Forums and Activities (time tracking)
  and modify any of these and save the changes correctly to the DB without the error message showing up
make any kind of change (eg. disable/enable a tracker, add/modify "Homepage" field, etc) on "Information tab"
click "Save" --> page is reloaded

notice that the reported error message is shown: "Subproject of is invalid"
notice that the changes made are actually being saved to the DB
notice that no errors/warnings are being logged

Deployment details¶

Environment:
  Redmine version                3.1.0.devel (trunk@r14420)
  OS                             Ubuntu 12.04.5 LTS
  Ruby and Gemset manager        rvm 1.26.11 (master@20150627)
  Ruby version                   2.1.6-p336 (2015-04-13) [i686-linux]
  Rails version                  4.2.3
  Environment                    development
  Database                       PostgreSQL 9.1.18 on i686-pc-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 32-bit
  Database adapter               pg 0.18.2
  Application server             n/a
  Webserver                      WEBrick 1.3.1
SCM:
  Subversion                     1.6.17
  Git                            1.7.9.5
  Filesystem
Redmine plugins:
  no plugin installed

Log snippets¶

View development log snippets...View development log snippets...

Started GET "/projects/child-20282" for 192.168.1.3 at 2015-07-11 05:31:58 +0200
Processing by ProjectsController#show as HTML
  Parameters: {"id"=>"child-20282"}
  [1m[36m (0.4ms)[0m  [1mSELECT MAX("settings"."updated_on") FROM "settings"[0m
  [1m[35mUser Load (0.3ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT 1  [["status", 1], ["id", 3]]
  Current user: tester1 (id=3)
  [1m[36mProject Load (0.3ms)[0m  [1mSELECT  "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT 1[0m  [["identifier", "child-20282"]]
  [1m[35m (0.2ms)[0m  SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1  [["project_id", 5]]
  [1m[36mMember Load (0.4ms)[0m  [1mSELECT  "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9) AND "members"."project_id" = $2  ORDER BY projects.name LIMIT 1[0m  [["user_id", 3], ["project_id", 5]]
  [1m[35mProject Load (0.4ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mMemberRole Load (0.0ms)[0m  [1mSELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)[0m
  [1m[35mRole Load (0.3ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)
  [1m[36mRole Load (0.3ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mMember Load (0.2ms)[0m  SELECT "members".* FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE "members"."project_id" = $1 AND "users"."type" = $2 AND "users"."status" = $3  [["project_id", 5], ["type", "User"], ["status", 1]]
  [1m[36mUser Load (0.4ms)[0m  [1mSELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" IN (3)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)[0m
  [1m[35mRole Load (0.6ms)[0m  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
  [1m[36mMember Load (0.9ms)[0m  [1mSELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE (projects.status <> 9) AND (members.user_id = 3 OR (projects.is_public = 't' AND users.type = 'GroupNonMember'))[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)
  [1m[36mProject Load (0.2ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = $1 AND (((projects.status <> 9) AND (projects.is_public = 't' OR projects.id IN (5))))  ORDER BY "projects"."lft" ASC[0m  [["parent_id", 5]]
  [1m[35mNews Load (0.2ms)[0m  SELECT  "news".* FROM "news" WHERE "news"."project_id" = $1  ORDER BY news.created_on DESC LIMIT 5  [["project_id", 5]]
  [1m[36mTracker Load (1.8ms)[0m  [1mSELECT 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" JOIN enabled_modules ON enabled_modules.project_id = projects.id AND enabled_modules.name = 'issue_tracking' WHERE (projects.lft >= 8 AND projects.rgt <= 9 AND projects.status <> 9)  ORDER BY "trackers"."position" ASC[0m
  [1m[35mSetting Load (0.5ms)[0m  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = $1  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "display_subprojects_issues"]]
  [1m[36mGroup Load (0.2ms)[0m  [1mSELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = $1[0m  [["user_id", 3]]
  [1m[35m (2.2ms)[0m  SELECT COUNT(*) AS count_all, tracker_id AS tracker_id FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 't' AND ((issues.is_private = 'f' OR issues.author_id = 3 OR issues.assigned_to_id IN (3)))) OR (projects.id IN (5) AND ((issues.is_private = 'f' OR issues.author_id = 3 OR issues.assigned_to_id IN (3))))))) AND (issue_statuses.is_closed = 'f') AND ((projects.id = 5 OR (projects.lft > 8 AND projects.rgt < 9))) GROUP BY "issues"."tracker_id" 
  [1m[36m (1.7ms)[0m  [1mSELECT COUNT(*) AS count_all, tracker_id AS tracker_id FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 't' AND ((issues.is_private = 'f' OR issues.author_id = 3 OR issues.assigned_to_id IN (3)))) OR (projects.id IN (5) AND ((issues.is_private = 'f' OR issues.author_id = 3 OR issues.assigned_to_id IN (3))))))) AND ((projects.id = 5 OR (projects.lft > 8 AND projects.rgt < 9))) GROUP BY "issues"."tracker_id"[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36m (1.1ms)[0m  [1mSELECT SUM("time_entries"."hours") FROM "time_entries" INNER JOIN "projects" ON "projects"."id" = "time_entries"."project_id" WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) AND (projects.is_public = 't' OR projects.id IN (5)))) AND ((projects.id = 5 OR (projects.lft > 8 AND projects.rgt < 9)))[0m
  [1m[35mToken Load (0.3ms)[0m  SELECT  "tokens".* FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='feeds') LIMIT 1  [["user_id", 3]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCustomField Load (0.8ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mSetting Load (0.3ms)[0m  [1mSELECT  "settings".* FROM "settings" WHERE "settings"."name" = $1  ORDER BY "settings"."id" DESC LIMIT 1[0m  [["name", "user_format"]]
  Rendered projects/_members_box.html.erb (2.9ms)
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/_sidebar.html.erb (3.4ms)
  Rendered projects/show.html.erb within layouts/base (25.8ms)
  [1m[35mUserPreference Load (0.3ms)[0m  SELECT  "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT 1  [["user_id", 3]]
  [1m[36mProject Load (0.4ms)[0m  [1mSELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE (projects.status<>9) AND "members"."user_id" = $1 AND (projects.status<>9) AND "projects"."status" = $2  ORDER BY projects.name[0m  [["user_id", 3], ["status", 1]]
  [1m[35mProject Load (0.6ms)[0m  SELECT "projects".* FROM "projects" WHERE (projects.lft < 8 AND projects.rgt > 9) AND (((projects.status <> 9) AND (projects.is_public = 't' OR projects.id IN (5))))  ORDER BY "projects"."lft" ASC
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mProject Load (0.5ms)[0m  SELECT  "projects".* FROM "projects" WHERE (projects.lft <= 8 AND projects.rgt >= 9)  ORDER BY "projects"."lft" ASC LIMIT 1
  [1m[36m (0.8ms)[0m  [1mSELECT COUNT(*) FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 5 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 10 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 9 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 9 AND versions.sharing = 'hierarchy'))))[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mTracker Exists (0.2ms)[0m  SELECT  1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mWiki Load (0.2ms)[0m  SELECT  "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mBoard Exists (0.2ms)[0m  SELECT  1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mRepository Load (0.2ms)[0m  [1mSELECT  "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 AND (is_default = 't') LIMIT 1[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
Completed 200 OK in 396ms (Views: 219.1ms | ActiveRecord: 34.3ms)

Started GET "/projects/child-20282/settings" for 192.168.1.3 at 2015-07-11 05:32:02 +0200
Processing by ProjectsController#settings as HTML
  Parameters: {"id"=>"child-20282"}
  [1m[36m (0.4ms)[0m  [1mSELECT MAX("settings"."updated_on") FROM "settings"[0m
  [1m[35mUser Load (0.3ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT 1  [["status", 1], ["id", 3]]
  Current user: tester1 (id=3)
  [1m[36mProject Load (0.2ms)[0m  [1mSELECT  "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT 1[0m  [["identifier", "child-20282"]]
  [1m[35m (0.2ms)[0m  SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1  [["project_id", 5]]
  [1m[36mMember Load (0.3ms)[0m  [1mSELECT  "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9) AND "members"."project_id" = $2  ORDER BY projects.name LIMIT 1[0m  [["user_id", 3], ["project_id", 5]]
  [1m[35mProject Load (0.4ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mMemberRole Load (0.3ms)[0m  [1mSELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)[0m
  [1m[35mRole Load (0.5ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)
  [1m[36mRole Load (0.4ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mIssueCustomField Load (0.5ms)[0m  SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField')  ORDER BY "custom_fields"."position" ASC
  [1m[36mTracker Load (0.5ms)[0m  [1mSELECT "trackers".* FROM "trackers"  ORDER BY "trackers"."position" ASC[0m
  [1m[35mWiki Load (0.2ms)[0m  SELECT  "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mRole Load (0.3ms)[0m  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
  [1m[36mMember Load (1.6ms)[0m  [1mSELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE (projects.status <> 9) AND (members.user_id = 3 OR (projects.is_public = 't' AND users.type = 'GroupNonMember'))[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)
  [1m[36mProject Load (0.4ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE (1=0)[0m
  [1m[35mProject Load (0.4ms)[0m  SELECT "projects".* FROM "projects" WHERE (projects.lft >= 8 AND projects.rgt <= 9)  ORDER BY "projects"."lft" ASC
  [1m[36mMember Load (0.2ms)[0m  [1mSELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9)  ORDER BY projects.name[0m  [["user_id", 3]]
  [1m[35mCACHE (0.1ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."id" ASC LIMIT 1[0m  [["builtin", 1]]
  [1m[35mProject Load (0.2ms)[0m  SELECT  "projects".* FROM "projects" WHERE "projects"."id" = $1 LIMIT 1  [["id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35m (0.3ms)[0m  SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1  [["project_id", 4]]
  [1m[36mMember Load (0.3ms)[0m  [1mSELECT  "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9) AND "members"."project_id" = $2  ORDER BY projects.name LIMIT 1[0m  [["user_id", 3], ["project_id", 4]]
  [1m[35mSetting Load (0.2ms)[0m  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = $1  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "text_formatting"]]
  [1m[36mCustomField Load (0.8ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  [1m[35mEnabledModule Load (0.3ms)[0m  SELECT "enabled_modules".* FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1  [["project_id", 5]]
  [1m[36mTracker Load (0.3ms)[0m  [1mSELECT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1  ORDER BY "trackers"."position" ASC[0m  [["project_id", 5]]
  Rendered projects/_form.html.erb (51.1ms)
  Rendered projects/_edit.html.erb (53.0ms)
  Rendered projects/settings/_modules.html.erb (5.4ms)
  [1m[35mRole Load (0.3ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."position" ASC  [["builtin", 0]]
  [1m[36mSQL (0.4ms)[0m  [1mSELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "member_roles"."id" AS t1_r0, "member_roles"."member_id" AS t1_r1, "member_roles"."role_id" AS t1_r2, "member_roles"."inherited_from" AS t1_r3, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6, "roles"."users_visibility" AS t2_r7, "roles"."time_entries_visibility" AS t2_r8, "roles"."all_roles_managed" AS t2_r9, "users"."id" AS t3_r0, "users"."login" AS t3_r1, "users"."hashed_password" AS t3_r2, "users"."firstname" AS t3_r3, "users"."lastname" AS t3_r4, "users"."admin" AS t3_r5, "users"."status" AS t3_r6, "users"."last_login_on" AS t3_r7, "users"."language" AS t3_r8, "users"."auth_source_id" AS t3_r9, "users"."created_on" AS t3_r10, "users"."updated_on" AS t3_r11, "users"."type" AS t3_r12, "users"."identity_url" AS t3_r13, "users"."mail_notification" AS t3_r14, "users"."salt" AS t3_r15, "users"."must_change_passwd" AS t3_r16, "users"."passwd_changed_on" AS t3_r17 FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "member_roles" "member_roles_members_join" ON "member_roles_members_join"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles_members_join"."role_id" WHERE "members"."project_id" = $1 AND "users"."status" = $2[0m  [["project_id", 5], ["status", 1]]
  [1m[35mPrincipal Load (0.3ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 3]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."position" ASC[0m  [["builtin", 0]]
  [1m[35mUser Load (0.4ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = $1 LIMIT 1  [["id", 3]]
  Rendered projects/settings/_members.html.erb (24.8ms)
  [1m[36mProject Load (0.5ms)[0m  [1mSELECT  "projects".* FROM "projects" WHERE (projects.lft <= 8 AND projects.rgt >= 9)  ORDER BY "projects"."lft" ASC LIMIT 1[0m
  [1m[35m (0.6ms)[0m  SELECT COUNT(*) FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 5 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 10 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 9 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 9 AND versions.sharing = 'hierarchy'))))
  [1m[36mVersion Load (0.8ms)[0m  [1mSELECT "versions".* FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 5 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 10 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 9 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 9 AND versions.sharing = 'hierarchy'))))[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mVersion Exists (0.2ms)[0m  SELECT  1 AS one FROM "versions" WHERE "versions"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_versions.html.erb (27.1ms)
  [1m[35mIssueCategory Exists (0.2ms)[0m  SELECT  1 AS one FROM "issue_categories" WHERE "issue_categories"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mIssueCategory Load (0.2ms)[0m  [1mSELECT "issue_categories".* FROM "issue_categories" WHERE "issue_categories"."project_id" = $1  ORDER BY issue_categories.name[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_issue_categories.html.erb (13.1ms)
  Rendered projects/settings/_wiki.html.erb (3.0ms)
  [1m[35mRepository Exists (0.2ms)[0m  SELECT  1 AS one FROM "repositories" WHERE "repositories"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mRepository Load (0.2ms)[0m  [1mSELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_repositories.html.erb (14.4ms)
  [1m[35mBoard Exists (0.3ms)[0m  SELECT  1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mBoard Load (0.2ms)[0m  [1mSELECT "boards".* FROM "boards" WHERE "boards"."project_id" = $1  ORDER BY position ASC[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  Rendered projects/settings/_boards.html.erb (19.3ms)
  [1m[36mCustomField Load (0.7ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  [1m[35m (0.2ms)[0m  SELECT "enumerations"."parent_id" FROM "enumerations" WHERE "enumerations"."type" IN ('TimeEntryActivity') AND "enumerations"."project_id" = $1  ORDER BY "enumerations"."position" ASC  [["project_id", 5]]
  [1m[36mTimeEntryActivity Load (0.4ms)[0m  [1mSELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('TimeEntryActivity') AND (enumerations.project_id IS NULL OR enumerations.project_id = 5)  ORDER BY "enumerations"."position" ASC[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  Rendered projects/settings/_activities.html.erb (28.7ms)
  Rendered common/_tabs.html.erb (201.7ms)
  Rendered projects/settings.html.erb within layouts/base (213.8ms)
  [1m[35mUserPreference Load (0.3ms)[0m  SELECT  "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT 1  [["user_id", 3]]
  [1m[36mProject Load (0.2ms)[0m  [1mSELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE (projects.status<>9) AND "members"."user_id" = $1 AND (projects.status<>9) AND "projects"."status" = $2  ORDER BY projects.name[0m  [["user_id", 3], ["status", 1]]
  [1m[35mProject Load (0.5ms)[0m  SELECT "projects".* FROM "projects" WHERE (projects.lft < 8 AND projects.rgt > 9) AND (((projects.status <> 9) AND (projects.is_public = 't' OR projects.id IN (5))))  ORDER BY "projects"."lft" ASC
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mRepository Load (0.4ms)[0m  SELECT  "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 AND (is_default = 't') LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
Completed 200 OK in 300ms (Views: 239.1ms | ActiveRecord: 20.1ms)

Started PATCH "/projects/child-20282" for 192.168.1.3 at 2015-07-11 05:32:26 +0200
Processing by ProjectsController#update as HTML
  Parameters: {"utf8"=>"âœ“", "authenticity_token"=>"<<<<token-scrubbed>>>>", "project"=>{"name"=>"Child-20282", "description"=>"", "homepage"=>"http://www.redmine.org", "is_public"=>"1", "tracker_ids"=>["1", "3", ""]}, "commit"=>"Save", "id"=>"child-20282"}
  [1m[35m (1.3ms)[0m  SELECT MAX("settings"."updated_on") FROM "settings" 
  [1m[36mUser Load (0.4ms)[0m  [1mSELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT 1[0m  [["status", 1], ["id", 3]]
  Current user: tester1 (id=3)
  [1m[35mProject Load (0.3ms)[0m  SELECT  "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT 1  [["identifier", "child-20282"]]
  [1m[36m (0.2ms)[0m  [1mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1[0m  [["project_id", 5]]
  [1m[35mMember Load (0.4ms)[0m  SELECT  "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9) AND "members"."project_id" = $2  ORDER BY projects.name LIMIT 1  [["user_id", 3], ["project_id", 5]]
  [1m[36mProject Load (0.4ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)[0m
  [1m[35mMemberRole Load (0.3ms)[0m  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)
  [1m[36mRole Load (0.5ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)[0m
  [1m[35mRole Load (0.3ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mRole Load (0.5ms)[0m  [1mSELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."id" ASC LIMIT 1[0m  [["builtin", 1]]
  [1m[35mMember Load (0.9ms)[0m  SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE (projects.status <> 9) AND (members.user_id = 3 OR (projects.is_public = 't' AND users.type = 'GroupNonMember'))
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)[0m
  [1m[35mProject Load (0.4ms)[0m  SELECT "projects".* FROM "projects" WHERE (1=0)
  [1m[36mProject Load (0.3ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE (projects.lft >= 8 AND projects.rgt <= 9)  ORDER BY "projects"."lft" ASC[0m
  [1m[35mMember Load (0.2ms)[0m  SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9)  ORDER BY projects.name  [["user_id", 3]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (4)
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."id" IN (6)[0m
  [1m[35mCACHE (0.0ms)[0m  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
  [1m[36mProject Load (0.3ms)[0m  [1mSELECT  "projects".* FROM "projects" WHERE "projects"."id" = $1 LIMIT 1[0m  [["id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36m (0.3ms)[0m  [1mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1[0m  [["project_id", 4]]
  [1m[35mMember Load (0.2ms)[0m  SELECT  "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND (projects.status<>9) AND "members"."project_id" = $2  ORDER BY projects.name LIMIT 1  [["user_id", 3], ["project_id", 4]]
  [1m[36mTracker Load (0.7ms)[0m  [1mSELECT "trackers".* FROM "trackers" WHERE "trackers"."id" IN (1, 3)[0m
  [1m[35mTracker Load (0.2ms)[0m  SELECT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1  ORDER BY "trackers"."position" ASC  [["project_id", 5]]
  [1m[36m (0.2ms)[0m  [1mBEGIN[0m
  [1m[35m (0.2ms)[0m  ROLLBACK
  [1m[36mIssueCustomField Load (0.4ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  [1m[35mTracker Load (0.5ms)[0m  SELECT "trackers".* FROM "trackers"  ORDER BY "trackers"."position" ASC
  [1m[36mWiki Load (0.4ms)[0m  [1mSELECT  "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT 1[0m  [["project_id", 5]]
  [1m[35mRole Load (0.4ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCustomField Load (0.5ms)[0m  SELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField')  ORDER BY "custom_fields"."position" ASC
  [1m[36mEnabledModule Load (0.3ms)[0m  [1mSELECT "enabled_modules".* FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1[0m  [["project_id", 5]]
  Rendered projects/_form.html.erb (9.4ms)
  Rendered projects/_edit.html.erb (10.7ms)
  Rendered projects/settings/_modules.html.erb (4.2ms)
  [1m[35mRole Load (0.3ms)[0m  SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."position" ASC  [["builtin", 0]]
  [1m[36mSQL (0.6ms)[0m  [1mSELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "member_roles"."id" AS t1_r0, "member_roles"."member_id" AS t1_r1, "member_roles"."role_id" AS t1_r2, "member_roles"."inherited_from" AS t1_r3, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6, "roles"."users_visibility" AS t2_r7, "roles"."time_entries_visibility" AS t2_r8, "roles"."all_roles_managed" AS t2_r9, "users"."id" AS t3_r0, "users"."login" AS t3_r1, "users"."hashed_password" AS t3_r2, "users"."firstname" AS t3_r3, "users"."lastname" AS t3_r4, "users"."admin" AS t3_r5, "users"."status" AS t3_r6, "users"."last_login_on" AS t3_r7, "users"."language" AS t3_r8, "users"."auth_source_id" AS t3_r9, "users"."created_on" AS t3_r10, "users"."updated_on" AS t3_r11, "users"."type" AS t3_r12, "users"."identity_url" AS t3_r13, "users"."mail_notification" AS t3_r14, "users"."salt" AS t3_r15, "users"."must_change_passwd" AS t3_r16, "users"."passwd_changed_on" AS t3_r17 FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "member_roles" "member_roles_members_join" ON "member_roles_members_join"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles_members_join"."role_id" WHERE "members"."project_id" = $1 AND "users"."status" = $2[0m  [["project_id", 5], ["status", 1]]
  [1m[35mPrincipal Load (0.3ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 3]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1  ORDER BY "roles"."position" ASC[0m  [["builtin", 0]]
  [1m[35mUser Load (0.3ms)[0m  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = $1 LIMIT 1  [["id", 3]]
  Rendered projects/settings/_members.html.erb (14.7ms)
  [1m[36mProject Load (0.4ms)[0m  [1mSELECT  "projects".* FROM "projects" WHERE (projects.lft <= 8 AND projects.rgt >= 9)  ORDER BY "projects"."lft" ASC LIMIT 1[0m
  [1m[35m (0.9ms)[0m  SELECT COUNT(*) FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 5 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 10 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 9 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 9 AND versions.sharing = 'hierarchy'))))
  [1m[36mVersion Load (0.6ms)[0m  [1mSELECT "versions".* FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 5 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 10 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 9 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 9 AND versions.sharing = 'hierarchy'))))[0m
  [1m[35mProject Load (0.5ms)[0m  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5)
  [1m[36m (0.3ms)[0m  [1mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mVersion Exists (0.3ms)[0m  SELECT  1 AS one FROM "versions" WHERE "versions"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_versions.html.erb (15.3ms)
  [1m[35mIssueCategory Exists (0.2ms)[0m  SELECT  1 AS one FROM "issue_categories" WHERE "issue_categories"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mIssueCategory Load (0.2ms)[0m  [1mSELECT "issue_categories".* FROM "issue_categories" WHERE "issue_categories"."project_id" = $1  ORDER BY issue_categories.name[0m  [["project_id", 5]]
  [1m[35mCACHE (0.1ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_issue_categories.html.erb (5.8ms)
  Rendered projects/settings/_wiki.html.erb (1.2ms)
  [1m[35mRepository Exists (1.0ms)[0m  SELECT  1 AS one FROM "repositories" WHERE "repositories"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mRepository Load (0.3ms)[0m  [1mSELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.1ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  Rendered projects/settings/_repositories.html.erb (22.9ms)
  [1m[35mBoard Exists (0.3ms)[0m  SELECT  1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT 1  [["project_id", 5]]
  [1m[36mBoard Load (0.8ms)[0m  [1mSELECT "boards".* FROM "boards" WHERE "boards"."project_id" = $1  ORDER BY position ASC[0m  [["project_id", 5]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  Rendered projects/settings/_boards.html.erb (14.3ms)
  [1m[36mCustomField Load (0.5ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  [1m[35m (0.2ms)[0m  SELECT "enumerations"."parent_id" FROM "enumerations" WHERE "enumerations"."type" IN ('TimeEntryActivity') AND "enumerations"."project_id" = $1  ORDER BY "enumerations"."position" ASC  [["project_id", 5]]
  [1m[36mTimeEntryActivity Load (0.4ms)[0m  [1mSELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('TimeEntryActivity') AND (enumerations.project_id IS NULL OR enumerations.project_id = 5)  ORDER BY "enumerations"."position" ASC[0m
  [1m[35mCACHE (0.1ms)[0m  SELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'TimeEntryActivityCustomField')  ORDER BY "custom_fields"."position" ASC[0m
  Rendered projects/settings/_activities.html.erb (10.0ms)
  Rendered common/_tabs.html.erb (107.5ms)
  Rendered projects/settings.html.erb within layouts/base (118.6ms)
  [1m[35mUserPreference Load (0.3ms)[0m  SELECT  "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT 1  [["user_id", 3]]
  [1m[36mProject Load (0.4ms)[0m  [1mSELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE (projects.status<>9) AND "members"."user_id" = $1 AND (projects.status<>9) AND "projects"."status" = $2  ORDER BY projects.name[0m  [["user_id", 3], ["status", 1]]
  [1m[35mProject Load (0.6ms)[0m  SELECT "projects".* FROM "projects" WHERE (projects.lft < 8 AND projects.rgt > 9) AND (((projects.status <> 9) AND (projects.is_public = 't' OR projects.id IN (5))))  ORDER BY "projects"."lft" ASC
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mCACHE (0.0ms)[0m  SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1  [["member_id", 4]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
  [1m[35mRepository Load (0.5ms)[0m  SELECT  "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 AND (is_default = 't') LIMIT 1  [["project_id", 5]]
  [1m[36mCACHE (0.0ms)[0m  [1mSELECT DISTINCT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = $1[0m  [["member_id", 4]]
Completed 200 OK in 214ms (Views: 148.0ms | ActiveRecord: 22.1ms)

Actions

Copy link

Updated by James H almost 9 years ago

interesting, i did not notice that it was still being written.
Thank you for looking into this.

Actions

Copy link

Updated by Toshi MARUYAMA over 8 years ago

Target version set to 3.2.0

Actions

Copy link

Updated by Sebastian Paluch over 8 years ago

This seems to be related also to the number of projects user can choose from to set subproject.

In our case the error came up for a user that has project administrator role (including creating subprojects) for one project (B) only:

Project A
 - Project B

It seems that in this case the subproject drop down list is not generated at all - user cannot change subproject so drop down list is empty and missing.

Actions

Copy link

Updated by Jean-Philippe Lang over 8 years ago

Subject changed from Cannot Change Project Settings on a Sub-Project if User Role is not permitted to create Sub-Projects. to Error message when editing a child project without add project/subprojects permissions
Status changed from Confirmed to Resolved
Assignee set to Jean-Philippe Lang
Target version changed from 3.2.0 to 2.6.8
Resolution set to Fixed