Sitefinity with MYSQL DB - Installation problems

Posted by Community Admin on 03-Aug-2018 23:03

Sitefinity with MYSQL DB - Installation problems

Sitefinity - General Discussions

All Replies

Posted by Community Admin on 29-Jun-2011 00:00

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

Posted by Community Admin on 29-Jun-2011 00:00

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


Posted by Community Admin on 04-Jul-2011 00:00

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

This thread is closed