procedure or function sf_CmsPageContent_upd has too many arguments specified.Cancel

I recently upgraded a project (so I thought) to 3.7 SP 3. Last week I started to receive the following error message when accessing certain pages:

procedure or function sf_CmsPageContent_upd has too many arguments specified.

After reviewing an earlier thread I checked the database and the incorrect schema number was listed, hinting that the database had not been upgraded. I followed the recommendation and since then everything has been working fine.

Today I have attempted to edit another page of the website and am receiving the error again. In it's entirety it states:

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.

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.

You have not updated your project properly. The dataAccess section of your web.config has not be merged. Currently your project is using the old DataAccess provider Nolics.ORMapper.DataProviders.SQLDataProvider instead of ExtendedSqlServer2005Provider

Kind regards,
Ivan Dimitrov
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

Ok, then check whether you have not connected an earlier version of Sitefinity to the same database which causes upgrade/downgrade each time you access the project . 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. ( How to check your version) . 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.

Kind regards,
Ivan Dimitrov
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

Webinars

Tools

Progress, Telerik, Sitefinity and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries.