Hi,
Sometime (only sometimes) when someone sends a private message to another member they get the following error. Does anyone know how to fix this? The message is sent, even if the error occurs. Using DNN 04.07.00 and forums 04.04.03.
ModuleId: 370
ModuleDefId: 96
FriendlyName: Send Private Message
ModuleControlSource: DesktopModules/Forum/Forum_PMAdd.ascx
AssemblyVersion: 04.07.00
PortalID: 0
PortalName: Beauty Swap Shop – the UK’s first and only specialist beauty exchange website
UserID: 15
UserName: Fi
ActiveTabID: 54
ActiveTabName: Forum
RawURL: /Forum/tabid/54/ctl/PMAdd/mid/370/pmid/1722/pmaction/reply/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.beautyswapshop.co.uk/Forum/tabid/54/ctl/PMAdd/mid/370/pmid/1722/pmaction/reply/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 6f1c531f-2533-462e-93a3-9faeac6e76c4
InnerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "beautyswapshop", table "dbo.Modules", column 'ModuleID'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "beautyswapshop", table "dbo.Modules", column 'ModuleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "beautyswapshop", table "dbo.Modules", column 'ModuleID'. 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at DotNetNuke.Entities.Modules.ModuleController.UpdateModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at DotNetNuke.Modules.Forum.ForumPreConfig.PreConfig(Int32 ModuleId, Int32 PortalId, Int32 UserId) at DotNetNuke.Modules.Forum.Config..ctor(Int32 ModuleID) at DotNetNuke.Modules.Forum.Config.GetForumConfig(Int32 ModuleID) at DotNetNuke.Modules.Forum.ForumUser..ctor(Int32 ModuleId) at DotNetNuke.Modules.Forum.ForumUserController.UserGet(Int32 PortalID, Int32 UserId, Int32 ModuleID) at DotNetNuke.Modules.Forum.ForumUserController.GetForumUser(Int32 UserID, Boolean UpdateLastVisit, Int32 ModuleID) at DotNetNuke.Modules.Forum.ForumEmail.RenderKeywords(Hashtable Keywords, Object objInfo, ForumContentTypeID ContentType, String PostUrl, String ProfileUrl, String Notes) at DotNetNuke.Modules.Forum.ForumEmail.GenerateEmail(String Notes, ForumEmailType emailType, Int32 ContentID, Config ForumConfig, String URL, String ProfileURL, Int32 PortalID) at DotNetNuke.Modules.Forum.Utils.SendForumMail(Int32 ContentID, String URL, ForumEmailType EmailType, String Notes, Config ForumConfig, String ProfileURL, Int32 PortalID) at DotNetNuke.Modules.Forum.PMAdd.PostToDatabase() --- End of inner exception stack trace ---
Source:
Server Name: GENERIC09
Any help would be much appreciated.
Anna