[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.
------------------------------------------------------------------------------
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