error with manual upgrade from 704 to 724 - Installing umbraco

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 14:51

Error with Manual Upgrade from 7.0.4 to 7.2.4

I am trying to upgrade to a newer version of Umbraco and am met with the following error in the browser:

Error during installation

Sequence contains more than one element

See the log for full details (logs can typically be found in the App_Data\Logs folder).

The log contains the following entries between when the upgrade starts and fails--From what I have found online it has to do with duplicate entries in database tables but I am unsure where to start looking with just the provided log information

2015-04-14 08:38:15,548 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 10] CurrentVersion different from configStatus: '7.2.4','7.0.4'
2015-04-14 08:38:19,012 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 11] CurrentVersion different from configStatus: '7.2.4','7.0.4'
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 9] CurrentVersion different from configStatus: '7.2.4','7.0.4'
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 9] CurrentVersion different from configStatus: '7.2.4','7.0.4'
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Web.Install.Controllers.InstallApiController - [Thread 9] Executing installation step: DatabaseUpgrade
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - [Thread 9] Running 'Upgrade' service
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Core.DatabaseContext - [Thread 9] Database upgrade started
2015-04-14 08:38:22,600 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Initializing database migrations
2015-04-14 08:38:22,615 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
2015-04-14 08:38:22,615 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
2015-04-14 08:38:22,631 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AdditionalIndexesAndKeys' to context
2015-04-14 08:38:22,631 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'ChangePasswordColumn' to context
2015-04-14 08:38:22,631 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AddChangeDocumentTypePermission' to context
2015-04-14 08:38:22,631 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'UpdateToNewMemberPropertyAliases' to context
2015-04-14 08:38:22,631 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AlterDataTypePreValueTable' to context
2015-04-14 08:38:22,647 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AddMissingForeignKeyForContentType' to context
2015-04-14 08:38:22,647 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'RemoveCmsDocumentAliasColumn' to context
2015-04-14 08:38:22,647 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Added UPGRADE migration 'AddIndexToUmbracoNodeTable' to context
2015-04-14 08:38:22,647 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 9] Executing sql statement 1: ALTER TABLE [umbracoUser] ALTER COLUMN [userPassword] NVARCHAR(500) NOT NULL
2015-04-14 08:38:22,678 [15] INFO  Umbraco.Core.DatabaseContext - [Thread 9] Database configuration status: <p>Upgrade completed!</p>
2015-04-14 08:38:22,678 [15] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 9] Installation step DatabaseUpgrade failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Sequence contains more than one element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Umbraco.Core.Configuration.GlobalSettings.RemoveSetting(String key)
   at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
   --- 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.ExecuteStep(InstallSetupStep step, JToken instruction)
   at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
2015-04-14 08:38:22,678 [15] INFO  Umbraco.Web.Install.Controllers.InstallApiController - [Thread 9] Step completed (took 72ms)
2015-04-14 08:38:22,678 [15] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 9] An error occurred during installation step DatabaseUpgrade
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Sequence contains more than one element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Umbraco.Core.Configuration.GlobalSettings.RemoveSetting(String key)
   at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
   --- 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.ExecuteStep(InstallSetupStep step, JToken instruction)
   at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)

The install log file contains:

[{"Name":"Permissions","ServerOrder":0,"IsComplete":true,"AdditionalData":{}},{"Name":"Upgrade","ServerOrder":1,"IsComplete":true,"AdditionalData":{}},{"Name":"MajorVersion7UpgradeReport","ServerOrder":1,"IsComplete":true,"AdditionalData":{}},{"Name":"DatabaseInstall","ServerOrder":11,"IsComplete":true,"AdditionalData":{"upgrade":true}},{"Name":"DatabaseUpgrade","ServerOrder":12,"IsComplete":false,"AdditionalData":{}},{"Name":"UmbracoVersion","ServerOrder":50,"IsComplete":false,"AdditionalData":{}}]

NOTE: This is just a base instance of Umbraco without any additional projects integrated.

Any help or suggestions where to start looking are appreciated!!! :)

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Apr 14, 2015 @ 15:09

Hi Thomas

What steps did you take during the upgrade? Did you follow the official documentation?

What database are you using? Is it locally or on a remote server?

Looking forward to hearing from you.

/Jan

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 15:23

Hi Jan,

The database is on a remote server on our network and I did follow the documentation in the general upgrade guide. Pretty much just copied over the necessary files from the 7.2.4 package while preserving some of the configuration files that have previously been setup--such as umbracoSettings, web.config, and urlRewrites.

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 15:24

*Database is on a MSSQL 2008 server.

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Apr 14, 2015 @ 15:27

Hi Thomas

Ok - Remember to remove the /install folder as well. This is a required step when going to or past 7.1.0. But don't think that's the culprit though.

Ehm...did you check the configurationStatus in the web.config btw? Does this still say 7.0.4? If so then it's probably something related to the permission settings I guess.

/Jan

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 15:36

Yep, still showing:

<add key="umbracoConfigurationStatus" value="7.0.4" />

I'll poke around the environment's permissions and try again to see if that has any success.

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Apr 14, 2015 @ 15:37

Hi Thomas

I think that's a good idea - But you should be able to get the upgrade finishing up by manually entering 7.2.4 instead - But it's probably a good idea to get to the bottom of things and do it the "proper way" instead :)

Looking forward to hearing from you.

/Jan

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 15:47

I opened up full permissions to 'Everyone' and still get the error during install. The install folder doesn't appear to exist in the root of the web application in its current state.

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 15:52

I had thought of that earlier, which makes the public side of the site work--but when attempting to get to the backoffice, the webpage throws an redirect loop error.

EDIT: NEVERMIND!!! Haha, we have 'location' tags implemented on this site and just noticed that there are two entries that need the 7.2.4 value set. Changing them both appears to have resolved it.

Looks like it upgraded okay. Thanks a bunch Jan!

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 16:04

Only question I have is whether the 'location' tags in the web.config and the existence of duplicate tags nested between those is what throws the "Sequence contains more than one element" error.

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib

Apr 14, 2015 @ 16:36

Hi Thomas

Happy to hear you figured the issue out :)

I think it could be the cause indeed - But do you mind showing what it looks like? Just so that I'm sure I know what I'm answering? :D

/Jan

Copy Link

Thomas Brinegar 84 posts 162 karma points

Apr 14, 2015 @ 16:43

Sure, so we have some child applications nested in IIS to this site and without the 'location' tags, it causes some issues between them. To keep the web.config settings applicable only to the public site and the backoffice, we have the location tags implemented throughout in a fashion similar to:

<location path="." inheritInChildApplications="false">
        <appSettings>
            <add key="umbracoConfigurationStatus" value="7.2.4" />
            <add key="umbracoReservedUrls" value="~/config/splashes/booting.aspx,~/install/default.aspx,~/config/splashes/noNodes.aspx,~/VSEnterpriseHelper.axd" />
            <add key="umbracoReservedPaths" value="~/umbraco,~/install/" />
            <add key="umbracoPath" value="~/umbraco" />
            <add key="umbracoHideTopLevelNodeFromPath" value="true" />
            <add key="umbracoUseDirectoryUrls" value="true" />
            <add key="umbracoTimeOutInMinutes" value="60" />
            <add key="umbracoDefaultUILanguage" value="en" />
            <add key="umbracoUseSSL" value="true" />
            <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
            <add key="webpages:Enabled" value="false" />
            <add key="enableSimpleMembership" value="false" />
            <add key="autoFormsAuthentication" value="false" />
            <add key="log4net.Config" value="config\log4net.config" />
        </appSettings>
    </location>
    <location path="Umbraco" inheritInChildApplications="false">
        <appSettings>
            <add key="umbracoConfigurationStatus" value="7.2.4" />
            <add key="umbracoReservedUrls" value="~/config/splashes/booting.aspx,~/install/default.aspx,~/config/splashes/noNodes.aspx,~/VSEnterpriseHelper.axd" />
            <add key="umbracoReservedPaths" value="~/umbraco,~/install/" />
            <add key="umbracoPath" value="~/umbraco" />
            <add key="umbracoHideTopLevelNodeFromPath" value="true" />
            <add key="umbracoUseDirectoryUrls" value="true" />
            <add key="umbracoTimeOutInMinutes" value="20" />
            <add key="umbracoDefaultUILanguage" value="en" />
            <add key="umbracoUseSSL" value="true" />
            <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
            <add key="webpages:Enabled" value="false" />
            <add key="enableSimpleMembership" value="false" />
            <add key="autoFormsAuthentication" value="false" />
            <add key="log4net.Config" value="config\log4net.config" />
        </appSettings>
    </location>

Without those, the child applications get .NET/IIS exceptions. I hadn't noticed that the 'umbracoConfigurationStatus' key was one of those which had two entries like this and when they were both updated the site started to behave.

Copy Link

is working on a reply...

Flag this post as spam?

Error with Manual Upgrade from 7.0.4 to 7.2.4