1

Closed

Can't edit existing news items

description

Tried to edit a news item I just created manually. Got the following constraint error:
 
You cannot add or change a record because a related record is required in table 'Prediction'.
 
System.Data.OleDb.OleDbException: You cannot add or change a record because a related record is required in table 'Prediction'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at controls_forms_NewsForm._update_Click(Object sender, EventArgs e) in d:\virtualservers\theforec\theforecastexchange.com\wwwroot\controls\forms\NewsForm.ascx.cs:line 129 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
If you think this was supposed to work you should contact the administrator and tell him about the bug.
Closed Feb 22, 2009 at 12:10 PM by 1halhag

comments

wrote Feb 22, 2009 at 12:10 PM

Resolved with changeset 25355.

wrote Jun 6, 2009 at 10:03 AM

wrote Jun 6, 2009 at 10:03 AM

wrote Feb 2, 2013 at 1:25 AM

wrote May 8, 2013 at 4:41 PM