[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Vendor Invoice error
- Subject: Re: Vendor Invoice error
- From: Liz Young <..hidden..>
- Date: Tue, 21 Aug 2007 12:55:23 -0700
On Tue August 21 2007 11:36:46 am Chris Travers wrote:
> On 8/21/07, Liz Young <..hidden..> wrote:
> > DBD::Pg::st execute failed: ERROR: date/time field value out of range:
> > "0" HINT: Perhaps you need a different "datestyle" setting.
> > Error!
>
> This is a known issue for some versions. To correct, log into the db with
> PgAdmin, psql, or the like and run the following query:
>
> UPDATE defaults SET value = NULL WHERE setting_key = 'closedto';
Thanks, that worked.
> To prevent this from happening again, please upgrade to 1.2.7.
I am already running 1.2.7, upgraded from 1.2.6.
Thanks,
Liz