jonny72 Posted October 26, 2010 Share Posted October 26, 2010 Hi,I am getting the following error message when trying to delete a category"an error occurred during deletion"I assume there is a problem with the database but have no idea how to fix it,Can anyone help please ! Link to comment Share on other sites More sharing options...
MrBaseball34 Posted October 26, 2010 Share Posted October 26, 2010 Well, I certainly don't think it would be a referential integrity issue because we know that PS enforces it...NOT!!!There could be a number of reasons that this is happening.Do you still have products in the category? What version are you using? Link to comment Share on other sites More sharing options...
MrBaseball34 Posted October 26, 2010 Share Posted October 26, 2010 Here's a very good article on the subject. http://www.databasejournal.com/features/mysql/article.php/2248101/Referential-Integrity-in-MySQL.htmI can't understand why they would not configure such a system without referential integrity.I do know that it would solve the old customer 0 problem that rears it's head every now and then and also keep the phantom carts from appearing.They should also be using transactions for tons of things but I know there is not one single transaction in the whole system. Link to comment Share on other sites More sharing options...
jonny72 Posted October 26, 2010 Author Share Posted October 26, 2010 hi, thanksthe version is 3.1.1there is three levels of sub-category but no products, the subcategories do not show on the BO Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts