+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / text being truncated

text being truncated

7 posts, 0 answered
  1. Mike Bentzen
    Mike Bentzen avatar
    11 posts
    Registered:
    10 May 2010
    15 Sep 2010
    Link to this post
    Hi,

    We're having a lot of difficulty with text being truncated when entering content into pages.
    I've made sure that the HTML is valid, but sitefinity continues to truncate the text.

    Any suggestions?

    Thanks.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    15 Sep 2010
    Link to this post
    Hi Mike Bentzen,

    How do you add content to your pages? Do you use GenericContent control? If you use GenericContent control, it wraps RadEditor and probably you have something in your content that is removed by a filter.  Can you perform some tests using this demo and/or send us sample HTML that is stripped at your end.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Mike Bentzen
    Mike Bentzen avatar
    11 posts
    Registered:
    10 May 2010
    15 Sep 2010
    Link to this post
    We are using the GenericContent Control. It is not being stripped when using that demo.

    Ivan, we have purchased sitefinity through Wide Media in Australia and we are not sure how to access our support package. Was it registered under a different email address?
  4. Mike Bentzen
    Mike Bentzen avatar
    11 posts
    Registered:
    10 May 2010
    15 Sep 2010
    Link to this post
    We've identified it could be a database issue.

    We hired Wide Media to create a template. They hosted the site on their server (and database using sql2005). They packaged it up and sent it to us. We received the package, loaded the database in sql 2005 and exported as sql2000.
    When importing the database, there was an error when importing nvarchar(max), and instead we changed all instances of this to "ntext", which I believe has a limit of 8000 bytes, and that is why it is being truncated.

    We also change the ExtendedSql2005Provider sections in the Web.config to ExtendedSql2000Provider. We logged in and could edit pages and assumed everything was working.

    However today we noticed when creating content on pages, (that have a lot of content), sitefinity or the database seems to truncate the text.

    Any suggestions would be greatly appreciated.

    Thanks.
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    16 Sep 2010
    Link to this post
    Hello Mike Bentzen,

    You could check whether the text exists in

    [sf_CmsTextContent] - used for shared content
    [sf_CmsControlProperty] where Name='Content' - used for not shared content when you have entered text directly into GenericContent content area.

    If the content is there, you should see it on a page, otherwise the control is showing some previous version of it and when the item/control was edited the content was also updated. You could check some of the previous versions and copy the content from there or perform rollback.

    Migration SQL 2005 to SQL 2000 is not backward compatible. By default you cannot restore a database of higher version to lower easily. This should be performed by scripts which alters the columns properly.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Mike Bentzen
    Mike Bentzen avatar
    11 posts
    Registered:
    10 May 2010
    16 Sep 2010
    Link to this post
    The only thing that we changed when performing the migration was the nvarchar(max). SQL Server 2000 does not support this type and therefore when we exported the sql script, we did a mass find and replace converting nvarchar(max) to ntext, without realising the consequences.

    If we were to purchase a sql 2005 database with our hosting plan, do you think we would we run into any other problems with converting over the database from sql 2000 to sql 2005 if we mapped the ntext type back to nvarchar(max)?

    Kind Regards,

    Mike
  7. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    17 Sep 2010
    Link to this post
    Hello Mike Bentzen,

    Generally such issues appears in case when you make downgrade which is not supported by default by MS SQL. I have not heard about upgrade issues related to this type of columns and this is something that is not controlled by Sitefinity.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
7 posts, 0 answered