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

Forums / Deployment / SQL & Sitefinity versions mismatch?

SQL & Sitefinity versions mismatch?

9 posts, 0 answered
  1. Cristian Apavaloaiei
    Cristian Apavaloaiei avatar
    20 posts
    Registered:
    29 Aug 2008
    24 Nov 2011
    Link to this post
    Hello,

    I've recently redeployed a sitefinity 3.7 instalation. I'm now getting an error message when editing a page:


    Exception information:
       Exception type: System.Data.SqlClient.
    SqlException
       Exception message: Procedure or function sf_CmsWebControl_ins has too many arguments specified.

    I'm guessing the problem is that there's a mismatch between the version of the db and the sitefinity instalation. Is there any way in which i can provide you the versions, and if so, will you be able to provide me with a sql statement to update the stored procedure (or preferably, the whole database, without losing data).

    Thank you
  2. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    25 Nov 2011
    Link to this post
    Hello Cristian Apavaloaiei,

    There might be few reasons for the problem.

    - There are two projects with different version connected to the same detabase
    - The web.config is not merged
    - There are changes to the stored procedure sf_CmsPageContent_ins

    What I can suggest you is to open sf_CmsVariables and change the SchemaVersion for instance to 1. Then request the project. Open the database table sf_CmsVariables and check SchemaVersion value. Next time when the error is thrown check SchemaVersion value and if this is different from this one that was set last time then you are making some downgrade and upgrade.

    Can you put the project in VisualStudio and load it through its web server. Try to replicate the issue there using another - local database ( created on the same machine)

    Regards,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Cristian Apavaloaiei
    Cristian Apavaloaiei avatar
    20 posts
    Registered:
    29 Aug 2008
    28 Nov 2011
    Link to this post
    Hello,

    The only instances of sitefinity connecting to the db are my local deployment and the production deployment. When i deployed the production binaries, i deleted the old contents of the website before publishing the new one. If I send you my current sitefinity version and the current stored procedure script, would you be able to provide a sql alter statement that would sync the stored proc with my current sitefinity version?

    Thank you
  4. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    30 Nov 2011
    Link to this post
    Hi Cristian Apavaloaiei,

    What you actually need is to restart your website in order for both versions to match up. For example in your case both the versions of the local and production environments need to match. If you upgrade one of the environments, the other will throw this errors, as the versions are mismatching. After you reset the problematic environment, the scripts will upgrade the system and the error will disappear.

    Regards,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Cristian Apavaloaiei
    Cristian Apavaloaiei avatar
    20 posts
    Registered:
    29 Aug 2008
    02 Dec 2011
    Link to this post
    Hello,

    I've asked my hosting provider to reset the environment as I do not have direct access to the server.
    The website has now been reset but I'm still getting an error while editing pages:

    Exception information:
        Exception type: System.Data.SqlClient.SqlException
        Exception message: Procedure or function sf_CmsWebControl_ins has too many arguments specified.

    Thread information:
        Thread ID: 26
        Thread account name: WEB10\robitero_web
        Is impersonating: False
        Stack trace:    at Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row)
       at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data)
       at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteCommand(StmtContext context, DataRow data)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData)
       at Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess)
       at Telerik.Cms.Data.StagedPage.AddControl(String containerId, ICmsWebControl cmsControl, Int32 ordinal)
       at Telerik.Cms.Data.StagedPage.AddControl(String containerId, Type type, String controlId)
       at Telerik.Cms.Web.UI.ToolBar.AddContol(String controlName, String zoneId, Int32 ordinal)
       at Telerik.Cms.Web.UI.Toolbox.Button_Command(Object sender, CommandEventArgs e)
       at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Please help as this is a blocking issue, and I can no longer update the website with any content since this problem appeared.
  6. Cristian Apavaloaiei
    Cristian Apavaloaiei avatar
    20 posts
    Registered:
    29 Aug 2008
    02 Dec 2011
    Link to this post
    Another thing that I have just noticed is that the old version of the website also is not working anymore (the one that existed before I published this new version). It throws exactly the same error, as I've tried deploying a backup of the website on my local IIS.
  7. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    05 Dec 2011
    Link to this post
    Hi Cristian Apavaloaiei,

    Can you open a ticket and send us your project so we can inspect it locally and diagnose the issue?

    Kind regards,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. Cristian Apavaloaiei
    Cristian Apavaloaiei avatar
    20 posts
    Registered:
    29 Aug 2008
    08 Dec 2011
    Link to this post
    Hello,

    Can you direct me to the correct support ticket section? I cannot find one labeled Sitefinity.
    Also, the max total size of attached files is 20MB, but my Sitefinity DB is 61 MB, while my sitefinity deployment is 160MB.

    Thank you
  9. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    12 Dec 2011
    Link to this post
    Hello Cristian Apavaloaiei,

    I see that you are communicating with a colleague of mine in a support ticket. Please attach the database as well in the ticket so we can take a look at your project locally.

    All the best,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
9 posts, 0 answered