[ic] Really need some help

[davideth at whojamadoogle.com]

> 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'
>
>
> [02/March/2026:13:47:02 -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','','','','','','','','22.70','HCPZ56522','','0.00','','','5','u06940','','','Real-time 
> Credit Card (visa -- authorizenet)','','20260213 
> 14:24:52','','','','','()','','','pending','Y','','','','','20260213','','','','','121xxxxxx98." 
> ". 02xxx5','','','62.70','','1','','0.00','0'
>
>
>
> [02/March/2026:13:51:22 -0600] huldacpz /cgi-bin/cart.cgi/ui 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 
> "pay_cert_ord_total"=?,"currency_locale"=?,"fname"=?,"subtotal"=?,"po_number"=?,"pay_cert_total"=?,"comments"=?,"state"=?,"b_country"=?,"email"=?,"campaign"=?,"b_lname"=?,"session"=?,"shipping"=?,"order_number"=?,"parent"=?,"salestax"=?,"b_company"=?,"archived"=?,"order_wday"=?,"username"=?,"payment_method"=?,"b_fname"=?,"zip"=?,"order_date"=?,"b_phone"=?,"b_address1"=?,"lname"=?,"b_state"=?,"address1"=?,"shipmode"=?,"store_id"=?,"phone_day"=?,"status"=?,"avs"=?,"phone_night"=?,"b_city"=?,"auth_code"=?,"city"=?,"fax"=?,"order_ymd"=?,"company"=?,"b_zip"=?,"country"=?,"b_address2"=?,"order_id"=?,"deleted"=?,"affiliate"=?,"total_cost"=?,"address2"=?,"tracking_number"=?,"nitems"=?,"update_date"=?,"complete"=?,"handling"=? 
> WHERE "code" = 'HCPZ56522'
> > values 
> were:'','','Jon','40.00','','','','Alaska','','jon_xx at xxxx.com','','','2FXASNxx','22.70','HCPZ56522','','0.00','','','5','u069xx','Real-time 
> Credit Card (visa -- authorizenet)','','996xx','20260213 
> 14:24:52','','','Hxxxxx','','17xx xxdner Drive','Priority (Priority 
> Mail US 
> only)','','','pending','Y','','','08xx2G','Wasilla','','20260213','Phoxx 
> xxtive Mexx,'','US','','121xxxxx0798." ". 02xxx5','','','62.70','Suxx 
> xx','','1','','','0.00'
>
>
> Also, please look in last months requests for the original query.
>
>
> ______________________________________
>
>> Look in both the interchange and catalog error.log files and see if 
>> there's any errors showing when you attempt to edit the company name 
>> in the admin UI.  Please share any log messages you find here.
>>
>>
>> Peter
>
>
>