LedgerSMB
The foundation for your business
Fork me on GitHub
[ledgersmb-users] Stuck upgrading 1.6.27 to anything beyond
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ledgersmb-users] Stuck upgrading 1.6.27 to anything beyond




Greetings,

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 dies with:

Error!

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?

Thank you,

Louis
_______________________________________________
users mailing list -- ..hidden..
To unsubscribe send an email to ..hidden..