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