On Dec 5, 2007 1:02 AM, Chris Sykes <[EMAIL PROTECTED]>
wrote:
> On Tue, 2007-12-04 at 09:37 -0800, Chris Travers wrote:
> > On Dec 4, 2007 2:19 AM, <[EMAIL PROTECTED]> 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
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
