Hi Kaare, On Tue, Nov 16, 2021 at 10:30 AM Kaare Rasmussen <kaare@jasonic.dk> wrote:

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.

What this means is that there are no records in acc_trans which are associated with the transaction referenced from the invoice row. If "qty - allocated = 0" then these records can be removed without side effects. If the condition does not hold, the question is whether qty is positive or negative. If it's positive, the record belongs to a sales transaction and the fact that "qty - allocated = 0" does not hold, means that at some point insufficient stock was available to allocate COGS. (Removing the row will prevent that COGS amount from being posted.) If it's negative, it means that there's stock left which hasn't been allocated to a sale yet for COGS. (Removing the row will leave an amount in inventory without explanation from purchase records.)

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?

A good and fair question. The answer is that we don't have that at the moment as a ready-made solution from the project. If you are going to build something like it, I'll gladly help you with the information you need in order to build it. Also, I think it's great to be able to include such a tool (even if it's not fully done and rough around the edges) in our set of utilities. Regards, Erik.

/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 to devel-leave@lists.ledgersmb.org

_______________________________________________ devel mailing list -- devel@lists.ledgersmb.org To unsubscribe send an email to devel-leave@lists.ledgersmb.org

-- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.