[ic] "bad timestamp external representation"?
janine at furfly.net
Tue Jul 27 13:09:05 EDT 2004
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:
184.108.40.206 EpZsCaBB:220.127.116.11 - [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.
18.104.22.168 EpZsCaBB:22.214.171.124 - [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?
More information about the interchange-users