While editing customer contacts we are seeing the following errors logged to stdout on the server:
ERROR: duplicate key value violates unique constraint "addr_addr_number_key"
CONTEXT: SQL statement "UPDATE addr SET addr_number = $1 , addr_line1 = $2 , addr_line2 = $3 , addr_line3 = $4 , addr_city = $5 , addr_state = $6 , addr_postalcode = $7 , addr_country = $8 , addr_active = $9 , addr_notes = $10 WHERE addr_id = $11 "
PL/pgSQL function "saveaddr" line 133 at SQL statement
STATEMENT: SELECT saveAddr(11,'183','','123 ABC ST','','Some Town','AZ','12345','United States',TRUE,'','CHANGEALL') AS result;
And there is a pop-up on the client as showing in the attached screenshot.
The changes being made to the contacts appear to be getting saved properly to the database, but I need to know if this is something to be concerned about, and if so how to fix?
This is with verison 3.7.4 of XTuple ERP (open source)
Thanks!
–
Bill Arlofski
Reverse Polarity, LLC
http://www.revpol.com/