Re: SQL error printing Packing List.

["M Lubratt" <..hidden..>]

Yes, they do.

I forgot to mention that this error occurred when trying to print a packing slip from the sales order.  If I went ahead and constructed an invoice and then printed the packing slip, I didn't get the error.  I didn't try it from the shipping screen though.

HTH!
Mark

On 5/1/07, Chris Travers <..hidden..> wrote:

Hi Matt,

DO these packing lists contain assemblies by any chance?

Best Wishes,
Chris Travers

On 4/30/07, M Lubratt <..hidden..> wrote:
> 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
>
>
> -------------------------------------------------------------------------
> 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
>
>

-------------------------------------------------------------------------
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