I'm trying to install Umbraco 7.x.x (latest stable version) on MySQL server that is hosted on binero.se. Using Visual Studio 2013 and the project is 4.5.1 empty web aplication, and installing via Package Manager Consol with the command 'Install-Package UmbracoCms'.
During the installation I get this error message towards the end:
Server Error in '/' 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.]
umbraco.library.GetXmlNodeByXPath(String xpathQuery) +51
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +92
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +155
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +19
UmbracoExamine.LegacyLibrary.GetXmlNodeByXPath(String xpathQuery) +150
UmbracoExamine.DataServices.UmbracoContentService.GetPublishedContentByXPath(String xpath) +42
UmbracoExamine.BaseUmbracoIndexer.GetXDocument(String xPath, String type) +168
UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type) +66
UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type) +1505
UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type) +275
Examine.LuceneEngine.Providers.LuceneIndexer.IndexAll(String type) in x:\Projects\Examine\Examine\Projects\Examine\LuceneEngine\Providers\LuceneIndexer.cs:675
UmbracoExamine.BaseUmbracoIndexer.IndexAll(String type) +54
UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild() +117
Examine.LuceneEngine.Providers.LuceneIndexer.RebuildIndex() in x:\Projects\Examine\Examine\Projects\Examine\LuceneEngine\Providers\LuceneIndexer.cs:630
UmbracoExamine.BaseUmbracoIndexer.RebuildIndex() +48
UmbracoExamine.UmbracoContentIndexer.RebuildIndex() +80
Examine.ExamineManager.LoadProviders() in x:\Projects\Examine\Examine\Projects\Examine\ExamineManager.cs:94
Examine.ExamineManager..ctor() in x:\Projects\Examine\Examine\Projects\Examine\ExamineManager.cs:25
Examine.ExamineManager..cctor() in x:\Projects\Examine\Examine\Projects\Examine\ExamineManager.cs:39
[TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception.]
Examine.ExamineManager.get_Instance() in x:\Projects\Examine\Examine\Projects\Examine\ExamineManager.cs:35
Umbraco.Web.Search.ExamineEvents.ApplicationStarted(UmbracoApplicationBase httpApplication, ApplicationContext applicationContext) +150
Umbraco.Core.ApplicationEventHandler.OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +62
Umbraco.Core.CoreBootManager.b__5(IApplicationEventHandler x) +79
Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable`1 items, Action`1 action) +204
Umbraco.Core.CoreBootManager.Complete(Action`1 afterComplete) +185
Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +74
Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +242
Umbraco.Core.UmbracoApplicationBase.Application_Start(Object sender, EventArgs e) +40
[HttpException (0x80004005): The type initializer for 'Examine.ExamineManager' threw an exception.]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +9916613
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +118
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +336
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296
[HttpException (0x80004005): The type initializer for 'Examine.ExamineManager' threw an exception.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9930508
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +101
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +254
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212
Umbraco still gets install to some level, I can logon and navigate for example. When I'm creating a Document Type I get this error:
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.
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.
If you see the documentation for Umbraco 7. it says SQL CE or MSSQL as the databases, http://our.umbraco.org/documentation/Installation/system-requirements and I think that you should consider to use MSSQL database, especially if you have plans of using some of the Umbraco packages. Some of the packages is only working with an MSSQL database an example could be the e-commerce package for called uCommerce.
I don´t think that the MySQL database has get much attention since the SQLCE database was introduced in Umbraco 4.6, if I remember correctly. So if I was you I would use an MSSQL database, or the build in SQLCE. I have seen lots of post that doesn´t recommend using this on live site. There have been some cases with loss of data in combination with IIS Express see this issue http://issues.umbraco.org/issue/U4-4621 on the issue tracker.
Your problem is most likely due to using MySql with case sensitivity turned on which is not supported. IIRC the installer should warn you about that and/or put error messages in your logs regarding MySql with case sensitivity turned on.
I'll update the docs to indicate that case sensitive queries are not supported. There is a PR to help with supporting case sensitive queries, however there would never be a guarantee that all packages would support that and the legacy APIs will probably still have issues.
Server Error during installation
Hi,
I'm trying to install Umbraco 7.x.x (latest stable version) on MySQL server that is hosted on binero.se.
Using Visual Studio 2013 and the project is 4.5.1 empty web aplication, and installing via Package Manager Consol with the command 'Install-Package UmbracoCms'.
During the installation I get this error message towards the end:
Server Error in '/' 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:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212
Umbraco still gets install to some level, I can logon and navigate for example. When I'm creating a Document Type I get this error:
Server Error in '/' Application.
Table '[Database name.CMSCONTENTTYPEALLOWEDCONTENTTYPE' 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 '[Database name].CMSCONTENTTYPEALLOWEDCONTENTTYPE' 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:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212
Hi Oliver,
If you see the documentation for Umbraco 7. it says SQL CE or MSSQL as the databases, http://our.umbraco.org/documentation/Installation/system-requirements and I think that you should consider to use MSSQL database, especially if you have plans of using some of the Umbraco packages. Some of the packages is only working with an MSSQL database an example could be the e-commerce package for called uCommerce.
I don´t think that the MySQL database has get much attention since the SQLCE database was introduced in Umbraco 4.6, if I remember correctly. So if I was you I would use an MSSQL database, or the build in SQLCE. I have seen lots of post that doesn´t recommend using this on live site. There have been some cases with loss of data in combination with IIS Express see this issue http://issues.umbraco.org/issue/U4-4621 on the issue tracker.
Hope this helps,
/Dennis
Thank you very much, this helps alot! I usually use MSSQL but for some reason I wanted to try MySQL this time.
Your problem is most likely due to using MySql with case sensitivity turned on which is not supported. IIRC the installer should warn you about that and/or put error messages in your logs regarding MySql with case sensitivity turned on.
I'll update the docs to indicate that case sensitive queries are not supported. There is a PR to help with supporting case sensitive queries, however there would never be a guarantee that all packages would support that and the legacy APIs will probably still have issues.
is working on a reply...