More in this section

Forums / General Discussions / Invalid object name 'subscription_info'.

Invalid object name 'subscription_info'.

2 posts, 1 answered
  1. Brad
    Brad avatar
    28 posts
    Registered:
    20 Sep 2010
    02 Jun 2011
    Link to this post

    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
      
      
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    07 Jun 2011
    Link to this post
    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 ON
    GO
      
    SETQUOTED_IDENTIFIER ON
    GO
      
    SETANSI_PADDING ON
    GO
      
    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 OFF
    GO


    All the best,
    Ivan Dimitrov
    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
    Answered
2 posts, 1 answered