Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 12:21
    Rune Grønkjær
    0

    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

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Nov 07, 2012 @ 12:28
    Rasmus Fjord
    0

    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.

  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 12:36
    Rune Grønkjær
    0

    @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

  • Albert 27 posts 49 karma points
    Nov 07, 2012 @ 12:49
    Albert
    0

    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. 

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Nov 07, 2012 @ 12:51
    Rasmus Fjord
    0

    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.

  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 13:20
    Rune Grønkjær
    0

    @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

  • Stefan Kip 1614 posts 4131 karma points c-trib
    Nov 07, 2012 @ 13:28
    Stefan Kip
    0

    Have you checked the db user permissions? Should at least have db_owner if I remember correctly...

  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 13:29
    Rune Grønkjær
    0

    @kipusoep - Yes. I can log into the adminstration both before and after the upgrade attempt.

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Nov 07, 2012 @ 13:35
    Sebastiaan Janssen
    0

    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.

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Nov 07, 2012 @ 13:37
    Sebastiaan Janssen
    0

    Also, maybe you forgot to delete the App_global.asax.dll, it might be in the way.

  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 13:46
    Rune Grønkjær
    0

    @Sebastiaan - Will try that. I did delete the App_global.asax.dll. Really weird stuff.

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Nov 07, 2012 @ 13:49
    Sebastiaan Janssen
    0

    @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.

  • Rune Grønkjær 1372 posts 3103 karma points
    Nov 07, 2012 @ 13:52
    Rune Grønkjær
    0

    @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.

Please Sign in or register to post replies

Write your reply to:

Draft