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

Forums / Set-up & Installation / msql starting project error

msql starting project error

9 posts, 0 answered
  1. Allison
    Allison avatar
    11 posts
    Registered:
    13 Jun 2008
    10 Jul 2008
    Link to this post
    When I create a project using mysql I get an error right at the end of the project creation/admin set up saying template data failed to install because packet size was exceeded or something. If I untick the use sample content it then goes to the next stage and I can log into the project. All looks ok but when I go to edit a page and publish it, I get an error saying:

    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() +193
    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) +132
    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) +177
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
    Any idea what is going wrong and how I can fix it? I have tried creating a few databases and a few projects and keep getting this same problem.
    Thanks,
    Allison
  2. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    11 Jul 2008
    Link to this post
    Hi Allison,

    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) 
    BEGIN 
        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; 
    END 


    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) 
    BEGIN 
        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')
         
    END 

    These changes can be made using the MySQL Administrator tool.

    I hope this workaround will be of help. We have updated your telerik points for reporting this issue.
    Let me know if you more assistance is needed.

    All the best,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Allison
    Allison avatar
    11 posts
    Registered:
    13 Jun 2008
    12 Jul 2008
    Link to this post
    Thanks for that - I made those changes you suggested. Now when I go to edit the page I get slightly different errors as below. The first one is when I try to add a generic content control to the home page and the second one when I click on publish to publish any edits I have made to the page. Should I be creating the project from scratch again or should these changes you suggested allow me to continue to work with my existing project and just make the changes I need?

    Column count doesn't match value count at row 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: MySql.Data.MySqlClient.MySqlException: Column count doesn't match value count at row 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:

    [MySqlException (0x80004005): Column count doesn't match value count at row 1]
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +503
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data) +780
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteCommand(StmtContext context, DataRow data) +76
    Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +429
    Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +755
    Nolics.ORMapper.Base.Transaction.Commit() +10
    Telerik.Cms.Data.StagedPage.AddControl(String containerId, ICmsWebControl cmsControl, Int32 ordinal) +338
    Telerik.Cms.Data.StagedPage.AddControl(String containerId, Type type, Int32 ordinal, String controlId) +198
    Telerik.Cms.Data.StagedPage.AddControl(String containerId, Type type, String controlId) +43
    Telerik.Cms.Web.UI.ToolBar.AddContol(String controlName, String zoneId, Int32 ordinal) +305
    Telerik.Cms.Web.UI.Toolbox.Button_Command(Object sender, CommandEventArgs e) +253
    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +105
    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
    System.Web.UI.WebControls.Button.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) +177


    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746


    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() +193
    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) +132
    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) +177
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746




    Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

  4. Allison
    Allison avatar
    11 posts
    Registered:
    13 Jun 2008
    12 Jul 2008
    Link to this post
    I tried creating a new project to see if the changes you suggested would solve the start up problem - no luck, still get the error message.

    Importing template data failed: Packets larger than max_allowed_packet are not allowed.. Check the error log for more details.

    And I cant make any changes to the existing project so now I am really stuck. i really need to get this website finished and live this weekend but I guess I will have to wait a few days for you guys to fix this seeing how it is now Sat mornign my time and friday night your time.


  5. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    14 Jul 2008
    Link to this post
    Hi Allison,

    Actually, we cannot reproduce the new described problems. Most probably they are related to MySQL settings. We got only the first error, which is fixed and we provided a workaround for it.
    Probably, it will take much more time to investigate the new problems.
    Is it possible for you to give us a remote desktop connection (Windows or GoToMeeting)?

    Best wishes,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  6. Allison
    Allison avatar
    11 posts
    Registered:
    13 Jun 2008
    14 Jul 2008
    Link to this post
    Hey Vlad,
    Happy to let you have a look at it if you want to get to the bottom of the issue with mysql.
    I ended up changing my hosting provider's server to a server that support sql express and went back to the original project I had created there and I am currently trying to get that one working. Have a problem with the connection string - are you able to help me with that instead? I desperately  need to get this website up and running.
    When I copy the connection string from my computer and replace the one in the production server's webconfig file I get an error about connecting to the database - we have to set impersonation as false (see below):
    <add name="Sitefinity" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Sitefinity.mdf;providerName="System.Data.SqlClient"; userName="localhost\allison" password="Grosvenor!"/>
       </connectionStrings>
      <system.web>
      <identity impersonate="false"
    My web hosting company say that remote connection to the sql express thing is all ok and permissions are ok, that it is just a problem with the connection string. I have tried putting password and username in there but no luck. Any idea where I am going wrong?
    Thanks,
    Allison

  7. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    15 Jul 2008
    Link to this post
    Hi Allison,

    Most probably the problem is related to the connection string. Are you sure it is correct? Why do you have 'userName' and 'password' attributes in the connectionStrings/add element? Please see the definition of the connectionsStrings element in the web.config here.

    What is the error you are getting?
    Also the account which runs the asp.net worker process should have permissions to the database file.
    Please ask your hosting provider to give you a correct connection string.

    Best wishes,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  8. Allison
    Allison avatar
    11 posts
    Registered:
    13 Jun 2008
    15 Jul 2008
    Link to this post
    Hi Vlad,
    Joe helped me through with this issue last night - so it is now resolved. Thanks for getting back to me. We had to try a few different connection strings before we hit on one that  worked. The hosting server has sql 2005 and sql express so I was able to just upload my sql express database into the same folder as all the other sitefinity project files and link to it. the database didnt have to be attached to their server (we tried that initially). Also had an issue with it not finding nn_next or something but again managed to solve that from another forum post. So all is well for now.
    One minor issue I am feeling a bit frustrated with is that I notice that the way my home page displays keeps changing. I have an event view on there as well as a blog view. I have set the events view to display a summary of 0 characters and the blog post to display a summary of 20 words. I notice that although the settings are still in there on that page, it randomly seems to change to display the entire content of the event, and that triggers the blog view to also display its entire contents. When I edit the page and edit the event view, the settings are still all ok but I just click on save changes and it goes back to displaying only the title of the event and that changes the blog view as well. I don't know why this is happening but it seems pretty random. Any ideas how to fix it?
    Thanks,
    Allison
  9. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    16 Jul 2008
    Link to this post
    Hello Allison,

    This is a known issue that can be resolved easily. Please follow the KB article Settings applied to the Content View based controls are reset.

    Let us know if you have any other questions.

    Greetings,
    Georgi
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
Register for webinar
9 posts, 0 answered