The log file should contain more details of the error. If you search for that "String or binary data would be truncated" message, you should find two matching lines. The first should contain more detail.
i just do like umbraco documentation i upgrade to 7.14 then make a new clear unbraco 8.1 website and connect my old database on it to back up my old website in umbraco 8.1 website and i faced this error i have no idea about that.
XD
It looks like the maximum length of the cmsPropertyData.dataNvarchar column in your database has been increased from the default of 500 or 512. The upgrade is trying to copy data from that column into another, and expects that the data will fit in the default 512 characters.
I think that's going to be awkward to fix. Let's start by checking how much data is causing a problem with this query:
SELECT * FROM cmsPropertyData WHERE LEN(dataNvarchar) > 512
Do you get lots of rows, or just a few? Are they all for the same propertytypeid, or several?
At least it's just one property on one document that's causing trouble. As a workaround, I would make a note of that contentNodeId, make sure that you've got a copy of that HTML value, then delete those 8 rows from the table.
That should let the migration continue, then you can edit the deleted value back into that document. The easiest way will be to just increase the maximum length of that column (it'll be called umbracoPropertyData.varcharValue after the migration) and then edit the affected document.
The "correct" fix would probably be to change that data type to store its values as text rather than varchar. However, that affects every other document that uses that data type, and has potential to go horribly wrong.
Okay. I faced the same problem while upgrading. Can you tell me which version are you at and to which are you trying to upgrade?
You need to go through some of the interim versions. First upgrade your site to version greater than 7.14. I upgrade to 7.15.4, then to 8.2.1 and then to 8.6.
It depends on which version your site is currently at. This method works for me. Because there are many tables which are added to the DB while the upgrade. Direct upgrade won't add those and creates this error.
How to Upgrade to umbraco 8 ?
Hi our
any body pass this error when migrate from 7 to 8 ?
You cant upgrade from 7 to 8. You can only migrate manually
More details here - https://umbraco.com/blog/umbraco-7-to-umbraco-8-a-developer-s-perspective/
that what i did i am trying to migrate an umbraco 7 DB to umbraco 8 project
I don't think I've seen that one before.
The log file should contain more details of the error. If you search for that "String or binary data would be truncated" message, you should find two matching lines. The first should contain more detail.
i just do like umbraco documentation i upgrade to 7.14 then make a new clear unbraco 8.1 website and connect my old database on it to back up my old website in umbraco 8.1 website and i faced this error i have no idea about that. XD
Could you share your log file? That'll give us more details about where the upgrade is failing.
{"@t":"2019-09-19T12:42:21.1438379Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.0.1 on DESKTOP-CSSE7RV.","TimingId":"ef22661","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.3533996Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.3577409Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.5661861Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Resolving composer types.","TimingId":"3314013","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.7347316Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Resolved.","Duration":168,"TimingId":"3314013","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:22.6226278Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Web.Logging.WebProfilerComponent","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:23.1531806Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Booted.","Duration":2015,"TimingId":"ef22661","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:23.4264781Z","@mt":"New url {Url} detected, re-discovering application url.","Url":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"810a0643-f1cb-4300-95eb-57e7e306b940"} {"@t":"2019-09-19T12:42:23.4274747Z","@mt":"ApplicationUrl: {UmbracoAppUrl} (UmbracoModule request)","UmbracoAppUrl":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"810a0643-f1cb-4300-95eb-57e7e306b940"} {"@t":"2019-09-19T12:42:23.6866392Z","@mt":"Umbraco must install or upgrade.","@l":"Warning","SourceContext":"Umbraco.Web.UmbracoModule","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":2,"HttpRequestId":"810a0643-f1cb-4300-95eb-57e7e306b940"} {"@t":"2019-09-19T12:42:30.4624514Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","EventType":"Information","EventId":0,"State":"Login attempt succeeded for username [email protected] from IP address ::1","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":3,"HttpRequestId":"ed2f2610-b43b-449b-b11d-9967139af430"} {"@t":"2019-09-19T12:42:30.4634504Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","EventType":"Information","EventId":0,"State":"User: [email protected] logged in from IP address ::1","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":3,"HttpRequestId":"ed2f2610-b43b-449b-b11d-9967139af430"} {"@t":"2019-09-19T12:42:35.4623531Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'Permissions'.","TimingId":"3386582","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":4,"HttpRequestId":"c78a9b22-549b-47fb-aceb-b246c911be17"} {"@t":"2019-09-19T12:42:35.4713009Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":8,"TimingId":"3386582","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":4,"HttpRequestId":"c78a9b22-549b-47fb-aceb-b246c911be17"} {"@t":"2019-09-19T12:42:35.4952691Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'Upgrade'.","TimingId":"bbb9a9a","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":15,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":5,"HttpRequestId":"cf009706-163a-4bfa-a29b-02d45d1b6f69"} {"@t":"2019-09-19T12:42:35.4962675Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":0,"TimingId":"bbb9a9a","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":15,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":5,"HttpRequestId":"cf009706-163a-4bfa-a29b-02d45d1b6f69"} {"@t":"2019-09-19T12:42:35.5131971Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'DatabaseInstall'.","TimingId":"11b9a12","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":16,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"e3e6aeaa-279b-48db-a15d-d7e3ce8e5fb1"} {"@t":"2019-09-19T12:42:35.5211678Z","@mt":"Database configuration status: Started","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":16,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"e3e6aeaa-279b-48db-a15d-d7e3ce8e5fb1"} {"@t":"2019-09-19T12:42:35.7256476Z","@mt":"Database requires upgrade","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":16,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"e3e6aeaa-279b-48db-a15d-d7e3ce8e5fb1"} {"@t":"2019-09-19T12:42:35.7256476Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":212,"TimingId":"11b9a12","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":16,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"e3e6aeaa-279b-48db-a15d-d7e3ce8e5fb1"} {"@t":"2019-09-19T12:42:35.8090319Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Executing installation step: 'DatabaseUpgrade'.","TimingId":"3e507e2","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"3a20b37c-7727-48ba-be4f-b270fb10dfe7"} {"@t":"2019-09-19T12:42:35.8100276Z","@mt":"Running 'Upgrade' service","SourceContext":"Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"3a20b37c-7727-48ba-be4f-b270fb10dfe7"} {"@t":"2019-09-19T12:42:35.8110260Z","@mt":"Database upgrade started","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"3a20b37c-7727-48ba-be4f-b270fb10dfe7"} {"@t":"2019-09-19T12:42:35.8160117Z","@mt":"Creating KeyValue structure.","SourceContext":"Umbraco.Core.Services.Implement.KeyValueService","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"3a20b37c-7727-48ba-be4f-b270fb10dfe7"} {"@t":"2019-09-19T12:42:35.8180334Z","@mt":"SQL [{ContextIndex}]:
It looks like the maximum length of the
cmsPropertyData.dataNvarcharcolumn in your database has been increased from the default of 500 or 512. The upgrade is trying to copy data from that column into another, and expects that the data will fit in the default 512 characters.I think that's going to be awkward to fix. Let's start by checking how much data is causing a problem with this query:
Do you get lots of rows, or just a few? Are they all for the same
propertytypeid, or several?At least it's just one property on one document that's causing trouble. As a workaround, I would make a note of that contentNodeId, make sure that you've got a copy of that HTML value, then delete those 8 rows from the table.
That should let the migration continue, then you can edit the deleted value back into that document. The easiest way will be to just increase the maximum length of that column (it'll be called
umbracoPropertyData.varcharValueafter the migration) and then edit the affected document.The "correct" fix would probably be to change that data type to store its values as text rather than varchar. However, that affects every other document that uses that data type, and has potential to go horribly wrong.
okay i will give it a try thanks a lot
i deleted the rows and try again but i faced the same problem i think that its take more time than before. i will share the new file
{"@t":"2019-09-25T14:15:46.8389503Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.0.1 on DESKTOP-CSSE7RV.","TimingId":"1090107","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:47.1045473Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:47.1077319Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:47.3121843Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Resolving composer types.","TimingId":"a77ae8a","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:47.4777232Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Resolved.","Duration":165,"TimingId":"a77ae8a","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:48.4012447Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Web.Logging.WebProfilerComponent","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:49.0252127Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Booted.","Duration":2193,"TimingId":"1090107","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"b1f8b111-f8b6-4a12-a8a8-a30006e3a7a6"} {"@t":"2019-09-25T14:15:49.4331832Z","@mt":"New url {Url} detected, re-discovering application url.","Url":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":10,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"61ee2381-af4e-4201-83e9-61937b42d901"} {"@t":"2019-09-25T14:15:49.4341502Z","@mt":"ApplicationUrl: {UmbracoAppUrl} (UmbracoModule request)","UmbracoAppUrl":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":10,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"61ee2381-af4e-4201-83e9-61937b42d901"} {"@t":"2019-09-25T14:15:49.7183894Z","@mt":"Umbraco must install or upgrade.","@l":"Warning","SourceContext":"Umbraco.Web.UmbracoModule","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":10,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":2,"HttpRequestId":"61ee2381-af4e-4201-83e9-61937b42d901"} {"@t":"2019-09-25T14:15:49.7971797Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":3,"HttpRequestId":"3a12d94a-9236-40dc-806a-30fdda4e8fce"} {"@t":"2019-09-25T14:15:50.9969700Z","@mt":"Updated version number from {OldVersion} to {NewVersion}","OldVersion":"1621031536","NewVersion":"1162304557","SourceContext":"Umbraco.Web.JavaScript.ClientDependencyConfiguration","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpSessionId":"gnmohrjgh5p4cft4vblzv4xo","HttpRequestNumber":3,"HttpRequestId":"3a12d94a-9236-40dc-806a-30fdda4e8fce"} {"@t":"2019-09-25T14:15:50.9999610Z","@mt":"Stopping ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO "} {"@t":"2019-09-25T14:15:51.0049758Z","@mt":"Released ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO "} {"@t":"2019-09-25T14:15:51.2858593Z","@mt":"Application shutdown. Details: {ShutdownReason}\r\n\r\nshutDownMessage={ShutdownMessage}\r\n\r\nshutDownStack={ShutdownStack}","ShutdownReason":"ConfigurationChange","ShutdownMessage":"CONFIG change\r\nHostingEnvironment initiated shutdown\r\nCONFIG change\r\nHostingEnvironment caused shutdown","ShutdownStack":" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.getStackTrace()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()\r\n at System.Web.HttpRuntime.ShutdownAppDomain(String stackTrace)\r\n at System.Web.Configuration.HttpConfigurationSystem.OnConfigurationChanged(Object sender, InternalConfigEventArgs e)\r\n at System.Configuration.Internal.InternalConfigRoot.OnConfigChanged(InternalConfigEventArgs e)\r\n at System.Configuration.BaseConfigurationRecord.OnStreamChanged(String streamname)\r\n at System.Web.Configuration.WebConfigurationHostFileChange.OnFileChanged(Object sender, FileChangeEvent e)\r\n at System.Web.DirectoryMonitor.FireNotifications()\r\n at System.Web.Util.WorkItem.CallCallbackWithAssert(WorkItemCallback callback)\r\n at System.Web.Util.WorkItem.OnQueueUserWorkItemCompletion(Object state)\r\n at System.Threading.QueueUserWorkItemCallback.WaitCallbackContext(Object state)\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()\r\n at System.Threading.ThreadPoolWorkQueue.Dispatch()\r\n at System.Threading.ThreadPoolWaitCallback.PerformWaitCallback()","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO "} {"@t":"2019-09-25T14:15:51.5341944Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.0.1 on DESKTOP-CSSE7RV.","TimingId":"e3af2f3","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:51.6479229Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:51.6488944Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:53.1718329Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Resolving composer types.","TimingId":"64374f3","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:53.2077370Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Resolved.","Duration":35,"TimingId":"64374f3","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:54.1542336Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Web.Logging.WebProfilerComponent","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:54.5970217Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Booted.","Duration":3070,"TimingId":"e3af2f3","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"484d6502-2de3-4127-a3dc-1c237aada1fb"} {"@t":"2019-09-25T14:15:55.0368769Z","@mt":"New url {Url} detected, re-discovering application url.","Url":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"22ac41cf-33e6-4b35-b387-f76019948aaa"} {"@t":"2019-09-25T14:15:55.0378738Z","@mt":"ApplicationUrl: {UmbracoAppUrl} (UmbracoModule request)","UmbracoAppUrl":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"22ac41cf-33e6-4b35-b387-f76019948aaa"} {"@t":"2019-09-25T14:15:55.0976834Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":2,"HttpRequestId":"22ac41cf-33e6-4b35-b387-f76019948aaa"} {"@t":"2019-09-25T14:15:56.8280529Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":3,"HttpRequestId":"67003866-8bb0-43fe-b825-e95328307836"} {"@t":"2019-09-25T14:15:57.9703155Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":17,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":4,"HttpRequestId":"949e0894-8260-4218-b12d-14ade6d75b31"} {"@t":"2019-09-25T14:15:58.0221766Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":14,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":5,"HttpRequestId":"c9308019-ce7d-455e-8786-12997b37261e"} {"@t":"2019-09-25T14:15:59.2479536Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","@l":"Warning","EventType":"Warning","EventId":0,"State":"Unprotect ticket failed","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"WARN ","HttpRequestNumber":6,"HttpRequestId":"244e2717-2a4e-4c61-9c68-052297e58215"} {"@t":"2019-09-25T14:15:59.8434115Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","EventType":"Information","EventId":0,"State":"Login attempt succeeded for username [email protected] from IP address ::1","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":15,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"244e2717-2a4e-4c61-9c68-052297e58215"} {"@t":"2019-09-25T14:15:59.8444087Z","@mt":"[{EventType}] Event Id: {EventId}, State: {State}","EventType":"Information","EventId":0,"State":"User: [email protected] logged in from IP address ::1","SourceContext":"Umbraco.Core.Logging.OwinLogger","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":15,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":6,"HttpRequestId":"244e2717-2a4e-4c61-9c68-052297e58215"} {"@t":"2019-09-25T14:16:00.4662619Z","@mt":"Could not validate XSRF token","@l":"Error","@x":"System.Web.Mvc.HttpAntiForgeryException (0x80004005): The anti-forgery token could not be decrypted. If this application is hosted by a Web Farm or cluster, ensure that all machines are running the same version of ASP.NET Web Pages and that the umbracoLock]","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteConstraintExpression","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":10,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":10,"HttpRequestId":"ff57c074-b586-4b21-80e8-f3632b0d31e6"} {"@t":"2019-09-25T14:16:05.8746532Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"ALTER TABLE [umbracoLock] DROP COLUMN [id];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":33636,"ProcessName":"iisexpress","ThreadId":10,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":10,"HttpRequestId":"ff57c074-b586-4b21-80e8-f3632b0d31e6"} {"@t":"2019-09-25T14:16:05.8766479Z","@mt":"SQL [{ContextIndex}]:
Oh! Faced with the same problem.
Log file is:
{"@t":"2019-09-19T12:42:21.1438379Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.0.1 on DESKTOP-CSSE7RV.","TimingId":"ef22661","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.3533996Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.MainDom","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.3577409Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.MainDom","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.5661861Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Resolving composer types.","TimingId":"3314013","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"08a07fba-b418-4cc5-afab-0dc2eb3166f3"} {"@t":"2019-09-19T12:42:21.7347316Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Resolved.","Duration":168,"TimingId":"3314013","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":1,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO url.","Url":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"810a0643-f1cb-4300-95eb-57e7e306b940"} {"@t":"2019-09-19T12:42:23.4274747Z","@mt":"ApplicationUrl: appurl.com} (UmbracoModule request)","UmbracoAppUrl":"http://localhost:30406/umbraco","SourceContext":"Umbraco.Core.Sync.ApplicationUrlHelper","ProcessId":9376,"ProcessName":"iisexpress","ThreadId":9,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"DESKTOP-CSSE7RV","Log4NetLevel":"INFO ","HttpRequestNumber":2,"HttpRequestId":"810a0643-f1cb-4300-95eb-57e7e306b940"} {"@t":"2019-09
same issue.
any solution yet?
Same problem.
Regards
There is no direct upgrade path from Umbraco 7 to Umbraco 8, but it is possible to migrate content from Umbraco 7 sites to Umbraco 8 sites.
Please refer to the below documentations it will help you,
https://our.umbraco.com/documentation/getting-started/setup/upgrading/version-specific
https://our.umbraco.com/documentation/getting-started/setup/upgrading/migrating-to-v8
Okay. I faced the same problem while upgrading. Can you tell me which version are you at and to which are you trying to upgrade? You need to go through some of the interim versions. First upgrade your site to version greater than 7.14. I upgrade to 7.15.4, then to 8.2.1 and then to 8.6. It depends on which version your site is currently at. This method works for me. Because there are many tables which are added to the DB while the upgrade. Direct upgrade won't add those and creates this error.
is working on a reply...