I started using sql-ledger about 5 years ago and my last upgrade was 2.6.19 This was partly due to the fact that I was going to move to ledger-smb one of these days. Well the day came and I upgraded through to ledgersmb 1.2.18. Everything seemed ok till we started getting the following errors while posting a payment to an invoice.
==================== *DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint "transactions_pkey" at LedgerSMB/IS.pm line 862. * Error! *INSERT INTO ar (id, customer_id) VALUES (?, ?) ERROR: duplicate key violates unique constraint "transactions_pkey"* ==================== This error seems to delete the invoice from the AR. A little googling and I found some comments about this being a referential integrity problem. The question is how do I fix it? Are there any tools to dump and restore the whole ledgersmb application without dumping the raw database? P.S. I signed up to the help mail list and it seems to be broken. -- Alvin Starr || voice: (416)585-9971x690 Interlink Connectivity || fax: (416)585-9974 [email protected] || ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
