Re: [Phpgroupware-users] addresbook entries disappear

[Brian Johnson]

I've seen a couple of entries disappear in my install.  In every case to date,
it has been that there is an address (or addresses) linked to the contact but
none are marked as the "preferred" address.

For an org try:

select * from phpgw_contact_org left join phpgw_contact_addr on
contact_id=org_id where name like '%insertnametofindhere%';

For a person replace all the "org" with "person" AND replace the "name" field
with "last_name"

This will show the addresses linked to a contact.  Look to make sure at least
one of them is marked with "Y" in the preferred field.  I have tried setting
them all to "Y" with an update stsrement and it seems to take the first one in
the db as preferred in that case.



Benoit Hamet (address@hidden) wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> Sorry to be late.
>
> I have exactly the same problem as Stephan.
> In Fact I'm not able to use the tabs at all, and I can't add manually
> people into the addressbook.
> I post a Bug report on this on Savannah, Hope that you can contribute
> there (
> https://savannah.gnu.org/bugs/?func=detailitem&item_id=8777 )
>
>
> For information, I cvs update today, but the bug is here for a long
> time. (But could not get date on this).
> Hope this help,
>
> Regards,
> Caeies.
>
> Brian Johnson wrote:
> > I have a few questions to help narrow down where the problem might lie.
> >
> > 1. Is this a new install or was the data upgraded from an old version?
>
> Update with no data in it from 0.9.16RC1
>
> >
> > 2. Is this for persons or organizations or both?
>
> Both
>
> >
> > 3. What data is disapearing?  phone numbers, addresses, etc?
>
> Not relevant
>
> >
> > 4. What data is being edited?
>
> Person, email Name firstname etc ...
>
> >
> > 5. Do you have the ability to run a SQL SELECT?  If not, get a SQL client 
> > for
> > your db .. the quickest way to debug is to look at the data and we may need 
> > to
> > run a couple SQL commands.
>
> Seems to be no data at all in the table, apart the owner.
>
> >
> >
> >
> >
> > Stephan Hagemann (address@hidden) wrote:
> >
> >>I have installed version 0.9.16.000 and just did a cvs-update. There is just
> >>the Default group and all the members of this group allow give all the 
> >>rights
> >>on the adressbook to the entire group.
> >>
> >>New entries show up as they should. When I try to change the entry there are
> >>two problems:
> >>- the old values are not shown in the corresponding fields while editing
> >>- once saved the entry can not be seen in the addressbook
> >>
> >>I believe this can only be a configuration / usage problem. But what is it?
> >>
> >>thx very much
> >>
> >>
> >>
> >>_______________________________________________
> >>Phpgroupware-users mailing list
> >>address@hidden
> >>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> >>
> >>
> >
> >
> >
> >
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.4 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFAlnGXd/RrA5d/NgMRAubhAKCPDy6igtUI2MYPPDYBn3O9v9LO9gCgpThE
> XvmZhvisau4HXNQ3Eakj6Fw=
> =tT7U
> -----END PGP SIGNATURE-----
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>