Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Chad 18 posts 122 karma points
    May 12, 2020 @ 15:49
    Chad
    1

    Unable to Upgrade form 8.5.5 to 8.6.0

    When trying to upgrade from 8.5.5 to 8.6.0 I'm getting a database error. Is this a bug or am I missing some db permissions?

    Database Error Screenshot

    Copy Link
  • Steve Morgan 1349 posts 4458 karma points c-trib
    May 13, 2020 @ 08:54
    Steve Morgan
    0

    Hi

    I've not seen this bug exactly but I have had issues where DBAs have locked down (correctly) the DB user Umbraco accesses the DB with.

    All we do is to temporarily use a sa account in the web.config so the upgrade goes through and then switch it back.

    HTH

    Steve

    Copy Link
  • Chad 18 posts 122 karma points
    May 15, 2020 @ 14:54
    Chad
    1

    Elevated permissions didn't seem to change anything. Running this drop manually seems to allow it to continue. Maybe a bug in umbraco migrations?

    ALTER TABLE umbracoRelationType
DROP CONSTRAINT IX_umbracoRelationType_alias;

    Is this constraint meant to be dropped in this ugprade?

    Copy Link
  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Jun 15, 2020 @ 12:00
    Sebastiaan Janssen
    1

    This seems to be something going wrong in a few people's databases, but we can't put our finger on exactly what the cause is, there are constraints in the DB that Umbraco didn't create and should indeed be dropped.

    I've reported it as a bug for the community to work on: https://github.com/umbraco/Umbraco-CMS/issues/8291

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft