MantisBT - v2.2 Release (Closed)
View Issue Details
0000586v2.2 Release (Closed)[All Projects] Generalpublic2010-09-29 05:282010-12-19 13:23
Reportersham 
Assigned Tocaseydk 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.2 
Summary0000586: viewing of projects ( in user mode) ( dept not added
Descriptioni have created user gave limited Permission.
i have attached jpg image of ready reference.
if i dont have department to user and try to access project we get error( in user mode)
 also no tasks are not displayed for the users.
TagsNo tags attached.
Attached Filesjpg 1.JPG (70,895) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=127&type=bug
jpg

Notes
(0001296)
caseydk   
2010-09-29 05:38   
Could you copy/paste the entire error message? Thanks.
(0001297)
sham   
2010-09-29 21:14   
ERROR: C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php(1116) : query failed(SELECT projects.project_id, project_name, project_parent FROM ((`projects` AS projects)) INNER JOIN `companies` AS companies ON projects.project_company = company_id WHERE project_original_parent = 5 AND project_active = 1 AND ((0=1) OR dept_id IS NULL) ORDER BY project_name) - error was: Unknown column 'dept_id' in 'where clause'
Backtrace:
0 C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php:1116 dprint()
1 C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php:1153 exec()
2 C:\wamp\www\web2project-2.1\modules\projects\projects.class.php:1220 loadList()
3 C:\wamp\www\web2project-2.1\modules\projects\vw_idx_projects.php:158 getStructuredProjects()
4 C:\wamp\www\web2project-2.1\style\web2project\overrides.php:101 require()
5 C:\wamp\www\web2project-2.1\modules\projects\index.php:152 show()
6 C:\wamp\www\web2project-2.1\index.php:363 require()
(0001298)
caseydk   
2010-09-30 10:58   
I've explored this one and it's trivial to reproduce.. just deny access to a department and poof. I've been hacking at it and don't see a clean way to handle it..
(0001301)
caseydk   
2010-10-06 20:50   
Resolved in r1469
(0001464)
caseydk   
2010-12-19 13:23   
In v2.2 release.

Issue History
2010-09-29 05:28shamNew Issue
2010-09-29 05:28shamFile Added: 1.JPG
2010-09-29 05:38caseydkNote Added: 0001296
2010-09-29 21:14shamNote Added: 0001297
2010-09-30 10:58caseydkNote Added: 0001298
2010-10-06 20:49caseydkProjectv2.1 Release (Closed) => v2.2 Release (Closed)
2010-10-06 20:50caseydkNote Added: 0001301
2010-10-06 20:50caseydkStatusnew => resolved
2010-10-06 20:50caseydkResolutionopen => fixed
2010-10-06 20:50caseydkAssigned To => caseydk
2010-12-19 13:23caseydkNote Added: 0001464
2010-12-19 13:23caseydkStatusresolved => closed
2010-12-19 13:23caseydkFixed in Version => 2.2