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 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
