Skip to main content
ErrorsMagento

Magento – 1215 Cannot add foreign key constraint

By March 28, 2017No Comments

When trying to upgrade a Magento 1.4.2.0 site I encountered the error ‘Cannot add foreign key constraint’, when trying to update the database to 1.5, 1.6, 1.7 or 1.8.

I was using a copy of the current website’s database, with fresh Magento 1.4.2.0 files.

General error: 1215 Cannot add foreign key constraint

Here’s the error in full;

Error in file: “/###/###/###/###/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php” – SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

Trace:
#0 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
#1 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘upgrade’, ‘1.6.0.0.9’, ‘1.6.0.0.18’)
#2 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(‘1.6.0.0.9’, ‘1.6.0.0.18’)
#3 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /###/###/###/###/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /###/###/###/###/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /###/###/###/###/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#7 /###/###/###/###/index.php(87): Mage::run(”, ‘store’)
#8 {main}

As this is now quite an old version of Magento (1.4.2) I found it hard to find anything relevant on discussion boards (Magento has since upgraded theirs so I needed to use Wayback machine to find working links).

Foreign key restraint discussion

The foreign key restraint posts in stackoverflow seemed to mostly concern custom code.

However I found one post where the author answered his own question that helped me resolve the issue.

Solution

Switching table engine from MyISAM to InnoDB

As I was migrating the site from another host, it was possible that the site was originally configured as InnoDB. I’ve never faced this issue before but as it was on a test server it wasn’t an issue to try.

However, you can’t convert all database tables from MyISAM into InnoDB without a script.

Stackoverflow again helped;

Run this SQL statement (in phpMyAdmin, SQL tab) to retrieve all the MyISAM tables in your database.

Replace value of the name_of_your_db variable with your database name.


SET @DATABASE_NAME = 'name_of_your_db';

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

Then copy the output code produced and run this as a new SQL query.

Here’s my code below;


ALTER TABLE `wishlist_item` ENGINE=InnoDB;	
ALTER TABLE `wishlist` ENGINE=InnoDB;	
ALTER TABLE `widget_instance_page_layout` ENGINE=InnoDB;	
ALTER TABLE `widget_instance_page` ENGINE=InnoDB;	
ALTER TABLE `widget_instance` ENGINE=InnoDB;	
ALTER TABLE `widget` ENGINE=InnoDB;	
ALTER TABLE `weee_tax` ENGINE=InnoDB;	
ALTER TABLE `weee_discount` ENGINE=InnoDB;	
ALTER TABLE `tax_order_aggregated_created` ENGINE=InnoDB;
ALTER TABLE `tax_class` ENGINE=InnoDB;	
ALTER TABLE `tax_calculation_rule` ENGINE=InnoDB;	
ALTER TABLE `tax_calculation_rate_title` ENGINE=InnoDB;
ALTER TABLE `tax_calculation_rate` ENGINE=InnoDB;	
ALTER TABLE `tax_calculation` ENGINE=InnoDB;	
ALTER TABLE `tag_summary` ENGINE=InnoDB;	
ALTER TABLE `tag_relation` ENGINE=InnoDB;	
ALTER TABLE `tag_properties` ENGINE=InnoDB;	
ALTER TABLE `tag` ENGINE=InnoDB;	
ALTER TABLE `smtppro_email_log` ENGINE=InnoDB;	
ALTER TABLE `sitemap` ENGINE=InnoDB;	
ALTER TABLE `shipping_tablerate` ENGINE=InnoDB;	
ALTER TABLE `shipping_matrixrate` ENGINE=InnoDB;	
ALTER TABLE `sendfriend_log` ENGINE=InnoDB;	
ALTER TABLE `sales_shipping_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `sales_shipping_aggregated` ENGINE=InnoDB;
ALTER TABLE `sales_refunded_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `sales_refunded_aggregated` ENGINE=InnoDB;	
ALTER TABLE `sales_recurring_profile_order` ENGINE=InnoDB;	
ALTER TABLE `sales_recurring_profile` ENGINE=InnoDB;	
ALTER TABLE `sales_payment_transaction` ENGINE=InnoDB;	
ALTER TABLE `sales_order_tax` ENGINE=InnoDB;	
ALTER TABLE `sales_order_aggregated_created` ENGINE=InnoDB;	
ALTER TABLE `sales_invoiced_aggregated_order` ENGINE=InnoDB;	
ALTER TABLE `sales_invoiced_aggregated` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_shipment_track` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_shipment_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_shipment_grid` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_shipment_comment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_shipment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_shipping_rate` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_payment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_item_option` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_address_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote_address` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_quote` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order_status_history` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order_payment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order_grid` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order_address` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_order` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_invoice_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_invoice_grid` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_invoice_comment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_invoice` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_creditmemo_item` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_creditmemo_grid` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_creditmemo_comment` ENGINE=InnoDB;	
ALTER TABLE `sales_flat_creditmemo` ENGINE=InnoDB;	
ALTER TABLE `sales_billing_agreement_order` ENGINE=InnoDB;	
ALTER TABLE `sales_billing_agreement` ENGINE=InnoDB;	
ALTER TABLE `sales_bestsellers_aggregated_yearly` ENGINE=InnoDB;	
ALTER TABLE `sales_bestsellers_aggregated_monthly` ENGINE=InnoDB;
ALTER TABLE `sales_bestsellers_aggregated_daily` ENGINE=InnoDB;	
ALTER TABLE `salesrule_product_attribute` ENGINE=InnoDB;	
ALTER TABLE `salesrule_label` ENGINE=InnoDB;	
ALTER TABLE `salesrule_customer` ENGINE=InnoDB;	
ALTER TABLE `salesrule_coupon_usage` ENGINE=InnoDB;	
ALTER TABLE `salesrule_coupon` ENGINE=InnoDB;	
ALTER TABLE `salesrule` ENGINE=InnoDB;	
ALTER TABLE `sagepay_api_debug` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_transaction_queue` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_transaction` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_tokencard` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_session` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_paypaltransaction` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_fraud` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_debug` ENGINE=InnoDB;	
ALTER TABLE `sagepaysuite_action` ENGINE=InnoDB;	
ALTER TABLE `sagepayreporting_fraud` ENGINE=InnoDB;	
ALTER TABLE `review_store` ENGINE=InnoDB;	
ALTER TABLE `review_status` ENGINE=InnoDB;	
ALTER TABLE `review_entity_summary` ENGINE=InnoDB;	
ALTER TABLE `review_entity` ENGINE=InnoDB;	
ALTER TABLE `review_detail` ENGINE=InnoDB;	
ALTER TABLE `review` ENGINE=InnoDB;	
ALTER TABLE `report_viewed_product_index` ENGINE=InnoDB;	
ALTER TABLE `report_event_types` ENGINE=InnoDB;	
ALTER TABLE `report_event` ENGINE=InnoDB;	
ALTER TABLE `report_compared_product_index` ENGINE=InnoDB;	
ALTER TABLE `rating_title` ENGINE=InnoDB;	
ALTER TABLE `rating_store` ENGINE=InnoDB;	
ALTER TABLE `rating_option_vote_aggregated` ENGINE=InnoDB;	
ALTER TABLE `rating_option_vote` ENGINE=InnoDB;	
ALTER TABLE `rating_option` ENGINE=InnoDB;	
ALTER TABLE `rating_entity` ENGINE=InnoDB;	
ALTER TABLE `rating` ENGINE=InnoDB;	
ALTER TABLE `protxDirect_TempData` ENGINE=InnoDB;	
ALTER TABLE `protxDirect_debug` ENGINE=InnoDB;	
ALTER TABLE `product_alert_stock` ENGINE=InnoDB;	
ALTER TABLE `product_alert_price` ENGINE=InnoDB;	
ALTER TABLE `productdebate` ENGINE=InnoDB;	
ALTER TABLE `poll_vote` ENGINE=InnoDB;	
ALTER TABLE `poll_store` ENGINE=InnoDB;	
ALTER TABLE `poll_answer` ENGINE=InnoDB;	
ALTER TABLE `poll` ENGINE=InnoDB;	
ALTER TABLE `permission_variable` ENGINE=InnoDB;	
ALTER TABLE `permission_block` ENGINE=InnoDB;	
ALTER TABLE `paypal_settlement_report_row` ENGINE=InnoDB;	
ALTER TABLE `paypal_settlement_report` ENGINE=InnoDB;	
ALTER TABLE `paypal_api_debug` ENGINE=InnoDB;	
ALTER TABLE `paypaluk_api_debug` ENGINE=InnoDB;	
ALTER TABLE `paygate_authorizenet_debug` ENGINE=InnoDB;	
ALTER TABLE `newsletter_template` ENGINE=InnoDB;	
ALTER TABLE `newsletter_subscriber` ENGINE=InnoDB;	
ALTER TABLE `newsletter_queue_store_link` ENGINE=InnoDB;	
ALTER TABLE `newsletter_queue_link` ENGINE=InnoDB;	
ALTER TABLE `newsletter_queue` ENGINE=InnoDB;	
ALTER TABLE `newsletter_problem` ENGINE=InnoDB;	
ALTER TABLE `log_visitor_online` ENGINE=InnoDB;	
ALTER TABLE `log_visitor_info` ENGINE=InnoDB;	
ALTER TABLE `log_visitor` ENGINE=InnoDB;	
ALTER TABLE `log_url_info` ENGINE=InnoDB;	
ALTER TABLE `log_url` ENGINE=InnoDB;	
ALTER TABLE `log_summary_type` ENGINE=InnoDB;	
ALTER TABLE `log_summary` ENGINE=InnoDB;	
ALTER TABLE `log_quote` ENGINE=InnoDB;	
ALTER TABLE `log_customer` ENGINE=InnoDB;	
ALTER TABLE `index_process_event` ENGINE=InnoDB;	
ALTER TABLE `index_process` ENGINE=InnoDB;	
ALTER TABLE `index_event` ENGINE=InnoDB;	
ALTER TABLE `googleoptimizer_code` ENGINE=InnoDB;	
ALTER TABLE `googlecheckout_notification` ENGINE=InnoDB;	
ALTER TABLE `googlecheckout_api_debug` ENGINE=InnoDB;	
ALTER TABLE `googlebase_types` ENGINE=InnoDB;	
ALTER TABLE `googlebase_items` ENGINE=InnoDB;	
ALTER TABLE `googlebase_attributes` ENGINE=InnoDB;	
ALTER TABLE `gift_message` ENGINE=InnoDB;	
ALTER TABLE `find_feed_import_codes` ENGINE=InnoDB;	
ALTER TABLE `eav_form_type_entity` ENGINE=InnoDB;	
ALTER TABLE `eav_form_type` ENGINE=InnoDB;	
ALTER TABLE `eav_form_fieldset_label` ENGINE=InnoDB;	
ALTER TABLE `eav_form_fieldset` ENGINE=InnoDB;	
ALTER TABLE `eav_form_element` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_varchar` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_type` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_text` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_store` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_int` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_decimal` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_datetime` ENGINE=InnoDB;	
ALTER TABLE `eav_entity_attribute` ENGINE=InnoDB;	
ALTER TABLE `eav_entity` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute_set` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute_option_value` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute_option` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute_label` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute_group` ENGINE=InnoDB;	
ALTER TABLE `eav_attribute` ENGINE=InnoDB;	
ALTER TABLE `downloadable_sample_title` ENGINE=InnoDB;	
ALTER TABLE `downloadable_sample` ENGINE=InnoDB;	
ALTER TABLE `downloadable_link_title` ENGINE=InnoDB;	
ALTER TABLE `downloadable_link_purchased_item` ENGINE=InnoDB;	
ALTER TABLE `downloadable_link_purchased` ENGINE=InnoDB;	
ALTER TABLE `downloadable_link_price` ENGINE=InnoDB;	
ALTER TABLE `downloadable_link` ENGINE=InnoDB;	
ALTER TABLE `directory_currency_rate` ENGINE=InnoDB;	
ALTER TABLE `directory_country_region_name` ENGINE=InnoDB;	
ALTER TABLE `directory_country_region` ENGINE=InnoDB;	
ALTER TABLE `directory_country_format` ENGINE=InnoDB;	
ALTER TABLE `directory_country` ENGINE=InnoDB;	
ALTER TABLE `design_change` ENGINE=InnoDB;	
ALTER TABLE `dataflow_session` ENGINE=InnoDB;	
ALTER TABLE `dataflow_profile_history` ENGINE=InnoDB;	
ALTER TABLE `dataflow_profile` ENGINE=InnoDB;	
ALTER TABLE `dataflow_import_data` ENGINE=InnoDB;	
ALTER TABLE `dataflow_batch_import` ENGINE=InnoDB;	
ALTER TABLE `dataflow_batch_export` ENGINE=InnoDB;	
ALTER TABLE `dataflow_batch` ENGINE=InnoDB;	
ALTER TABLE `custommenu_store` ENGINE=InnoDB;	
ALTER TABLE `custommenu` ENGINE=InnoDB;	
ALTER TABLE `customer_group` ENGINE=InnoDB;	
ALTER TABLE `customer_form_attribute` ENGINE=InnoDB;	
ALTER TABLE `customer_entity_varchar` ENGINE=InnoDB;	
ALTER TABLE `customer_entity_text` ENGINE=InnoDB;	
ALTER TABLE `customer_entity_int` ENGINE=InnoDB;	
ALTER TABLE `customer_entity_decimal` ENGINE=InnoDB;	
ALTER TABLE `customer_entity_datetime` ENGINE=InnoDB;	
ALTER TABLE `customer_entity` ENGINE=InnoDB;	
ALTER TABLE `customer_eav_attribute_website` ENGINE=InnoDB;	
ALTER TABLE `customer_eav_attribute` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity_varchar` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity_text` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity_int` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity_decimal` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity_datetime` ENGINE=InnoDB;	
ALTER TABLE `customer_address_entity` ENGINE=InnoDB;	
ALTER TABLE `cron_schedule` ENGINE=InnoDB;	
ALTER TABLE `coupon_aggregated_order` ENGINE=InnoDB;	
ALTER TABLE `coupon_aggregated` ENGINE=InnoDB;	
ALTER TABLE `core_variable_value` ENGINE=InnoDB;	
ALTER TABLE `core_variable` ENGINE=InnoDB;	
ALTER TABLE `core_url_rewrite` ENGINE=InnoDB;	
ALTER TABLE `core_translate` ENGINE=InnoDB;	
ALTER TABLE `core_store_group` ENGINE=InnoDB;	
ALTER TABLE `core_store` ENGINE=InnoDB;	
ALTER TABLE `core_session` ENGINE=InnoDB;	
ALTER TABLE `core_resource` ENGINE=InnoDB;	
ALTER TABLE `core_layout_update` ENGINE=InnoDB;	
ALTER TABLE `core_layout_link` ENGINE=InnoDB;	
ALTER TABLE `core_flag` ENGINE=InnoDB;	
ALTER TABLE `core_email_template` ENGINE=InnoDB;	
ALTER TABLE `core_config_data` ENGINE=InnoDB;	
ALTER TABLE `core_cache_tag` ENGINE=InnoDB;	
ALTER TABLE `core_cache_option` ENGINE=InnoDB;	
ALTER TABLE `core_cache` ENGINE=InnoDB;	
ALTER TABLE `cms_page_store` ENGINE=InnoDB;	
ALTER TABLE `cms_page` ENGINE=InnoDB;	
ALTER TABLE `cms_block_store` ENGINE=InnoDB;	
ALTER TABLE `cms_block` ENGINE=InnoDB;	
ALTER TABLE `checkout_agreement_store` ENGINE=InnoDB;	
ALTER TABLE `checkout_agreement` ENGINE=InnoDB;
ALTER TABLE `catalog_product_super_link` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_super_attribute_pricing` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_super_attribute_label` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_super_attribute` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_relation` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option_type_value` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option_type_title` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option_type_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option_title` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_option` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link_type` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link_attribute_varchar` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link_attribute_int` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link_attribute_decimal` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link_attribute` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_link` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_website` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_tier_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_opt_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_opt_agr_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_final_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_downlod_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_cfg_opt_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_cfg_opt_agr_id` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_bundle_sel_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_bundle_opt_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price_bundle_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_eav_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_eav_decimal_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_eav_decimal` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_index_eav` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_varchar` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_tier_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_text` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_media_gallery_value` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_media_gallery` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_int` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_gallery` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_decimal` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_entity_datetime` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_enabled_index` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_stock_index` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_selection_price` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_selection` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_price_index` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_option_value` ENGINE=InnoDB;	
ALTER TABLE `catalog_product_bundle_option` ENGINE=InnoDB;	
ALTER TABLE `catalog_eav_attribute` ENGINE=InnoDB;	
ALTER TABLE `catalog_compare_item` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_product_index_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_product_index_enbl_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_product_index` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_product` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity_varchar` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity_text` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity_int` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity_decimal` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity_datetime` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_entity` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_anc_products_index_idx` ENGINE=InnoDB;	
ALTER TABLE `catalog_category_anc_categs_index_idx` ENGINE=InnoDB;	
ALTER TABLE `catalogsearch_result` ENGINE=InnoDB;	
ALTER TABLE `catalogsearch_query` ENGINE=InnoDB;	
ALTER TABLE `catalogsearch_fulltext` ENGINE=InnoDB;	
ALTER TABLE `catalogrule_product_price` ENGINE=InnoDB;	
ALTER TABLE `catalogrule_product` ENGINE=InnoDB;	
ALTER TABLE `catalogrule_group_website` ENGINE=InnoDB;	
ALTER TABLE `catalogrule_affected_product` ENGINE=InnoDB;	
ALTER TABLE `catalogrule` ENGINE=InnoDB;	
ALTER TABLE `cataloginventory_stock_status_idx` ENGINE=InnoDB;	
ALTER TABLE `cataloginventory_stock_status` ENGINE=InnoDB;	
ALTER TABLE `cataloginventory_stock_item` ENGINE=InnoDB;	
ALTER TABLE `cataloginventory_stock` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_price` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_minimal_price` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_eav` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_aggregation_to_tag` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_aggregation_tag` ENGINE=InnoDB;	
ALTER TABLE `catalogindex_aggregation` ENGINE=InnoDB;	
ALTER TABLE `api_user` ENGINE=InnoDB;	
ALTER TABLE `api_session` ENGINE=InnoDB;	
ALTER TABLE `api_rule` ENGINE=InnoDB;	
ALTER TABLE `api_role` ENGINE=InnoDB;	
ALTER TABLE `api_assert` ENGINE=InnoDB;	
ALTER TABLE `aitsys_status` ENGINE=InnoDB;	
ALTER TABLE `aitsys_news` ENGINE=InnoDB;	
ALTER TABLE `aitexporter_profile` ENGINE=InnoDB;	
ALTER TABLE `aitexporter_import_error` ENGINE=InnoDB;	
ALTER TABLE `aitexporter_import` ENGINE=InnoDB;	
ALTER TABLE `aitexporter_export_order` ENGINE=InnoDB;	
ALTER TABLE `aitexporter_export` ENGINE=InnoDB;	
ALTER TABLE `admin_user` ENGINE=InnoDB;	
ALTER TABLE `admin_rule` ENGINE=InnoDB;	
ALTER TABLE `admin_role` ENGINE=InnoDB;	
ALTER TABLE `admin_assert` ENGINE=InnoDB;	
ALTER TABLE `adminnotification_inbox` ENGINE=InnoDB;

Andrew Taylor

A senior UI designer with over 25 years of web design and web development experience working for some of the largest companies in the UK. An expert in all things Magento and WordPress.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.