But still i dont think it will make the big diff for ya.
Before you run through the install process, have you tried to go in and take the database down and starting it again so you are sure nothing else is hooked into it.
@Albert - the permissions are good. Network Service can do it all. I know because I actually forgot it on the copy I was working on and got another error before the database install.
@Rasmus - Yep I have done what it says. About the database. It's a complete copy of the original database. Nothing else using it.
What is bugging me is that it's the database that can't install. What could possibly go wring there??
I don't know what's going wrong, but update your database like this:
ALTER TABLE [umbracoUser2app] DROP CONSTRAINT [FK_umbracoUser2app_umbracoApp] GO ALTER TABLE [umbracoAppTree] DROP CONSTRAINT [FK_umbracoAppTree_umbracoApp] GO
And then change the version number in your web.config to 4.9.1 and you should be done.
@Rune we did actually recently find a flaw with database upgrades and have no idea how it could EVER have worked for anybody.. I think you might have that problem now. We're fixing it for the next time we need to do a db upgrade.
Upgrading from 4.7.1 to 4.9.1 database 35% error
Hi Guys,
I'm pulling out my hairs here. Have spent hours on trying to upgrade a site from 4.7.1 to 4.9.1.
All I get is this:
I have tried everything:
1. Merging my config files with winmerge
2. Using only the onld config files
3. Overwriting everything with the new files.
The site is pretty custom with custom sections and dashboards, but nothing that should be intrusive. Everything by the Umbraco book, so to speak.
I believe my site is sticking me the finger. Can anyone help me get even with it?
/Rune
have you tried splitting it into 2 steps ?
4.7.1>>4.8>>4.9.1
since there is some breaking changes in 4.8, dont recall them to be about the database but still worth to have with.
@Rasmus - I have tried these:
4.7.1 - 4.9.1
4.7.1 - 4.8.1
4.7.1 - 4.7.2 - 4.8.1
All ended in the same result. Haven't tried 4.8 as you suggest. Should the diffrence between 4.8 and 4.8.1 be that great?
/Rune
It's not necessary to split the upgrade. I upgrade a site from 4.7.1 to 4.9
Check the permissions of the root folder.
Well i dunno.
I always grab the 4.x version first and then 4.x.x since its always in the 4.x the breaking changes is listed.
check the "importent when upgrading"
4.8 http://umbraco.codeplex.com/releases/view/86586
4.8.1 http://umbraco.codeplex.com/releases/view/92481
But still i dont think it will make the big diff for ya.
Before you run through the install process, have you tried to go in and take the database down and starting it again so you are sure nothing else is hooked into it.
@Albert - the permissions are good. Network Service can do it all. I know because I actually forgot it on the copy I was working on and got another error before the database install.
@Rasmus - Yep I have done what it says. About the database. It's a complete copy of the original database. Nothing else using it.
What is bugging me is that it's the database that can't install. What could possibly go wring there??
/Rune
Have you checked the db user permissions? Should at least have db_owner if I remember correctly...
@kipusoep - Yes. I can log into the adminstration both before and after the upgrade attempt.
I don't know what's going wrong, but update your database like this:
And then change the version number in your web.config to 4.9.1 and you should be done.
Also, maybe you forgot to delete the App_global.asax.dll, it might be in the way.
@Sebastiaan - Will try that. I did delete the App_global.asax.dll. Really weird stuff.
@Rune we did actually recently find a flaw with database upgrades and have no idea how it could EVER have worked for anybody.. I think you might have that problem now. We're fixing it for the next time we need to do a db upgrade.
@sebastiaan - Yes, I read about that. And it might just be that. But thanks for the sql script. I will have a go with it when I can get back to this.
is working on a reply...