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

Forums / Set-up & Installation / sf_CmsPageContent_upd has too many arguments

sf_CmsPageContent_upd has too many arguments

3 posts, 1 answered
  1. FIMS Computing Services FIMS - UWO
    FIMS Computing Services FIMS - UWO avatar
    9 posts
    Registered:
    16 Dec 2005
    25 May 2010
    Link to this post
    I recently had to resetup our SQL server after a problem and I used the Data Export function to move the data files from a backup server. However I think the backup server was running an earlier version of SiteFinity as I am now getting Stored Procedure errors such as above.  I check the sf_CmsPageContent_upd stored procedure and it does have different arguments between the two servers.

    Is there a script that will allow me to update the StoredProcedures without losing my existing data?  Thanks

    Server Error in '/SiteFinityTest' Application.

    Procedure or function sf_CmsPageContent_upd 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_CmsPageContent_upd 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_CmsPageContent_upd has too many arguments specified.]
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +503
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data) +712
    Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteCommand(StmtContext context, DataRow data) +76
    Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +1091
    Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +909
    Telerik.Cms.Data.StagedPage.CheckOut(Boolean increaseVersion) +385
    Telerik.Cms.Data.StagedPage.CheckOut() +26
    Telerik.Cms.Web.EditPage.OnPreInit(EventArgs e) +1119
    System.Web.UI.Page.PerformPreInit() +31
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282


    Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    26 May 2010
    Link to this post
    Hello FIMS Computing Services FIMS - UWO,

    Thank you for using our services.

    If the database has been used with an earlier version of Sitefinity and you connect it to a website with a later version when you restart the website the application should automatically upgrade the database and its stored procedures in order to match the currently used version. Please make sure that the database you are connected to does not have other Sitefinity websites using older Sitefinity also connected to the database. If this is the case whenever each website is restarted the database will be dongraded/upgraded to match the version of the restarted website.

    You can also go to your database and open the table sf_CmsVariables, there you should see a row with name SchemaVersion and the value should be the same as the build number of your website. For instance if you are using Sitefinity 3.7 SP3 (3.7.2096 build) the value will be 2096. If you reset the value to say 1 and restart the website, when the website is initialized it will upgrade the database to the correct number.

    Best wishes,
    Radoslav Georgiev
    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.
    Answered
  3. FIMS Computing Services FIMS - UWO
    FIMS Computing Services FIMS - UWO avatar
    9 posts
    Registered:
    16 Dec 2005
    26 May 2010
    Link to this post
    Resetting the version number to 1 did the trick.

    Thanks
    Charles
Register for webinar
3 posts, 1 answered