As a temporary fix try this in psql:
UPDATE BATCH SET locked_by = NULL;
I am looking further in to why this might happen.
On Tue, Sep 23, 2014 at 6:40 AM, Max van Biezen <mvanb...@gmail.com> wrote:
> Hi,
>
> I have converted the 1.3.40 database to 1.4.1 and I updated an entry
> using menu cash/voucher/receipt. After that I approved the batch and
> also immediately updated the reconciliation (not using custom script).
> There no errors reported in the logs. Then I logged off. When logging
> on again I get the result below complaining about the action of
> yesterday
>
> Not sure what I can do here as this is about the first action I took
> after converting from 1.3.40 to 1.4.1
>
> Max
>
> 2014/09/23 15:31:14 - DEBUG - LedgerSMB::_db_init LedgerSMB.pm (744) -- end
> DBD::Pg::st execute failed: ERROR: update or delete on table "batch"
> violates foreign key constraint "voucher_batch_id_fkey" on table
> "voucher"
> DETAIL: Key (id)=(47) is still referenced from table "voucher". at
> LedgerSMB/Session.pm line 190.
> 2014/09/23 15:31:14 - ERROR - LedgerSMB::dberror LedgerSMB.pm (772) --
> Logging SQL State 23503, error 7, string ERROR: update or delete on
> table "batch" violates foreign key constraint "voucher_batch_id_fkey"
> on table "voucher"
> DETAIL: Key (id)=(47) is still referenced from table "voucher".
> 23503:ERROR: update or delete on table "batch" violates foreign key
> constraint "voucher_batch_id_fkey" on table "voucher"
> DETAIL: Key (id)=(47) is still referenced from table "voucher". at
> LedgerSMB.pm line 781.
> Compilation failed in require at /usr/local/lsmb14/login.pl line 8.
> [Tue Sep 23 15:31:14 2014] [error] [client 10.28.45.106] Premature end
> of script headers: login.pl, referer:
> http://srv2.int/ledgersmb/login.pl
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
