SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child ro

[rack::SPEED]

Folgender Fehler tritt auf, wenn nicht alle Tabellen mit der InnoDB Engine betrieben werden:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or  update a child row: a foreign key constraint fails  (`XXXXXX/cataloginventory_stock_status`, CONSTRAINT  `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`)  REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE C)

Abhilfe schafft die Umstellung der jeweiligen Tabellen-Engine:

!!! VORHER EIN BACKUP DER DATENBANK ERSTELLEN !!!

alter table admin_assert                                engine=innodb;
alter table admin_role                                  engine=innodb;
alter table admin_rule                                  engine=innodb;
alter table admin_user                                  engine=innodb;
alter table adminnotification_inbox                     engine=innodb;
alter table catalog_category_entity                     engine=innodb;
alter table catalog_category_entity_datetime            engine=innodb;
alter table catalog_category_entity_decimal             engine=innodb;
alter table catalog_category_entity_int                 engine=innodb;
alter table catalog_category_entity_text                engine=innodb;
alter table catalog_category_entity_varchar             engine=innodb;
alter table catalog_category_product                    engine=innodb;
alter table catalog_category_product_index              engine=innodb;
alter table catalog_compare_item                        engine=innodb;
alter table catalog_product_bundle_option               engine=innodb;
alter table catalog_product_bundle_option_link          engine=innodb;
alter table catalog_product_bundle_option_value         engine=innodb;
alter table catalog_product_bundle_selection            engine=innodb;
alter table catalog_product_enabled_index               engine=innodb;
alter table catalog_product_entity                      engine=innodb;
alter table catalog_product_entity_datetime             engine=innodb;
alter table catalog_product_entity_decimal              engine=innodb;
alter table catalog_product_entity_gallery              engine=innodb;
alter table catalog_product_entity_int                  engine=innodb;
alter table catalog_product_entity_media_gallery        engine=innodb;
alter table catalog_product_entity_media_gallery_value  engine=innodb;
alter table catalog_product_entity_text                 engine=innodb;
alter table catalog_product_entity_tier_price           engine=innodb;
alter table catalog_product_entity_varchar              engine=innodb;
alter table catalog_product_link                        engine=innodb;
alter table catalog_product_link_attribute              engine=innodb;
alter table catalog_product_link_attribute_decimal      engine=innodb;
alter table catalog_product_link_attribute_int          engine=innodb;
alter table catalog_product_link_attribute_varchar      engine=innodb;
alter table catalog_product_link_type                   engine=innodb;
alter table catalog_product_option                      engine=innodb;
alter table catalog_product_option_price                engine=innodb;
alter table catalog_product_option_title                engine=innodb;
alter table catalog_product_option_type_price           engine=innodb;
alter table catalog_product_option_type_title           engine=innodb;
alter table catalog_product_option_type_value           engine=innodb;
alter table catalog_product_super_attribute             engine=innodb;
alter table catalog_product_super_attribute_label       engine=innodb;
alter table catalog_product_super_attribute_pricing     engine=innodb;
alter table catalog_product_super_link                  engine=innodb;
alter table catalog_product_website                     engine=innodb;
alter table catalogindex_eav                            engine=innodb;
alter table catalogindex_minimal_price                  engine=innodb;
alter table catalogindex_price                          engine=innodb;
alter table cataloginventory_stock                      engine=innodb;
alter table cataloginventory_stock_item                 engine=innodb;
alter table catalogrule                                 engine=innodb;
alter table catalogrule_product                         engine=innodb;
alter table catalogrule_product_price                   engine=innodb;
alter table catalogsearch_query                         engine=innodb;
alter table checkout_agreement                          engine=innodb;
alter table checkout_agreement_store                    engine=innodb;
alter table cms_block                                   engine=innodb;
alter table cms_block_store                             engine=innodb;
alter table cms_page                                    engine=innodb;
alter table cms_page_store                              engine=innodb;
alter table core_config_data                            engine=innodb;
alter table core_email_template                         engine=innodb;
alter table core_layout_link                            engine=innodb;
alter table core_layout_update                          engine=innodb;
alter table core_resource                               engine=innodb;
alter table core_session                                engine=innodb;
alter table core_store                                  engine=innodb;
alter table core_store_group                            engine=innodb;
alter table core_translate                              engine=innodb;
alter table core_url_rewrite                            engine=innodb;
alter table core_website                                engine=innodb;
alter table cron_schedule                               engine=innodb;
alter table customer_address_entity                     engine=innodb;
alter table customer_address_entity_datetime            engine=innodb;
alter table customer_address_entity_decimal             engine=innodb;
alter table customer_address_entity_int                 engine=innodb;
alter table customer_address_entity_text                engine=innodb;
alter table customer_address_entity_varchar             engine=innodb;
alter table customer_entity                             engine=innodb;
alter table customer_entity_datetime                    engine=innodb;
alter table customer_entity_decimal                     engine=innodb;
alter table customer_entity_int                         engine=innodb;
alter table customer_entity_text                        engine=innodb;
alter table customer_entity_varchar                     engine=innodb;
alter table customer_group                              engine=innodb;
alter table dataflow_batch                              engine=innodb;
alter table dataflow_batch_export                       engine=innodb;
alter table dataflow_batch_import                       engine=innodb;
alter table dataflow_import_data                        engine=innodb;
alter table dataflow_profile                            engine=innodb;
alter table dataflow_profile_history                    engine=innodb;
alter table dataflow_session                            engine=innodb;
alter table design_change                               engine=innodb;
alter table directory_country                           engine=innodb;
alter table directory_country_format                    engine=innodb;
alter table directory_country_region                    engine=innodb;
alter table directory_country_region_name               engine=innodb;
alter table directory_currency_rate                     engine=innodb;
alter table eav_attribute                               engine=innodb;
alter table eav_attribute_group                         engine=innodb;
alter table eav_attribute_option                        engine=innodb;
alter table eav_attribute_option_value                  engine=innodb;
alter table eav_attribute_set                           engine=innodb;
alter table eav_entity                                  engine=innodb;
alter table eav_entity_attribute                        engine=innodb;
alter table eav_entity_datetime                         engine=innodb;
alter table eav_entity_decimal                          engine=innodb;
alter table eav_entity_int                              engine=innodb;
alter table eav_entity_store                            engine=innodb;
alter table eav_entity_text                             engine=innodb;
alter table eav_entity_type                             engine=innodb;
alter table eav_entity_varchar                          engine=innodb;
alter table gift_message                                engine=innodb;
alter table googlecheckout_api_debug                    engine=innodb;
alter table newsletter_problem                          engine=innodb;
alter table newsletter_queue                            engine=innodb;
alter table newsletter_queue_link                       engine=innodb;
alter table newsletter_queue_store_link                 engine=innodb;
alter table newsletter_subscriber                       engine=innodb;
alter table newsletter_template                         engine=innodb;
alter table paygate_authorizenet_debug                  engine=innodb;
alter table paypal_api_debug                            engine=innodb;
alter table paypaluk_api_debug                          engine=innodb;
alter table poll                                        engine=innodb;
alter table poll_answer                                 engine=innodb;
alter table poll_store                                  engine=innodb;
alter table poll_vote                                   engine=innodb;
alter table product_alert_price                         engine=innodb;
alter table rating                                      engine=innodb;
alter table rating_entity                               engine=innodb;
alter table rating_option                               engine=innodb;
alter table rating_option_vote                          engine=innodb;
alter table rating_option_vote_aggregated               engine=innodb;
alter table rating_store                                engine=innodb;
alter table rating_title                                engine=innodb;
alter table report_event                                engine=innodb;
alter table report_event_types                          engine=innodb;
alter table review                                      engine=innodb;
alter table review_detail                               engine=innodb;
alter table review_entity                               engine=innodb;
alter table review_entity_summary                       engine=innodb;
alter table review_status                               engine=innodb;
alter table review_store                                engine=innodb;
alter table sales_counter                               engine=innodb;
alter table sales_discount_coupon                       engine=innodb;
alter table sales_flat_order_item                       engine=innodb;
alter table sales_flat_quote                            engine=innodb;
alter table sales_flat_quote_address                    engine=innodb;
alter table sales_flat_quote_address_item               engine=innodb;
alter table sales_flat_quote_item                       engine=innodb;
alter table sales_flat_quote_item_option                engine=innodb;
alter table sales_flat_quote_payment                    engine=innodb;
alter table sales_flat_quote_shipping_rate              engine=innodb;
alter table sales_giftcert                              engine=innodb;
alter table sales_order                                 engine=innodb;
alter table sales_order_datetime                        engine=innodb;
alter table sales_order_decimal                         engine=innodb;
alter table sales_order_entity                          engine=innodb;
alter table sales_order_entity_datetime                 engine=innodb;
alter table sales_order_entity_decimal                  engine=innodb;
alter table sales_order_entity_int                      engine=innodb;
alter table sales_order_entity_text                     engine=innodb;
alter table sales_order_entity_varchar                  engine=innodb;
alter table sales_order_int                             engine=innodb;
alter table sales_order_tax                             engine=innodb;
alter table sales_order_text                            engine=innodb;
alter table sales_order_varchar                         engine=innodb;
alter table sales_quote                                 engine=innodb;
alter table sales_quote_address                         engine=innodb;
alter table sales_quote_address_decimal                 engine=innodb;
alter table sales_quote_address_int                     engine=innodb;
alter table sales_quote_address_text                    engine=innodb;
alter table sales_quote_address_varchar                 engine=innodb;
alter table sales_quote_decimal                         engine=innodb;
alter table sales_quote_entity                          engine=innodb;
alter table sales_quote_entity_datetime                 engine=innodb;
alter table sales_quote_entity_decimal                  engine=innodb;
alter table sales_quote_entity_int                      engine=innodb;
alter table sales_quote_entity_text                     engine=innodb;
alter table sales_quote_entity_varchar                  engine=innodb;
alter table sales_quote_int                             engine=innodb;
alter table sales_quote_item                            engine=innodb;
alter table sales_quote_item_decimal                    engine=innodb;
alter table sales_quote_item_int                        engine=innodb;
alter table sales_quote_item_text                       engine=innodb;
alter table sales_quote_item_varchar                    engine=innodb;
alter table sales_quote_rule                            engine=innodb;
alter table sales_quote_text                            engine=innodb;
alter table sales_quote_varchar                         engine=innodb;
alter table salesrule                                   engine=innodb;
alter table salesrule_customer                          engine=innodb;
alter table shipping_tablerate                          engine=innodb;
alter table sitemap                                     engine=innodb;
alter table tag                                         engine=innodb;
alter table tag_relation                                engine=innodb;
alter table tag_summary                                 engine=innodb;
alter table tax_calculation                             engine=innodb;
alter table tax_calculation_rate                        engine=innodb;
alter table tax_calculation_rate_title                  engine=innodb;
alter table tax_calculation_rule                        engine=innodb;
alter table tax_class                                   engine=innodb;
alter table tax_rate                                    engine=innodb;
alter table tax_rate_data                               engine=innodb;
alter table tax_rate_type                               engine=innodb;
alter table tax_rule                                    engine=innodb;
alter table wishlist                                    engine=innodb;
alter table wishlist_item                               engine=innodb;