[SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

[Peter D. <mer...@ma...>]

Hi,
I just updated my system with Mandriva 2007 which comes with Postgresql 8.x.
My previous db was postgresql 7.4.4
Before rebuilding my system checked with sql-ledger FAQ which mention=20
about some problems with older versions.
So I done global backup of my db's using pg_dumpall
After restoring the dump onto new system and connecting Sql-Ledger to=20
it I encountered a problem during trying
to create sales order. (it was my first transaction after restore)

DBD::Pg::st execute failed: ERROR: column "oid" does not exist
Error!
SELECT oid AS oid, qty,
   (SELECT SUM(qty) FROM inventory
   WHERE trans_id =3D 10559
   AND orderitems_id =3D ?) AS total
   FROM inventory
   WHERE trans_id =3D 10559
   AND orderitems_id =3D ?
ERROR: column "oid" does not exist

What will be the best approach in this case to correct this?

Thanks
Peter


--=20
Low Prices, Wide Selection of Gas Masks
Everyday low price guarantee. We offer special police discounts and an extr=
emely wide selection of gas masks, filters and huge selection of preparedne=
ss gear.
http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=3D24e08df2353d2e6cb9bae=
3a0e3c8c61e