ProductCart Shopping Cart Software Forums : Content Page Length https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 13:35:08 +0000 Fri, 06 Aug 2010 00:52:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3633 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Content Page Length : If you are using the same description...]]> https://forum.productcart.com/content-page-length_topic3633_post15178.html#15178 Author: ProductCart
Subject: 3633
Posted: 06-August-2010 at 12:52am

If you are using the same description and it is saved successfully when adding/editing a product, but not when adding/editing a Content Page, then there are only 2 possibilities:
  1. Database field size issue
    The database field holding the information is smaller than the amount of information that you are trying to save, as mentioned earlier in this thread.
  2. Code truncating data
    The form handler that handles the information submitted when adding/editing a content page is truncating the data. This would explain why the issue persists after editing the database field size.
Next step:
  • which version of ProductCart are you currently running?
  • which version of ProductCart did you originally install?
]]> Fri, 06 Aug 2010 00:52:57 +0000 https://forum.productcart.com/content-page-length_topic3633_post15178.html#15178 <![CDATA[Content Page Length : This is only happening on my content...]]> https://forum.productcart.com/content-page-length_topic3633_post15173.html#15173 Author: dccreatives
Subject: 3633
Posted: 05-August-2010 at 11:31am

This is only happening on my content pages. Not on my product pages.]]> Thu, 05 Aug 2010 11:31:28 +0000 https://forum.productcart.com/content-page-length_topic3633_post15173.html#15173 <![CDATA[Content Page Length : Dan, that&#039;s fascinating....]]> https://forum.productcart.com/content-page-length_topic3633_post15172.html#15172 Author: Greg Dinger
Subject: 3633
Posted: 05-August-2010 at 11:31am

Dan, that's fascinating. I saw that EI disabled that feauture in 4.1 but never heard the background as to why.  Thanks for sharing.]]> Thu, 05 Aug 2010 11:31:12 +0000 https://forum.productcart.com/content-page-length_topic3633_post15172.html#15172 <![CDATA[Content Page Length : We had a similar issue with a...]]> https://forum.productcart.com/content-page-length_topic3633_post15171.html#15171 Author: netprofits
Subject: 3633
Posted: 05-August-2010 at 11:22am

We had a similar issue with a version 3.x store. The eventual solution was to modify the viewprd.asp module (in the pc folder) and comment out the section that contains this comment:
'// increase visits for product
 
(This is around line 320 depending on your version).
For some strange reason, the update of the product visits was causing an error with pages that had longer descriptions.
]]> Thu, 05 Aug 2010 11:22:17 +0000 https://forum.productcart.com/content-page-length_topic3633_post15171.html#15171 <![CDATA[Content Page Length : I can only recommend that you...]]> https://forum.productcart.com/content-page-length_topic3633_post15170.html#15170 Author: Greg Dinger
Subject: 3633
Posted: 05-August-2010 at 10:57am

I can only recommend that you either file a support ticket or hire a developer who will have the ability to evaluate the issue at the code level and resolve it.  I've taken this as far as I know how to without actually connecting to the database and performing debugging procedures.]]> Thu, 05 Aug 2010 10:57:22 +0000 https://forum.productcart.com/content-page-length_topic3633_post15170.html#15170 <![CDATA[Content Page Length : I updated it and ran the query...]]> https://forum.productcart.com/content-page-length_topic3633_post15168.html#15168 Author: dccreatives
Subject: 3633
Posted: 05-August-2010 at 10:50am

I updated it and ran the query to no avail. I am insterting the content with HTML tags. It does not want to take more text. Here is the page: http://208.106.234.13/store/pc/Frequently-Asked-Questions-d2.htm]]> Thu, 05 Aug 2010 10:50:34 +0000 https://forum.productcart.com/content-page-length_topic3633_post15168.html#15168 <![CDATA[Content Page Length : Mark Shipp, ever watchful to make...]]> https://forum.productcart.com/content-page-length_topic3633_post15160.html#15160 Author: Greg Dinger
Subject: 3633
Posted: 04-August-2010 at 5:13pm

Mark Shipp, ever watchful to make sure database-related posts are handled ever so correctly, gently reminded me of an oversight.   I knew this, but overlooked it. 
 
You need to run this query after changing the data type:

UPDATE pcContents SET pcCont_Comments = pcCont_Comments

 
That query will write teh data over itself in order to have the data correctly stored in the database.  As Mark stated it:  they need to run a script to assign the column back to itself otherwise the data remains in the LOB and not placed back into the DB where it belongs. 
 
Thanks Mark!
 
 
]]> Wed, 04 Aug 2010 17:13:28 +0000 https://forum.productcart.com/content-page-length_topic3633_post15160.html#15160 <![CDATA[Content Page Length : The field pcCont_Comments is defined...]]> https://forum.productcart.com/content-page-length_topic3633_post15159.html#15159 Author: Greg Dinger
Subject: 3633
Posted: 04-August-2010 at 3:49pm

The field pcCont_Comments is defined as type nvarchar(4000).  If you can pop into the database with SQL Studio, and change that field to nvarchar(MAX), you will get 8000.  Give that a try.]]> Wed, 04 Aug 2010 15:49:42 +0000 https://forum.productcart.com/content-page-length_topic3633_post15159.html#15159 <![CDATA[Content Page Length : MS SQL 2005 ]]> https://forum.productcart.com/content-page-length_topic3633_post15158.html#15158 Author: dccreatives
Subject: 3633
Posted: 04-August-2010 at 3:42pm

MS SQL 2005]]> Wed, 04 Aug 2010 15:42:33 +0000 https://forum.productcart.com/content-page-length_topic3633_post15158.html#15158 <![CDATA[Content Page Length : What database areyou running?...]]> https://forum.productcart.com/content-page-length_topic3633_post15157.html#15157 Author: Greg Dinger
Subject: 3633
Posted: 04-August-2010 at 3:37pm

What database are you running?  SQL 2000, 2005 or 2008?]]> Wed, 04 Aug 2010 15:37:44 +0000 https://forum.productcart.com/content-page-length_topic3633_post15157.html#15157