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

SQL error printing Packing List.



FreeBSD 6.2
LS 1.1.12

I'm trying to print a packing slip and I'm getting the following error:

DBD::Pg::st execute failed: ERROR: column a.true does not exist
LINE 8: ORDER BY a.TRUE
^

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 = '11018'
ORDER BY a.TRUE
ERROR: column a.true does not exist
LINE 8: ORDER BY a.TRUE
^


I searched the archives/forums/bug tracker for this and I found 2 messages, one of which was saying it was being looked into, but there wasn't a followup after that.

Can anyone help with this?

Thanks!
Mark