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

Re: 1.2.0-rc5 problem with cash receipt

Robert Fraser wrote:

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: ""

Well what it is telling you is, the date you supplied for the payment is missing :). I don't actully recall if we supply that date or it if is supposed to be user supplied.

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

Any pointers to what this might be?




Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash


Ledger-smb-users mailing list


      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/