Re: [Phpgroupware-developers] Searching the addressbook

[Bob Crandell]

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 'where
clause')

File: /home/web/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 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