Re: [Phpgroupware-users] Upgrade from 0.9.14.006 to 0.9.16.001 - address book entries missing

[Brian Johnson]

It might not be your problem since it sounds like you are missing bits of
contact data, not the entire contact.

Most people find installing and using the phpmyadmin software convenient for
database interaction.



Dirk H. Schulz (address@hidden) wrote:
>
> Hi Brian,
>
> --On Freitag, 24. September 2004 13:34 Uhr +0000 Brian Johnson
> <address@hidden> wrote:
>
> > I have found that addressbook entries occassionally vanish and have
> > discovered the following:
> > 1. the addressbook will not display contacts that have one or more
> > addresses but none of them are marked as the preferred address
> > 2. if you remove and address from a contact and leave one or more
> > addresses, the preferred selection will display at one of the other
> > addresses but doesn't actually save it that way unless you edit that
> > address and save it as the preferred address
> >
> > Every once in a while I use set ALL the addresses as being preferred by
> > using UPDATE phpgw_contact_addr SET preferred='Y' .. note that this
> > nullifies the feature of having a preferred address.
>
> How do I do that? Sounds like an sql statement. But I am not very firm with
> sql.
>
> Thanks for your help.
>
> Dirk
>
>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
>
>