Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade Error 4.09.0 to 5.01.00Upgrade Error 4.09.0 to 5.01.00
Previous
 
Next
New Post
8/1/2009 4:50 PM
 

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
********************************************************************************************************************


 

 


 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade Error 4.09.0 to 5.01.00Upgrade Error 4.09.0 to 5.01.00


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out