Re: 1.2.0-rc5 problem with cash receipt

["Joshua D. Drake" <..hidden..>]

Robert Fraser wrote:
> 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!

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)
> VALUES (?, (SELECT id
> FROM chart
> WHERE accno = ?),
> ?, ?, ?, ?)
> ERROR: invalid input syntax for type date: ""*
>
> Any pointers to what this might be?
>
> Thanks
>
> Rob
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> 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
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


--

      === 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
             http://www.commandprompt.com/

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