Error on Lengthy Custom Input Fields

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mattprice Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 03-June-2007 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote mattprice Report Post Thanks(0) Quote Reply Topic: Error on Lengthy Custom Input Fields 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

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply 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).

mattprice Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 03-June-2007 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote mattprice Report Post Thanks(0) Quote Reply 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

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply 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.

mattprice Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 03-June-2007 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote mattprice Report Post Thanks(0) Quote Reply 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.