[Phpgroupware-tracker] [bug #5364] selecting 'private' in the java addressbooks results in sql error

[nobody]

=================== BUG #5364: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5364&group_id=509

Submitted by: pooh_                   Project: phpGroupWare                 
Submitted on: Wed 09/17/2003 at 06:58
Category:  email                      Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  selecting 'private' in the java addressbooks results in sql error

Original Submission:  Database error: Invalid SQL: SELECT contact_person.title 
AS per_title, contact_person.first_name AS per_first_name, 
contact_person.last_name AS per_last_name, contact_org.name AS org_name, 
contact_central.contact_id AS contact_id FROM phpgw_contact_person AS 
contact_person RIGHT JOIN phpgw_contact AS contact_central ON 
contact_central.contact_id = contact_person.person_id LEFT JOIN 
phpgw_contact_org AS contact_org ON contact_org.org_id = 
contact_central.contact_id WHERE contact_central.contact_type_id = 1 AND 
contact_central.access = private AND contact_central.owner = 3

MySQL Error: 1054 (Unknown column 'private' in 'where clause')



File: 
/home/e-smith/files/ibays/test/html/phpgwapi/inc/class.contacts_sql.inc.php

Line: 751



Session halted.



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=5364&group_id=509

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