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

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

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.

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.


ph. 98421450 (h)
    94791571 (w)

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.
Ledger-smb-users mailing list