Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5

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

Thanks Adrian & Enrique

Edited backup and reinstalled.
At the moment everything working fine

Peter

> ----- Original Message -----
> From: "Adrian Blake" <adr...@ie...>
> To: sql...@li...
> Subject: Re: [SL] Sql-Ledger 2.6.22/PostgreSQL 8.1.5
> Date: Thu, 04 Jan 2007 05:58:30 +1100
>=20
>=20
> Peter,
>=20
> I did the same a few days ago. see Enrique's comments. Was the=20
> SQL-Ledger the latest version or near latest?
>=20
> Adrian
>=20
> Peter Dabrowski wrote:
> > Hi,
> > I just updated my system with Mandriva 2007 which comes with=20
> > Postgresql 8.x. My previous db was postgresql 7.4.4
> > Before rebuilding my system checked with sql-ledger FAQ which=20
> > mention 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=20
> > Sql-Ledger to 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
> --
> Adrian Blake
> Molonglo Radio Observatory
> University of Sydney
> 1152 Hoskinstown Rd
> Bungendore 2621
> ph. 02 80042212  mobile 0407 232 978
>=20
> http://150.101.125.30
>=20
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

>


--=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