More in this section

Forums / Bugs & Issues / Problem with Blog module

Problem with Blog module

3 posts, 0 answered
  1. Len
    Len avatar
    14 posts
    10 Jul 2008
    27 Aug 2008
    Link to this post
    I am having issues.  I have deleted and recreated everything associated with the blog but I am still experiencing the same issue.  Below is the error trace:

    Server Error in '/' Application.
    Data at the root level is invalid. Line 1, position 1.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Exception: Data at the root level is invalid. Line 1, position 1.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [Exception: Data at the root level is invalid. Line 1, position 1.]
       Telerik.Cms.Engine.Design.SettingsListConverter.DeserializeDesignerSettings(String settingsCollection) +398
       Telerik.Cms.Engine.Design.SettingsListConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value) +53
       System.ComponentModel.TypeConverter.ConvertFromInvariantString(String text) +37
       Telerik.Cms.Data.WebControlBase.LoadControl(Control control, PropertyDescriptorCollection properties) +164
       Telerik.Cms.Data.CmsWebControl.LoadControl(Control control, PropertyDescriptorCollection properties) +9
       Telerik.Cms.Data.WebControlBase.LoadControl(TemplateControl template, Control& control) +289
       Telerik.Cms.Data.WebControlBase.LoadControl(TemplateControl template) +24
       Telerik.Cms.Data.WebControlBase.LoadControl() +9
       Telerik.Cms.Data.StagedPage.HasRewriterService(CmsWebControl ctrl) +77
       Telerik.Cms.Data.StagedPage.Copy(StagedPage source, PageContentBase target) +674
       Telerik.Cms.Data.StagedPage.Publish() +194
       Telerik.Cms.Data.StagedPage.CheckIn() +71
       Telerik.Cms.Web.UI.ToolBar.Button_Command(Object sender, CommandEventArgs e) +135
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +105
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

    Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

  2. Georgi
    Georgi avatar
    3583 posts
    28 Oct 2016
    28 Aug 2008
    Link to this post
    Hi Len,

    Are you using MySQL database?
    It seems that there is an issue when saving xml values to the MySQL database. The controls which have such properties are ContentView, NewsView, BlogPosts.

    The problem is that MySQL adds a '?' symbol in the beginning of the xml string. We are still investigating a reason for that and are on the way to fix it. The fix will be included in next release. 

    For the time being we can suggest that you apply the workaround described below:
    Modify the two stored procedures in the database: sf_CmsControlProperty_upd and sf_CmsControlProperty_ins.

    In sf_CmsControlProperty_upd replace `Value` = P_Value  with `Value` = Replace(P_Value, '?<?xml', '<?xml')
    CREATE DEFINER=`root`@`localhost` PROCEDURE `sf_CmsControlProperty_upd`(in PO_ControlID varchar(39), in PO_Name varchar(54), in P_ParentID varchar(39), in P_ParentName varchar(54), in P_Value longtext) 
        DECLARE _msg TINYINT; 
        UPDATE `sf32`.`sf_CmsControlProperty` SET `ParentID` = P_ParentID, `ParentName` = P_ParentName, `Value` = Replace(P_Value, '?<?xml''<?xml'WHERE `ControlID` = PO_ControlID AND `Name` = PO_Name; 
        IF (row_count() <> 1) THEN SET _msg='error'END IF; 

    In sf_CmsControlProperty_ins replace P_Value with Replace(P_Value, '?<?xml', '<?xml')
    CREATE DEFINER=`root`@`localhost` PROCEDURE `sf_CmsControlProperty_ins`(in P_ControlID varchar(39), in P_Name varchar(54), in P_ParentID varchar(39), in P_ParentName varchar(54), in P_Value longtext) 
        DECLARE _msg TINYINT; 
        INSERT INTO `sf32`.`sf_CmsControlProperty` (`ControlID`, `Name`, `ParentID`, `ParentName`, `Value`) VALUES (P_ControlID, P_Name, P_ParentID, P_ParentName, Replace(P_Value, '?<?xml''<?xml')

    These changes can be made using the MySQL Administrator tool.

    I hope this workaround will be of help.
    Let me know if you more assistance is needed.

    Sincerely yours,
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. Len
    Len avatar
    14 posts
    10 Jul 2008
    28 Aug 2008
    Link to this post
    Thank you very much Georgi.  That did the trick.

Register for webinar
3 posts, 0 answered