Cathal,Thanks for the advice. I did all the checks and tried again, but received the following message:StartJob Starting Installation Info Starting Installation - DNN_Forum Info Starting Installation - Script Info Begin Sql execution Info Folder Created - C:\Users\Administrateur\Documents\My Web Sites\HereIsHow\DesktopModules\Forum\Providers\DataProviders\SqlDataProvider\ Info Created - 03.00.00.SqlDataProvider Info Executing 03.00.00.SqlDataProvider Info Start Sql execution: 03.00.00.SqlDataProvider file Info End Sql execution: 03.00.00.SqlDataProvider file Info Created - 03.10.05.SqlDataProvider Info Executing 03.10.05.SqlDataProvider Info Start Sql execution: 03.10.05.SqlDataProvider file Info End Sql execution: 03.10.05.SqlDataProvider file Info Created - 04.03.00.SqlDataProvider Info Executing 04.03.00.SqlDataProvider Info Start Sql execution: 04.03.00.SqlDataProvider file Info End Sql execution: 04.03.00.SqlDataProvider file Info Created - 04.03.04.SqlDataProvider Info Executing 04.03.04.SqlDataProvider Info Start Sql execution: 04.03.04.SqlDataProvider file Info End Sql execution: 04.03.04.SqlDataProvider file Info Created - 04.04.03.SqlDataProvider Info Executing 04.04.03.SqlDataProvider Info Start Sql execution: 04.04.03.SqlDataProvider file Info End Sql execution: 04.04.03.SqlDataProvider file Info Created - 04.04.04.SqlDataProvider Info Executing 04.04.04.SqlDataProvider Info Start Sql execution: 04.04.04.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Il existe déjà un objet nommé 'Forum_Members_GetByEmail' dans la base de données. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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): Il existe déjà un objet nommé 'Forum_Members_GetOnline' dans la base de données. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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 Info End Sql execution: 04.04.04.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - DNN_Forum Info Deleted temporary install folder EndJob Installation Failed Any idea what still causes the problem ?
|