Hello,
in these days I'm testing Forum module. All worked fine. Today I changed the group name (1 group 4 child forum). After this operation, if I delete a thread, an sql error occurs. I tried more and more times. The only way to avoid the error is to restore the original name group. Anyway the threads are deleted, but the counter of thread/posts is not updated. This is the SQL error:
ModuleId: 581
ModuleDefId: 121
FriendlyName:
ModuleControlSource: DesktopModules/Forum/Forum_PostDelete.ascx
AssemblyVersion: 5.1.4
PortalID: 3
PortalName: XXXXX
UserID: 1
UserName: host
ActiveTabID: 194
ActiveTabName: Forum
RawURL: /Forum/tabid/194/ctl/PostDelete/mid/581/forumid/5/postid/4/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.XXXXX.it/Forum/tabid/194/ctl/PostDelete/mid/581/forumid/5/postid/4/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.1.10) Gecko/20100504 Firefox/3.5.10 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: d22172b5-d675-447c-a410-f1eb5353b3d2
InnerException: L'istruzione UPDATE ha generato un conflitto con il vincolo COLUMN FOREIGN KEY 'FK_Forum_Posts_Forum_Threads' nel database 'Federsim', tabella 'Forum_Threads', column 'ThreadID'. L'istruzione è stata interrotta.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: L'istruzione UPDATE ha generato un conflitto con il vincolo COLUMN FOREIGN KEY 'FK_Forum_Posts_Forum_Threads' nel database 'Federsim', tabella 'Forum_Threads', column 'ThreadID'. L'istruzione è stata interrotta. ---> System.Data.SqlClient.SqlException: L'istruzione UPDATE ha generato un conflitto con il vincolo COLUMN FOREIGN KEY 'FK_Forum_Posts_Forum_Threads' nel database 'Federsim', tabella 'Forum_Threads', column 'ThreadID'. L'istruzione è stata interrotta. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) in System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) in DotNetNuke.Modules.Forum.SqlDataProvider.PostDelete(Int32 PostID, Int32 ModID, String Notes, Int32 PortalID) in DotNetNuke.Modules.Forum.PostController.PostDelete(Int32 PostID, Int32 ModeratorID, String Notes, Int32 PortalID, Int32 GroupID, Boolean DeleteThread, Int32 ParentID) in DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) --- Fine dell'analisi dello stack dell'eccezione interna ---
What operations I can do in order to restore the normal behaviour?
|