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

Home All Forums

1
2
3
4
5

Home

Getting Started

Installing DNN ...

Error with upgrade 04.09.01 to 05.01.00

7/7/2009 2:03 AM

Catalin Zaharia

www.mindmaster.ro
Joined: 9/8/2005

Posts: 4

Error with upgrade 04.09.01 to 05.01.00

Hi,

I have following issues:

1. site admin

- In admin site settings I cannot change the Advanced settings>page management> defalult login page (I had before upgrade LOGIN XP and now does not work)

- in OTHER SETTINGS> DEFAULT LANGUAGE is missing.

- then I get this error:

Error: Site Settings is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'DefaultLanguage', table 'Mindmaster2.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'DefaultLanguage', table 'Mindmaster2.dbo.Portals'; column does not allow nulls. UPDATE fails. The statement has been terminated. 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory, Int32 lastModifiedByUserID) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory) at DotNetNuke.Modules.Admin.Portals.SiteSettings.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

2. language settings in admin or host is not accesible

Error: Custom Portal Locale is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/Admin/Localization/Languages.ascx' does not exist. ---> System.Web.HttpException: The file '/Admin/Localization/Languages.ascx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

3. SKIN module is not accesible:

Error: Skins is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/Admin/Skins/EditSkins.ascx' does not exist. ---> System.Web.HttpException: The file '/Admin/Skins/EditSkins.ascx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

4. MODULE DEFINITION is not accesible

Error: Module Definitions is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/Admin/ModuleDefinitions/ModuleDefinitions.ascx' does not exist. ---> System.Web.HttpException: The file '/Admin/ModuleDefinitions/ModuleDefinitions.ascx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

5. the upgrade errors are:

Upgrading DotNetNuke

Current Assembly Version: 05.01.00

Current Database Version: 04.09.01

Upgrade Status Report

00:00:00.109 - Upgrading to Version: 05.01.00

00:00:00.249 - Executing Script: 05.00.00.SqlDataProvider

Error! (see 05.00.00.log for more information)

00:00:11.294 - Executing Script: 05.00.01.SqlDataProvider

Success

00:00:19.246 - Executing Script: 05.01.00.SqlDataProvider

Error! (see 05.01.00.log for more information)

00:00:27.135 - Executing Application Upgrades: 05.00.00

Error!

00:00:55.317 - Executing Application Upgrades: 05.00.01

Success

00:00:55.364 - Executing Application Upgrades: 05.01.00

Error!

00:00:55.458 - Cleaning Up Files: 05.00.00

Success

00:00:56.192 - Cleaning Up Files: 05.00.01

Success

00:00:56.255 - Cleaning Up Files: 05.01.00

Success

00:00:56.473 - Updating Config Files: 05.00.00

Success

00:00:56.473 - Updating Config Files: 05.00.01

Success

00:00:56.473 - Updating Config Files: 05.01.00

Success

00:00:56.676 - Performing General Upgrades

00:00:57.036 - Installing Optional Modules:

00:00:57.051 - Installing Package File HTML_Community_05.01.00_Install:

Server Error in '/' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

6. 05.00.00 log error in /providers/dataproviders/sqldataprovider/

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)

7. 05.01.00 log error in /providers/dataproviders/sqldataprovider/

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

Is really important to fix the language problem login redirect.

Thank you.

Catalin

Page 1 of 1

Home

Getting Started

Installing DNN ...

Error with upgrade 04.09.01 to 05.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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Upgrading DotNetNuke

Current Assembly Version: 05.01.00

Current Database Version: 04.09.01

Upgrade Status Report

Server Error in '/' Application.

Runtime Error

DNN Corp. (DotNetNuke)