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

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



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)