[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
1.4.0-b3 Error Saving Purchase Transaction
- Subject: 1.4.0-b3 Error Saving Purchase Transaction
- From: "Nick Prater" <..hidden..>
- Date: Mon, 4 Feb 2013 11:56:06 -0000 (GMT)
I've hit a problem using 1.4.0-b3 and would appreciate any help or
guidance in resolving the issue:
Purchases->Add Transaction
Enter details and click 'Update' followed by 'Save'
Gives:
Error!
INSERT INTO ap (invnumber, person_id,
entity_credit_account)
VALUES (?, (select u.entity_id from users u
join entity e on(e.id = u.entity_id)
where u.username=? and u.entity_id in(select p.entity_id from person p) ), ?)
ERROR: duplicate key value violates unique constraint "transactions_pkey"
DETAIL: Key (id)=(4) already exists.
CONTEXT: SQL statement "INSERT INTO transactions (id, table_name, approved)
VALUES (new.id, TG_RELNAME, new.approved)"
PL/pgSQL function "track_global_sequence" line 4 at SQL statement
dbversion: 1.4.0, company: npbroadcast
Error!
Died at LedgerSMB/Form.pm line 493.
dbversion: 1.4.0, company: npbroadcast
Any help or suggestions gratefully received.
Many thanks and best wishes,
Nick