Below is the error message. It says "There is already an object named 'Forum_Members_GetByEmail' in the database." but when I checked the database after installation failure, I couldn't find the object Forum_Members_GetByEmail.

Has anyone experienced this before?

Thanks.

Errmsg:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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.TdsParser.ThrowExceptionAndWarning() 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 (0x80131904): 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.TdsParser.ThrowExceptionAndWarning() 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