Re: 1.4.28 --- income statement messed up

On Sat, Jun 25, 2016 at 2:00 AM, Michael Richardson <..hidden..> wrote:

Trying to clear up these unposted drafts, I found that some could be deleted
without hassle (if I do them one at a time).
Others, I thought I could post and then reverse.

I get this after copy-to-new on the Add Transaction, and inserting - signs
everywhere:

==> /var/log/apache2/error.log <==
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: ""
LINE 1: select invnumber from ar where id = ''
^ at LedgerSMB/Form.pm line 3437.
DBD::Pg::st fetchrow_array

I think this behaviour is only triggered when the form has an 'approved' field which evaluates to 'true'.

Do you have any others you need/want/can do? If so, you could try adding

delete $form->{approved};

to the 3 'copy_to_new' functions (in bin/aa.pl, bin/is.pl and bin/ir.pl), between the other delete $form->{...} statements and let me know the result?

I'm expecting it to be a solution. If so, I'm happy to include this in 1.4.30.

Regards,

Erik.

failed: no statement executing at LedgerSMB/Form.pm line 3438.

DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB/Form.pm line 3276.

DBD::Pg::st fetchrow_array failed: no statement executing at
LedgerSMB/Form.pm line 3277.

DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB/Form.pm line 3397.
Can't locate object method "_error" via package "Form" at
/usr/local/share/perl/5.14.2/old-handler.pl line 223.
Compilation failed in require at /usr/share/ledgersmb/ap.pl line 7.

I notice that after "Update", I see:
Action: update, ID:
with a blank there.

After looking at some logs, I did:
marlin-[~] mcr 10006 %sudo mv /usr/local/share/perl/5.14.2/old-handler.pl
/usr/local/share/perl/5.14.2/old-handler.pl-BAD

I then went back to the newly posted transaction and tried to reverse it
again, and it worked.

--
] Never tell me the odds! | ipv6 mesh networks [
] Michael Richardson, Sandelman Software Works | network architect [
] ..hidden.. http://www.sandelman.ca/ | ruby on rails [

------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.