ProductCart Shopping Cart Software Forums : Error on Lengthy Custom Input Fields https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 19:06:40 +0000 Thu, 11 Mar 2010 02:29:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3499 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Error on Lengthy Custom Input Fields : There is a Wiki article http:/...]]> https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13352.html#13352 Author: mattprice
Subject: 3499
Posted: 11-March-2010 at 2:29am

There is a Wiki article 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.  ]]> Thu, 11 Mar 2010 02:29:04 +0000 https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13352.html#13352 <![CDATA[Error on Lengthy Custom Input Fields : Glad that worked out for you....]]> https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13350.html#13350 Author: Guests
Subject: 3499
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.
]]> Wed, 10 Mar 2010 20:47:22 +0000 https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13350.html#13350 <![CDATA[Error on Lengthy Custom Input Fields : Fantastic Sean, many thanks. ScArray21...]]> https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13348.html#13348 Author: mattprice
Subject: 3499
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 
]]> Wed, 10 Mar 2010 19:42:41 +0000 https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13348.html#13348 <![CDATA[Error on Lengthy Custom Input Fields : Hi Matt, inc_SaveShoppingCart.asp...]]> https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13345.html#13345 Author: Guests
Subject: 3499
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).
]]> Wed, 10 Mar 2010 14:28:48 +0000 https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13345.html#13345 <![CDATA[Error on Lengthy Custom Input Fields : My store is not live yet but I...]]> https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13342.html#13342 Author: mattprice
Subject: 3499
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
 


Edited by mattprice - 10-March-2010 at 8:51am]]> Wed, 10 Mar 2010 08:50:05 +0000 https://forum.productcart.com/error-on-lengthy-custom-input-fields_topic3499_post13342.html#13342