Re: [Phpgroupware-developers] Searching the addressbook

[Bob Crandell]

Hi,

That drop down list has Person Data, Communications Data, Location Data, and
Other Data?  Talk about not seeing what you are looking at ...

Doing a search on the Person Data produces the error listed below.  All the
others work as expected.

Is the data I sent you helping at all?

One more thing (don't hate me) Choose Organizations, pick one, any one and
choose Edit or View.  It works.  Choose Persons, pick one, any one and choose
Edit.  You get a patterned background.  If you choose view it goes white.  I'm
using idsociaety in Mozilla 1.6.

I hope this helps.

Alex Borges (address@hidden) wrote:
>
> El dom, 29-02-2004 a las 22:13, Bob Crandell escribió:
> > Sorry, Alex.
> >
> > I've set up a cron job to pull down the latest CVS at 4 every morning.
> >
> > My main addressbook shows Full name, Home phone, Office phone
>
> BTW, great job @ testing....:)
>
> Um... here is the thing. We commited a patch last week that makes it so
> you choose what kind of data are you searching for (adds a drop down box
> to the index page). This reduces the complexity a lot and is also
> standard in all the addressbooks ive checked (from outlook to mozilla,
> to any ldap based front end).
>
> If youre not seeing this extra combo in the index, then sopmething went
> wrong in your update... (cause im seeing it here)...
>
> Please report back on this asap...
>
> >
> > Database error: Invalid SQL: SELECT count(person_id) AS count_persons FROM
> > phpgw_contact AS contact_central 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
> > (595483,599437,599438,599443,599444,599449,599454,599441,599450,599456,599439))
> > 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 '%robin%' OR
> > UPPER(contact_person.prefix) LIKE '%robin%' OR UPPER(contact_person.suffix)
> > LIKE '%robin%' OR UPPER(contact_person.birthday) LIKE '%robin%' OR
> > UPPER(contact_person.pubkey) LIKE '%robin%' OR UPPER(contact_person.title)
> > LIKE '%robin%' OR UPPER(contact_person.department) LIKE '%robin%' OR
> > UPPER(contact_person.initials) LIKE '%robin%' OR UPPER(contact_person.sound)
> > LIKE '%robin%' OR UPPER(contact_person.active) LIKE '%robin%'))
> > 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.
> >

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