[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: Bettina Gille <address@hidden>
Date: Wed 09/10/2003 at 21:44 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
the db error got fixed. the missing private acl access level is a feature 
request, not a bug. please add it as a feature request again. thanks





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


Submitted by: fugu                    Project: phpGroupWare                 
Submitted on: Sat 09/06/2003 at 03:24
Category:  projects                   Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  Fixed                    Assigned to:  ceb                     
Status:  Closed                       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 

Follow-up Comments
*******************

-------------------------------------------------------
Date: Wed 09/10/2003 at 21:44       By: ceb
the db error got fixed. the missing private acl access level is a feature 
request, not a bug. please add it as a feature request again. thanks




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/