Re: Date Error in Tax report

On Sat, Jun 23, 2012 at 5:12 AM, Nigel Titley <..hidden..> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users