[ic] Really need some help

[Peter]

On 04/03/2026 08:43, davideth--- via interchange-users wrote:
> 
>> Thanks Peter:
>>
>>
>> Here are 3 occurences
>>
>>
>> [02/March/2026:13:17:34 -0600] huldacpz /cgi-bin/cart.cgi/admin/ 
>> flex_editor set_slice error as called by Vend::Data: DBD::Pg::st 
>> execute failed: ERROR:  invalid input syntax for type timestamp: "" 
>> at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1420.
>>
>> >
>> > 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"=?,"archived"=?,"order_wday"=?,"username"=?,"b_fname"=?,"zip"=?,"payment_method"=?,"b_phone"=?,"order_date"=?,"b_address1"=?,"lname"=?,"b_state"=?,"address1"=?,"shipmode"=?,"phone_day"=?,"store_id"=?,"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" = 'HCPZ56522'
>>
>> > values 
>> were:'','','40.00','','','','','','','','0.00','HCPZ56522','','0.00','','','5','u06909','','','Real-time Credit Card (visa -- authorizenet)','','20260213 14:24:52','','','','','()','','','pending','Y','','','','','20260213','','','','','121xxxxxx798." ". 0xxxx5','','','40.00','','1','','0.00','0'

<snipping two more instances which are basically the same error>

Basically put Interchange is trying to update the transactions table 
with an empty string in a field that is defined as type timestamp, 
likely the update_date field and postgresql is complaining because it 
won't accept the empty string as input for this field type.  There are a 
few possible different solutions:

* Drop the affected column from the db.

* Change the type of the field to varchar or a similar type that allows 
an empty string as a field.

* Fix the metadata for the table in IC so that it populates the field 
with a suitable default.


Peter