Customizing ProductCart - Content Page Length

Print Page | Close Window

Content Page Length

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=3633
Printed Date: 28-September-2024 at 10:16pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Content Page Length

Posted By: darvexwomp
Subject: Content Page Length
Date Posted: 18-April-2010 at 6:32pm

Hi,

I was wondering if there is a length limit when adding content to a custom content page. I am trying to add a fair of amount of information for a page that I created on our site but it times out on me when I try to save it. If I cut the length of the HTML by about half, it updates right away and displays on the page. It seems to be related to the amount of data. I checked my html which only includes simple table tags ( no <oi> or <ul> ) and ran it thru a validator to make sure it wasn't something in my code. Does anyone have any thoughts on this?

Thanks,
Brian

-------------
"I gave my love a chicken...It had no bones"

Replies:

Posted By: dccreatives
Date Posted: 04-August-2010 at 1:57pm

I am having the same issue. Ever sorted it out?

I am trying to paste small amounts at once, but I am still timing out.

Posted By: Greg Dinger
Date Posted: 04-August-2010 at 3:37pm

What database are you running? SQL 2000, 2005 or 2008?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: dccreatives
Date Posted: 04-August-2010 at 3:42pm

MS SQL 2005

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Greg Dinger
Date 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!

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: dccreatives
Date 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 - http://208.106.234.13/store/pc/Frequently-Asked-Questions-d2.htm

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: netprofits
Date 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.

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: dccreatives
Date Posted: 05-August-2010 at 11:31am

This is only happening on my content pages. Not on my product pages.

Posted By: ProductCart
Date 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:

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.
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?

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software