Sign in Register
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
    Steve Brereton
    0

    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
    Dec 02, 2024 @ 21:52
    Nick
    0

    I think you need to upgrade to 8.1.2

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

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies