3.7 SP3 -&gt; SP4 - SQL ErrorCancel

I updated my sitefinity install to SP4 a few weeks ago, and it has been working well on my Dev and Pre-Prod environments...

Im now trying to release this new version in Production, with some custom changes I've made...

But i'm getting this error:

Server Error in '/' Application.

Cannot find the object "sf_CmsWebControl" because it does not exist or you do not have permissions.

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:
Cannot find the object "sf_CmsWebControl" because it does not exist or
you do not have permissions.

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.

As I said, it was working in dev and pre-prod environments, there's a few configurations that changed, another database, but since the database was working with the previous version, I dont understand what is going on. The rights for the user are probably less permissive, is it trying to create, modify or drop a table, or something like that ?

The following table - sf_CmsWebControl does not exist in your database ( it has been removed manually or you have not migrated it) or the database user does not have permissions over it.

All the best,
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

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

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

Yes this column is added since Sitefintiy SP4. It looks like you have not upgraded the project properly or it has been upgraded partially. This column IsCategorized should be added the the table. You can create it manually. We added the column to this table to fix an issue with renaming category from backend UI.

Sincerely yours,
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

I upgraded to SP4 with the standard patch, a zip containing some files... I didnt want to reinstall because we have a lot of custom developments. Sitefinity seems to update the database by itself since the new column is in my dev database, where Sitefinity has all the rights needed to alter tables...

Are there others tables that were modified or created ? I have less tables in production...

Do you have a complete update script that I could run myself ?

Or if i give the db user the rights it need to create/alter tables, temporarily, will it work ?

Upgrade the database on your local server where you can work in full trust and then restore a backup to the production or just restore your staging database if there are no changes to the content. We use datalayer that makes all queries and creates the tables and this is why we do not have upgrade scripts.

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.