I'm attempting to upgrade a site running Umbraco 7.4.3 to 7.5.2 but run into a little issue during the database upgrade. However, I'm getting the following error when the database is being update for the new version:
The database failed to upgrade. ERROR: The database configuration failed with the following message: There are no primary or candidate keys in the referenced table 'umbracoNode' that match the referencing column list in the foreign key 'FK_umbracoRedirectUrl'.
Could not create constraint or index. See previous errors. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
Did you manually set the version in your web. Config to 7.5.2? You should leave it at 7.4.3 and let the upgrade installer do the work of changing the version.
Thanks for the responses, unfortunately still no luck. I haven't changed the config and also just tried going to 7.5.3 with the same result (on a different site/database).
I managed to get around it by creating the new umbracoRedirect table manually but it seems like a workaround which I'm a little uneasy with.
Yeah, this kind of workarounds is mostly why people usually get upgrade errors.. so this might work for now, but you will probably get upgrade troubles again down the road.
Can you confirm that when you upgraded your website and before you saw the Umbraco upgrade installed that the umbracoConfigurationStatus appSetting in your web.config was set to the version you were coming from (7.4.3 you said)?
If yes, then can you list (you still have the database backup from before upgrading, I hope) what's in the umbracoMigration table before upgrade?
Alright.. now I'm tickled.. It SHOULD have worked!
Right, can you try one more thing, can you see if you can set the umbracoConfigurationStatus in your web.config to 7.3.0 and see if that helps?
If that doesn't help, would you be able to zip up your website + database for me and send it off to [email protected] as a Dropbox or WeTransfer link? I'm really curious what the problem is and of course if we have a bug somewhere we're eager to get it fixed!
So I had a suspicion and I think I confirmed it now. Set your version in web.config to 7.2.8 and try again. I suspect that earlier migrations did not run completely/successfully and might have been "hacked around" so that's why you're missing something. Setting the version back to 7.2.8 made the upgrade succeed immediately!
I'm running into the same issue upgrading from an umbraco 626 site. Usually, we try to upgrade incrementally (maybe 626 to 728 and then 728 to 743 and then 743 to 753). This time, we tried upgrading straight from 626. I got the exact same error message, and, unless I'm just glazing over it, there is no migration table in our umbraco 626 site. Any idea what my problem is? Should we go back to our incremental upgrade strategy? Or do you expect that there is a simple fix and we can take a shortcut?
We successfully upgraded our site from 626 to 728. Unfortunately, we get the same errors when attempting to upgrade from 728 to 753. Looks like we need need to do another intermediate upgrade to 743?
I just did a schema compare of the umbraco database we are trying to upgrade to another umbraco 728 database. We inherited this site, and it looks like a bunch of custom indexes and interesting properties have been added to a lot of the tables. Either that or something went very differently in a prior upgrade. My problem is probably due to those schema differences between our the site and a regular 728 site.
We were able to upgrade another of our umbraco 728 sites to 753 without difficulty.
I had the same issue after upgrading a site from 7.4.1. to latest version (currently 7.5.4)
"The database failed to upgrade. ERROR: The database configuration failed with the following message: There are no primary or candidate keys in the referenced table 'umbracoNode' that match the referencing column list in the foreign key 'FKumbracoRedirectUrl'.
Could not create constraint or index. See previous errors. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')"
It only had 7.4.1 in the umbracoMigration Table.
I changed the umbracoConfigurationStatus in the web config file to 7.2.8 and run the site again and this time the upgrade worked. Strange!
7.5.2 Upgrade
Hi,
I'm attempting to upgrade a site running Umbraco 7.4.3 to 7.5.2 but run into a little issue during the database upgrade. However, I'm getting the following error when the database is being update for the new version:
Anyone run into this or can suggest a solution?
Any help would be hugely appreciated.
Hi Onejl,
Just released Umbraco 7.5.3, maybe you have to uprage to 7.5.3?
Did you manually set the version in your web. Config to
7.5.2? You should leave it at7.4.3and let the upgrade installer do the work of changing the version.Hi guys,
Thanks for the responses, unfortunately still no luck. I haven't changed the config and also just tried going to 7.5.3 with the same result (on a different site/database).
I managed to get around it by creating the new umbracoRedirect table manually but it seems like a workaround which I'm a little uneasy with.
Thanks.
Yeah, this kind of workarounds is mostly why people usually get upgrade errors.. so this might work for now, but you will probably get upgrade troubles again down the road.
Can you confirm that when you upgraded your website and before you saw the Umbraco upgrade installed that the
umbracoConfigurationStatusappSetting in your web.config was set to the version you were coming from (7.4.3you said)?If yes, then can you list (you still have the database backup from before upgrading, I hope) what's in the
umbracoMigrationtable before upgrade?It might look a little bit like this:
Yep, checked the version in the web.config and definitely said 7.4.3.
And yes, I still kept a backup of the database, here's my migration table:
Alright.. now I'm tickled.. It SHOULD have worked!
Right, can you try one more thing, can you see if you can set the
umbracoConfigurationStatusin your web.config to7.3.0and see if that helps?If that doesn't help, would you be able to zip up your website + database for me and send it off to [email protected] as a Dropbox or WeTransfer link? I'm really curious what the problem is and of course if we have a bug somewhere we're eager to get it fixed!
Same result I'm afraid! I've dropped you an email. Thanks again for the help.
Thanks for sending me the bits!
So I had a suspicion and I think I confirmed it now. Set your version in web.config to
7.2.8and try again. I suspect that earlier migrations did not run completely/successfully and might have been "hacked around" so that's why you're missing something. Setting the version back to 7.2.8 made the upgrade succeed immediately!I've tried this as well, but has not solved my issue. I'm going from 7.5.13 to 7.10.4.
It is possible that we've hacked this before as we've had a similar issue with foreign keys before.
Thanks Sebastiaan, that's done the trick nicely.
I got same problem here is my migration table
I tried first to change the umbracoConfigurationStatus to 7.3.5 this dident help.
it just made other errors.
Then I also tried the 7.2.8 this worked for me as well this has saved mee for crying myself to sleep. :D
Thanks you Sebastian Janssen
Hi all,
same problem. Clean install 7.4.3. :-) Workaround setting config to 7.2.8 also worked.
I'm running into the same issue upgrading from an umbraco 626 site. Usually, we try to upgrade incrementally (maybe 626 to 728 and then 728 to 743 and then 743 to 753). This time, we tried upgrading straight from 626. I got the exact same error message, and, unless I'm just glazing over it, there is no migration table in our umbraco 626 site. Any idea what my problem is? Should we go back to our incremental upgrade strategy? Or do you expect that there is a simple fix and we can take a shortcut?
Thanks.
We successfully upgraded our site from 626 to 728. Unfortunately, we get the same errors when attempting to upgrade from 728 to 753. Looks like we need need to do another intermediate upgrade to 743?
I just did a schema compare of the umbraco database we are trying to upgrade to another umbraco 728 database. We inherited this site, and it looks like a bunch of custom indexes and interesting properties have been added to a lot of the tables. Either that or something went very differently in a prior upgrade. My problem is probably due to those schema differences between our the site and a regular 728 site.
We were able to upgrade another of our umbraco 728 sites to 753 without difficulty.
I had the same issue after upgrading a site from 7.4.1. to latest version (currently 7.5.4) "The database failed to upgrade. ERROR: The database configuration failed with the following message: There are no primary or candidate keys in the referenced table 'umbracoNode' that match the referencing column list in the foreign key 'FKumbracoRedirectUrl'. Could not create constraint or index. See previous errors. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')"
It only had 7.4.1 in the umbracoMigration Table. I changed the umbracoConfigurationStatus in the web config file to 7.2.8 and run the site again and this time the upgrade worked. Strange!
is working on a reply...