[ic] "bad timestamp external representation"?

Eric Small interchange at ericsmall.com
Tue Jul 27 13:31:02 EDT 2004

Janine Sisk wrote:
> HI all,
> Thanks for all the GPG help, i finally did get it working smoothly.
> Now we have a new problem.  The client says that he's getting these 
> errors when trying to mark orders as shipped:
> EpZsCaBB: - [27/July/2004:12:18:06 -0400] shop 
> /cgi-bin/shop/process Runtime error: DBD::Pg::st execute failed: ERROR: 
>  Bad timestamp external representation '2004-07-' at 
> /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1626.
> EpZsCaBB: - [27/July/2004:12:19:44 -0400] shop 
> /cgi-bin/shop/admin/order Vend::Table::DBI - Length Exception! - Data 
> length: 25 Field length: 8

I ran into that problem quite recently.
See my post from 6/30/04

I never got any responses to my post about it and the only "fix" I came 
up with on my own was to switch to MySQL.

I did find a workaround for PostgreSQL though, which is detailed in my 
earlier post.

Sorry I can't be of more help,

Interchange 5.2.0 / Debian 3.0 Stable / MySQL 4.0.20-log

More information about the interchange-users mailing list