+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / MySql Installation Problems on Production

MySql Installation Problems on Production

2 posts, 0 answered
  1. Ian Johnson
    Ian Johnson avatar
    11 posts
    Registered:
    11 Jan 2006
    28 Jan 2009
    Link to this post
    Hi,

    I created a blank database on my host and then had them import my mysqldump sql file which was done successfully. Web.config has been changed to access the shared hosting database. I now get this error - I checked in phpmyadmin and the table monte_database.sf_cmsvariables definitely exists and contains data.

    Any ideas how to solve this one?

    Table 'monte_database.sf_CmsVariables' doesn't exist

    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: MySql.Data.MySqlClient.MySqlException: Table 'monte_database.sf_CmsVariables' doesn't exist

    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:

    [MySqlException (0x80004005): Table 'monte_database.sf_CmsVariables' doesn't exist]
       MySql.Data.MySqlClient.MySqlStream.OpenPacket() +267
       MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +55
       MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +48
       MySql.Data.MySqlClient.MySqlDataReader.NextResult() +466
       MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +865
       MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
       System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +389
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data) +780
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecutePKQuery(OdbClassInfo classInfo, DataRow pkData) +180
       Nolics.ORMapper.DataProviders.SQLDataProvider.ExecuteKeyQuery(DataSet queries, Boolean fPrimaryKey) +248
       Nolics.ORMapper.DataProviders.SQLDataProvider.QueryByPrimaryKey(DataSet keys) +7
       Nolics.ORMapper.Base.PrimeryKeyQuery.LoadPKQuery() +38
       Nolics.ORMapper.Base.OdbClass.LoadByPrimaryKey(IOdbClass primaryKey, OdbDataProvider provider, ObDataCache cache) +79
       Telerik.Cms.Data.DefaultProvider.SetVariable(String name, String value, Transaction tran, Boolean global) +80
       Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +677
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +663
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +102
       Telerik.ManagerBase`1.SetProvider(String providerName) +201
       Telerik.ManagerBase`1..ctor(String providerName) +86
       Telerik.ManagerBase`1..ctor() +11
       Telerik.Cms.CmsManager..ctor() +5
       Telerik.Cms.Web.UrlHelper..cctor() +521
    
    [TypeInitializationException: The type initializer for 'Telerik.Cms.Web.UrlHelper' threw an exception.]
       Telerik.Cms.Web.CmsHttpModule.Init(HttpApplication context) +101
       System.Web.HttpApplication.InitModulesCommon() +66
       System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1006
       System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +259
       System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +114
       System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +350
    
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    29 Jan 2009
    Link to this post
    Hello Ian Johnson,

    Something is wrong with your database. Could you add the following code snippet to a user control and see if it will return results from your database. Otherwise just run the query.

     
      <asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="SqlDataSource" AllowPaging="true" AutoGenerateRows="true" Visible="true"
        </asp:DetailsView> 
        <asp:sqldatasource id="SqlDataSource"   
                  selectcommand="SELECT * FROM [sf_CmsVariables]" 
                  connectionstring="Data Source=IDIMITROV;Integrated Security=SSPI;initial Catalog=C:\PROGRAM FILES\TELERIK\SITEFINITY3.5\WEBSITES\RADCONTROLSQ3\APP_DATA\SITEFINITY.MDF" 
                  runat="server">           
        </asp:sqldatasource> 

    Let us know about the results.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
2 posts, 0 answered