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