[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Error when posting sales-invoice containing stock-assembly as an item
- Subject: Error when posting sales-invoice containing stock-assembly as an item
- From: "Charlie Ambrose" <..hidden..>
- Date: Sat, 28 Apr 2007 00:54:31 +1000
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)