https://sourceforge.net/p/ledger-smb/bugs/1274/
On Sun, Nov 2, 2014 at 5:08 PM, Chris Travers <chris.trav...@gmail.com>
wrote:
>
>
> On Sun, Nov 2, 2014 at 11:50 AM, Max van Biezen <mvanb...@gmail.com>
> 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
>> Ledger-smb-users@lists.sourceforge.net
>> 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.
> http://www.efficito.com/learn_more
>
--
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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
