[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Missing column



Hello,

We've migrated from sql-ledger 2.6.22 to ledgerSMB 1.1.6. Everthing works fine so far, but when we try to print an sales-order, containing assemblies we've received the following message:

*DBD::Pg::st execute failed: FEHLER: Spalte a.true existiert nicht
*


   Error!

*SELECT p.partnumber, p.description, p.unit, a.qty,
pg.partsgroup, p.partnumber AS sku, p.assembly, p.id, p.bin
FROM assembly a
JOIN parts p ON (a.parts_id = p.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE a.bom = '1'
AND a.id = '10260'
ORDER BY a.TRUE
FEHLER: Spalte a.true existiert nicht

Any idea to get  LS working correctly??

Ubuntu 6.10. postgresql 8.0, apache 2.0

Best wishes

Liam
*