Copied to clipboard

Flag this post as spam?

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

  • tgtrajeev 4 posts 24 karma points
    Aug 28, 2021 @ 18:45

    Error while data migration in Umbraco 8.5 from Umbraco 7.14+

    We are getting error while migrating the content. Can you help us?

    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Surrogate pairs are not supported. Please check log file for additional information (can be found in '/AppData/Logs/') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\a\1\s\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 47 --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.14.MoveNext() in d:\a\1\s\src\Umbraco.Web\Install\Controllers\InstallApiController.cs:line 236 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task) at Umbraco.Web.Install.Controllers.InstallApiController.

  • Ben McKean 272 posts 549 karma points
    Sep 03, 2021 @ 12:57
    Ben McKean

    Hi tgtrajeev

    Did you find a solution to this or find a solution to finding emojis as mentioned here

    Thanks Ben

  • Ben McKean 272 posts 549 karma points
    Sep 03, 2021 @ 13:54
    Ben McKean

    This query worked for me:

    SELECT id, text
    FROM UmbracoNode
    WHERE CAST(text AS VARCHAR(80)) <> CAST(text AS NVARCHAR(80));
Please Sign in or register to post replies

Write your reply to: