Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tony Lorentzen 79 posts 158 karma points
    Jul 15, 2016 @ 19:29
    Tony Lorentzen
    0

    Error after upgrade from 7.2.6 to 7.4.3

    Seems like I always have issues when upgrading my Umbraco installations for clients... Urgh :-( I've done all the version specific upgrades and followed the steps to update config files, but after finishing the upgrade I get this error:

    Update error

    Any ideas? I'm running it on a Windows Server 2012 R2 using SQL Server CE on the installation.

    Help! :-)

  • Tony Lorentzen 79 posts 158 karma points
    Jul 15, 2016 @ 19:37
    Tony Lorentzen
    0

    The error I'm getting in the EventLog is:

    Type validation failed. The value type: 'DateTime' does not match the > DataType in PropertyType with alias: 'producedFromDate'

  • Tony Lorentzen 79 posts 158 karma points
    Jul 15, 2016 @ 22:04
    Tony Lorentzen
    0

    Here's an excerpt from the UmbracoTraceLog:

     2016-07-15 18:53:42,593 [P10792/D5/T1] INFO  Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on SRVWEB
     2016-07-15 18:53:42,686 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Determining hash of code files on disk
     2016-07-15 18:53:42,700 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Hash determined (took 15ms)
     2016-07-15 18:53:42,818 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
     2016-07-15 18:53:42,839 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 21ms)
     2016-07-15 18:53:42,880 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
     2016-07-15 18:53:42,882 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 2ms)
     2016-07-15 18:53:42,883 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
     2016-07-15 18:53:42,884 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 1ms)
     2016-07-15 18:53:42,908 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
     2016-07-15 18:53:42,909 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
     2016-07-15 18:53:42,909 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
     2016-07-15 18:53:42,913 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 3ms)
     2016-07-15 18:53:42,962 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
     2016-07-15 18:53:42,963 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 0ms)
     2016-07-15 18:53:42,963 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
     2016-07-15 18:53:42,964 [P10792/D5/T1] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms)
     2016-07-15 18:53:46,601 [P10792/D5/T1] INFO  Umbraco.Core.CoreBootManager - Umbraco application startup complete (took 4436ms)
     2016-07-15 18:53:49,562 [P10792/D5/T57] INFO  Umbraco.Core.Sync.ApplicationUrlHelper - ApplicationUrl: http://beta.mysitedomain.dk:80/umbraco (UmbracoModule request)
     2016-07-15 18:54:01,881 [P10792/D5/T59] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Permissions
     2016-07-15 18:54:01,905 [P10792/D5/T59] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 23ms)
     2016-07-15 18:54:01,969 [P10792/D5/T50] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: Upgrade
     2016-07-15 18:54:01,970 [P10792/D5/T50] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 0ms)
     2016-07-15 18:54:02,011 [P10792/D5/T52] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseInstall
     2016-07-15 18:54:02,028 [P10792/D5/T52] INFO  Umbraco.Core.DatabaseContext - Database configuration status: Started
     2016-07-15 18:54:02,032 [P10792/D5/T52] INFO  Umbraco.Core.DatabaseContext - Database requires upgrade
     2016-07-15 18:54:02,033 [P10792/D5/T52] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 21ms)
     2016-07-15 18:54:02,056 [P10792/D5/T55] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade
     2016-07-15 18:54:02,063 [P10792/D5/T55] INFO  Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service
     2016-07-15 18:54:02,076 [P10792/D5/T55] INFO  Umbraco.Core.DatabaseContext - Database upgrade started
     2016-07-15 18:54:02,109 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Mappers.BaseMapper
     2016-07-15 18:54:02,111 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Mappers.BaseMapper, found 0 (took 1ms)
     2016-07-15 18:54:02,625 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
     2016-07-15 18:54:02,628 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Persistence.Migrations.IMigration
     2016-07-15 18:54:02,630 [P10792/D5/T55] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Persistence.Migrations.IMigration, found 0 (took 2ms)
     2016-07-15 18:54:02,755 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context
     2016-07-15 18:54:02,787 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context
     2016-07-15 18:54:02,862 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context
     2016-07-15 18:54:02,916 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context
     2016-07-15 18:54:02,943 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context
     2016-07-15 18:54:03,001 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context
     2016-07-15 18:54:03,054 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context
     2016-07-15 18:54:03,077 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context
     2016-07-15 18:54:03,126 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context
     2016-07-15 18:54:03,173 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context
     2016-07-15 18:54:03,190 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context
     2016-07-15 18:54:03,233 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context
     2016-07-15 18:54:03,250 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context
     2016-07-15 18:54:03,293 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context
     2016-07-15 18:54:03,369 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context
     2016-07-15 18:54:03,404 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context
     2016-07-15 18:54:03,459 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context
     2016-07-15 18:54:03,487 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context
     2016-07-15 18:54:03,506 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserLanguagesToIsoCode' to context
     2016-07-15 18:54:03,508 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureMigrationsTableIdentityIsCorrect' to context
     2016-07-15 18:54:03,539 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context
     2016-07-15 18:54:03,570 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context
     2016-07-15 18:54:03,605 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context
     2016-07-15 18:54:03,621 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context
     2016-07-15 18:54:03,651 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context
     2016-07-15 18:54:03,665 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context
     2016-07-15 18:54:03,686 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 2: DELETE FROM [umbracoMigration] WHERE 1 = 1
    
     2016-07-15 18:54:03,709 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: UPDATE [umbracoNode] SET [uniqueID] = 'd96f6272-7598-8bad-e91c-37fa1d18af87' WHERE [id] = 1044
    
     2016-07-15 18:54:03,710 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 5: UPDATE [umbracoNode] SET [uniqueID] = 'e7242b78-ed06-2d23-5649-0602dc83036a' WHERE [id] = 2003
    
     2016-07-15 18:54:03,711 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 6: UPDATE [umbracoNode] SET [uniqueID] = 'd8cf185c-392f-591a-6100-c1d9d9963817' WHERE [id] = 1031
    
     2016-07-15 18:54:03,711 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 7: UPDATE [umbracoNode] SET [uniqueID] = '16bc0049-e8f5-d321-6c76-3dfbb1367a2d' WHERE [id] = 1032
    
     2016-07-15 18:54:03,712 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 8: UPDATE [umbracoNode] SET [uniqueID] = '34599b89-f7f5-1535-66e0-c6fd0ea11880' WHERE [id] = 1033
    
     2016-07-15 18:54:03,712 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: UPDATE [umbracoNode] SET [uniqueID] = 'cacc31a9-5416-0a6f-ed9c-17aec8c35e20' WHERE [id] = 1420
    
     2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 10: UPDATE [umbracoNode] SET [uniqueID] = 'd758b615-fd3c-693b-7e5a-a65f374e3628' WHERE [id] = 1421
    
     2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 11: UPDATE [umbracoNode] SET [uniqueID] = '54ef81ba-af55-f832-1528-954d451331e5' WHERE [id] = 2548
    
     2016-07-15 18:54:03,713 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 12: UPDATE [umbracoNode] SET [uniqueID] = '205fd936-d956-4a30-691c-ca1dac51d2bd' WHERE [id] = 2552
    
     2016-07-15 18:54:03,714 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 13: UPDATE [umbracoNode] SET [uniqueID] = '341ad732-b802-ec51-7576-cde0b1c9d44e' WHERE [id] = 2569
    
     2016-07-15 18:54:03,714 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 14: UPDATE [umbracoNode] SET [uniqueID] = '2c461702-de8a-5413-8aa4-0a2cafe01960' WHERE [id] = 1051
    
     2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 15: UPDATE [umbracoNode] SET [uniqueID] = 'f47d11f3-2266-ca30-379b-c5002f63a962' WHERE [id] = 1053
    
     2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 16: UPDATE [umbracoNode] SET [uniqueID] = 'aee5ce48-d999-f45c-6dc5-5e435d3b5ee4' WHERE [id] = 1055
    
     2016-07-15 18:54:03,715 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 17: UPDATE [umbracoNode] SET [uniqueID] = 'b78c1159-b060-dbbf-fa88-e996e499d69d' WHERE [id] = 1064
    
     2016-07-15 18:54:03,716 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 18: UPDATE [umbracoNode] SET [uniqueID] = '65f3b6b6-9467-c010-c0cf-1e851b039e1c' WHERE [id] = 1066
    
     2016-07-15 18:54:03,716 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 19: UPDATE [umbracoNode] SET [uniqueID] = '3bd332dd-c821-8a02-6971-4874c889c232' WHERE [id] = 1444
    
     2016-07-15 18:54:03,717 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 20: UPDATE [umbracoNode] SET [uniqueID] = 'c22f3edd-4402-0492-755a-f002f672ce67' WHERE [id] = 1451
    
     2016-07-15 18:54:03,717 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 21: UPDATE [umbracoNode] SET [uniqueID] = '22ad3c40-920c-b047-2b2f-5f503020ed0b' WHERE [id] = 1992
    
     2016-07-15 18:54:03,718 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 22: UPDATE [umbracoNode] SET [uniqueID] = '9613608b-571b-fd7e-2861-c23484710bf7' WHERE [id] = 2095
    
     2016-07-15 18:54:03,718 [P10792/D5/T55] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 23: UPDATE [umbracoNode] SET [uniqueID] = '36afc3c0-26cd-5919-815c-6b227fc4c593' WHERE [id] = 2178
    
     2016-07-15 18:54:03,893 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\animate.min.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\animate.min.css.bak before being migrated to new format
     2016-07-15 18:54:03,895 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\blue.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\blue.css.bak before being migrated to new format
     2016-07-15 18:54:03,897 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\bootstrap.min.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\bootstrap.min.css.bak before being migrated to new format
     2016-07-15 18:54:03,899 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\custom.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\custom.css.bak before being migrated to new format
     2016-07-15 18:54:03,900 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\gray.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\gray.css.bak before being migrated to new format
     2016-07-15 18:54:03,902 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\green.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\green.css.bak before being migrated to new format
     2016-07-15 18:54:03,904 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\main.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\main.css.bak before being migrated to new format
     2016-07-15 18:54:03,906 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\navy.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\navy.css.bak before being migrated to new format
     2016-07-15 18:54:03,908 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\orange.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\orange.css.bak before being migrated to new format
     2016-07-15 18:54:03,910 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\owl.carousel.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\owl.carousel.css.bak before being migrated to new format
     2016-07-15 18:54:03,912 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\owl.transitions.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\owl.transitions.css.bak before being migrated to new format
     2016-07-15 18:54:03,913 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\pink.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\pink.css.bak before being migrated to new format
     2016-07-15 18:54:03,915 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\purple.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\purple.css.bak before being migrated to new format
     2016-07-15 18:54:03,917 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\red.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\red.css.bak before being migrated to new format
     2016-07-15 18:54:03,919 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\twentytwenty.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\twentytwenty.css.bak before being migrated to new format
     2016-07-15 18:54:03,920 [P10792/D5/T55] INFO  Umbraco.Web.Strategies.Migrations.OverwriteStylesheetFilesFromTempFiles - CSS file is being backed up from C:\WebsitesPreprod\mysitedomain.dk\css\XSLTsearch.css, to C:\WebsitesPreprod\mysitedomain.dk\App_Data\TEMP\CssMigration\XSLTsearch.css.bak before being migrated to new format
     2016-07-15 18:54:03,945 [P10792/D5/T55] INFO  Umbraco.Core.DatabaseContext - Database configuration status: <p>Upgrade completed!</p>
     2016-07-15 18:54:03,951 [P10792/D5/T55] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 1896ms)
     2016-07-15 18:54:03,961 [P10792/D5/T60] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: UmbracoVersion
     2016-07-15 18:54:04,007 [P10792/D5/T60] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.ICacheRefresher
     2016-07-15 18:54:04,009 [P10792/D5/T60] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 0 (took 2ms)
     2016-07-15 18:54:04,091 [P10792/D5/T60] INFO  umbraco.content - Load Xml from file...
     2016-07-15 18:54:04,132 [P10792/D5/T60] INFO  umbraco.content - Loaded Xml from file.
     2016-07-15 18:54:04,195 [P10792/D5/T60] INFO  umbraco.content - Loading content from database...
     2016-07-15 18:54:06,005 [P10792/D5/T60] INFO  Umbraco.Core.Configuration.ClientDependencyConfiguration - Updated version number from 1418882887 to 1456837871
     2016-07-15 18:54:06,394 [P10792/D5/T60] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 2433ms)
     2016-07-15 18:54:06,618 [P10792/D5/T52] ERROR UmbracoExamine.DataServices.UmbracoLogService - Provider=ExternalIndexer, NodeId=-1
    System.Exception: Cannot index queue items, the index doesn't exist!,, IndexSet: ExternalIndexSet
     2016-07-15 18:54:06,692 [P10792/D5/T63] INFO  umbraco.content - Save Xml to file...
     2016-07-15 18:54:06,837 [P10792/D5/T68] INFO  umbraco.content - Saved Xml to file.
     2016-07-15 18:54:07,569 [P10792/D6/T65] INFO  Umbraco.Core.CoreBootManager - Umbraco 7.4.3 application starting on SRVWEB
     2016-07-15 18:54:07,735 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Determining hash of code files on disk
     2016-07-15 18:54:07,767 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Hash determined (took 31ms)
     2016-07-15 18:54:07,964 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
     2016-07-15 18:54:08,010 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 0 (took 45ms)
     2016-07-15 18:54:08,091 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
     2016-07-15 18:54:08,095 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 4ms)
     2016-07-15 18:54:08,096 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
     2016-07-15 18:54:08,098 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 0 (took 1ms)
     2016-07-15 18:54:08,150 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.Mvc.SurfaceController
     2016-07-15 18:54:08,153 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 2ms)
     2016-07-15 18:54:08,154 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
     2016-07-15 18:54:08,165 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 0 (took 11ms)
     2016-07-15 18:54:08,296 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
     2016-07-15 18:54:08,298 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 0 (took 1ms)
     2016-07-15 18:54:08,298 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
     2016-07-15 18:54:08,299 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 0 (took 0ms)
     2016-07-15 18:54:11,655 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
     2016-07-15 18:54:12,752 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
     2016-07-15 18:54:12,780 [P10792/D6/T65] INFO  Umbraco.Core.DatabaseContext - CanConnect = True
     2016-07-15 18:54:12,833 [P10792/D6/T65] WARN  Umbraco.Core.Sync.DatabaseServerMessenger - No last synced Id found, this generally means this is a new server/install. The server will build its caches and indexes, and then adjust its last synced Id to the latest found in the database and maintain cache updates based on that Id.
     2016-07-15 18:54:12,904 [P10792/D6/T65] INFO  umbraco.content - Load Xml from file...
     2016-07-15 18:54:12,943 [P10792/D6/T65] INFO  umbraco.content - Loaded Xml from file.
     2016-07-15 18:54:13,011 [P10792/D6/T65] INFO  umbraco.content - Loading content from database...
     2016-07-15 18:54:17,079 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Starting resolution types of Umbraco.Core.PropertyEditors.IParameterEditor
     2016-07-15 18:54:17,083 [P10792/D6/T65] INFO  Umbraco.Core.PluginManager - Completed resolution of types of Umbraco.Core.PropertyEditors.IParameterEditor, found 0 (took 4ms)
     2016-07-15 18:54:18,049 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=2559
     2016-07-15 18:54:18,106 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=2559
     2016-07-15 18:54:18,511 [P10792/D6/T59] INFO  UmbracoExamine.DataServices.UmbracoLogService - Field "email" is listed multiple times in the index set "InternalMemberIndexSet". Please ensure all names are unique, Provider=InternalMemberIndexer, NodeId=1415
     2016-07-15 18:54:19,304 [P10792/D6/T66] INFO  umbraco.content - Save Xml to file...
     2016-07-15 18:54:19,335 [P10792/D6/T55] INFO  umbraco.content - Saved Xml to file.
     2016-07-15 18:54:28,811 [P10792/D6/T65] ERROR Umbraco.Core.CoreBootManager - An error occurred running OnApplicationStarted for handler Umbraco.Web.BatchedDatabaseServerMessengerStartup
    System.Exception: Type validation failed. The value type: 'DateTime' does not match the DataType in PropertyType with alias: 'producedFromDate'
       at Umbraco.Core.Models.Property.set_Value(Object value)
       at Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(PropertyDataDto[] dtos)
       at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPropertyCollection(Sql docSql, IEnumerable`1 documentDefs)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sql)
       at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPagedResultsByQuery[TDto,TContentBase](IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple`2 nodeIdSelect, Func`2 processQuery, String orderBy, Direction orderDirection, Func`1 defaultFilter)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, String filter)
       at Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter)
       at UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type)
       at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
       at Umbraco.Web.WebBootManager.<InitializeResolvers>b__f()
       at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize()
       at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
       at Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x)
     2016-07-15 18:54:28,818 [P10792/D6/T65] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
    System.Exception: Type validation failed. The value type: 'DateTime' does not match the DataType in PropertyType with alias: 'producedFromDate'
       at Umbraco.Core.Models.Property.set_Value(Object value)
       at Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(PropertyDataDto[] dtos)
       at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPropertyCollection(Sql docSql, IEnumerable`1 documentDefs)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sql)
       at Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPagedResultsByQuery[TDto,TContentBase](IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple`2 nodeIdSelect, Func`2 processQuery, String orderBy, Direction orderDirection, Func`1 defaultFilter)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery`1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, String filter)
       at Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter)
       at UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type)
       at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
       at Umbraco.Web.WebBootManager.<InitializeResolvers>b__f()
       at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize()
       at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
       at Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x)
       at Umbraco.Core.EnumerableExtensions.ForEach[TItem](IEnumerable`1 items, Action`1 action)
       at Umbraco.Core.CoreBootManager.Complete(Action`1 afterComplete)
       at Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete)
       at Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e)
     2016-07-15 18:54:36,903 [P10792/D5/T52] INFO  Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: ConfigurationChange
    
    _shutDownMessage=CONFIG change
    HostingEnvironment initiated shutdown
    CONFIG change
    CONFIG change
    CONFIG change
    CONFIG change
    HostingEnvironment caused shutdown
    
    _shutDownStack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
       at System.Environment.get_StackTrace()
       at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
       at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
       at System.Web.HttpRuntime.OnConfigChange(String message)
       at System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)
       at System.Web.DirectoryMonitor.FireNotifications()
       at System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
       at System.Threading.ThreadPoolWorkQueue.Dispatch()
     2016-07-15 18:54:38,884 [P10792/D6/T50] ERROR UmbracoExamine.DataServices.UmbracoLogService - Provider=ExternalIndexer, NodeId=-1
    System.Exception: Cannot index queue items, the index doesn't exist!,, IndexSet: ExternalIndexSet
     2016-07-15 18:55:08,952 [P10792/D6/T45] INFO  Umbraco.Core.UmbracoApplicationBase - Application shutdown. Details: InitializationError
    
    _shutDownMessage=Initialization Error
    HostingEnvironment initiated shutdown
    HostingEnvironment caused shutdown
    
    _shutDownStack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
       at System.Environment.get_StackTrace()
       at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()
       at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)
       at System.Web.HttpRuntime.AppDomainShutdownTimerCallback(Object state)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.TimerQueueTimer.CallCallback()
       at System.Threading.TimerQueueTimer.Fire()
       at System.Threading.TimerQueue.FireNextTimers()
    
  • Dennis Aaen 4491 posts 18156 karma points admin hq c-trib
    Jul 16, 2016 @ 07:52
    Dennis Aaen
    0

    Hi Tony,

    You said that you have done all the version specific upgrades and followed the steps to update config files.

    Did you remember to copy over the folders:

    Bin

    Umbraco

    Umbraco_Client from the new fresh 7.4.3 installation https://our.umbraco.org/documentation/Getting-Started/Setup/Upgrading/general

    Also remember to merge the global.aspx and web.config file.

    Hope this helps,

    /Dennis

  • Sebastiaan Janssen 4988 posts 15101 karma points MVP admin hq
    Jul 16, 2016 @ 08:41
    Sebastiaan Janssen
    0

    I get a few results when I Google for Type validation failed. The value type: 'DateTime' does not match the > DataType in PropertyType with alias: 'producedFromDate' but nothing really conclusive and no real solutions.

    What packages do you have installed?

    If you can take a backup of your database and send me a Dropbox/WeTransfer link then I can have a look at what the problem is ([email protected]).

  • Tony Lorentzen 79 posts 158 karma points
    Jul 16, 2016 @ 08:55
    Tony Lorentzen
    0

    Yeah i've done all of those things too :-)

    It seems like Umbraco thinks the document property is a datetime type when it is a string... ?

  • Tony Lorentzen 79 posts 158 karma points
    Jul 16, 2016 @ 14:05
    Tony Lorentzen
    0

    Hey Sebastiaan - appreciate your offer to look at the Database but unfortunately due to client confidentiality I'm unable to share it with anyone :-(

  • Sebastiaan Janssen 4988 posts 15101 karma points MVP admin hq
    Jul 18, 2016 @ 05:46
    Sebastiaan Janssen
    1

    Try to go in and query the database:

    SELECT * FROM cmsPropertyData WHERE propertyTypeId IN (
        SELECT id FROM cmsPropertyType WHERE alias = 'producedFromDate'
    ) AND (dataInt IS NOT NULL OR dataDecimal IS NOT NULL OR dataNVarChar IS NOT NULL OR dataNtext IS NOT NULL)
    

    This will result in all the data that is stored for the producedFromDate property that is NOT in the dataDate column, where it was supposed to be stored. You can then move this data into the dataDate column.

    It's hard to tell why this data was stored in the wrong column, especially if this site started as a v7 site. It could be a package, or an import?
    I can imagine that in older versions of Umbraco we sometimes might have stored things wrong, but since v6 that should not have happened any more. This is why I wanted to look at your database to see if I could figure out the cause and improve Umbraco for everyone if possible.

  • Tony Lorentzen 79 posts 158 karma points
    Jul 20, 2016 @ 09:11
    Tony Lorentzen
    1

    All of the data is stored correctly in the datanvarchar fields (as they should be) as the the data isn't a date type but rather a period i.e. "Fall 2016", "Spring 2016". They aren't precise dates which is why the date type isn't set to a date.

    However - this led me onto investigate something else because I remember we changed the documenttype from Date to Textbook (or rather from DateTime to Nvarchar) and sure enough - there's was still some "old" data in the dataDate column which was causing the problems. Seems like when you change a document property type that the data isn't converted into the new format until the corresponding document has been opened and saved/published again. It'd be nice if there was a way to specify if you want to convert or maybe nullify the data for that particular document property when it is being changed. Obviously - some conversions are pretty straightforward like from date to string, whereas others aren't that easily convertible if at all.

    Anyhow - I nulled all of the old data in the dataDate field for that document property and one more and then my upgrade worked.

    Thanks for your help Sebastian!

Please Sign in or register to post replies

Write your reply to:

Draft