Sitefinity with MYSQL DB - Installation problems
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
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
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