When i perform a POS Sale for either a service or product the following
error comes up:


DBD::Pg::st execute failed: ERROR: null value in column "chart_id"
violates not-null constraint


Error!


INSERT INTO acc_trans 
(trans_id, chart_id, amount, 
transdate, source, memo, cleared)
VALUES (?, (SELECT id FROM chart
WHERE accno = ?),
?, ?, ?, ?, ?)
ERROR: null value in column "chart_id" violates not-null constraint


Using the following setup:
- PostgreSQL 8.2
- Perl v5.8.8
- Apache 2.2.6
LedgerSMB 1.2.12 from source


Any help is most appreciated.  Thanks in advance.

john

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Reply via email to