Register   Login
     
  Latest Posts  
RE: Toolbar links at the top of the articles module
by wassis on 1/08/2009 12:59 PM
RE: Site hanging when posting comments
by smcculloch on 1/08/2009 12:10 PM
RE: Site hanging when posting comments
by smcculloch on 1/08/2009 12:00 PM
RE: Site hanging when posting comments
by glenwin on 1/08/2009 11:21 AM
RE: Layout Settings: Listing View
by smcculloch on 1/08/2009 10:36 AM
RE: Lightbox implementation
by smcculloch on 1/08/2009 10:35 AM
RE: 4.9.0 and 5.0.0 with Simple gallery
by smcculloch on 1/08/2009 10:34 AM
RE: Site hanging when posting comments
by smcculloch on 1/08/2009 10:33 AM
RE: Ligtbox effect does not working in DNN 5
by smcculloch on 1/08/2009 10:33 AM
Site hanging when posting comments
by glenwin on 1/08/2009 10:22 AM
  Forums  
Subject: Can't Delete an Article - Error Attached
Prev Next
You are not authorized to post a reply.

Author Messages
Jack HoelzUser is Offline
Gold Membership
Nuke Master
Nuke Master
Posts:815


3/02/2005 6:10 AM  
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_DnnForge_NewsArticles_ArticleCategories_DnnForge_NewsArticles_Article'. The conflict occurred in database 'beta', table 'DnnForge_NewsArticles_ArticleCategories', column 'ArticleID'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_DnnForge_NewsArticles_ArticleCategories_DnnForge_NewsArticles_Article'. The conflict occurred in database 'beta', table 'DnnForge_NewsArticles_ArticleCategories', column 'ArticleID'. The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_DnnForge_NewsArticles_ArticleCategories_DnnForge_NewsArticles_Article'. The conflict occurred in database 'beta', table 'DnnForge_NewsArticles_ArticleCategories', column 'ArticleID'.
The statement has been terminated.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
DnnForge.NewsArticles.SqlDataProvider.DeleteArticle(Int32 articleID)
DnnForge.NewsArticles.ArticleController.DeleteArticle(Int32 articleID)
DnnForge.NewsArticles.ucSubmitNews.lnkDelete_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1292

[PageLoadException: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_DnnForge_NewsArticles_ArticleCategories_DnnForge_NewsArticles_Article'. The conflict occurred in database 'beta', table 'DnnForge_NewsArticles_ArticleCategories', column 'ArticleID'.
The statement has been terminated.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +346
DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e) +361
System.Web.UI.TemplateControl.OnError(EventArgs e) +109
System.Web.UI.Page.HandleError(Exception e) +68
System.Web.UI.Page.ProcessRequestMain() +2100
System.Web.UI.Page.ProcessRequest() +218
System.Web.UI.Page.ProcessRequest(HttpContext context) +18
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87



Get The Net!!

Jack Hoelz
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12807


3/02/2005 12:58 PM  
Thanks for the report - I know what this one is, and will resolve it ASAP.

Scott McCulloch
Site Administrator
You are not authorized to post a reply.
Forums > Modules > News Articles > Can't Delete an Article - Error Attached



ActiveForums 3.7