bugphpGroupWare - Bugs: bug #5364, selecting 'private' in the java...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #5364: selecting 'private' in the java addressbooks results in sql error

Submitted by:  Hsing-Foo Wang <pooh_>
Submitted on:  Wed 17 Sep 2003 06:58:57 AM UTC  
 
Item Group: 0.9.16RC1Category: email
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Alejandro Borges (lex) <alexbsa>Open/Closed: Closed
Component Version: NoneOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Thu 18 Sep 2003 09:41:39 PM UTC, comment #1:

$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?

Alejandro Borges (lex) <alexbsa>In charge of this item.
Wed 17 Sep 2003 06:58:57 AM UTC, 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.

Hsing-Foo Wang <pooh_>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

No Changes Have Been Made to This Item

Back to the top


Powered by Savane 3.1-cleanup1