Problem with forum RSS

• • Reply
  

  kbsdesign

  Member

  2 Points

  18 Posts

  Problem with forum

  Oct 12, 2010 12:42 PM|LINK

  Hi,

  I have some problem with the forum. When im not logged in then its ok. When im logged inn and try to view a thread then i get this error:

  System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MembersThreads_MemberInfo". The conflict occurred in database "kbsdesi_clubDB", table "dbo.MemberInfo", column 'memberid'.
  The statement has been terminated.
  
  Source Error:
  
  

  Line 391: cmd.Parameters.AddWithValue("@memberid", memberid) Line 392: conn.Open() Line 393: cmd.ExecuteNonQuery() Line 394: conn.Close() Line 395: End Using

  
  Source File: D:\hshome\kbsdesign\kbsdesign.web.surftown.nu\App_Code\Forums.vb    Line: 393
  
  Stack Trace:
  
  

  [SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MembersThreads_MemberInfo". The conflict occurred in database "kbsdesi_clubDB", table "dbo.MemberInfo", column 'memberid'. The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137 ClubSiteForums.Forums.MarkThreadRead(Int32 threadid, Guid memberid) in D:\hshome\kbsdesign\kbsdesign.web.surftown.nu\App_Code\Forums.vb:393 ASP.forum_thread_aspx.Page_Load(Object sender, EventArgs e) in D:\hshome\kbsdesign\kbsdesign.web.surftown.nu\Forum\Thread.aspx:80 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627   Anyone know what can be wrong? When i have the site local, everything work. After i put it online i get this error.   I really appreciate all help i can get on this.

• • Reply
  

  aabruzzese

  Contributor

  2806 Points

  759 Posts

  Re: Problem with forum

  Dec 09, 2010 03:42 PM|LINK

  It has been ages since I have last looked at the forum for this project, if I remember Mark had a perfectly working forum for the kit but anyways ther is a page that has plenty of info for this problem as when you google the text you will find it all over the place:

   

  http://norskwebforum.no/viewtopic.php?f=22&t=44014

   

  They have it in non english but there are several code sections with the fix and how to apply it for each page invovled.

   

   

  AngeloA