Invalid object name 'subscription_info'.
Hey all,
Getting a strange error this time - everytime I try to hit our site, we're getting (or trying to be) redirected to the /Sitefinity/Licensing area, even though our Standard license is still applied.
The only changes we made were that we added a project to our solution for a simple formselector dialog area on our Events. Error below: Unfortunately it's not giving us much to work with, and we're not sure why all of a sudden this may have changed?
Any help is greatly appreciated!
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: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'subscription_info'. 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: Invalid object name 'subscription_info'.] Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql) +519 OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache) +1316 [MetadataException: HighLow Key Generator failure for class 'Telerik.Sitefinity.Newsletters.Model.SubscriptionInfo': Could not find the required table [subscription_info] or its primary key column [subscription_info_id]. Please check the configuration and do not forget to update the database.] DynamicModule.ns.Wrapped_OpenAccessPageProvider_c352cacc87fa4ab7a2b1c22ca97b43a0.Initialize(String providerName, NameValueCollection config, Type managerType) +405 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +2211 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74 Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +214 Telerik.Sitefinity.Modules.Pages.PageManager..ctor() +52 Telerik.Sitefinity.Modules.Pages.PageManager..cctor() +41 [TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Modules.Pages.PageManager' threw an exception.] Telerik.Sitefinity.Modules.Pages.PageManager.GetManager() +0 Telerik.Sitefinity.Web.UI.ControlUtilities.GetControlTemplate(String key, Expression`1 predicate) +35 Telerik.Sitefinity.Web.UI.ControlUtilities.GetTemplate(TemplateInfo info) +773 Telerik.Sitefinity.Web.RouteHandlerBase.GetHttpHandler(RequestContext requestContext) +88 System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +11340424 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +266 Hi Brad,
Please try upgrading your project to the latest official release.
Please check whether you have the following table in your database
[sf_subscription_info]
If not you could try to recreate it with the following code
USE [YOUR_DB_NAME]GO SETANSI_NULLS ONGO SETQUOTED_IDENTIFIER ONGO SETANSI_PADDING ONGO CREATETABLE[dbo].[sf_subscription_info]( [sf_subscription_info_id] [int] NOTNULL, [subscription_list_id] [uniqueidentifier] NULL, [subscription_date] [datetime] NOTNULL, [id2] [uniqueidentifier] NULL, [last_modified] [datetime] NOTNULL, [id] [uniqueidentifier] NULL, [application_name] [varchar](255) NULL, [voa_version] [smallint] NOTNULL, CONSTRAINT[pk_sf_subscription_info] PRIMARYKEYCLUSTERED ( [sf_subscription_info_id] ASC)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY]) ON[PRIMARY] GO SETANSI_PADDING OFFGO