On Wed, Apr 9, 2014 at 9:31 AM, Lyle <[email protected]> wrote:
> Hi,
> I'm getting errors when I try to update an old transaction. It's dying
> in the SQL, but I'm not totally sure where as it's not giving me a line
> number. The error is being captured, then then it's dying again in the
> error reporting method:
>
First, a disclaimer: In general it is a problem to update old
transactions. Because it violates basic accounting principles there are
topics such as COGS generation where there are no accepted correct answers.
Yet the old SQL-Ledger behavior is still possible to restore (probably
will be until 1.5), so be warned.
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] DBD::Pg::db do
> failed: ERROR: permission denied for relation acc_trans, referer:
> http://mydomain.com/ledgersmb/ap.pl
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] DBD::Pg::st
> execute failed: ERROR: current transaction is aborted, commands ignored
> until end of transaction block, referer:
> http://mydomain.com/ledgersmb/ap.pl
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] 2014/04/10
> 17:28:55 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1102) -- Logging SQL
> State 25P02, error 7, string ERROR: current transaction is aborted,
> commands ignored until end of transaction block, referer:
> http://mydomain.com/ledgersmb/ap.pl
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] Can't use string
> ("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at
> LedgerSMB.pm line 942., referer: http://mydomain.com/ledgersmb/ap.pl
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] Compilation
> failed in require at ap.pl line 7., referer:
> http://mydomain.com/ledgersmb/ap.pl
> [Thu Apr 10 17:28:55 2014] [error] [client 192.168.1.40] Premature end of
> script headers: ap.pl, referer: http://mydomain.com/ledgersmb/ap.pl
>
> I remember in lsmb 1.2 I had to run some code to enable old transactions
> to be updated. Is that this case in 1.3?
>
Right. You can re-enable this by granting DELETE permissions on acc_trans.
This will be removed in future versions (probably 1.5).
The Correct Way:
The correct way to handle this is to void and re-enter the invoice. We
have a void button at the bottom for this.
>
>
>
> Lyle
>
>
>
> ------------------------------------------------------------------------------
> Put Bad Developers to Shame
> Dominate Development with Jenkins Continuous Integration
> Continuously Automate Build, Test & Deployment
> Start a new project now. Try Jenkins in the cloud.
> http://p.sf.net/sfu/13600_Cloudbees
> _______________________________________________
> Ledger-smb-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
