Magento category thumbnail field not shown in admin

Question

I installed Magento 1.9.1.0 without sample data, but there is no thumbnail field in the admin panel, adding or editing a category page. How to show thumbnail stored in admin for a category?

Answer 1

I solve this problem by running the following requests in my phpMyAdmin,

one)

INSERT INTO `eav_attribute` (`attribute_id`, `entity_type_id`, `attribute_code`, `attribute_model`, `backend_model`, `backend_type`, `backend_table`, `frontend_model`, `frontend_input`, `frontend_label`, `frontend_class`, `source_model`, `is_required`, `is_user_defined`, `default_value`, `is_unique`, `note`) VALUES(140, 3, 'thumbnail', NULL, 'catalog/category_attribute_backend_image', 'varchar', NULL, NULL, 'image', 'Thumbnail Image', NULL, NULL, 0, 0, NULL, 0, NULL); 

2)

  INSERT INTO `catalog_eav_attribute` (`attribute_id`, `frontend_input_renderer`, `is_global`, `is_visible`, `is_searchable`, `is_filterable`, `is_comparable`, `is_visible_on_front`, `is_html_allowed_on_front`, `is_used_for_price_rules`, `is_filterable_in_search`, `used_in_product_listing`, `used_for_sort_by`, `is_configurable`, `apply_to`, `is_visible_in_advanced_search`, `position`, `is_wysiwyg_enabled`, `is_used_for_promo_rules`) VALUES (140, NULL, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 0, 0, 0, 0); 

3)

 INSERT INTO `eav_entity_attribute` (`entity_attribute_id`, `entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`) VALUES (337, 3, 3, 4, 140, 3); 

Here I use id_attribute as 140, use the identifier for this in these queries using a unique value

Answer 2

The simplest solution is to activate the Mage_XmlConnect module, starting from version 1.9.1.0, this module is inactive by default. You can activate this module by changing

application / etc / modules / Mage_XmlConnect.xml

change the value of the <active> from false to true

Answer 3

She had the same problem with 1.9, but she managed to solve it manually by inserting the attribute directly into the database. Check the following 3 tables eav_attribute , catalog_eav_attribute , eav_entity_attribute for the image attribute (I have an identifier of 45) and duplicate it according to the thumbnail, I hope this helps.