A rather annoying issue: during the install the DB upgrade fails with following message:
The database configuration failed with the following message: The operation failed because an index or statistics with name 'IXumbracoNodeTrashed' already exists on table 'umbracoNode'. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
Any idea? UmbracoTraceLog.txt is empty of course...
Trying to delete the index mentioned causes another warning:
The database configuration failed with the following message: The operation failed because an index or statistics with name 'IXcmsContentVersionContentId' already exists on table 'cmsContentVersion'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IXmacroPropertyType' is dependent on column 'macroPropertyType'.
ALTER TABLE DROP COLUMN macroPropertyType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
Yet another unresolved question on Our :) Did anybody get this working? It's been stale for 3 years now and I just got the same issue. (Upgrading from 7.2.8 to 7.6.5)
I just got this issue upgrading from 6.2.6 to 7.0.4 (long story). You can safely delete each of the indexes the install complains about (there are a further three). The install will recreate the indexes.
If you are at all worried they may not be recreated, just script them first so that they can be reapplied later if necessary.
Ideally, these should have been conditionally checked for and dropped or ignored.
Upgrade issues 6.2.1 -> 7.0.2
Hi guys,
A rather annoying issue: during the install the DB upgrade fails with following message:
Any idea? UmbracoTraceLog.txt is empty of course...
Trying to delete the index mentioned causes another warning:
To be continued...
Did you ever get a resolution here. I have the same issue.
Have this message that may be related.
The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IXmacroPropertyType' is dependent on column 'macroPropertyType'. ALTER TABLE DROP COLUMN macroPropertyType failed because one or more objects access this column. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')
Hi Jonas
Have you been following this guide? http://our.umbraco.org/documentation/Installation/Upgrading/v7-upgrade
/Jan
Yet another unresolved question on Our :) Did anybody get this working? It's been stale for 3 years now and I just got the same issue. (Upgrading from 7.2.8 to 7.6.5)
I just got this issue upgrading from 6.2.6 to 7.0.4 (long story). You can safely delete each of the indexes the install complains about (there are a further three). The install will recreate the indexes.
If you are at all worried they may not be recreated, just script them first so that they can be reapplied later if necessary.
Ideally, these should have been conditionally checked for and dropped or ignored.
is working on a reply...