Support Forum Thread

Home > Support > Forums home > Sitefinity 3.x > Set-up & Installation > msql starting project error

Allison, 7/10/2008 9:38:35 AM

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

, 7/11/2008 11:45:05 AM

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

Allison, 7/11/2008 7:56:57 PM

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.

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

Allison, 7/11/2008 8:20:30 PM

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.

, 7/14/2008 5:16:55 AM

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

Allison, 7/14/2008 5:27:20 AM

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/15/2008 4:54:54 AM

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

Allison, 7/15/2008 5:41:02 AM

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

, 7/16/2008 8:01:55 AM

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

a product by telerik

Sitefinity ASP.NET CMS - Content Management System