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

[ledgersmb-users] Re: Stuck upgrading 1.6.27 to anything beyond

Different error:

   Can't create directory /tmp/deleted_transaction_files/hethcote: No such
   file or directory at
   line 38.

   dbversion: , company: 1.6.31

Created directory:

   Can't create directory /tmp/deleted_transaction_files/hethcote:
   Permission denied at
   line 38.

   dbversion: , company: 1.6.31

Chowned directory:


Thank you!

On Thu, 3 Jun 2021, Erik Huelsmann wrote:

Hi Louis,

On Wed, Jun 2, 2021 at 8:06 PM Louis <..hidden..> wrote:


      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 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/846886b3e36bd32db9fb99125bae17633323a749#diff-ead07c84baac57a9542f388a07a2a

Let me know if that solves your problem!



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

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