On Wed, Jun 2, 2021 at 8:06 PM Louis <..hidden..
I was beginning to move from the 1.6 line when I encountered an error. I
was able to isolate the error to the upgrade from 1.6.27 -> 1.6.28 which
Error applying upgrade script ./sql/changes/1.6/track-deleted-transactions.sql: ERROR: update or delete
on table "transactions" violates foreign key constraint
"file_transaction_ref_key_fkey" on table "file_transaction"
DETAIL: Key (id)=(17812) is still referenced from table "file_transaction". at
/usr/local/ledgersmb/tools/../lib/LedgerSMB/Database/Change.pm line 227.
dbversion: , company: 1.6.28
This happened at postgresql 9.6 and also at 11.
Can anyone help me past this issue?
Let me know if that solves your problem!