[ic] "bad timestamp external representation"?

Janine Sisk janine at furfly.net
Tue Jul 27 13:09:05 EDT 2004


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 searched for the error but only found people discussing 4.6.x 
versions of Interchange;  this is Interchange 5.2 and Postgres 7.3.6.  
I'm hesitant to try any old solutions (assuming I could find one) 
without knowing they're still valid.

My guess is that I need to specify a date format string - it's probably 
using something like YYYY-MM-DD HH:MM:SS etc etc etc, when something 
much shorter is expected.  But where?

thanks,

janine



More information about the interchange-users mailing list