[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
upgrades and database integrity.
- Subject: upgrades and database integrity.
- From: Alvin Starr <..hidden..>
- Date: Thu, 07 Jan 2010 19:35:51 -0500
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. *
*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?
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