[ic] "bad timestamp external representation"?
Janine Sisk
janine at furfly.net
Wed Jul 28 10:18:33 EDT 2004
Resending....
Well, I've narrowed it down a bit. The error log shows this:
63.69.52.133 EpZsCaBB:63.69.52.133 - [27/July/2004:16:14:21 -0400] shop
/cgi-bin/shop/process Vend::Table::DBI - Length Exception! - Data
length: 25 Field length: 8
63.69.52.133 EpZsCaBB:63.69.52.133 - [27/July/2004:16:14:21 -0400] shop
/cgi-bin/shop/process Vend::Table::DBI - Length Exception - Table:
orderline, Field: update_date. Action to take: truncate_log
63.69.52.133 EpZsCaBB:63.69.52.133 - [27/July/2004:16:14:21 -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.
So it gets a very long date string from somewhere, truncates it to the
expected length, and then gets an error inserting it because it's no
longer a valid date.
The default date format in Postgres is very long, and that's probably
the culprit:
shop=> select now();
now
-------------------------------
2004-07-27 16:22:30.469621-04
(1 row)
MySQL, according to a book I happened to have handy, has a default
format of YYYYMMDDHHMMSS, which would truncate into 8 characters that
actually work as a date.
I can't find any way of telling Postgres to use that date format. Does
this mean Interchange isn't really compatible with Postgres after all,
or am I missing something here?
thanks,
janine
On Jul 27, 2004, at 1:31 PM, Eric Small wrote:
> 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
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
More information about the interchange-users
mailing list