[ic] "bad timestamp external representation"?

[Eric Small]

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:
> 
> 63.69.52.133 EpZsCaBB:63.69.52.133 - [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.
> 
>>
> 63.69.52.133 EpZsCaBB:63.69.52.133 - [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
http://www.icdevgroup.org/pipermail/interchange-users/2004-June/039780.html

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,
Eric

-- 
Interchange 5.2.0 / Debian 3.0 Stable / MySQL 4.0.20-log