Magento 1.5. After deleting product in admin section, category's products count doesn't decrease

Is this a known bug ( can someone give a link )? How t开发者_StackOverflow中文版o fix it?

What category count are you talking about? In layered navigation on the front end? In the category tree in the admin? Was it a simple or configurable product that you deleted? I assume you are on 1.5.1.0?

I don't see anything similar to this. You can search the Magento Bug Tracker here: http://www.magentocommerce.com/bug-tracking

Yes, I found the solution: Take a backup of your database first and then run this query

DELETE FROM catalog_category_product where product_id NOT IN (SELECT entity_id FROM (catalog_product_entity))