Re: Upgrade from 1.2.7 - 1.2.9

[Chris Sykes <..hidden..>]

On Tue, 2007-12-04 at 09:37 -0800, Chris Travers wrote:
> On Dec 4, 2007 2:19 AM, <..hidden..> wrote:
>         TO upgrade from 1.2.7 - 1.2.9 all i need to do is run perl
>         Build.pl and
>         copy over my existig ledgsersmb.conf file?

> In stable releases, you only need to unpack over the top.  No other
> changes are required.

I just tried this (though 1.2.6 -> 1.2.9).  I can still log in, but when
trying to access various features (e.g. sales->Sales Invoice) I get the
following error:

DBD::Pg::st execute failed: ERROR: date/time field value out of range: "0"
HINT: Perhaps you need a different "datestyle" setting.

Error!

SELECT value::date FROM defaults 
WHERE setting_key = 'closedto'
ERROR: date/time field value out of range: "0"
HINT: Perhaps you need a different "datestyle" setting.

I have full backups, so rolling back should be no problem.  Hopefully
this is something simple/obvious to fix?

Kind regards,

-- 
Chris Sykes

Next Step Solutions Limited
Unit K6 Liners Industrial Estate, Pitt Road
Freemantle, Southampton, UK, SO15 3FQ
Tel: 02380 224200
Mob: 07726 305061