Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Forum Module [L...  Problems with Private Messaging: The INSERT statement conflicted with the FOREIGN KEY
Previous Previous
 
Next Next
New Post 11/1/2007 3:15 PM
Unresolved
User is offline yellokat
24 posts
10th Ranked


Problems with Private Messaging: The INSERT statement conflicted with the FOREIGN KEY 

Hi.

Interesting situation - User 1 complained about not being able to send a PM  to another User2.  User1 has also successfully sent several private messages to host and User3.  User3 has no issues with sending PMs to either host or other users and no other complaints have been received.  Below is the error from the view log.  What do I do?

ModuleId: 546
ModuleDefId: 105
FriendlyName: Send Private Message
ModuleControlSource: DesktopModules/Forum/Forum_PMAdd.ascx
AssemblyVersion: 04.06.02
PortalID: 0
PortalName: LinguaPlay
UserID: 52
UserName: Vika
ActiveTabID: 124
ActiveTabName: Форум
RawURL: /Главная/Форум/tabid/124/ctl/PMAdd/mid/546/userid/54/language/en-US/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.linguaplay.co.uk/%D0%93%D0%BB%D0%B0%D0%B2%D0%BD%D0%B0%D1%8F/%D0%A4%D0%BE%D1%80%D1%83%D0%BC/tabid/124/ctl/PMAdd/mid/546/userid/54/language/en-US/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Supplied by blueyonder; SV1)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2780d0ea-2ce2-49a0-817d-9bc8047ba119
InnerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dnn_ModuleSettings_dnn_Modules". The conflict occurred in database "linguaplay", table "dbo.dnn_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_dnn_ModuleSettings_dnn_Modules". The conflict occurred in database "linguaplay", table "dbo.dnn_Modules", column 'ModuleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dnn_ModuleSettings_dnn_Modules". The conflict occurred in database "linguaplay", table "dbo.dnn_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 ---

 
New Post 11/5/2007 1:02 AM
User is offline Crispy
3424 posts
www.apptheory.com
4th Ranked










Re: Problems with Private Messaging: The INSERT statement conflicted with the FOREIGN KEY 

The time User1 had an error, how did he or she reach the Add PM Page? The only reason that error would happen is if the ForumConfiguration is not set (which stores all the module settings) and it tries to re-add itself. This should only happen in very very rare cases and I admit there should be better error trapping. Did the user come directly to the send message page? Did the user try sending another message to User2? Does User2 have PM enabled?

 



 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Forum Module [L...  Problems with Private Messaging: The INSERT statement conflicted with the FOREIGN KEY
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com
Jetkey Smart Map
Smart Map is an AJAX powered Google Map module that displays driving directions, proximity search results and data from your own databases. Smart Map reads GPX (GPS data) files, GeoRSS feeds, and KML data. You can pass any querystring parameter to Smart Map and into your own custom queries to control what data displays on the map.
smartmap.jetkey.com
DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP