Re: Error when posting sales-invoice containing stock-assembly as an item

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

Hi Charlie;

I have this fixed in svn.  I can send you a new, fixed IS.pm if you
like.  A hotfix anouncement will be going out shortly.

Best Wishes,
Chris Travers

On 4/27/07, Charlie Ambrose <..hidden..> wrote:
> I get the following error when trying to post a sales-invoice containing a stock-assembly as an item:
> ----
> DBD::Pg::st execute failed: called with 1 bind variables when 0 are needed at LedgerSMB/IS.pm line 1027.
> Error!
>
>
> SELECT sum(
> p.inventory_accno_id),
> p.assembly
> FROM parts p
> JOIN assembly a
> ON (a.parts_id = p.id)
> WHERE a.id = 12142
> GROUP BY p.assembly
> called with 1 bind variables when 0 are needed
> ----
> I have checked all entries in the sales-invoice form; all necessary fields are filled and the data
> in each field is valid.
>
> I have recently migrated from SQL-Ledger 2.6.18 ---> LedgerSMB version 1.2.1 ---> 1.2.3
>
> I believe I have followed all steps required to correctly migrate from SQL-Ledger ---> LedgerSMB.
> In particular, I ran (and checked) the Postgres table-alterations contained in
> the script Pg-upgrade-2.6.18-2.6.19.sql.
>
> Any help trying to track-down the source of the error would be appreciated.
>
> Thanks,
>
> --Charlie
> ph. 98421450 (h)
>     94791571 (w)
> (Mon-Thu)
>
>
> -------------------------------------------------------------------------
> 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