MantisBT - v2.2 Release (Closed)
View Issue Details
0000622v2.2 Release (Closed)[All Projects] Generalpublic2010-11-04 22:342010-12-19 13:24
Assigned Tocaseydk 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.2 
Summary0000622: I can't open project which have empty field above name of department selected
DescriptionWhen I'm creating new project, I'm choosing department. If I accidently select empty field above name of departments after closing this project I can't open it any more. Not even with admin user.

I can't open this project, I can't delete it.
TagsNo tags attached.
has duplicate 0000617closed caseydk On changing start date : Access Denied | You have attempted to access an item in web2Project without the sufficient permissions 
has duplicate 0000605closed caseydk Denial access to a project for anyone 
Attached Fileszip (1,181,012) 1969-12-31 16:00

2010-11-07 11:18   
I tried to reproduce this issue, by the screencast provided, but couldn't. Steps I took (on a clean install):
 * admin user create company Baz, create department Bazzinga
 * admin user create user role bar, with the following permissions:
   * App: Departments - Edit - allow
   * App: Projects - Access, View, Edit, Add - allow
   * Companies: Baz - Access, View - allow
 * admin user create user Foo, which is added to company Baz and department Bazzinga
 * admin adds user role bar to user Foo

After that, logged in as Foo, created a new project Test, for company selected Test, for department selected none. Result, user Foo can access the new project Test.

Most likely I missed something, but this is all I got out from the video. If you could, please provide exact steps to reproduce this issue on a clean install.

Question: is the user eb4740 allowed only to open projects just for a department within a company? If so, then when creating a new project there shouldn't be an option to select "none" for the department.
2010-11-08 01:21   
Ok, I have simplify problema.
I have Test Company with one department.
App: Projects - Access View Add Edit - allow
Companies: TEST Company - Access View - allow
App: Departments - Access View Add Edit - allow

User have this role, nothing else.
When he creates new project, he choose Company "Test Company" and accidently select empty field above name of department.
After that he (no one else including admin) can open/edit/delete this project.
2010-12-03 12:19   
When you were selecting that field, a dept_id of zero was getting stored in project_departments.. then on the permissions check, since there wasn't a match for dept_id zero, you'd be blocked from viewing the project.
Resolved in r1509, will be in v2.2 release.

You may want to run this to clean up old data:

delete FROM `project_departments` WHERE department_id = 0;
2010-12-19 13:24   
In v2.2 release.

Issue History
2010-11-04 22:34miroslawNew Issue
2010-11-04 22:34miroslawFile Added:
2010-11-07 11:18robertbasicNote Added: 0001343
2010-11-08 01:21miroslawNote Added: 0001344
2010-11-24 23:35caseydkProjectv2.1 Release (Closed) => v2.2 Release (Closed)
2010-11-24 23:47caseydkPrioritynormal => urgent
2010-12-03 12:19caseydkNote Added: 0001392
2010-12-03 12:19caseydkStatusnew => resolved
2010-12-03 12:19caseydkResolutionopen => fixed
2010-12-03 12:19caseydkAssigned To => caseydk
2010-12-14 21:38caseydkRelationship addedhas duplicate 0000617
2010-12-14 21:39caseydkRelationship addedhas duplicate 0000605
2010-12-19 13:24caseydkNote Added: 0001479
2010-12-19 13:24caseydkStatusresolved => closed
2010-12-19 13:24caseydkFixed in Version => 2.2