Matthias,
Thanks for your reply. Unfortunately, I am still experiencing problems.
I ran the statement in the Pinned thread without errors. When I then attempted to to delete a post (using the Host account), this is the error message that was displayed:
Error: Delete Post is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The parameter 'to' cannot be an empty string. Parameter name: to ---> System.ArgumentException: The parameter 'to' cannot be an empty string. Parameter name: to at System.Net.Mail.MailMessage..ctor(String from, String to) at DotNetNuke.Services.Mail.Mail.SendMail(String MailFrom, String MailTo, String Cc, String Bcc, MailPriority Priority, String Subject, Mailformat Bodyformat, Encoding BodyEncoding, String Body, String Attachment, String SMTPServer, String SMTPAuthentication, String SMTPUsername, String SMTPPassword, Boolean SMTPEnableSSL) at DotNetNuke.Services.Mail.Mail.SendMail(String MailFrom, String MailTo, String Cc, String Bcc, MailPriority Priority, String Subject, Mailformat Bodyformat, Encoding BodyEncoding, String Body, String Attachment, String SMTPServer, String SMTPAuthentication, String SMTPUsername, String SMTPPassword) at DotNetNuke.Services.Mail.Mail.SendMail(String MailFrom, String MailTo, String Bcc, String Subject, String Body, String Attachment, String BodyType, String SMTPServer, String SMTPAuthentication, String SMTPUsername, String SMTPPassword) at DotNetNuke.Modules.Forum.Utils.SendForumMail(Int32 ContentID, String URL, ForumEmailType EmailType, String Notes, Config ForumConfig, String ProfileURL, Int32 PortalID) at DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
I then tried to run the statement in your 2nd solution, and got this error:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'. Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'. The statement has been terminated. 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.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) DECLARE @ModuleDefID int SELECT @ModuleDefID = ModuleDefID FROM ModuleDefinitions WHERE FriendlyName = 'Forum' INSERT INTO Permission(PermissionCode, ModuleDefID, PermissionKey, PermissionName) VALUES('FORUM_MODULE',@ModuleDefID,'FORUMADMIN','Forum Administrator') INSERT INTO Permission(PermissionCode, ModuleDefID, PermissionKey, PermissionName) VALUES('FORUM_MODULE',@ModuleDefID,'FORUMGLBMOD','Global Moderator')
I would appreciate any futher thoughts you might have on how to resolve this issue. Thanks again!