Re: [Phpgroupware-users] Addressbook error?

[Brian Johnson]

There's a db diagram floating around somewhere.

I think it might be on the wiki or jarg might have it



Alejandro Borges (address@hidden) wrote:
>
> El dom, 15-05-2005 a las 16:53 +0200, James Mohr escribi�:
> > Hello Lance!
> >
> > I'm a newbie to PHPGroupWare, but I do have a little SQL experience. You say
> > you are trying to add some address information. Does this mean you are 
> > trying
> > to add information to an existing record? If so, then the SQL query that is
> > being done is very wrong here. This is doing an insert, which is going to
> > create a whole new record.
> >
> > Looking in my MySQL database, the primary key is the contact_addr_id field
> > which is auto increment, so it is logical to me that it is not listed as one
> > of the fields.  However, I am still confused as to why it is doing an insert
> > if you are updating existing data. Can you add new records OK?
>
> Doesnt work that way. The addressbook has one record per person or
> organization exlclusively in the contacts, person and org tables.
>
> Addresses, phones, im, other-non-ordered data and catalogs are in other
> tables.
>
> So its perfectly normal that it tries an insert when adding an address
> (you would allways need more than one table if you want to support a
> contact that has an unlimited number of addresses, phones, emails...and
> other data associated to them).
>
> Not normal that it fails but, sadly, i havent been able to reproduce
> that.
> >
> > Regards,
> >
> > Jim Mohr
> >
> > On Saturday 14 May 2005 22:44, Lance Hoffmeyer wrote:
> > > Hey all,
> > >
> > > I can add names and numbers and various information fine.  When I try
> > > to add some address information to the addressbook but I keep getting
> > > the error:  How do I fix this error so I can add information to this 
> > > table?
> > >
> > > Lance
> > >
> > >
> > >
> > > *Database error:* Invalid SQL: INSERT INTO phpgw_contact_addr (add1,
> > > state, add2, postal_code, city, country, addr_type_id, preferred,
> > > created_on, created_by, modified_on, modified_by, contact_id) VALUES
> > > ('', 'TX', '', '78026', '', '', 2, 'Y', 1116103161, 6, 1116103161, 6, 69)
> > > *PostgreSQL Error*: 1 (ERROR: duplicate key violates unique constraint
> > > "phpgw_contact_addr_pkey")
> > >
> > > *File:* -1
> > > *Line:* -1
> > >
> > > *Session halted.
> > > *
> > >
> > > *
> > > *
> > >
> > > *
> > > *
> >
>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
>
>