in

dashCommerce

An ASP.NET Open Source e-Commerce Application

Deleting Category

Last post 06-25-2008 8:40 PM by theonlylawislove. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-25-2008 11:30 AM

    Deleting Category

    This happens when I try to delete a category.  Any ideas?

     A critical error has occurred: The DELETE statement conflicted with the REFERENCE constraint "FK_dashCommerce_Products_Categories_dashCommerce_ProductCategories". The conflict occurred in database "datakno_HarrisGolf", table "dbo.dashCommerce_Store_Product_Category_Map", column 'CategoryId'. The statement has been terminated.

  • 06-25-2008 2:02 PM In reply to

    Re: Deleting Category

    You've got products linked to that category, which is the foreign key constraint you are encountering.

    --
    Support dashCommerce - Buy Our Stuff!!


    Find a bug? Create a Work Item for a fast response.. Want to help? Create a patch for us! Documentation? Help us write some!
    Filed under:
  • 06-25-2008 2:25 PM In reply to

    Re: Deleting Category

    But I deleted the product.  Or is the product not actually deleted because it says "isdelete / true"...

     I removed the category from the "deleted" product and it's working.  Is there a way through the GUI to actually delete a product?

  • 06-25-2008 8:40 PM In reply to

    Re: Deleting Category

    No. It is not deleted. The application just interprets the product as deleted.

    This restraint is held at the DB level. Therfore, the db entry must be deleted.

    Delete the product manually in your DB. You may find more restraints keeping you from doing that, like inventory and descriptors.

    ~Paul
Page 1 of 1 (4 items)