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

Error while printing Packing Slip



Hello!

LS 1.1.12

I was trying to print a packing slip from the Shipping menu and I received 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 don't want to upgrade to 1.2.  Is there a patch available for this?

Thanks!
Mark