Using ProductCart - Error on Lengthy Custom Input Fields

Error on Lengthy Custom Input Fields

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3499
Printed Date: 01-March-2025 at 9:31am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Error on Lengthy Custom Input Fields

Posted By: mattprice
Subject: Error on Lengthy Custom Input Fields
Date Posted: 10-March-2010 at 8:50am

My store is not live yet but I have been developing it since V3. I have upgraded to V4 and I have hit an error which I am pretty sure I did not see in V3.

My store will extensively use Text Area Custom Input Fields where the customer is likely to enter 20 or more lines of text. I am hitting an error when a customer enters around 500 characters and trys to add the product to cart. They get hit with the following error:-

Microsoft OLE DB Provider for SQL Server error '80040e57'

String or binary data would be truncated.

/order/pc/inc_SaveShoppingCart.asp, line 194

It is fine if the customer has only entered a few lines of text so it has something to do with field length. I believe the inc_SaveSHoppingCart.asp is a new V4 file and has something to do with the new Saved Cart feature.

Can anyone see what might be going on here in V4 that wasnt happening in V3 (at least I dont think) ?

Many Thanks

Matt

Replies:

Posted By: Guests
Date Posted: 10-March-2010 at 2:28pm

Hi Matt,

inc_SaveShoppingCart.asp is indeed new with v4 along with a new table in the database, pcSavedCratArray. The problem is that the field storing this data is not large enough for your purposes.

I belive the field in this table that stores this data is SCArray4. You will want to change this field:

SQL 2000: make it an ntext field

SQL 2005: make it nvarchar(max)

Just need to get confirmation on whether this is the correct field (possibly could be SCArray21).

Posted By: mattprice
Date Posted: 10-March-2010 at 7:42pm

Fantastic Sean, many thanks.

ScArray21 was the correct field for Custom Input Data. SCArray4 dealt with product options.

Matt

Posted By: Guests
Date Posted: 10-March-2010 at 8:47pm

Glad that worked out for you. Was not easy to figure out which field was storing what exactly.

I'm totally a glass house throwing stones, but it would be nice if EI did make use of the comment fileds in the db to explain what's fields with abstract names like this are actually used for.

Posted By: mattprice
Date Posted: 11-March-2010 at 2:29am

There is a Wiki article http://wiki.earlyimpact.com/developers/cartcontent - http://wiki.earlyimpact.com/developers/cartcontent that deals with Cart Array Assignments. I think these same numbers follow through for the new saved cart features.