Magento rewriting block, helper and models plus override issues

Posted by Damodar Bashyal on January 06, 2014

 

Magento is an awesome ecommerce web application but sometimes it gives a real headache. As I am creating mobile theme, the requirement was, it should load desktop version theme on everything other than mobile devices. But the real challenge was when user decides to load desktop version even on mobile devices it should load desktop version not mobile template.

More»

Magento fix database table engines.

Posted by Damodar Bashyal on September 23, 2013

 

Magento-logo

/*run these if exists*/

ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_2` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_3` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_4` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_2` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_3` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_4` ENGINE=InnoDB;

/*below table exists in enterprise version. tested on 1.12.0.2*/

More»

Magento Reindex Issue / Error on Product Flat Data

Posted by Damodar Bashyal on September 17, 2013

 

I was getting below error today:

There was a problem with reindexing process.SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ('database'.'#sql-70c_45b87', CONSTRAINT 'FK_CAT_PRD_FLAT_2_ENTT_ID_CAT_PRD_ENTT_ENTT_ID' FOREIGN KEY ('entity_id') REFERENCES 'catalog_product_entity' ('entity_id') ON DELETE CASCADE ON UPDAT)

Index Management   System   Magento Admin

More»