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

Re: Missing column



Hold on-- looking into this one.

On 1/5/07, Willi Romer <..hidden..> wrote:
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
*

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users