Re: Error while printing Packing Slip

["Chris Travers" <..hidden..>]

Hi;

Although I believe this was fixed in 1.2, the fix is something you can
correct yourself.  Delete any ORDER BY clause referencing anything
like $oid.

I.e. "ORDER BY $oid" would be deleted.

Best Wishes,
Chris Travers

On 5/26/07, M Lubratt <..hidden..> wrote:
> 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
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users