[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Missing column
- Subject: Missing column
- From: Willi Romer <..hidden..>
- Date: Fri, 05 Jan 2007 10:09:11 +0100
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
*