[Phpgroupware-developers] Addressbook Search

[Bob Crandell]

Hi,

Searching the addressbook returns this error:
Database error: Invalid SQL: SELECT count(person_id) AS count_persons FROM
phpgw_contact AS contact_central LEFT JOIN phpgw_contact_comm AS contact_comm
ON contact_comm.contact_id = contact_central.contact_id INNER JOIN
phpgw_contact_person AS contact_person ON contact_person.person_id =
contact_central.contact_id WHERE ((( ((contact_central.access = 'public' AND
contact_central.owner IN
(599450,599438,599454,599456,599439,599441,595483,599437,599443,599444,599449))
OR contact_central.owner = 599438) AND ( (contact_central.cat_id = '8' OR
UPPER(contact_central.cat_id) LIKE '%,8,%') OR (contact_central.cat_id = '19'
OR UPPER(contact_central.cat_id) LIKE '%,19,%') OR (contact_central.cat_id =
'20' OR UPPER(contact_central.cat_id) LIKE '%,20,%') )) AND
(UPPER(contact_person.per_full_name) LIKE '%pederson%' OR
UPPER(contact_central.owner) LIKE '%pederson%' OR
UPPER(contact_central.contact_id) LIKE '%pederson%')) AND
((UPPER(contact_comm.comm_data) LIKE '%pederson%' AND
contact_comm.comm_descr_id = 3) OR (UPPER(contact_comm.comm_data) LIKE
'%pederson%' AND contact_comm.comm_descr_id = 4)))
MySQL Error: 1054 (Unknown column 'contact_person.per_full_name' in 'where
clause')

File: /home/web/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1339

Session halted.

The same search using the addressbook while composing an email works.
This is version 0.9.14.512 using the ProBusiness Template.
The last CVS update I did was Thursday or Friday.

Thanks
Bob

--
Assured Computing, Inc.
When you need to be sure.
http://www.assuredcomp.com/
P.O. Box 40814
Eugene, OR 97404
Voice - 541-868-0331
FAX - 541-463-1627