database configuration error during v715 to v81 migration - Using Umbraco and getting started

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Steve Brereton 32 posts 173 karma points

Aug 16, 2024 @ 16:37

Database configuration error during v7.15 to v8.1 migration

The database configuration failed with the following message: Invalid cast from 'System.DateTime' to 'System.ValueTuple`2[[System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.

The lines immediately above in the log are

 {"@t":"2024-08-16T15:38:53.6497186Z","@mt":"Execute {MigrationType}","MigrationType":"DropTemplateDesignColumn","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":12616,"ProcessName":"w3wp","ThreadId":136,"AppDomainId":13,"AppDomainAppId":"LMW3SVC7ROOT","MachineName":"xxxx","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"6ba8733d-691b-4f63-b7d2-035f6f2f3c07"}
{"@t":"2024-08-16T15:38:53.6687201Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":9167,"Sql":"ALTER TABLE [cmsTemplate] DROP COLUMN [design];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":12616,"ProcessName":"w3wp","ThreadId":136,"AppDomainId":13,"AppDomainAppId":"LMW3SVC7ROOT","MachineName":"xxx","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"6ba8733d-691b-4f63-b7d2-035f6f2f3c07"}
{"@t":"2024-08-16T15:38:53.6709642Z","@mt":"At {OrigState}","OrigState":"{08919C4B-B431-449C-90EC-2B8445B5C6B1}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":12616,"ProcessName":"w3wp","ThreadId":136,"AppDomainId":13,"AppDomainAppId":"LMW3SVC7ROOT","MachineName":"xxx","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"6ba8733d-691b-4f63-b7d2-035f6f2f3c07"}
{"@t":"2024-08-16T15:38:53.6709642Z","@mt":"Execute {MigrationType}","MigrationType":"TablesForScheduledPublishing","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":12616,"ProcessName":"w3wp","ThreadId":136,"AppDomainId":13,"AppDomainAppId":"LMW3SVC7ROOT","MachineName":"xxx","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"6ba8733d-691b-4f63-b7d2-035f6f2f3c07"}

Suggests its not expecting the System.DateTime value?

Copy Link

Nick 9 posts 99 karma points

19 days ago

0

I think you need to upgrade to 8.1.2

See gitpost https://github.com/umbraco/Umbraco-CMS/issues/5852

Copy Link
is working on a reply...

Please Sign in or register to post replies