Here are the steps :
1.Clean install with version 1.0.1987.0.1 then,
2. Create and edit categories under Default Category with the following setting :
|__CATEGORY A : is active : yes
|__Sub-category 1 : is active : yes
|__Sub-category 2 : is active : NO
|__Sub-category 3 : is active : NO
|__Sub-category 4 : is active : yes
A. In back-end : the category name (sub-category 2 and 3) are not displayed in light gray in the category tree
B. In front-end : the category name (sub-category 2 and 3) are not displayed but there’s a blank space in the navigation bar (see image attached 1.0.1987.0.1)
I tried exactly the same settings with version 1.0 and everything works fine (as you can see in image attached 1.0)
In the database :
A. the value of the is_active field in table ‘catalog_category_entity’ is always set to 1 (for all the categories even the 2 and the 3, and although in the admin panel the default value is no (?) )
B. in the table ‘catalog_category_entity_int’ I found, for each category, a row related to attribute_id 23 set to ‘0’ when the category is supposed to be not active an ‘1’ in the other case . This row does not appear in version 1.0.
Of course if I change this value from 0 to 1 in phpmyadmin the category name is displayed normally in the front-end. And also by setting the is_active field in table ‘catalog_category_entity’ 1 to 0 the category this category is not visible on the front end and ame is displayed as light gray in the category tree in the admin panel.
It’es very easy to verify the problem. Please tell me if it doesn’t occur in your environment.
PS : you can see the same problem in the demo admin panel of magento : http://demo-admin.magentocommerce.com/ running version 1.0.19700 . If you try to declare a category to be not active it will not change the dysplay in the category tree (name not dysplayed in light gray)
PS2 : I hope I will be understood even with my lamentable english ...I try to learn reading Agatha Christie’s books and listening american songs…
Click thumbnail to see full-size image