My install error is a bit different. I'm upgrading from Forum 4.4.3 to 5.0.1. I tried to search for my particular error, but can't seem to find anything. Looking at this and the other mentioned posts, it doesn't address my problem. One of the other post that I read is to uninstall the existing forum module and delete the forum tables, procedures, etc, and do a reinstall. If I do that, wouldn't I lose all existing forum data? I would rather hang on to the current data if possible. Thx for any help in advance.
| StartJob |
Starting Installation |
| Info |
Starting Installation - DNN_Forum |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version -
04.04.04.SqlDataProvider |
| Info |
Created - 04.04.04.SqlDataProvider |
| Info |
Executing 04.04.04.SqlDataProvider |
| Info |
Start Sql execution: 04.04.04.SqlDataProvider file |
SQL Execution resulted in following Exceptions:
System.Data.SqlClient.SqlException: Column names in each table must be unique.
Column name 'EnableSelfNotifications' in table 'dbo.Forum_Users' is specified
more than once. at System.Data.SqlClient.SqlConnection. (SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection. (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) ALTER TABLE dbo.[Forum_Users] WITH NOCHECK ADD
[EnableSelfNotifications] [BIT] DEFAULT (1) NOT NULL
System.Data.SqlClient.SqlException: Column names in each table must be unique.
Column name 'EnableProfileWeb' in table 'dbo.Forum_Users' is specified more than
once. at System.Data.SqlClient.SqlConnection. (SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection. (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) ALTER TABLE dbo.[Forum_Users] WITH NOCHECK ADD
[EnableProfileWeb] [BIT] DEFAULT (1) NOT NULL
System.Data.SqlClient.SqlException: Column names in each table must be unique.
Column name 'EnableDefaultPostNotify' in table 'dbo.Forum_Users' is specified
more than once. at System.Data.SqlClient.SqlConnection. (SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection. (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) ALTER TABLE dbo.[Forum_Users] WITH NOCHECK ADD
[EnableDefaultPostNotify] [BIT] DEFAULT (1) NOT NULL
System.Data.SqlClient.SqlException: There is already an object named
'Forum_Members_GetByEmail' in the database. at
System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection. (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.[Forum_Members_GetByEmail] @PortalId INT,
@EmailToMatch NVARCHAR(256), @PageIndex INT, @PageSize INT AS BEGIN -- Set the
page bounds DECLARE @PageLowerBound INT DECLARE @PageUpperBound INT SET
@PageLowerBound = @PageSize * @PageIndex SET @PageUpperBound = @PageSize - 1 +
@PageLowerBound -- Create a temp table TO store the select results CREATE TABLE
#PageIndexForUsers ( IndexId INT IDENTITY(0, 1) NOT NULL, UserId INT ) -- Insert
into our temp table IF ( @EmailToMatch IS NULL ) INSERT INTO #PageIndexForUsers
( UserId ) SELECT UserId FROM dbo.Forum_vw_ForumUsers WHERE Email IS NULL AND (
PortalId = @PortalId OR ( PortalId IS NULL AND @PortalId IS NULL ) ) ORDER BY
Email ELSE INSERT INTO #PageIndexForUsers ( UserId ) SELECT UserId FROM
dbo.Forum_vw_ForumUsers WHERE LOWER(Email) LIKE LOWER(@EmailToMatch) AND (
PortalId = @PortalId OR ( PortalId IS NULL AND @PortalId IS NULL ) ) ORDER BY
Email SELECT U.[UserID], [PostCount], [EnableDisplayInMemberList],
[EnableOnlineStatus], [EnablePM], [PortalID], [FirstName], [LastName], [Email],
[Username], [PostCount], ( SELECT COUNT(UserID) FROM dbo.Forum_vw_ForumUsers )
AS TotalRecords FROM dbo.Forum_vw_ForumUsers U INNER JOIN #PageIndexForUsers P
ON U.UserID = P.UserID WHERE ( PortalId = @PortalId OR ( PortalId IS NULL AND
@PortalId IS NULL ) ) AND P.IndexId >= @PageLowerBound AND P.IndexId <=
@PageUpperBound ORDER BY LOWER(U.Email) END System.Data.SqlClient.SqlException:
There is already an object named 'Forum_Members_GetOnline' in the database. at
System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection. (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.[Forum_Members_GetOnline] @PortalID INT AS
SELECT U.[UserID], [PostCount], [EnableDisplayInMemberList],
[EnableOnlineStatus], [EnablePM], U.[PortalID], [FirstName], [LastName],
[Email], [Username], [PostCount], ( SELECT COUNT(UserID) FROM
dbo.Forum_vw_ForumUsers ) AS TotalRecords FROM dbo.UsersOnline UO INNER JOIN
dbo.Forum_vw_ForumUsers U ON UO.UserID = U.UserID WHERE U.PortalID = @PortalID