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

[nobody]

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

Changes by: Alejandro Borges (lex) <address@hidden>
Date: Thu 09/18/03 at 15:41 (Mexico/General)

------------------ Additional Follow-up Comments ----------------------------
$this->filters=array(                           

'owner' => $GLOBALS['phpgw_info']['user']['account_id'],        'access' => 
'private');



filters gets fed into contacts->get_persons



If you replace 'private' with ''private'' the problem goes away. But it really 
points to a casting/quoting problem in sql_generator (unless that requires me 
to handle quoting, in which case ill just do that)....EALD?





=================== BUG #5364: FULL BUG SNAPSHOT ===================


Submitted by: pooh_                   Project: phpGroupWare                 
Submitted on: Wed 09/17/03 at 00:58
Category:  email                      Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  alexbsa                 
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.

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

-------------------------------------------------------
Date: Thu 09/18/03 at 15:41         By: alexbsa
$this->filters=array(                           

'owner' => $GLOBALS['phpgw_info']['user']['account_id'],        'access' => 
'private');



filters gets fed into contacts->get_persons



If you replace 'private' with ''private'' the problem goes away. But it really 
points to a casting/quoting problem in sql_generator (unless that requires me 
to handle quoting, in which case ill just do that)....EALD?



-------------------------------------------------------
Date: Wed 09/17/03 at 07:38         By: eald
can anyone c&p the $contact->criteria(); call?


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/