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

1.2.0-rc5 problem with cash receipt



Hi

I am getting an error with recording a payment (1.2.0RC5, Postgres 8.1.8):

DBD::Pg::st execute failed: ERROR: invalid input syntax for type date: ""

Error!


INSERT INTO acc_trans
(trans_id, chart_id, transdate,
amount, source, memo)
VALUES (?, (SELECT id
FROM chart
WHERE accno = ?),
?, ?, ?, ?)
ERROR: invalid input syntax for type date: ""

Any pointers to what this might be?


Thanks

Rob