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

Re: ERROR: date/time field value out of range: "31/10/2014"



https://sourceforge.net/p/ledger-smb/bugs/1274/

On Sun, Nov 2, 2014 at 5:08 PM, Chris Travers <..hidden..> wrote:


On Sun, Nov 2, 2014 at 11:50 AM, Max van Biezen <..hidden..> wrote:
Hi,

I want to execute an entry via cash/vouchers/reverse receipt. It fails
complaining about the date format. I am running 1.4.6RC2. How to tell
ledgersmb the date field is okay?

Max


DBD::Pg::st execute failed: ERROR:  date/time field value out of
range: "31/10/2014"
LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...
                                                        ^
HINT:  Perhaps you need a different "datestyle" setting. at
LedgerSMB.pm line 585.
2014/11/02 20:46:30 - ERROR - LedgerSMB::dberror LedgerSMB.pm (772) --
Logging SQL State 22008, error 7, string ERROR:  date/time field value
out of range: "31/10/2014"
LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...

I will file a bug report on this.  If anyone else wants to take a crack at it, the problem is probably that we aren't telling LSMB it is a dae field.  I.e. we need to identify the fieldname involved and then add a $request->dates('fieldname') or $request->dates_series(1, $request->{rowcount}, 'fieldname') as appropriate.

                                                        ^
HINT:  Perhaps you need a different "datestyle" setting.
2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (649) --
Invalid date/time entered
More information has been reported in the error logs at LedgerSMB.pm line 775.
2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (650) --
dbversion: 1.4.6, company: <DB-name>
Died at LedgerSMB.pm line 663.
Compilation failed in require at /usr/local/lsmb14/payment.pl line 8.

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users