Hi Wade

Have you checked the logfile on the server in /App_Data/Logs to see if some more detail is provided?

Sounds like there is a permission issue somewhere - I'd probably try to get in touch with the hosting provider to make sure everything is setup correctly on the server. Some weird error might have happened.

What database are you using btw?

/Jan

Its a SQL CE database. I've never had this problem before. It wasn't working on my localhost, and then I found these posts:

[https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/59695-Error-On-Publishing-Pages][1]

[https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/58112-Cant-publish-due-to-MySqlWebv20?p=0][2]

Which says that I should uninstall the MySQL WebProviders. I did that and it started working again on my localhost. Then I uploaded it and got the same error. I've contacted my host about changing the permissions but it hasn't happened yet.

at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)
   at Umbraco.Core.PluginManager.CreateInstances[T](IEnumerable`1 types, Boolean throwException)
2016-02-18 12:36:11,523 [34] INFO  umbraco.BusinessLogic.Log - [Thread 73] Log scrubbed.  Removed all items older than 2015-12-20 12:36:11
2016-02-18 12:36:11,523 [34] INFO  Umbraco.Core.UmbracoApplicationBase - [Thread 73] Application shutdown. Reason: ConfigurationChange
2016-02-18 12:45:48,671 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Determining hash of code files on disk
2016-02-18 12:45:48,671 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Hash determined (took 4ms)
2016-02-18 12:45:48,686 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
2016-02-18 12:45:48,702 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 35 (took 19ms)
2016-02-18 12:45:48,780 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2016-02-18 12:45:48,780 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2016-02-18 12:45:48,780 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
2016-02-18 12:45:48,780 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 14 (took 0ms)
2016-02-18 12:45:48,800 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Web.Mvc.SurfaceController
2016-02-18 12:45:48,801 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 4 (took 0ms)
2016-02-18 12:45:48,801 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
2016-02-18 12:45:48,803 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 34 (took 2ms)
2016-02-18 12:45:48,807 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
2016-02-18 12:45:48,808 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 0ms)
2016-02-18 12:45:48,808 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
2016-02-18 12:45:48,808 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2016-02-18 12:45:49,220 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Web.Trees.TreeController
2016-02-18 12:45:49,220 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Trees.TreeController, found 5 (took 0ms)
2016-02-18 12:45:49,236 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of umbraco.interfaces.ITree
2016-02-18 12:45:49,236 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.ITree, found 19 (took 0ms)
2016-02-18 12:45:49,236 [9] INFO  Umbraco.Web.Search.ExamineEvents - [Thread 1] Initializing Examine and binding to business logic events
2016-02-18 12:45:49,706 [9] INFO  Umbraco.Web.Search.ExamineEvents - [Thread 1] Adding examine event handlers for index providers: 3
2016-02-18 12:45:49,722 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of umbraco.interfaces.IApplication
2016-02-18 12:45:49,722 [9] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplication, found 7 (took 0ms)
2016-02-18 12:45:52,969 [9] ERROR Umbraco.Core.PluginManager - [Thread 1] Error creating type umbraco.presentation.nodeFactory.UmbracoSiteMapProviderAccessUpdate
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Configuration.ConfigurationErrorsException: Authentication to host '' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'d1.65.01a8.ip4.static.sl-reverse.com' (using password: NO) (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 284) ---> MySql.Data.MySqlClient.MySqlException: Authentication to host '' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'d1.65.01a8.ip4.static.sl-reverse.com' (using password: NO) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user ''@'d1.65.01a8.ip4.static.sl-reverse.com' (using password: NO)
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at MySql.Web.Common.SchemaManager.GetSchemaVersion(String connectionString)
   at MySql.Web.Common.SchemaManager.CheckSchema(String connectionString, NameValueCollection config)
   at MySql.Web.SiteMap.MySqlSiteMapProvider.Initialize(String name, NameValueCollection config)
   at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
   --- End of inner exception stack trace ---
   at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
   at System.Web.Configuration.ProvidersHelper.InstantiateProviders(ProviderSettingsCollection configProviders, ProviderCollection providers, Type providerType)
   at System.Web.Configuration.SiteMapSection.get_ProvidersInternal()
   at System.Web.SiteMap.Initialize()
   at System.Web.SiteMap.get_Provider()
   at umbraco.presentation.nodeFactory.UmbracoSiteMapProviderAccessUpdate..ctor()
   --- End of inner exception stack trace ---

  [1]: https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/59695-Error-On-Publishing-Pages
  [2]: https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/58112-Cant-publish-due-to-MySqlWebv20?p=0

Could it be a problem with the machine.config? System.Configuration.ConfigurationErrorsException: Authentication to host '' for user '' using method 'mysqlnativepassword' failed with message: Access denied for user ''@'d1.65.01a8.ip4.static.sl-reverse.com' (using password: NO) (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 284) --->

Thanks for the responses guys. Sebastiaan, sorry this didn't change anything. Is MySqlSiteMapProvider the same as the Web Providers under Connector/Net in MySQL?

The host tells me all permissions are set to full now too and the error is still occurring.

I don't really know what any of these things are but I know that everybody else who's added the <remove /> from above had this exact error disappear for them. :-) I would double and triple check that it's in the web.config on your hosting provider's end and if it is, ask your hosting provider if they can add it to their machine.config or whatever higher config file that they enforce on you.

If you do a google search for UmbracoSiteMapProviderAccessUpdate you'll see that the only two solutions we've seen so far is: uninstall the MySql connector or add this to your web.config. :)

Thanks Sebastiaan.

I've double and triple checked and it's definitely there. This was originally there:

<add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" />

So I tried with it in and with taking it out but it hasn't worked. I've contacted the host and asked them to remove it from the machine.config too. I'll wait to hear back from them I guess!

Sorry guys,

I double checked.... but I hadn't tripled checked! I had the providers part of the code not sitting inside the sitemap part. Been looking at it for too long and overlooked it. Thank you Sebastiaan. Genius!

I found this line in the system.web section:

<sessionState mode="InProc" customProvider="DefaultSessionProvider">
      <providers>
        <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" />
      </providers>
    </sessionState>

And entered this immediately underneath it, and it now works!

<siteMap>
  <providers>
    <remove name="MySqlSiteMapProvider" />
  </providers>
</siteMap>

Once again thank you!

is working on a reply...