More in this section

Forums / General Discussions / Sitefinity with MYSQL DB - Installation problems

Sitefinity with MYSQL DB - Installation problems

3 posts, 0 answered
  1. Madhavan
    Madhavan avatar
    19 posts
    Registered:
    31 Jan 2011
    29 Jun 2011
    Link to this post
    Hi,

      I am trying to install the Sitefinity 4.2 with MYSQL Db and I get this following error. Any Idea on why I am getting this
    error. I am able to see that the securityconfig is created. 

    Server Error in '/sf' Application.

    Object reference not set to an instance of an object.

    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.NullReferenceException: Object reference not set to an instance of an object.

    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: 

    [NullReferenceException: Object reference not set to an instance of an object.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c) +355
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c) +256
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c) +256
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c) +256
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +243
       OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +293
       OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() +60
    
    [DataStoreException: Error executing query: System.NullReferenceException: Object reference not set to an instance of an object.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
       at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
    SQL:
    SELECT COUNT(1) AS  EXPR1                  FROM `sf_roles` a WHERE a.`app_name` = ?                       AND a.`id` = ?                        System.NullReferenceException: Object reference not set to an instance of an object.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.MySqlOrigFactory.MapException(Exception exc, ConnectionImp c)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
       at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()]
       Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +7
       OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.executeQueryAll(ApplicationContext context, ImmutableQueryDetails query, CompiledQuery compiledQuery, QueryParameters parameters, Int32 skip, Int32 take) +296
       OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getAllQueryResults(CompiledQuery cq, QueryParameters parameters, Int32 skip, Int32 take) +32
       OpenAccessRuntime.DataObjects.OpenAccessQueryImp.executeWithArrayImp(Object[] parameters) +611
       OpenAccessRuntime.DataObjects.OpenAccessQueryImp.executeWithArray(Object[] parameters) +211
       Telerik.OpenAccess.RT.QueryResultImpl.check() +56
       Telerik.OpenAccess.RT.QueryResultImpl.GetEnumerator() +18
       Telerik.OpenAccess.RT.QueryResultImpl.System.Collections.IEnumerable.GetEnumerator() +5
       Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuery(Piece`1 piece, Object[] grpVals) +374
       Telerik.OpenAccess.Query.Piece`1.System.Collections.IEnumerable.GetEnumerator() +7
       Telerik.Sitefinity.Data.Linq.LinqQuery`2.System.Collections.IEnumerable.GetEnumerator() +22
       Telerik.Sitefinity.Data.Linq.OpenAccess.OpenAccessQueryProvider`2.Execute(Expression expression) +481
       Telerik.Sitefinity.Data.Linq.OpenAccess.OpenAccessQueryProvider`2.System.Linq.IQueryProvider.Execute(Expression expression) +5
       System.Linq.Queryable.Count(IQueryable`1 source) +243
       Telerik.Sitefinity.Web.UI.Backend.AdministratorPane.EnsureRole(RoleDataProvider roles, RoleInfo role) +366
       Telerik.Sitefinity.Web.UI.Backend.AdministratorPane.DoWork() +56
       Telerik.Sitefinity.Web.UI.Backend.StartupWizard.wizard_FinishButtonClick(Object sender, InternalWizardNavigationEventArgs e) +144
       Telerik.Sitefinity.Web.UI.Backend.InternalWizard.OnFinishButtonClick(InternalWizardNavigationEventArgs e) +96
       Telerik.Sitefinity.Web.UI.Backend.InternalWizard.OnBubbleEvent(Object source, EventArgs e) +539
       System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +125
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +169
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +9
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1


    Thanks
  2. Madhavan
    Madhavan avatar
    19 posts
    Registered:
    31 Jan 2011
    29 Jun 2011
    Link to this post
    I deleted the all the config files except the project it seemed to work fine. I finally got this error message. everytime I try to login I am getting this error.

    Server Error in '/sf' Application.

    Additional non-parsable characters are at the end of the string.

    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.FormatException: Additional non-parsable characters are at the end of the string.

    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: 

    [FormatException: Additional non-parsable characters are at the end of the string.]
       DynamicModule.ns.Wrapped_OpenAccessMembershipProvider_a8ba07938ab64387bb2fa41820a606ae.ValidateUser(String userName, String password) +220
       Telerik.Sitefinity.Security.UserManager.ValidateUser(String userName, String password) +28
       Telerik.Sitefinity.Security.SecurityManager.AuthenticateUser(String membershipProviderName, String userName, String password, Boolean persistent, User& user) +68
       Telerik.Sitefinity.Security.Web.UI.LoginForm.LoginForm_Authenticate(Object sender, AuthenticateEventArgs e) +130
       System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +115
       System.Web.UI.WebControls.Login.AttemptLogin() +127
       System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
       System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +125
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +169
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +9
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1



  3. Garo
    Garo avatar
    4 posts
    Registered:
    24 Sep 2012
    04 Jul 2011
    Link to this post
    Hello Madhavan,
    Would you be so kind to send us your MySQL database and config files in order to investigate the issue? For your convenience, you can follow the following article explaining fast and easy MySQL dumping, published at http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/ .

    All the best,
    Garo
    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
3 posts, 0 answered