Copied to clipboard

Flag this post as spam?

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


  • Rob Watkins 369 posts 701 karma points
    Jul 27, 2017 @ 09:45
    Rob Watkins
    0

    DB Installation woes - 4.8 -> 7.6.4

    Trying out the new upgrade functionality on an old 4.8 install -> 7.6.4, and run into a problem:

    The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IXumbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')

    The SQL it is running is:

     2017-07-27 10:39:47,444 [P8764/D14/T22] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 142: ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL
    

    It is incredibly infuriating because it has done loads of the upgrade perfectly, and the column is already a uniqueidentifier so it shouldn't need to run this code anyway!

    I don't understand why the migration code earlier creates the index, then tries to modify the column, failing on the index it has just added?

    Is there a fix?

    P.S. There seems to be a lot of threads about this Unique ID error, with the advice to upgrade to 7.2.3 first; as the new improved upgrader was only put into 7.3, this doesn't seem like it will work here.

  • Rob Watkins 369 posts 701 karma points
    Jul 27, 2017 @ 10:57
    Rob Watkins
    100

    Fixed this quite easily in the end by doing an upgrade to 7.3.3 first, then upgrading to 7.6.4.

    All went very smoothly, hope the templates and custom code is as easy! :oD

Please Sign in or register to post replies

Write your reply to:

Draft