Hi
Trying to upgrade my 1.7.24 version to 1.9.3, I get this error.
Error!
*Error applying upgrade script ./sql/changes/1.6/track-deleted-transactions.sql: ERROR: update or delete on table "transactions" violates foreign key constraint "invoice_trans_id_fkey" on table "invoice" DETAIL: Key (id)=(27) is still referenced from table "invoice". at lib/LedgerSMB/Database/Change.pm line 309. *
dbversion: 1.9.3, company:
---
The problem is that rows in the invoice table still reference transaction rows, while the upgrade script tries to delete them.
We have experienced several data related issues during the past couple of years, so I'm thinking that it would be an idea to start all over with only the contact, product, and account information. Do we have a way to port only the essential data to the new version?
/kaare
The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. This release contains the following fixes and improvements:
Changelog for 1.9.3
- Sort the buttons on the e-mail entry screen
- Fix issues with the PDF output for PNL and Balance sheet reports
- Fix indenting on the hierarchical PNL and balance sheet HTML reports
- Add link to download HTML PNL and balance sheet reports
- Add rudimentary CSS to HTML PNL and balance sheet reports
- Fix off-by-one column on the PNL and balance sheet total lines
- Remove application links on downloaded HTML PNL and balance sheet reports
- Use a temp table to prevent bulk payments trampling on each other
- Fix sorting on fixed asset searches (#6151)
For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.9.3/README.md
The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.9.3
The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.9.3
Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.9.3
These are the sha256 checksums of the uploaded files:
265aaa291f2a021e5c77e9fb674740669a19d552856f841b73f62cc040bf0a4a ledgersmb-1.9.3.tar.gz f97ecc7fa4277648a018ff508d656c403b2445cf4669a0e52908e23f83c74861 ledgersmb-1.9.3.tar.gz.asc _______________________________________________ devel mailing list --devel@lists.ledgersmb.org To unsubscribe send an email todevel-leave@lists.ledgersmb.org