Re: Hotfix available for LedgerSMB 1.2.5 error

[Vladimir Botka <..hidden..>]

Dne Fri, 18 May 2007 12:55:34 -0700
"Chris Travers" <..hidden..> napsal(a):

> When issuing an AP transaction in 1.2.5 (only), you may get the
> following error:
> 
> ERROR: column "customer_id" does not exist
> 
> This problem was caused by a problem with one of the performance
> patches which made it into 1.2.5.  A fix has been committed to SVN
> branches/1.2
> 
> Anyone experiencing this problem has the following options:
> 1)  Downgrade to 1.2.4 (just requires untarring over the top)
> 2)  Contacting me for an appropriate hotfix (I will send you a
> replacement Form.pm).
> 3)  Download Form.pm from SVN (branches/1.2).
> 
> Best Wishes,
> Chris Travers

I have solved this issue with:

1. dump the 1.2.4 dataset
#pg_dump -d -F tar -U pgsql -f dataset.dump dataset.1.2.4
2. create new dataset.1.2.5 (in admin.pl)
3. restore the dataset
"#pg_restore -c -U pgsql -d dataset.1.2.5 dataset.dump"

There was no complains from lSmb 1.2.5 up till now. Is this O.K. ?
-vlado

-- 
Dr.Vladimir Botka
..hidden..