Re: [SL] Upgrade problem

[Paul T. <pt...@wa...>]

Adrian Blake schreef:
> Progress:
>
> the error is now:
>
> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
> .
> .
> .
>
> ERROR: column t.validto does not exist
>
> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
> postgres 7.? to 8.1.?
>
> Adrian
>
> Dieter Simader wrote:
>   
>> edit the backup you made with SQL-Ledger,
>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>> (see the FAQ)
>> restore the backup with psql
>>
>> psql -U sql-ledger dbname < backup.sql
>>
>>     
>
>   
Had the same here some time ago, the SQL-Ledger internal backup (you did 
make one I hope) was my rescue.
Clean install of System on a new computer, including latest of 
everything, then unzip the sql-ledger backed up file.
Look at version, install latest SQL-Ledger and carefully read any 
remarks about uodating from older versions.
Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
Rather then hacking in files I suggest using some of the update scripts 
in the tar-balls.
You should be up and running that way in half a day..

BTW, this is also a good way to transfer complete set of accounts from 
say customer to bookkeeper.
If customer uses SQL-Ledger and bookkeeper is at least able to do the 
same that is.
Add any needed year end corrections, like salary journal entries and 
some amortisation.
Do yearend report and return to customer.