I upgraded to 5.1.1 as well and have this same error. In addition, skins and language under host are not displaying. Any idea how to get around this with out restoring previous versions?
ashleyo wrote
I just upgraded to 5.1.1 and I'm still getting this error.
Module Definitions is still visible in the host menu. Plus Extensions, is not visible.
When upgrading I did get an error: 00:00:00.062 - Executing Script: 05.01.01.SqlDataProvider Error! (See 05.01.01.log for more information).
Here's the log:
System.Data.SqlClient.SqlException: 'DF_Packages_IsSystemPackage' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Fix bug in drop index in 5.0 script - replay failed part of script */
/**********************************************************************/
ALTER TABLE nuke1.Packages DROP CONSTRAINT DF_Packages_IsSystemPackage
CREATE TABLE nuke1.Tmp_Packages
(
PackageID int NOT NULL IDENTITY (1, 1),
PortalID int NULL,
Name nvarchar(128) NOT NULL,
FriendlyName nvarchar(250) NOT NULL,
[Description] nvarchar(2000) NULL,
PackageType nvarchar(100) NOT NULL,
[Version] nvarchar(50) NOT NULL,
License ntext NULL,
Manifest ntext NULL,
[Owner] nvarchar(100) NULL,
Organization nvarchar(100) NULL,
Url nvarchar(250) NULL,
Email nvarchar(100) NULL,
ReleaseNotes ntext NULL,
IsSystemPackage bit NOT NULL,
CreatedByUserID int NULL,
CreatedOnDate datetime NULL,
LastModifiedByUserID int NULL,
LastModifiedOnDate datetime NULL
)
ALTER TABLE nuke1.Tmp_Packages ADD CONSTRAINT DF_Packages_IsSystemPackage DEFAULT ((0)) FOR IsSystemPackage
SET IDENTITY_INSERT nuke1.Tmp_Packages ON
IF EXISTS(SELECT * FROM nuke1.Packages)
EXEC('INSERT INTO nuke1.Tmp_Packages (PackageID, PortalID, Name, FriendlyName, Description, PackageType, Version, License, Manifest, Owner, Organization, Url, Email, ReleaseNotes, IsSystemPackage, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate)
SELECT PackageID, PortalID, Name, FriendlyName, Description, PackageType, Version, License, Manifest, Owner, Organization, Url, Email, ReleaseNotes, IsSystemPackage, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate FROM nuke1.Packages WITH (HOLDLOCK TABLOCKX)')
SET IDENTITY_INSERT nuke1.Tmp_Packages OFF
ALTER TABLE nuke1.Assemblies DROP CONSTRAINT FK_PackageAssemblies_PackageAssemblies
ALTER TABLE nuke1.DesktopModules DROP CONSTRAINT FK_DesktopModules_Packages
ALTER TABLE nuke1.LanguagePacks DROP CONSTRAINT FK_LanguagePacks_Packages
DROP TABLE nuke1.Packages
EXECUTE sp_rename N'nuke1.Tmp_Packages', N'Packages', 'OBJECT'
ALTER TABLE nuke1.Packages ADD CONSTRAINT PK_Packages PRIMARY KEY CLUSTERED ( PackageID )
CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON nuke1.Packages ( Owner, Name, PortalID )
ALTER TABLE nuke1.LanguagePacks ADD CONSTRAINT FK_LanguagePacks_Packages FOREIGN KEY ( PackageID ) REFERENCES nuke1.Packages ( PackageID ) ON UPDATE NO ACTION ON DELETE CASCADE
ALTER TABLE nuke1.DesktopModules WITH NOCHECK ADD CONSTRAINT FK_DesktopModules_Packages FOREIGN KEY ( PackageID ) REFERENCES nuke1.Packages ( PackageID ) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE nuke1.Assemblies ADD CONSTRAINT FK_PackageAssemblies_PackageAssemblies FOREIGN KEY ( PackageID ) REFERENCES nuke1.Packages ( PackageID ) ON UPDATE NO ACTION ON DELETE CASCADE
How can I fix this?