Re: [Phpgroupware-users] Addressbook error?

[James Mohr]

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?

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.
> *
>
> *
> *
>
> *
> *

-- 
---------------------------------------
"Be more concerned with your character than with your reputation. Your
character is what you really are while your reputation is merely what others
think you are." -- John Wooden
---------------------------------------
Be sure to visit the Linux Tutorial:  http://www.linux-tutorial.info