Re: [Phpgroupware-developers] Searching the addressbook

[Dave Hall]

Bob Crandell <address@hidden> wrote:

Oops, that made it into 16 final :(

/me makes a plan for a 0.9.16.001 release :(

> 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
> 
> 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 
> 'whereclause')
> 
> File: 
>
/home/web/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.phpLine:
1339
> 
> Session halted.
> 
> Is the data I sent you helping at all?
> 
> I just thought of something.  Did the changes you make require a 
> visit to
> Setup?  I'll check as soon as I hit Send.
> 
> Thanks
> Bob
> 
> Alex Borges (address@hidden) wrote:
> >
> > I hope this catches you....
> > Monday will be too late, we release saturday!
> >
> > El vie, 27-02-2004 a las 12:26, Bob Crandell escribió:
> > > Alex,
> > >
> > > I'm on my way out of town now.  I'll let you know Monday when I 
> get back.
> > >
> > > Thanks
> > >
> > >
> > > Alex Borges (address@hidden) wrote:
> > > >
> > > > Update from cvs... let me know about what you think....
> > > >
> > > > El jue, 26-02-2004 a las 22:33, Bob Crandell escribió:
> > > > > Hi Alex,
> > > > >
> > > > > You asked what search I was using.  I'm answering here 
> 'cause I don't know
> > > > > better.
> > > > >
> > > > > I entered susan in the search field.
> > > > >
> > > > > There are more than on susan in the list.
> > > > >
> > > > > 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
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Phpgroupware-developers mailing list
> > > > > address@hidden
> > > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > Phpgroupware-developers mailing list
> > > > address@hidden
> > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > > >
> > >
> > > --
> > > 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
> > >
> >
> >
> >
> > _______________________________________________
> > Phpgroupware-developers mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >
> 
> --
> 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
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>