Different error:

Error! Can't create directory /tmp/deleted_transaction_files/hethcote: No such file or directory at /usr/local/ledgersmb/sql/changes/1.6/track-deleted-transactions.sql.checks.pl line 38.

dbversion: , company: 1.6.31

Created directory:

Error! Can't create directory /tmp/deleted_transaction_files/hethcote: Permission denied at /usr/local/ledgersmb/sql/changes/1.6/track-deleted-transactions.sql.checks.pl line 38.

dbversion: , company: 1.6.31

Chowned directory:

success.

Thank you!

On Thu, 3 Jun 2021, Erik Huelsmann wrote:

Hi Louis,

On Wed, Jun 2, 2021 at 8:06 PM Louis lbmlist@hethcote.com wrote:

  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?

Yes, I think I can: instead of upgrading to 1.6.28, could you try upgrading to 1.6.31 or 1.6.32? There is a fix in .31 which should fix this exact problem:https://github.com/ledgersmb/LedgerSMB/commit/846886b3e36bd32db9fb99125bae17... 5209456ce790b04251bc9bd7d179ea85cb1R6

Let me know if that solves your problem!

Regards,

-- Bye, Erik.

http://efficito.com%C2%A0-- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

Hi Louis,

On Thu, Jun 3, 2021 at 6:24 AM Louis B. Moore lbmoore@hethcote.com wrote:

Different error:

Error!
Can't create directory /tmp/deleted_transaction_files/hethcote: No such
file or directory at
/usr/local/ledgersmb/sql/changes/1.6/

track-deleted-transactions.sql.checks.pl line 38.

Ok. That's a bug in the upgrade script, where it doesn't create the "/tmp/deleted_transaction_files/" directory before creating the "hethcote" directory within it. I'm working to create a new release as I write this, which should fix that problem. Before running the upgrade to 1.6.33 (if David's advice didn't help you yet), please remove the /tmp/deleted_transaction_files directory you created manually. Before removing it: please check that you're not accidentally deleting files that were downloaded into it.

HTH,