#1076 internal server error AP Transaction

Mark Deason

When entering a new AP Transaction without filling in Invoice Created, I get an Internal Server Error referring me to the Apache error log, which states...

Wed Feb 19 16:19:36.135360 2014] [authz_core:error] [pid 13456:tid 2903427904] [client] AH01630: client denied by server configuration: /var/lib/ledgersmb/css/ledgersmb.css, referer:
DBD::Pg::st execute failed: ERROR: invalid input syntax for type date: ""
LINE 17: crdate = '',
^ at LedgerSMB/AA.pm line 403.
DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at LedgerSMB.pm line 833.
2014/02/19 16:19:42 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1099) -- Logging SQL State 25P02, error 7, string ERROR: current transaction is aborted, commands ignored until end of transaction block
Can't use string ("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at LedgerSMB.pm line 941.
Compilation failed in require at /usr/share/ledgersmb/ap.pl line 7.
[Wed Feb 19 16:19:42.971443 2014] [cgid:error] [pid 13456:tid 2895035200] [client] Premature end of script headers: ap.pl, referer:


Bugs: #1076


<< < 1 2 (Page 2 of 2)
  • Hi John,

    Thanks for your comment!

    Some things about the situation:
    A company is able to issue (sales) invoice in the following ways:
    - paper based invoice, in Hungary it is typically a preprinted small book, filled by manually, it has preprinted and registered unique serial numbers
    - using any kind of computer based solution
    - ledgersmb itself

    When we use sales invoice from ledgersmb (product or services), we already force the invoice created day to the current day, the user cannot modify it and saved on post.

    Any other case, when the user enter other invoices from other systems, the invoice created date cannot be forced to today, because the field value is unknown and independent of ledgersmb. For example the operator only enters all incoming (or outgoing from other systems or book) invoices once a month: it is his responsibility to enter the correct days or ignore it.

    I found some invoice from Germany for example, where only the Transdate exists on the invoice, there is no other date on the invoice. In this case we use this date for invoice created and due date, too.

    In Hungary there are some rules, how to fill an invoice if one pays in cash or wire transfer, continuous delivery like cellphone or electricity costs or a one-time project.
    If we want to force all rules into ledgersmb, it will break other's workflow, just like this one additional field.
    In this case, the user has to know the basic, how to issue a correct invoice. Anyway, I think it is the user's responsibility to know the basic of the business.

    The Plan B could be that the user (sysadmin/app admin) makes changes to the original code to meet his/her requirements.

<< < 1 2 (Page 2 of 2)