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 <[EMAIL PROTECTED]> 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 > Ledger-smb-users@lists.sourceforge.net > 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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
