sql-ledger-users

[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

[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=
.=20
My previous db was postgresql 7.4.4
Before rebuilding my system checked with sql-ledger FAQ which 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 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
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

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

[Adrian B. <adr...@ie...>]

Peter,

I did the same a few days ago. see Enrique's comments. Was the SQL-Ledger the latest version or near latest?

Adrian

Peter Dabrowski wrote:
> 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 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 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 = 10559
>  AND orderitems_id = ?) AS total
>  FROM inventory
>  WHERE trans_id = 10559
>  AND orderitems_id = ?
> ERROR: column "oid" does not exist
> 
> What will be the best approach in this case to correct this?
> 
> Thanks
> Peter
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

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

[Dirk E. S. <ds...@ca...>]

> Hi,
> I just updated my system with Mandriva 2007 which comes with Postgresql

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

You will have to edit your backups by hand as described in the FAQ:

http://www.sql-ledger.org/cgi-bin/nav.pl?page=3Dmisc/faq.html&title=3DFAQ

Check for the section PostgreSQL 8.0+

Good luck

Enrique

>
> Thanks
> Peter
>




--=20
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com