Those passwords you've posted are WITH legacy encoding, the modern passwords don't look like that and are longer.
you cannot just reset a password to a known hash when useLegacyEncoding="false" for a websites. You should definitely not set this to true for new sites the old hashing isn't very secure these days.
Do this:
Revert your settings back to what they were originally, i assume this means: useLegacyEncoding="false" and Hashed
Ensure that your users are not locked, out as Daniel suggests, check your user table for userNoConsole or userDisabled you won't be able to log in if either of those are true ... this could just be your problem
You can then do either:
Use the Forgot password feature on the login screen - you'll need smtp configured for that
Do a password reset trick:
Clear the value in your web.config umbracoConfigurationStatus
Remove your connection strings
Change the password in your DB for user 0 to default
Go to the site, it will show the normal installer
Enter a username/password
Go to advanced and fill out your DB connection information exactly as you had it before
Proceed with the install, this will reset user 0's password to the one you entered
Shannon I am trying your method , but stil i have error
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions.
NB: I have granted all permission to umbraco user but still shit !!! damn , umbraco why why they complicate like this ? its localhost , can they implement a simple method to reset user forgotten password?
I am trying your method using reset trick , I still get error
The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
NB: I have full permission in database for the user!
shutDownStack= w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
w System.Environment.getStackTrace()
w System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
w System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()
w System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
w System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e)
w System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e)
w System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)
w System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e)
w System.Web.DirectoryMonitor.FireNotifications()
w System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
w System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state)
w System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state)
w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
w System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
w System.Threading.ThreadPoolWorkQueue.Dispatch()
w System.Threading.ThreadPoolWaitCallback.PerformWaitCallback()
2018-03-01 17:02:47,237 [P5688/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001
2018-03-01 17:02:47,259 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk
2018-03-01 17:02:47,274 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 14ms)
2018-03-01 17:02:47,362 [P5688/D2/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom...
2018-03-01 17:02:47,364 [P5688/D2/T1] INFO Umbraco.Core.MainDom - Acquired MainDom.
2018-03-01 17:02:47,367 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:02:47,850 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 483ms)
2018-03-01 17:02:47,850 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler
2018-03-01 17:02:47,854 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 3ms)
2018-03-01 17:02:47,881 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:02:47,882 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:02:47,882 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2018-03-01 17:02:47,885 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 3ms)
2018-03-01 17:02:47,886 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:02:47,887 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:02:47,887 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter
2018-03-01 17:02:47,894 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 7ms)
2018-03-01 17:02:47,911 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:02:47,911 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:02:47,912 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController
2018-03-01 17:02:47,920 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 8ms)
2018-03-01 17:02:47,921 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:02:47,921 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:02:47,922 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController
2018-03-01 17:02:47,929 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 7ms)
2018-03-01 17:02:49,807 [P5688/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2649ms)
2018-03-01 17:02:50,131 [P5688/D2/T10] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request)
2018-03-01 17:05:16,251 [P5688/D2/T17] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions
2018-03-01 17:05:16,320 [P5688/D2/T17] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 69ms)
2018-03-01 17:05:16,370 [P5688/D2/T10] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseConfigure
2018-03-01 17:05:16,404 [P5688/D2/T10] INFO Umbraco.Core.DatabaseContext - Configured a new ConnectionString using the 'System.Data.SqlClient' provider.
2018-03-01 17:05:16,409 [P5688/D2/T10] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 39ms)
2018-03-01 17:05:16,563 [P5688/D2/T17] INFO Umbraco.Core.MainDom - Stopping...
2018-03-01 17:05:16,564 [P5688/D2/T17] INFO Umbraco.Core.MainDom - Released MainDom.
2018-03-01 17:05:19,661 [P5688/D3/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001
2018-03-01 17:05:19,683 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk
2018-03-01 17:05:19,699 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 15ms)
2018-03-01 17:05:19,745 [P5688/D3/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom...
2018-03-01 17:05:19,747 [P5688/D3/T1] INFO Umbraco.Core.MainDom - Acquired MainDom.
2018-03-01 17:05:19,750 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:20,455 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 704ms)
2018-03-01 17:05:20,455 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler
2018-03-01 17:05:20,457 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms)
2018-03-01 17:05:20,552 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms)
2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter
2018-03-01 17:05:20,556 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 1ms)
2018-03-01 17:05:20,572 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:20,572 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:20,573 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController
2018-03-01 17:05:20,573 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms)
2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController
2018-03-01 17:05:20,575 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 0ms)
2018-03-01 17:05:22,293 [P5688/D3/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2747ms)
2018-03-01 17:05:28,455 [P5688/D3/T11] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request)
2018-03-01 17:05:30,340 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall
2018-03-01 17:05:30,343 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database configuration status: Started
2018-03-01 17:05:30,348 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database requires upgrade
2018-03-01 17:05:30,349 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 9ms)
2018-03-01 17:05:30,551 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade
2018-03-01 17:05:30,553 [P5688/D3/T11] INFO Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service
2018-03-01 17:05:30,557 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database upgrade started
2018-03-01 17:05:30,575 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:30,575 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:30,576 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving [Umbraco.Core.Persistence.Mappers.MapperForAttribute]Umbraco.Core.Persistence.Mappers.BaseMapper
2018-03-01 17:05:30,596 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved [Umbraco.Core.Persistence.Mappers.MapperForAttribute]Umbraco.Core.Persistence.Mappers.BaseMapper (took 20ms)
2018-03-01 17:05:30,967 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
2018-03-01 17:05:30,969 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable
2018-03-01 17:05:30,970 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms)
2018-03-01 17:05:30,970 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.Persistence.Migrations.IMigration
2018-03-01 17:05:30,985 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.Persistence.Migrations.IMigration (took 14ms)
2018-03-01 17:05:31,019 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
2018-03-01 17:05:31,020 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
2018-03-01 17:05:31,068 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AdditionalIndexesAndKeys' to context
2018-03-01 17:05:31,071 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ChangePasswordColumn' to context
2018-03-01 17:05:31,073 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddChangeDocumentTypePermission' to context
2018-03-01 17:05:31,073 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateToNewMemberPropertyAliases' to context
2018-03-01 17:05:31,092 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AlterDataTypePreValueTable' to context
2018-03-01 17:05:31,189 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMissingForeignKeyForContentType' to context
2018-03-01 17:05:31,206 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveCmsDocumentAliasColumn' to context
2018-03-01 17:05:31,217 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context
2018-03-01 17:05:31,226 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context
2018-03-01 17:05:31,251 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context
2018-03-01 17:05:31,269 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context
2018-03-01 17:05:31,277 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context
2018-03-01 17:05:31,295 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context
2018-03-01 17:05:31,307 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context
2018-03-01 17:05:31,315 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context
2018-03-01 17:05:31,337 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context
2018-03-01 17:05:31,360 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context
2018-03-01 17:05:31,367 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context
2018-03-01 17:05:31,390 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context
2018-03-01 17:05:31,398 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context
2018-03-01 17:05:31,417 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context
2018-03-01 17:05:31,447 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context
2018-03-01 17:05:31,461 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context
2018-03-01 17:05:31,514 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context
2018-03-01 17:05:31,565 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context
2018-03-01 17:05:31,580 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserLanguagesToIsoCode' to context
2018-03-01 17:05:31,583 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureMigrationsTableIdentityIsCorrect' to context
2018-03-01 17:05:31,601 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context
2018-03-01 17:05:31,617 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context
2018-03-01 17:05:31,931 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context
2018-03-01 17:05:31,964 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context
2018-03-01 17:05:31,981 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context
2018-03-01 17:05:32,000 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context
2018-03-01 17:05:32,001 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTablesAgain' to context
2018-03-01 17:05:32,022 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIndexOnCmsPropertyData' to context
2018-03-01 17:05:32,023 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRedirectUrlTable' to context
2018-03-01 17:05:32,024 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateAllowedMediaTypesAtRoot' to context
2018-03-01 17:05:32,034 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexesToUmbracoRelationTables' to context
2018-03-01 17:05:32,047 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToUmbracoNodePath' to context
2018-03-01 17:05:32,072 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToUser2NodePermission' to context
2018-03-01 17:05:32,091 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeUniqueIdColumn' to context
2018-03-01 17:05:32,110 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMacroUniqueIdColumn' to context
2018-03-01 17:05:32,110 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'NormalizeTemplateGuids' to context
2018-03-01 17:05:32,123 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIndexOnCmsPropertyData' to context
2018-03-01 17:05:32,134 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoDeployTables' to context
2018-03-01 17:05:32,135 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ReduceLoginNameColumnsSize' to context
2018-03-01 17:05:32,135 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToCmsMemberLoginName' to context
2018-03-01 17:05:32,141 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddLockTable' to context
2018-03-01 17:05:32,143 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddLockObjects' to context
2018-03-01 17:05:32,164 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserTables' to context
2018-03-01 17:05:32,227 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserGroupTables' to context
2018-03-01 17:05:32,262 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserStartNodeTable' to context
2018-03-01 17:05:32,277 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ReduceDictionaryKeyColumnsSize' to context
2018-03-01 17:05:32,278 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToDictionaryKeyColumn' to context
2018-03-01 17:05:32,279 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTemplatePermissions' to context
2018-03-01 17:05:32,291 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: CREATE CLUSTERED INDEX [IXumbracoUserLoginsIndex] ON [umbracoUserLogins] ([contextID])
2018-03-01 17:05:32,613 [P5688/D3/T11] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (f3e8e571).
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions.
w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
w System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
w System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
w System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
w System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
w System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
w System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
w StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() w c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:wiersz 266
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
w Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
w Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
ClientConnectionId:e0f0d41e-b620-4adc-84be-23b3a945e282
Error Number:1088,State:12,Class:16
2018-03-01 17:05:32,740 [P5688/D3/T11] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions.
w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
w System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
w System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
w System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
w System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
w System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
w System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
w StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() w c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:wiersz 266
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0()
w Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy)
w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command)
w Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
w Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
w Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
w Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
w Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
ClientConnectionId:e0f0d41e-b620-4adc-84be-23b3a945e282
Error Number:1088,State:12,Class:16
2018-03-01 17:05:32,745 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary:
The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
FKcmsContentcmsContentTypenodeId,FKcmsContentVersioncmsContentnodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentTypecmsContentTypenodeId,FKcmsDocumentTypecmsTemplatenodeId,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextcmsDictionaryid,FKcmsMemberTypecmsContentTypenodeId,FKcmsMembercmsContentnodeId,FKcmsContentXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyTypeGroupcmsContentTypenodeId,FKcmsPropertyTypecmsDataTypenodeId,FKcmsPropertyTypecmsContentTypenodeId,FKcmsTagRelationshipcmsContent,FKcmsContentTypeAllowedContentTypecmsContentType,FKcmsContentTypeAllowedContentTypecmsContentType1,FKumbracoRedirectUrlumbracoNodeuniqueID,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXcmsDictionarykey,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroUniqueId,IXcmsMacroPropertyAlias,IXcmsMacroPropertyUniquePropertyId,IXcmsMacroPropertyAlias,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoRedirectUrl,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUser2NodePermissionnodeId,IXumbracoUserStartNode_startNodeType
2018-03-01 17:05:32,800 [P5688/D3/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Obiekt docelowy wywołania zgłosił wyjątek. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
w Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- Koniec śladu stosu wyjątków wewnętrznych ---
w System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
w System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
w System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
w Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
2018-03-01 17:05:32,827 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2275ms)
2018-03-01 17:05:32,827 [P5688/D3/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Obiekt docelowy wywołania zgłosił wyjątek. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions.
Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
w Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
--- Koniec śladu stosu wyjątków wewnętrznych ---
w System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
w System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
w System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
w Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
w Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
2018-03-01 17:05:46,656 [P5688/D2/T11] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
shutDownStack= w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
w System.Environment.getStackTrace()
w System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
w System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()
w System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
w System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e)
w System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e)
w System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)
w System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e)
w System.Web.DirectoryMonitor.FireNotifications()
w System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
w System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state)
w System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state)
w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
w System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
w System.Threading.ThreadPoolWorkQueue.Dispatch()
w System.Threading.ThreadPoolWaitCallback.PerformWaitCallback()
You'll need to allow it to change the password so modify this line in your webconfig to add the allowManuallyChangingPassword to the UsersMembershipProvider
Your username will now be Admin and the password Admin1234!
Just to check you added the allowManuallyChangingPassword attribute flag to the UsersMembershipProvider and didn't just changed the existing on the UmbracoMembershipProvider to true?
I've lost count of the number of times I've tried to log in using my username after Umbraco changed the setting so you had to use your email address instead.
Geofrey - have you tried to upgrade an existing instance that failed and now you're logged out?
Can you explain what you did and what went wrong. Looking at that error log it looks like you tried to run an upgrade and didn't have the right DB permissions. It's now done half of the DB changes and is complaining that umbracoUserLogins table has been deleted when it tries to apply changes from the beginning of the upgrade again.
Just to prove the theory manually create the table it's complaining about (which has been removed since 7.3) and see if we get a different error.
CREATE TABLE [dbo].[umbracoUserLogins](
[contextID] [uniqueidentifier] NOT NULL,
[userID] [int] NOT NULL,
[timeout] [bigint] NOT NULL
) ON [PRIMARY]
I can't login to umbraco back office
I've tried resetting the password via the database using this command :
and these values -
also changed the following in proces:
NB:
I am using localhost server
All didn't work.
Any help would be appreciated.
Thanks
Hi Geofrey
Is database connection working? Can you check the log also?
/Alex
Hii
Bro everything works perfectly if the connection wasn't working I couldn't manage to get login page to Umbraco cms right?
I tried everything but nothing those method provided in Umbraco forums for resetting Umbraco user password ain't working in new version of Umbraco,
Please if anyone knows or have some friends who work at Umbraco can you ask them to help me out on this?
NOTE: Those methods above works only on older versions of Umbraco
I'm on my phone, so can't confirm, but I believe you need to set the
userNoConsole
(or similar) column to 0 tooObviously backup your database before running any queries
Those passwords you've posted are WITH legacy encoding, the modern passwords don't look like that and are longer.
you cannot just reset a password to a known hash when
useLegacyEncoding="false"
for a websites. You should definitely not set this to true for new sites the old hashing isn't very secure these days.Do this:
useLegacyEncoding="false"
andHashed
userNoConsole
oruserDisabled
you won't be able to log in if either of those are true ... this could just be your problemumbracoConfigurationStatus
default
Hii
Shannon I am trying your method , but stil i have error
NB: I have granted all permission to umbraco user but still shit !!! damn , umbraco why why they complicate like this ? its localhost , can they implement a simple method to reset user forgotten password?
Hii,
I am trying your method using reset trick , I still get error
NB: I have full permission in database for the user!
2018-03-01 16:39:09,274 [P6412/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 16:39:09,304 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 16:39:09,327 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 22ms) 2018-03-01 16:39:09,445 [P6412/D2/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 16:39:09,447 [P6412/D2/T1] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 16:39:09,450 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:10,045 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 594ms) 2018-03-01 16:39:10,045 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 16:39:10,059 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 13ms) 2018-03-01 16:39:10,087 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:10,088 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:10,088 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 16:39:10,095 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 6ms) 2018-03-01 16:39:10,096 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:10,096 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:10,097 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 16:39:10,100 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 3ms) 2018-03-01 16:39:10,115 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:10,116 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:10,116 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 16:39:10,118 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 2ms) 2018-03-01 16:39:10,119 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:10,120 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:10,120 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 16:39:10,123 [P6412/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 2ms) 2018-03-01 16:39:12,335 [P6412/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 3146ms) 2018-03-01 16:39:15,731 [P6412/D2/T11] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 16:39:24,599 [P6412/D2/T9] INFO Umbraco.Core.Configuration.ClientDependencyConfiguration - Updated version number from 1521748705 to 1796440500 2018-03-01 16:39:24,610 [P6412/D2/T11] INFO Umbraco.Core.MainDom - Stopping... 2018-03-01 16:39:24,611 [P6412/D2/T11] INFO Umbraco.Core.MainDom - Released MainDom. 2018-03-01 16:39:27,674 [P6412/D3/T18] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 16:39:27,705 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 16:39:27,723 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Hash determined (took 18ms) 2018-03-01 16:39:27,772 [P6412/D3/T18] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 16:39:27,774 [P6412/D3/T18] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 16:39:27,777 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:28,431 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 653ms) 2018-03-01 16:39:28,431 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 16:39:28,433 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms) 2018-03-01 16:39:28,519 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:28,520 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:28,520 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 16:39:28,521 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms) 2018-03-01 16:39:28,521 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:28,522 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:28,522 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 16:39:28,523 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 1ms) 2018-03-01 16:39:28,541 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:28,541 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:28,541 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 16:39:28,542 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms) 2018-03-01 16:39:28,543 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:28,543 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:28,543 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 16:39:28,544 [P6412/D3/T18] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 1ms) 2018-03-01 16:39:30,341 [P6412/D3/T18] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2805ms) 2018-03-01 16:39:36,578 [P6412/D3/T12] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 16:39:41,122 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:41,122 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:41,123 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController 2018-03-01 16:39:41,138 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController (took 15ms) 2018-03-01 16:39:41,735 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:41,735 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:41,738 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IAction 2018-03-01 16:39:41,749 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IAction (took 11ms) 2018-03-01 16:39:42,123 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:39:42,123 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:39:42,124 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IParameterEditor 2018-03-01 16:39:42,126 [P6412/D3/T12] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IParameterEditor (took 2ms) 2018-03-01 16:39:54,776 [P6412/D2/T16] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
_shutDownMessage=CONFIG change HostingEnvironment initiated shutdown CONFIG change Element HostingEnvironment spowodował zamknięcie
shutDownStack= w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) w System.Environment.getStackTrace() w System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal() w System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand() w System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace) w System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e) w System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e) w System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname) w System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e) w System.Web.DirectoryMonitor.FireNotifications() w System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback) w System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state) w System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state) w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() w System.Threading.ThreadPoolWorkQueue.Dispatch() w System.Threading.ThreadPoolWaitCallback.PerformWaitCallback() 2018-03-01 16:40:54,552 [P6412/D3/T12] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username [email protected] from IP address ::1 2018-03-01 16:41:00,735 [P6412/D3/T16] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username [email protected] from IP address ::1 2018-03-01 16:41:01,966 [P6412/D3/T12] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username [email protected] from IP address ::1 2018-03-01 16:41:07,082 [P6412/D3/T21] INFO Umbraco.Core.Security.BackOfficeSignInManager - Event Id: 0, state: Login attempt failed for username [email protected] from IP address ::1 2018-03-01 16:49:19,812 [P11416/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 16:49:19,883 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 16:49:19,948 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 65ms) 2018-03-01 16:49:20,140 [P11416/D2/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 16:49:20,142 [P11416/D2/T1] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 16:49:20,144 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:22,830 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 2686ms) 2018-03-01 16:49:22,831 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 16:49:22,840 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 9ms) 2018-03-01 16:49:23,067 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:23,070 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 2ms) 2018-03-01 16:49:23,070 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 16:49:23,079 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 8ms) 2018-03-01 16:49:23,080 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:23,080 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:23,081 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 16:49:23,090 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 9ms) 2018-03-01 16:49:23,110 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:23,110 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:23,110 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 16:49:23,121 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 10ms) 2018-03-01 16:49:23,123 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:23,123 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:23,124 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 16:49:23,132 [P11416/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 8ms) 2018-03-01 16:49:27,147 [P11416/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 7459ms) 2018-03-01 16:49:30,526 [P11416/D2/T9] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 16:49:37,297 [P11416/D2/T11] INFO Umbraco.Core.Configuration.ClientDependencyConfiguration - Updated version number from 1796440500 to 28458025 2018-03-01 16:49:37,527 [P11416/D2/T12] INFO Umbraco.Core.MainDom - Stopping... 2018-03-01 16:49:37,528 [P11416/D2/T12] INFO Umbraco.Core.MainDom - Released MainDom. 2018-03-01 16:49:43,275 [P11416/D2/T11] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:43,275 [P11416/D2/T11] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:43,275 [P11416/D2/T11] INFO Umbraco.Core.PluginManager - Resolving [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController 2018-03-01 16:49:43,288 [P11416/D2/T11] INFO Umbraco.Core.PluginManager - Resolved [Umbraco.Web.Trees.TreeAttribute]Umbraco.Web.Trees.TreeController (took 12ms) 2018-03-01 16:49:48,789 [P11416/D3/T17] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 16:49:48,814 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 16:49:48,830 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Hash determined (took 16ms) 2018-03-01 16:49:48,896 [P11416/D3/T17] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 16:49:48,898 [P11416/D3/T17] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 16:49:48,900 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:49,823 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 921ms) 2018-03-01 16:49:49,823 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 16:49:49,825 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms) 2018-03-01 16:49:49,974 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:49,975 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:49,975 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 16:49:49,975 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms) 2018-03-01 16:49:49,976 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:49,977 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:49,977 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 16:49:49,979 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 2ms) 2018-03-01 16:49:50,018 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:50,019 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:50,019 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 16:49:50,019 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms) 2018-03-01 16:49:50,020 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:49:50,021 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:49:50,021 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 16:49:50,022 [P11416/D3/T17] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 1ms) 2018-03-01 16:49:52,715 [P11416/D3/T17] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 4149ms) 2018-03-01 16:50:03,419 [P11416/D3/T15] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 16:50:04,705 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:50:04,705 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:50:04,706 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IAction 2018-03-01 16:50:04,718 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IAction (took 12ms) 2018-03-01 16:50:05,206 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 16:50:05,206 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 16:50:05,206 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IParameterEditor 2018-03-01 16:50:05,214 [P11416/D3/T15] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IParameterEditor (took 8ms) 2018-03-01 16:50:08,509 [P11416/D2/T12] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
_shutDownMessage=CONFIG change HostingEnvironment initiated shutdown CONFIG change Element HostingEnvironment spowodował zamknięcie
shutDownStack= w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) w System.Environment.getStackTrace() w System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal() w System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand() w System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace) w System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e) w System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e) w System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname) w System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e) w System.Web.DirectoryMonitor.FireNotifications() w System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback) w System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state) w System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state) w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() w System.Threading.ThreadPoolWorkQueue.Dispatch() w System.Threading.ThreadPoolWaitCallback.PerformWaitCallback() 2018-03-01 17:02:47,237 [P5688/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 17:02:47,259 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 17:02:47,274 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 14ms) 2018-03-01 17:02:47,362 [P5688/D2/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 17:02:47,364 [P5688/D2/T1] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 17:02:47,367 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:02:47,850 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 483ms) 2018-03-01 17:02:47,850 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 17:02:47,854 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 3ms) 2018-03-01 17:02:47,881 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:02:47,882 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:02:47,882 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 17:02:47,885 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 3ms) 2018-03-01 17:02:47,886 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:02:47,887 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:02:47,887 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 17:02:47,894 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 7ms) 2018-03-01 17:02:47,911 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:02:47,911 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:02:47,912 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 17:02:47,920 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 8ms) 2018-03-01 17:02:47,921 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:02:47,921 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:02:47,922 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 17:02:47,929 [P5688/D2/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 7ms) 2018-03-01 17:02:49,807 [P5688/D2/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2649ms) 2018-03-01 17:02:50,131 [P5688/D2/T10] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 17:05:16,251 [P5688/D2/T17] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions 2018-03-01 17:05:16,320 [P5688/D2/T17] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 69ms) 2018-03-01 17:05:16,370 [P5688/D2/T10] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseConfigure 2018-03-01 17:05:16,404 [P5688/D2/T10] INFO Umbraco.Core.DatabaseContext - Configured a new ConnectionString using the 'System.Data.SqlClient' provider. 2018-03-01 17:05:16,409 [P5688/D2/T10] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 39ms) 2018-03-01 17:05:16,563 [P5688/D2/T17] INFO Umbraco.Core.MainDom - Stopping... 2018-03-01 17:05:16,564 [P5688/D2/T17] INFO Umbraco.Core.MainDom - Released MainDom. 2018-03-01 17:05:19,661 [P5688/D3/T1] INFO Umbraco.Core.CoreBootManager - Umbraco 7.7.6 application starting on EB-PL0001 2018-03-01 17:05:19,683 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Determining hash of code files on disk 2018-03-01 17:05:19,699 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Hash determined (took 15ms) 2018-03-01 17:05:19,745 [P5688/D3/T1] INFO Umbraco.Core.MainDom - Acquiring MainDom... 2018-03-01 17:05:19,747 [P5688/D3/T1] INFO Umbraco.Core.MainDom - Acquired MainDom. 2018-03-01 17:05:19,750 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:20,455 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 704ms) 2018-03-01 17:05:20,455 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IApplicationStartupHandler 2018-03-01 17:05:20,457 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IApplicationStartupHandler (took 1ms) 2018-03-01 17:05:20,552 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter 2018-03-01 17:05:20,553 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter (took 0ms) 2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:20,554 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.PropertyEditors.IPropertyValueConverter 2018-03-01 17:05:20,556 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.PropertyEditors.IPropertyValueConverter (took 1ms) 2018-03-01 17:05:20,572 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:20,572 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:20,573 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.Mvc.SurfaceController 2018-03-01 17:05:20,573 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.Mvc.SurfaceController (took 0ms) 2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:20,574 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Web.WebApi.UmbracoApiController 2018-03-01 17:05:20,575 [P5688/D3/T1] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Web.WebApi.UmbracoApiController (took 0ms) 2018-03-01 17:05:22,293 [P5688/D3/T1] INFO Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 2747ms) 2018-03-01 17:05:28,455 [P5688/D3/T11] INFO Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://localhost:52081/umbraco (UmbracoModule request) 2018-03-01 17:05:30,340 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall 2018-03-01 17:05:30,343 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database configuration status: Started 2018-03-01 17:05:30,348 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database requires upgrade 2018-03-01 17:05:30,349 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 9ms) 2018-03-01 17:05:30,551 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade 2018-03-01 17:05:30,553 [P5688/D3/T11] INFO Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service 2018-03-01 17:05:30,557 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - Database upgrade started 2018-03-01 17:05:30,575 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:30,575 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:30,576 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving [Umbraco.Core.Persistence.Mappers.MapperForAttribute]Umbraco.Core.Persistence.Mappers.BaseMapper 2018-03-01 17:05:30,596 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved [Umbraco.Core.Persistence.Mappers.MapperForAttribute]Umbraco.Core.Persistence.Mappers.BaseMapper (took 20ms) 2018-03-01 17:05:30,967 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations 2018-03-01 17:05:30,969 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving umbraco.interfaces.IDiscoverable 2018-03-01 17:05:30,970 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved umbraco.interfaces.IDiscoverable (took 0ms) 2018-03-01 17:05:30,970 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolving Umbraco.Core.Persistence.Migrations.IMigration 2018-03-01 17:05:30,985 [P5688/D3/T11] INFO Umbraco.Core.PluginManager - Resolved Umbraco.Core.Persistence.Migrations.IMigration (took 14ms) 2018-03-01 17:05:31,019 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context 2018-03-01 17:05:31,020 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context 2018-03-01 17:05:31,068 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AdditionalIndexesAndKeys' to context 2018-03-01 17:05:31,071 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ChangePasswordColumn' to context 2018-03-01 17:05:31,073 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddChangeDocumentTypePermission' to context 2018-03-01 17:05:31,073 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateToNewMemberPropertyAliases' to context 2018-03-01 17:05:31,092 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AlterDataTypePreValueTable' to context 2018-03-01 17:05:31,189 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMissingForeignKeyForContentType' to context 2018-03-01 17:05:31,206 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveCmsDocumentAliasColumn' to context 2018-03-01 17:05:31,217 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context 2018-03-01 17:05:31,226 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context 2018-03-01 17:05:31,251 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context 2018-03-01 17:05:31,269 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context 2018-03-01 17:05:31,277 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context 2018-03-01 17:05:31,295 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context 2018-03-01 17:05:31,307 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context 2018-03-01 17:05:31,315 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context 2018-03-01 17:05:31,337 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context 2018-03-01 17:05:31,360 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context 2018-03-01 17:05:31,367 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context 2018-03-01 17:05:31,390 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context 2018-03-01 17:05:31,398 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context 2018-03-01 17:05:31,417 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context 2018-03-01 17:05:31,447 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context 2018-03-01 17:05:31,461 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context 2018-03-01 17:05:31,514 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context 2018-03-01 17:05:31,565 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context 2018-03-01 17:05:31,580 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserLanguagesToIsoCode' to context 2018-03-01 17:05:31,583 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureMigrationsTableIdentityIsCorrect' to context 2018-03-01 17:05:31,601 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context 2018-03-01 17:05:31,617 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context 2018-03-01 17:05:31,931 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context 2018-03-01 17:05:31,964 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context 2018-03-01 17:05:31,981 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context 2018-03-01 17:05:32,000 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context 2018-03-01 17:05:32,001 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTablesAgain' to context 2018-03-01 17:05:32,022 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIndexOnCmsPropertyData' to context 2018-03-01 17:05:32,023 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRedirectUrlTable' to context 2018-03-01 17:05:32,024 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateAllowedMediaTypesAtRoot' to context 2018-03-01 17:05:32,034 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexesToUmbracoRelationTables' to context 2018-03-01 17:05:32,047 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToUmbracoNodePath' to context 2018-03-01 17:05:32,072 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToUser2NodePermission' to context 2018-03-01 17:05:32,091 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeUniqueIdColumn' to context 2018-03-01 17:05:32,110 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMacroUniqueIdColumn' to context 2018-03-01 17:05:32,110 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'NormalizeTemplateGuids' to context 2018-03-01 17:05:32,123 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIndexOnCmsPropertyData' to context 2018-03-01 17:05:32,134 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoDeployTables' to context 2018-03-01 17:05:32,135 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ReduceLoginNameColumnsSize' to context 2018-03-01 17:05:32,135 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToCmsMemberLoginName' to context 2018-03-01 17:05:32,141 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddLockTable' to context 2018-03-01 17:05:32,143 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddLockObjects' to context 2018-03-01 17:05:32,164 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserTables' to context 2018-03-01 17:05:32,227 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserGroupTables' to context 2018-03-01 17:05:32,262 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserStartNodeTable' to context 2018-03-01 17:05:32,277 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'ReduceDictionaryKeyColumnsSize' to context 2018-03-01 17:05:32,278 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddIndexToDictionaryKeyColumn' to context 2018-03-01 17:05:32,279 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTemplatePermissions' to context 2018-03-01 17:05:32,291 [P5688/D3/T11] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: CREATE CLUSTERED INDEX [IXumbracoUserLoginsIndex] ON [umbracoUserLogins] ([contextID])
2018-03-01 17:05:32,613 [P5688/D3/T11] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (f3e8e571). System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions. w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) w System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) w System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) w System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) w System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) w System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) w System.Data.SqlClient.SqlCommand.ExecuteNonQuery() w StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() w c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:wiersz 266 w Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() w Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func
1 func) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) w Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) ClientConnectionId:e0f0d41e-b620-4adc-84be-23b3a945e282 Error Number:1088,State:12,Class:16 2018-03-01 17:05:32,740 [P5688/D3/T11] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions. w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) w System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) w System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) w System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) w System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) w System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) w System.Data.SqlClient.SqlCommand.ExecuteNonQuery() w StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() w c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:wiersz 266 w Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() w Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func
1 func) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) w Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) w Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) w Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) w Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) w Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade) w Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) ClientConnectionId:e0f0d41e-b620-4adc-84be-23b3a945e282 Error Number:1088,State:12,Class:16 2018-03-01 17:05:32,745 [P5688/D3/T11] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FKcmsContentcmsContentTypenodeId,FKcmsContentVersioncmsContentnodeId,FKcmsDocumentcmsContentnodeId,FKcmsDocumentcmsTemplatenodeId,FKcmsDocumentTypecmsContentTypenodeId,FKcmsDocumentTypecmsTemplatenodeId,FKcmsDataTypePreValuescmsDataTypenodeId,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextcmsDictionaryid,FKcmsMemberTypecmsContentTypenodeId,FKcmsMembercmsContentnodeId,FKcmsContentXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentnodeId,FKcmsPreviewXmlcmsContentVersionVersionId,FKcmsPropertyTypeGroupcmsContentTypenodeId,FKcmsPropertyTypecmsDataTypenodeId,FKcmsPropertyTypecmsContentTypenodeId,FKcmsTagRelationshipcmsContent,FKcmsContentTypeAllowedContentTypecmsContentType,FKcmsContentTypeAllowedContentTypecmsContentType1,FKumbracoRedirectUrlumbracoNodeuniqueID,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXcmsDictionarykey,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroUniqueId,IXcmsMacroPropertyAlias,IXcmsMacroPropertyUniquePropertyId,IXcmsMacroPropertyAlias,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoRedirectUrl,IXumbracoUserGroupuserGroupAlias,IXumbracoUserGroupuserGroupName,IXumbracoUser2NodePermissionnodeId,IXumbracoUserStartNode_startNodeType2018-03-01 17:05:32,800 [P5688/D3/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Obiekt docelowy wywołania zgłosił wyjątek. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') w Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- Koniec śladu stosu wyjątków wewnętrznych --- w System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) w System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) w System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) w Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) 2018-03-01 17:05:32,827 [P5688/D3/T11] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2275ms) 2018-03-01 17:05:32,827 [P5688/D3/T11] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Obiekt docelowy wywołania zgłosił wyjątek. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot find the object "umbracoUserLogins" because it does not exist or you do not have permissions. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') w Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- Koniec śladu stosu wyjątków wewnętrznych --- w System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) w System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) w System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) w Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) w Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel) 2018-03-01 17:05:46,656 [P5688/D2/T11] INFO Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
_shutDownMessage=CONFIG change HostingEnvironment initiated shutdown CONFIG change Element HostingEnvironment spowodował zamknięcie
shutDownStack= w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) w System.Environment.getStackTrace() w System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal() w System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand() w System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace) w System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e) w System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e) w System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname) w System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e) w System.Web.DirectoryMonitor.FireNotifications() w System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback) w System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state) w System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state) w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) w System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() w System.Threading.ThreadPoolWorkQueue.Dispatch() w System.Threading.ThreadPoolWaitCallback.PerformWaitCallback()
Hi,
As an alternative.. (as I bothered to just test this and Shannon posted before me and certainly more right!)
Put your webconfig back how it was then: Download https://our.umbraco.org/projects/developer-tools/umbraco-admin-reset/ and drop the dll in your bin folder.
You'll need to allow it to change the password so modify this line in your webconfig to add the allowManuallyChangingPassword to the UsersMembershipProvider
Your username will now be Admin and the password Admin1234!
Remember to change the web.config back.
Hii Steve Morgan
I started with your simple and short cut method out there but unfortunatelly this does not work in new version of umbraco 7.7.6
Thanks for your help though, now am checking Shannon method
Hi,
I downloaded 7.7.6 and tested it so you've probably not set back your web.config settings.
Might be worth doing a diff against a vanilla blank download if Shannon's tips don't work.
Steve
I did check here:
Just to check you added the allowManuallyChangingPassword attribute flag to the UsersMembershipProvider and didn't just changed the existing on the UmbracoMembershipProvider to true?
Yep
And here is data base nothing is changed !
You are using the email address and not the username (worth a shot).
what do you mean?
I've lost count of the number of times I've tried to log in using my username after Umbraco changed the setting so you had to use your email address instead.
Geofrey - have you tried to upgrade an existing instance that failed and now you're logged out?
Can you explain what you did and what went wrong. Looking at that error log it looks like you tried to run an upgrade and didn't have the right DB permissions. It's now done half of the DB changes and is complaining that umbracoUserLogins table has been deleted when it tries to apply changes from the beginning of the upgrade again.
Just to prove the theory manually create the table it's complaining about (which has been removed since 7.3) and see if we get a different error.
CREATE TABLE [dbo].[umbracoUserLogins]( [contextID] [uniqueidentifier] NOT NULL, [userID] [int] NOT NULL, [timeout] [bigint] NOT NULL ) ON [PRIMARY]
is working on a reply...