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

[Brian Johnson]

I haven't checked the actual table or field names

Do a select * from phpgw_contact_addr to check if it is the right table name
and to see the proper field name and values

you could also do a select * from phpgw_contact_addr where not preferred
like'Y' to see which ones are not preferred addresses

the update command is used to change values in existing rows like update
table_name set field_to_change = some_value where field_to_filter_on =
filter_value



Dirk H. Schulz (address@hidden) wrote:
>
> Hi Brian,
>
> --On Freitag, 24. September 2004 14:08 Uhr +0000 Brian Johnson
> <address@hidden> wrote:
>
> > It might not be your problem since it sounds like you are missing bits of
> > contact data, not the entire contact.
>
> Both, as far as I can see.
>
> >
> > Most people find installing and using the phpmyadmin software convenient
> > for database interaction.
>
> Well, there is no problem using the mysql cli client. I do that quite
> often, but simply creating, dumping and deleting databases. I do not work
> in the tables, so far.
> That is why I need the exact syntax - or is it that already?
>
> Dirk
>
>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
>
>