Upgrades Questions on upgrading to version 7.x.
Version 7.x > Upgrades > Error upgrading to V7 View modes: 
User avatar
Certified Developer v6
Certified Developer v6
dave - 11/19/2012 10:29:25 AM
   
Error upgrading to V7
I received this error when running the v7 upgrade via KIM:


-- Update table [CMS_WebPartLayout]
DROP INDEX [IX_CMS_WebPartLayout_WebPartLayoutCheckedOutByUserID]
ON [CMS_WebPartLayout];

ALTER TABLE [CMS_WebPartLayout]
DROP CONSTRAINT [FK_CMS_WebPartLayout_WebPartLayoutCheckedOutByUserID_CMS_User];

ALTER TABLE [CMS_WebPartLayout]
DROP
COLUMN [WebPartLayoutCheckedOutByUserID],

COLUMN [WebPartLayoutCheckedOutFilename],

COLUMN [WebPartLayoutCheckedOutMachineName];

ALTER TABLE [CMS_WebPartLayout]
ADD
CONSTRAINT [DEFAULT_CMS_WebPartLayout_WebPartLayoutCodeName]
DEFAULT ('') FOR [WebPartLayoutCodeName],
CONSTRAINT [DEFAULT_CMS_WebPartLayout_WebPartLayoutDisplayName]
DEFAULT ('') FOR [WebPartLayoutDisplayName];

Failed to run SQLscript: 'FK_CMS_WebPartLayout_WebPartLayoutCheckedOutByUserID_CMS_User' is not a constraint.
Could not drop constraint. See previous errors.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 11/20/2012 3:22:48 AM
   
RE:Error upgrading to V7
Hi Dave,

The constraint was removed since it is no longer being used - so basically if it was not there, it is OK, just, you may need to run this part of the query which was probably not executed after the error:

ALTER TABLE [CMS_WebPartLayout]
DROP
COLUMN [WebPartLayoutCheckedOutByUserID],

COLUMN [WebPartLayoutCheckedOutFilename],

COLUMN [WebPartLayoutCheckedOutMachineName];

ALTER TABLE [CMS_WebPartLayout]
ADD
CONSTRAINT [DEFAULT_CMS_WebPartLayout_WebPartLayoutCodeName]
DEFAULT ('') FOR [WebPartLayoutCodeName],
CONSTRAINT [DEFAULT_CMS_WebPartLayout_WebPartLayoutDisplayName]
DEFAULT ('') FOR [WebPartLayoutDisplayName];



In general, if you have big DB with many records, it is better to run the SQL script directly over the DB using SQL management studio to avoid time outs.

Best regards,
Juraj Ondrus