upgrades and database integrity.

[Alvin Starr <..hidden..>]

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