Re: Upgrade from 1.2.7

On Dec 5, 2007 1:02 AM, Chris Sykes <..hidden..> wrote:

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.

This was actually caused by a bug prior to 1.2.9 which was causing some issues with date formats and closedto dates. This should only happen when the closedto date is left blank in the preferences screen ( i.e. you have never closed your books). If this event, you can either close your books for past years, or you can run the following SQL command against your database:

UPDATE defaults SET value = NULL WHERE setting_key = 'closedto';

Best Wishes,
Chris Travers

Re: Upgrade from 1.2.7 - 1.2.9