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


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

    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.

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

    Hi tgtrajeev

    Did you find a solution to this or find a solution to finding emojis as mentioned here https://our.umbraco.com/forum/umbraco-8/99194-umbraco-8-upgrade-taking-long-time

    Thanks Ben

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

    This query worked for me:

    SELECT id, text
FROM UmbracoNode
WHERE CAST(text AS VARCHAR(80)) <> CAST(text AS NVARCHAR(80));
    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