[ic] Really need some help

[Peter]

On 13/03/2026 07:45, davideth--- via interchange-users wrote:
> I have an urgent problem. using  Interchange 5.10.0 © 2002-2009 under 
> CentOS v7.9.2009 STANDARD kvm
> 
> Apparently, there is a glitch in interchange that allows unacceptable 
> characters in the userdb file and possibly others as well. .

You have not shown this.

> An order was placed, process, and credit card was filed, however, the 
> userdb files is almost empty It has the user name, item, date, but 
> incorrect order total as there was a shipping charge. The order was 
> properly logged to tracking.asc and all details are there. email was 
> sent correctly to customer and to our orders@ .

<snipped a bunch of useless information>

> Ah, found the error message!
> 
> 72.xx.xxx.xxx xxxxxxxxx:72.xx.xxx.xxx - [13/February/2026:14:24:52 
> -0600] huldacpz /cgi-bin/cart.cgi/ord/finalize set_slice error as called 
> by Vend::UserDB: DBD::Pg::st execute failed:
> 
>  >>>>>>  ERROR:  value too long for type character varying(64) at /usr/ 
> local/interchange/lib/Vend/Table/DBI.pm line 1420.

This means that a field in the db is too short for the data that IC is 
attempting to save with an UPDATE query.

>  > query was:update "userdb" SET 
> "address1"=?,"address2"=?,"b_country"=?,"city"=?,"company"=?,"country"=?,"email"=?,"fname"=?,"lname"=?,"mv_shipmode"=?,"phone_day"=?,"state"=?,"zip"=?,"updated"=?,"preferences"=? WHERE "username" = 'u06940'
>  > values were xxx

You just removed the most import data and replaced it with an "xxx". 
Look for the data that appears to be really long (longer than 64 chars), 
match it with the column name above, and check with your database schema 
to see if it's a field defined as varchar(64).  Once you've identified 
this field then your options to fix the issue are (1) increase the 
length of the field in question, or (2) set a max field length for the 
field in IC (which I don't have the time to look up how to do right now).


Peter