Forums

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): Deployment > SQL & Sitefinity versions mismatch?

• Cristian Apavaloaiei

  Posted on Nov 24, 2011 (permalink)

  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

  Reply

• Victor Velev Victor Velev

  Posted on Nov 25, 2011 (permalink)

  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

  Reply

• Cristian Apavaloaiei

  Posted on Nov 28, 2011 (permalink)

  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
  

  Reply

• Victor Velev Victor Velev

  Posted on Nov 30, 2011 (permalink)

  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

  Reply

• Cristian Apavaloaiei

  Posted on Dec 2, 2011 (permalink)

  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.
  

  Reply

• Cristian Apavaloaiei

  Posted on Dec 2, 2011 (permalink)

  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.

  Reply

• Victor Velev Victor Velev

  Posted on Dec 5, 2011 (permalink)

  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

  Reply

• Cristian Apavaloaiei

  Posted on Dec 8, 2011 (permalink)

  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

  Reply

• Victor Velev Victor Velev

  Posted on Dec 12, 2011 (permalink)

  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

  Reply

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): Deployment > SQL & Sitefinity versions mismatch?