[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: upgrade from sql-ledger 2.8
- Subject: Re: upgrade from sql-ledger 2.8
- From: Maanus Kask <..hidden..>
- Date: Fri, 3 Apr 2009 16:04:28 +0300
On Wed, 11 Mar 2009 09:12:24 -0700
Chris Travers <..hidden..> wrote:
> > ERROR: column "version" of relation "defaults" does not exist
> > -------------
> > chart_id indeed contains NULL's. What is this acc_trans and what
> > can I do with NULL values?
> Ok. We have two issues here that need to be addressed. The first is
> that you will need to comment out references to the defaults table for
> The second are those null values (which we don't allow). These occur
> when information is entered against an UNKNOWN account, which really
> shouldn't happen.
> 1) Do your books balance?
> 2) Do you use AR, AP, and income accounts?
No, it did not balance, I just dropped this DB.
Took another one. Managed to run the upgrade scripts and even log in.
When I want to open an old invoice it says:
DBD::Pg::st execute failed: ERROR: column i.notes does not exist
LINE 5: pr.projectnumber, i.serialnumber, i.notes,
^ at LedgerSMB/IS.pm line 1957.
Has'nt anyone done this (convert from SL2.8 to LedgerSMB) before?