[Phpgroupware-tracker] [bug #5094] Projects has a 'Private' access level, but no controls for assigning access.

[nobody]

=================== BUG #5094: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5094&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Tue 09/09/03 at 16:56 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
           Bug Group | 0.9.16 pre RC             | 0.9.16RC1
         Assigned to | None                      | ceb




=================== BUG #5094: FULL BUG SNAPSHOT ===================


Submitted by: fugu                    Project: phpGroupWare                 
Submitted on: Sat 09/06/03 at 13:24
Category:  projects                   Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  ceb                     
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  Projects has a 'Private' access level, but no controls for assigning 
access. 

Original Submission:  looking at the preference 'Grant Access' and the ACL 
slelect box (same page I assume) where most applications have 
Read|Add|Edit|Delete|Private as access levels, Projects is missing private. 



After assigning a Project the check box 'Private' it disappears (as it should) 
but when requesting in Projects to view 'only private' i recieve the following 
error: 





Database error: Invalid SQL: SELECT * from phpgw_p_projects WHERE  
coordinator=50' AND access='private'  AND status != 'archive'   AND parent=0

 MySQL Error: 1064 (You have an error in your SQL syntax.  Check the manual 
that corresponds to your MySQL server version for the right syntax to use near 
'' AND access='private'  AND status != 'archive'   AND parent=0')

 

File: /path/to/phpgroupware/projects/inc/class.soprojects.inc.php

Line: 193



Session halted.                 





                  

-hope this helps 



No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5094&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/