Re: [Phpgroupware-developers] Searching the addressbook

[Alex Borges]

K, time to send you do some hacking....:)

On contacts_sql line 3173 says:

 if($index!==False &&  $index!==Null)

Try deleting o that you end up with:
if($index!==False)

Write down results
Then try
if($index!==NULL)

And report back...

El lun, 01-03-2004 a las 18:00, Bob Crandell escribió:
> 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
> 
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>