Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Fix categories after usage of Magmi utility "Clear Catalog, Categories and Reviews v1.0.1" */
- /* For Magento 1.7.0.2, make the same from clean install of Magento for any another version */
- SET FOREIGN_KEY_CHECKS=0;
- TRUNCATE `catalog_category_entity`;
- INSERT INTO `catalog_category_entity` (`entity_id`, `entity_type_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES
- (1, 3, 0, 0, '2014-02-26 16:08:26', '2014-02-26 16:08:26', '1', 0, 0, 1),
- (2, 3, 3, 1, '2014-02-26 16:08:26', '2014-02-26 16:08:26', '1/2', 1, 1, 0);
- TRUNCATE `catalog_category_entity_datetime`;
- TRUNCATE `catalog_category_entity_decimal`;
- TRUNCATE `catalog_category_entity_int`;
- INSERT INTO `catalog_category_entity_int` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES
- (1, 3, 67, 0, 1, 1),
- (2, 3, 67, 1, 1, 1),
- (3, 3, 42, 0, 2, 1),
- (4, 3, 67, 0, 2, 1),
- (5, 3, 42, 1, 2, 1),
- (6, 3, 67, 1, 2, 1);
- TRUNCATE `catalog_category_entity_text`;
- INSERT INTO `catalog_category_entity_text` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES
- (1, 3, 65, 0, 1, NULL),
- (2, 3, 65, 1, 1, NULL),
- (3, 3, 65, 0, 2, NULL),
- (4, 3, 65, 1, 2, NULL);
- TRUNCATE `catalog_category_entity_varchar`;
- INSERT INTO `catalog_category_entity_varchar` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES
- (1, 3, 41, 0, 1, 'Root Catalog'),
- (2, 3, 41, 1, 1, 'Root Catalog'),
- (3, 3, 43, 1, 1, 'root-catalog'),
- (4, 3, 41, 0, 2, 'Default Category'),
- (5, 3, 41, 1, 2, 'Default Category'),
- (6, 3, 49, 1, 2, 'PRODUCTS'),
- (7, 3, 43, 1, 2, 'default-category');
- SET FOREIGN_KEY_CHECKS=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement