#1110 if no date in sales invoice then "internal server error"

1.4
closed-fixed
nobody
GUI (2)
5
2014-04-27
2014-04-12
mvb88
No

When creating a sales invoice then "Invoice Created" and "Invoice Date"
are not set a with a default, resulting in the error below when clicking "update". When I enter a correct formatted date then the update succeeds as expected. Compared to previous LSMB's these fields had by default the current date set which was useful for the end user would be nice to have that again.

DBD::Pg::st execute failed: ERROR:  invalid input syntax for type date: ""
LINE 5:          AND transdate = ''
                                 ^ at LedgerSMB/IS.pm line 2231
    IS::exchangerate_defaults('DBI::db=HASH(0x3af6e48)', 'Form=HASH(0x1045a48)') called at LedgerSMB/IS.pm line 2150
    IS::retrieve_item('IS', 'HASH(0x1161370)', 'Form=HASH(0x1045a48)') called at bin/is.pl line 1289
    lsmb_legacy::update called at old-handler.pl line 207
    lsmb_legacy::__ANON__() called at /usr/share/perl5/Try/Tiny.pm line 76
    eval {...} called at /usr/share/perl5/Try/Tiny.pm line 67
    Try::Tiny::try('CODE(0x11612c8)', 'Try::Tiny::Catch=REF(0x550f108)') called at old-handler.pl line 224
    require old-handler.pl called at /usr/local/lsmb14/is.pl line 7
DBD::Pg::st fetchrow_array failed: no statement executing at LedgerSMB/IS.pm line 2232
    IS::exchangerate_defaults('DBI::db=HASH(0x3af6e48)', 'Form=HASH(0x1045a48)') called at LedgerSMB/IS.pm line 2150
    IS::retrieve_item('IS', 'HASH(0x1161370)', 'Form=HASH(0x1045a48)') called at bin/is.pl line 1289
    lsmb_legacy::update called at old-handler.pl line 207
    lsmb_legacy::__ANON__() called at /usr/share/perl5/Try/Tiny.pm line 76
    eval {...} called at /usr/share/perl5/Try/Tiny.pm line 67
    Try::Tiny::try('CODE(0x11612c8)', 'Try::Tiny::Catch=REF(0x550f108)') called at old-handler.pl line 224
    require old-handler.pl called at /usr/local/lsmb14/is.pl line 7

Discussion

  • Erik Huelsmann

    Erik Huelsmann - 2014-04-27

    The defaults are now filled out (at least in my tests).

     
  • Erik Huelsmann

    Erik Huelsmann - 2014-04-27
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks