If someone could help and guide me through this I would appreciate. My last backup goes to DNN 3.2.2 so if I can avoid to do a restore I would be great (that will teach me to do a backup between all my upgrades). Below you can find the Installation results and error logs. Btw dont know if this can be the source of the problem but I am using SQL Serveur 2000, so maybe the script was written for 2005 or 2008?
Thanks
Error message received while running the upgrade:
********************************************************************************************************************
00:00:00.046 - Upgrading to Version: 05.01.00
00:00:00.093 - Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:05.578 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:06.140 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:42.015 - Executing Application Upgrades: 05.00.00 Error!
00:00:59.515 - Executing Application Upgrades: 05.00.01 Success
00:00:59.546 - Executing Application Upgrades: 05.01.00 Error!
00:00:59.781 - Cleaning Up Files: 05.00.00 Success
00:01:00.984 - Cleaning Up Files: 05.00.01 Success
00:01:02.265 - Cleaning Up Files: 05.01.00 Success
00:01:03.468 - Updating Config Files: 05.00.00 Success
00:01:03.468 - Updating Config Files: 05.00.01 Success
00:01:03.468 - Updating Config Files: 05.01.00 Success
00:01:03.468 - Performing General Upgrades
00:01:03.843 - Installing Optional Modules:
00:01:03.859 - Installing Package File HTML_Community_05.01.00_Install:
********************************************************************************************************************
********************************************************************************************************************
The log 5.00.00.log:
********************************************************************************************************************
System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
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)
/***********************************************************/
/* End Update Admin Modules to conform to Module Standards */
/***********************************************************/
/* Update Packages */
/*******************/
ALTER TABLE dbo.Packages
ADD PortalID int NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Description nvarchar(2000) NULL
ALTER TABLE dbo.Packages
ALTER COLUMN License ntext NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Manifest ntext NULL
ALTER TABLE dbo.Packages
ADD Owner nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Organization nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Url nvarchar(250) NULL
ALTER TABLE dbo.Packages
ADD Email nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD ReleaseNotes ntext NULL
ALTER TABLE dbo.Packages
ADD IsSystemPackage bit NOT NULL CONSTRAINT DF_Packages_IsSystemPackage DEFAULT 0
DROP INDEX IX_Packages ON dbo.Packages
CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON dbo.Packages ( Owner, Name, PortalID )
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[AddPackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
INSERT INTO dbo.Packages
(
PortalID,
[Name],
FriendlyName,
[Description],
PackageType,
Version,
License,
Manifest,
ReleaseNotes,
[Owner],
Organization,
Url,
Email,
IsSystemPackage
)
VALUES (
@PortalID,
@Name,
@FriendlyName,
@Description,
@PackageType,
@Version,
@License,
@Manifest,
@ReleaseNotes,
@Owner,
@Organization,
@Url,
@Email,
@IsSystemPackage
)
SELECT SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[UpdatePackage]
@PortalID int,
@Name nvarchar(50),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit
AS
UPDATE dbo.Packages
SET
PortalID = @PortalID,
FriendlyName = @FriendlyName,
[Description] = @Description,
PackageType = @PackageType,
Version = @Version,
License = @License,
Manifest = @Manifest,
[Owner] = @Owner,
Organization = @Organization,
Url = @Url,
Email = @Email,
ReleaseNotes = @ReleaseNotes,
IsSystemPackage = @IsSystemPackage
WHERE [Name] = @Name
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[GetPackages]
@PortalID int
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
ORDER BY PackageType ASC, [FriendlyName] ASC
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[GetPackagesByType]
@PortalID int,
@PackageType nvarchar(50)
AS
SELECT *
FROM dbo.Packages
WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
AND PackageType = @PackageType
ORDER BY [FriendlyName] ASC
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.GetPackageByName
@PortalID int,
@Name nvarchar(250)
AS
SELECT *
FROM dbo.Packages
WHERE [Name] = @Name
AND (PortalID = @PortalID OR @PortalID IS NULL)
********************************************************************************************************************
********************************************************************************************************************
The log 5.01.00.log:
********************************************************************************************************************
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[AddPackage]
@PortalID int,
@Name nvarchar(128),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit,
@CreatedByUserID int
AS
INSERT INTO dbo.Packages
(
PortalID,
[Name],
FriendlyName,
[Description],
PackageType,
Version,
License,
Manifest,
ReleaseNotes,
[Owner],
Organization,
Url,
Email,
IsSystemPackage,
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate]
)
VALUES (
@PortalID,
@Name,
@FriendlyName,
@Description,
@PackageType,
@Version,
@License,
@Manifest,
@ReleaseNotes,
@Owner,
@Organization,
@Url,
@Email,
@IsSystemPackage,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
)
SELECT SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[UpdatePackage]
@PortalID int,
@Name nvarchar(128),
@FriendlyName nvarchar(250),
@Description nvarchar(2000),
@PackageType nvarchar(50),
@Version nvarchar(50),
@License ntext,
@Manifest ntext,
@Owner nvarchar(100),
@Organization nvarchar(100),
@Url nvarchar(250),
@Email nvarchar(100),
@ReleaseNotes ntext,
@IsSystemPackage bit,
@LastModifiedByUserID int
AS
UPDATE dbo.Packages
SET
PortalID = @PortalID,
FriendlyName = @FriendlyName,
[Description] = @Description,
PackageType = @PackageType,
Version = @Version,
License = @License,
Manifest = @Manifest,
[Owner] = @Owner,
Organization = @Organization,
Url = @Url,
Email = @Email,
ReleaseNotes = @ReleaseNotes,
IsSystemPackage = @IsSystemPackage,
[LastModifiedByUserID] = @LastModifiedByUserID, [LastModifiedOnDate] = getdate()
WHERE [Name] = @Name
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
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)
CREATE PROCEDURE dbo.[GetPackageByName]
@PortalID int,
@Name nvarchar(128)
AS
SELECT *
FROM dbo.Packages
WHERE [Name] = @Name
AND (PortalID = @PortalID OR @PortalID IS NULL)
System.Data.SqlClient.SqlException: Table 'EventLog' 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)
/* Change primary key of EventLog Table */
/****************************************/
IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
--Note this name does NOT have an object qualifier in 4.x upgrades
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
--Note this name does have an object qualifier in 5.x installs
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
ALTER TABLE dbo.EventLog
ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END
********************************************************************************************************************