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

Date Error in Tax report



If I run a tax report, with bounds of 1st Jan 2012 and 31st May 2012 I get the following error message

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.

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