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.
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*/
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)