[ic] So does anyone actually use Interchange with Postgres?

[James P. Kinney III]

On Wed, 2004-07-28 at 13:44, Janine Sisk wrote:

> 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.

I am having a related issue also with the timestamp in IC 5.2 and
Postgresql 7.4 On various Redhat/Fedora setups.

While trying to edit an order in UI, I get an error message that says
the timestamp data was invalid and shows it to be ''. I've been digging
through the DBI.pm (line 1251) which was the line number given in the
error message. The update_date column in transactions seems to be the
culprit. But it is set to be 'timestamp without time zone' and it is not
marked as 'NOT NULL'. (I've set some line wraps below)

192.168.1.18 L7i3FZXi:192.168.1.18 - [19/July/2004:15:10:11 -0400]
industrial /cgi-bin/industrial/admin/flex_editor set_slice error as
called by Vend::Data: DBD::Pg::st execute failed: ERROR:  Bad timestamp
external representation '' at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1251.
>
> query was:update transactions SET
currency_locale=?,fname=?,subtotal=?,po_number=?,comments=?,state=?,
b_country=?,email=?,campaign=?,b_lname=?,shipping=?,order_number=?,
parent=?,salestax=?,b_company=?,order_wday=?,archived=?,username=?,
b_fname=?,zip=?,payment_method=?,b_phone=?,order_date=?,b_address1=?,
lname=?,b_state=?,address1=?,shipmode=?,store_id=?,phone_day=?,
status=?,avs=?,b_city=?,phone_night=?,city=?,fax=?,order_ymd=?,
company=?,b_zip=?,country=?,b_address2=?,order_id=?,affiliate=?,
deleted=?,total_cost=?,address2=?,nitems=?,update_date=?,handling=?,complete=? WHERE code = '1074'
> values
were:'','Fred','129.95','','','CA','','testthis at mytestsite.com',
'','','0.00','1074','','0.00','','1','','fred','','90210','credit_card','','20040719 15:06:34','','Flintstone','','1111 anywhere Ln','1DA (UPS Next Day Air)','','555-1234','pending','','','','Los Angeles','','20040719','','','US','','','ORDER_DESK','','129.95','','1','','0.00','0'

NOTE-------------------------------------------------------------------^^^^ empty timestamp field.

I can't find a reference to calling a system time anywhere.

If I set the column to be varchar(24) I don't get the error. But it
_should_ be a timestamp for proper date work later.

Mike, where should I be looking to fix this?

-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.icdevgroup.org/pipermail/interchange-users/attachments/20040728/d664b094/attachment.bin