I had a slightly different idea, but had to reload the page because my token had expired.Sounds like the product may have in some way been linked to category 17 and in deletion the master_categories_id did not get properly reassigned. Two ways I can think of correcting this, though probably could come up with several.The first (though I don't think best) was to create a new category and then reassign the categories_id to 17. Then properly delete the product. In a way this touches the database more than it should especially with the reassignment to a previously existing number.The other is to run a query reassigning the master_categories_id for those having 17 to reassign them to some existing category (even if that category is made just for this purpose).The sql to reassign the identified product to another category (27 picked for discussion) is:
Code:
UPDATE products SET master_categories_id = 27 WHERE master_categories = 17;
Though DrByte's method seems like it could be "easier" to an extent. My thought with the product being assigned to a category (preferably of its own) was that I thought an option was offered when deleting a category to also delete all of the product in it...
Bookmarks