[Pkg-sql-ledger-discussion] Bug#675816: ledgersmb: Unable to upgrade from 1.2 db to 1.3 db

[Robert James Clay]

On Mon, 2012-06-04 at 09:47 -0400, Jos Geluk wrote:
> I am the user who originally reported the failure in the 
> ledger-smb-users mailing list. No, I haven't resolved this issue yet, 
> and I haven't been able to upgrade my databases either.
> In fact, I upgraded this system to Ubuntu 12.04 and re-installed 
> LedgerSMB from the .deb-files, and I get the same error (apart from the 
> line "eval 102" now reading "eval 92").

> After that, all tables have zero rows (and the "customer" table is 
> missing altogether. Is this normal, btw?)

   I'm not sure about that and it may depend, in part, on the data in
the original database. When I tested a v1.2 db against 1.3.15-2, the
conversion didn't complete.  Against a 1.3.17-1 install I have; it
appears to complete but there's no converted data.  Still investigating.


> I am using Postgres 9.1 on this system. For the "contrib dir", which the 
> page "Database Management Console" asks for, I enter 
> /usr/share/postgresql/9.1/extension/. I have entered the same path in 
> /etc/ledgersmb/ledgersmb.conf, but when I used the old default, I got 
> the same error.

   I see the same thing when I'm doing db test conversions and since
it's a configuration item I'm not even sure why that field is displayed.





Jame