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

Forums / Set-up & Installation / SP1 Upgrade Error

SP1 Upgrade Error

9 posts, 0 answered
  1. Ben Alexandra
    Ben Alexandra avatar
    215 posts
    Registered:
    15 Sep 2012
    03 Jul 2007
    Link to this post
    Hi,

    I went to upgrade to SP1 for one site and got a strange error:



     

    Server Error in '/' Application.

    Incorrect syntax near 's'.
    Unclosed quotation mark after the character string ', ', ', ')'.

    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.Data.SqlClient.SqlException: Incorrect syntax near 's'.
    Unclosed quotation mark after the character string ', ', ', ')'.

    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:

    [SqlException (0x80131904): Incorrect syntax near 's'.
    Unclosed quotation mark after the character string ', ', ', ')'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857194
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734806
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
       System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +380
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
       Telerik.Cms.Data.DefaultProvider.ManualUpgrade() +1522
       Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +680
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +844
       Telerik.ManagerBase`1.InstantiateProviders(ProviderSettingsCollection configProviders, IDictionary`2 providers, Type providerType) +203
       Telerik.ManagerBase`1.Initialize() +873
       Telerik.ManagerBase`1..ctor(String providerName) +42
       Telerik.ManagerBase`1..ctor() +30
       Telerik.Cms.CmsManager..ctor() +24
       Telerik.Cms.Web.UrlHelper..cctor() +892
    
    [TypeInitializationException: The type initializer for 'Telerik.Cms.Web.UrlHelper' threw an exception.]
       Telerik.Cms.Web.CmsHttpModule.BeginRequest(Object sender, EventArgs e) +1561
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
    


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


    I then went on the server that still has the 3.0 code with no SP1 and tried to run the site and got the following error:

     

    Server Error in '/' Application.

    Procedure or function sf_CmsRootPage_ins has too many arguments specified.

    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.Data.SqlClient.SqlException: Procedure or function sf_CmsRootPage_ins has too many arguments specified.

    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:

    [SqlException (0x80131904): Procedure or function sf_CmsRootPage_ins has too many arguments specified.]
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +511
       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) +415
       Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +756
       Nolics.ORMapper.Base.Transaction.Commit() +10
       Telerik.Cms.Data.DefaultProvider.CreateRootPage() +108
       Telerik.Cms.Data.DefaultProvider.GetRootPage() +100
       Telerik.Cms.CmsManager.GetRootPage() +15
       Telerik.Cms.Web.UrlHelper.FillTable(CmsManager man) +99
       Telerik.Cms.Web.UrlHelper..cctor() +680
    
    [TypeInitializationException: The type initializer for 'Telerik.Cms.Web.UrlHelper' threw an exception.]
       Telerik.Cms.Web.CmsHttpModule.BeginRequest(Object sender, EventArgs e) +844
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
    


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


    I then restored the database back to a version from right before I did the upgrade, but even from the 3.0 site I got the same errors. I rebooted the server and then the 3.0 site came up fine.  I then copied the 3.0 SP1 site over to the server and ran it and got the same error message.  I then tried the 3.0 site again and it was killed again, but with a different error:

    When I go to /sitefinity/ in the 3.0 site now I can log in, but once i do I get the error message about "sf_CmsRootPage_ins has too many arguments specified"

    Does SP1 do a database upgrade?  Seems that something in the SP1 is killing the db.

    Any ideas?

    Thanks,

    Ben

  2. Bob
    Bob avatar
    330 posts
    Registered:
    24 Sep 2012
    03 Jul 2007
    Link to this post
    Hello Ben,

    Sorry for the inconvenience. This is a bug in the database upgrade scripts. We will fix it and release new build in a few days.

    You can workaround this problem if it is acceptable for you by replacing all single quotation marks [ ' ] with some other character in table sf_CmsPageBase columns MenuName, Title, Description and Keywords.

    Thank you for reporting this issue. Your Telerik account has been updated.

    Regards,
    Bob
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Ben Alexandra
    Ben Alexandra avatar
    215 posts
    Registered:
    15 Sep 2012
    03 Jul 2007
    Link to this post
    Hi,

    I tried that (no problem), but now I'm getting a different error:

    Thanks for any help

    Ben


     

    Server Error in '/' Application.

    String or binary data would be truncated.
    The statement has been terminated.

    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.Data.SqlClient.SqlException: String or binary data would be truncated.
    The statement has been terminated.

    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:

    [SqlException (0x80131904): String or binary data would be truncated.
    The statement has been terminated.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857194
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734806
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
       System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +380
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
       Telerik.Cms.Data.DefaultProvider.ManualUpgrade() +1522
       Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +680
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +844
       Telerik.ManagerBase`1.InstantiateProviders(ProviderSettingsCollection configProviders, IDictionary`2 providers, Type providerType) +203
       Telerik.ManagerBase`1.Initialize() +873
       Telerik.ManagerBase`1..ctor(String providerName) +42
       Telerik.ManagerBase`1..ctor() +30
       Telerik.Cms.CmsManager..ctor() +24
       Telerik.Cms.Web.UrlHelper..cctor() +892
    
    [TypeInitializationException: The type initializer for 'Telerik.Cms.Web.UrlHelper' threw an exception.]
       Telerik.Cms.Web.CmsHttpModule.BeginRequest(Object sender, EventArgs e) +1561
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
    


    Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
  4. Sean
    Sean avatar
    271 posts
    Registered:
    31 May 2006
    04 Jul 2007
    Link to this post
    For those of you trying to fix the quotation problem, note NOT the truncated string problem, you can run this script when you get the error:

    update sf_CmsPageBase set [description]=replace([description],'''', ''''''where [description] like '%''%' 
    update sf_CmsPageBase set MenuName=replace(MenuName ,'''', ''''''where MenuName like '%''%' 
    update sf_CmsPageBase set Title=replace(Title ,'''', ''''''where Title like '%''%' 
    update sf_CmsPageBase set Keywords =replace(Keywords ,'''', ''''''where Keywords like '%''%' 

    Then load your application again and the upgrade should follow through as expected.

    I had to come up with this quickly because a live server I upgraded had this problem, phew.... talk about working under pressure.  This is why you should test the upgrade with an exact copy of the DB on live :)

    Please note that you should run this script unless you are sure there are quotation mark problems that are being caused by the SP1 upgrade.

    Sean
  5. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    04 Jul 2007
    Link to this post
    Hello Ben,

    Could you please open a new support ticket and send us your project database so that we can help you further?

    Kind regards,
    Rebecca
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  6. Ben Alexandra
    Ben Alexandra avatar
    215 posts
    Registered:
    15 Sep 2012
    06 Jul 2007
    Link to this post
    I've opened a ticket, thanks.

    Any chance you'll release a zip/executable that just has the /bin/ and /sitefinity/ folders?  It's kinda a hassle to uninstall the entire app, reboot and reinstall it just to get those 2 folders.  Maybe there's an easier way, but that seems to be the suggested path.

    Also, there was some mention of some more sophisticated templates/themes being released with Sitefinity.  Is that still planned? 

    I'd also love to see a place where people shared components (UserControls, code, templates, themes, etc.) that they'd written.  Has anyone thought about doing something like that?

    Thanks

    Ben
  7. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    06 Jul 2007
    Link to this post

    Yes, Ben, we agree that the current uninstall/install process can be a real drag. We will provide a zip with the binaries  together with the SP2 next week.

    We will provide the site templates with the September release of Sitefinity. This will be a feature of the Project Manager that will allow you to choose form predefined site templates (themes, pages, controls, etc) when you create a new project. For version 3.2 we are going to extend it and you will be able to export an existing Sitefinity web site  to a template.

    We have thought about this too. There will be a Code Library section soon.

    Best wishes,
    Rebecca
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  8. Kevin Pipher
    Kevin Pipher avatar
    91 posts
    Registered:
    30 Nov 2005
    10 Jul 2007
    Link to this post
    Hi Rebecca,

    Can you confirm when SP2 will be available? I don't see it documented anywhere on the sitefinity website, but you've mentioned it here.

    Will it be possible to directly upgrade from v3 to SP2 without applying anything from SP1?

    Thanks,
    Kevin
  9. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    10 Jul 2007
    Link to this post
    Hello Kevin Pipher,

    SP2 should be out tomorrow or the day after tomorrow.
    Yes, it will be possible to upgrade from version 3.0 to SP2 directly.
    Actually, we would recommend doing so to avoid the upgrade problems with SP1.

    Regards,
    Rebecca
    the Telerik team

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