On Sat, Jun 23, 2012 at 5:12 AM, Nigel Titley <[email protected]> wrote:
> If I run a tax report, with bounds of 1st Jan 2012 and 31st May 2012 I
> get the following error message
>
Which version is this?
> Error!
>
> *Invalid date/time entered
> More information has been reported in the error logs
> *
>
> *The error log says
> *
> DBD::Pg::st execute failed: ERROR: date/time field value out of range:
> "05 31 2012"
> LINE 1: ...blic"."tax_form_summary_report"('1', '01 1 2012', '05 31 201...
> ^
> HINT: Perhaps you need a different "datestyle" setting. at LedgerSMB.pm
> line 828.
> 2012/06/23 08:06:40 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1085) --
> Logging SQL State 22008, error 7, string ERROR: date/time field value out
> of range: "05 31 2012"
> LINE 1: ...blic"."tax_form_summary_report"('1', '01 1 2012', '05 31 201...
> ^
> HINT: Perhaps you need a different "datestyle" setting.
> Issuing rollback() due to DESTROY without explicit disconnect() of
> DBD::Pg::db handle dbname=test at /usr/local/ledgersmb/taxform.pl line 8.
>
> Looks like it is trying to use a US style date setting on a UK database.
> I'm running the latest snapshot on Ubuntu.
>
I thought I had one datestyle setting bug that might cause a problem like
this fixed in .19. If you are using .19 I will debug further. If not, you
probably want to upgrade first.
Best Wishes
Chris Travers
>
>
> Nigel
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
