More in this section

Forums / Developing with Sitefinity / Comments delete

Comments delete

1 posts, 0 answered
  1. Pravat
    Pravat avatar
    59 posts
    Registered:
    22 Jun 2010
    08 Aug 2012
    Link to this post
    Hi Team,
                 I am using site 4.0. When i try to delete unwanted comments, i am getting following error. Please guide me how to delete the comment?

    Thanks & Regards,
    Pravat Sharma
    0 item(s) are successfully deleted. 1 item(s) cannot be deleted (see below).
    Content Item : Delete failed: Telerik.OpenAccess.RT.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "ref_sf_blg_psts_sf_cmmnt_sf_cm". The conflict occurred in database "shellmena", table "dbo.sf_blog_posts_sf_commnt", column 'content_id2'.
    The statement has been terminated.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
       at penAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql) Row: GenericOID@95807c36 Comment content_id=eb6f3d57-eaef-46f6-9170-9471211c9959
    DELETE FROM [sf_commnt] WHERE [content_id] = ?
    (set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "ref_sf_blg_psts_sf_cmmnt_sf_cm". The conflict occurred in database "shellmena", table "dbo.sf_blog_posts_sf_commnt", column 'content_id2'.

    The statement has been terminated.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()   at OpenAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql)
1 posts, 0 answered