This is the error log: 05.01.01.log.  ewa_ is my db prefix.

Does this pose a problem?  The site seem to operate fine.  Sould I restore the previous version?

the site is www.enjoythisworld.com

Thanks,

Bertus Viljoen

SqlClient.SqlException: Could not drop object 'dbo.ewa_Packages' because it is referenced by a FOREIGN KEY constraint.
Error: The new name 'ewa_Packages' is already in use as a OBJECT name and would cause a duplicate that is not permitted.
Table 'ewa_Packages' already has a primary key defined on it.
Could not create 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 dbo.ewa_Packages DROP CONSTRAINT DF_ewa_Packages_IsSystemPackage

CREATE TABLE dbo.Tmp_ewa_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 dbo.Tmp_ewa_Packages ADD CONSTRAINT DF_ewa_Packages_IsSystemPackage DEFAULT ((0)) FOR IsSystemPackage

SET IDENTITY_INSERT dbo.Tmp_ewa_Packages ON

IF EXISTS(SELECT * FROM dbo.ewa_Packages)
     EXEC('INSERT INTO dbo.Tmp_ewa_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 dbo.ewa_Packages WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_ewa_Packages OFF

ALTER TABLE dbo.ewa_Assemblies DROP CONSTRAINT FK_ewa_PackageAssemblies_PackageAssemblies

ALTER TABLE dbo.ewa_DesktopModules DROP CONSTRAINT FK_ewa_DesktopModules_ewa_Packages

ALTER TABLE dbo.ewa_LanguagePacks DROP CONSTRAINT FK_ewa_LanguagePacks_ewa_Packages

DROP TABLE dbo.ewa_Packages

EXECUTE sp_rename N'dbo.Tmp_ewa_Packages', N'ewa_Packages', 'OBJECT'

ALTER TABLE dbo.ewa_Packages ADD CONSTRAINT PK_ewa_Packages PRIMARY KEY CLUSTERED ( PackageID )

CREATE UNIQUE NONCLUSTERED INDEX IX_ewa_Packages ON dbo.ewa_Packages ( Owner, Name, PortalID )

ALTER TABLE dbo.ewa_LanguagePacks ADD CONSTRAINT FK_ewa_LanguagePacks_ewa_Packages FOREIGN KEY ( PackageID ) REFERENCES dbo.ewa_Packages ( PackageID ) ON UPDATE  NO ACTION ON DELETE  CASCADE
   
ALTER TABLE dbo.ewa_DesktopModules WITH NOCHECK ADD CONSTRAINT FK_ewa_DesktopModules_ewa_Packages FOREIGN KEY ( PackageID ) REFERENCES dbo.ewa_Packages ( PackageID ) ON UPDATE  CASCADE ON DELETE  CASCADE

ALTER TABLE dbo.ewa_Assemblies ADD CONSTRAINT FK_ewa_PackageAssemblies_PackageAssemblies FOREIGN KEY ( PackageID ) REFERENCES dbo.ewa_Packages ( PackageID ) ON UPDATE  NO ACTION ON DELETE  CASCADE