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

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

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

      Quellcode

      1. 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 !!!

      Quellcode

      1. alter table admin_assert engine=innodb;
      2. alter table admin_role engine=innodb;
      3. alter table admin_rule engine=innodb;
      4. alter table admin_user engine=innodb;
      5. alter table adminnotification_inbox engine=innodb;
      6. alter table catalog_category_entity engine=innodb;
      7. alter table catalog_category_entity_datetime engine=innodb;
      8. alter table catalog_category_entity_decimal engine=innodb;
      9. alter table catalog_category_entity_int engine=innodb;
      10. alter table catalog_category_entity_text engine=innodb;
      11. alter table catalog_category_entity_varchar engine=innodb;
      12. alter table catalog_category_product engine=innodb;
      13. alter table catalog_category_product_index engine=innodb;
      14. alter table catalog_compare_item engine=innodb;
      15. alter table catalog_product_bundle_option engine=innodb;
      16. alter table catalog_product_bundle_option_link engine=innodb;
      17. alter table catalog_product_bundle_option_value engine=innodb;
      18. alter table catalog_product_bundle_selection engine=innodb;
      19. alter table catalog_product_enabled_index engine=innodb;
      20. alter table catalog_product_entity engine=innodb;
      21. alter table catalog_product_entity_datetime engine=innodb;
      22. alter table catalog_product_entity_decimal engine=innodb;
      23. alter table catalog_product_entity_gallery engine=innodb;
      24. alter table catalog_product_entity_int engine=innodb;
      25. alter table catalog_product_entity_media_gallery engine=innodb;
      26. alter table catalog_product_entity_media_gallery_value engine=innodb;
      27. alter table catalog_product_entity_text engine=innodb;
      28. alter table catalog_product_entity_tier_price engine=innodb;
      29. alter table catalog_product_entity_varchar engine=innodb;
      30. alter table catalog_product_link engine=innodb;
      31. alter table catalog_product_link_attribute engine=innodb;
      32. alter table catalog_product_link_attribute_decimal engine=innodb;
      33. alter table catalog_product_link_attribute_int engine=innodb;
      34. alter table catalog_product_link_attribute_varchar engine=innodb;
      35. alter table catalog_product_link_type engine=innodb;
      36. alter table catalog_product_option engine=innodb;
      37. alter table catalog_product_option_price engine=innodb;
      38. alter table catalog_product_option_title engine=innodb;
      39. alter table catalog_product_option_type_price engine=innodb;
      40. alter table catalog_product_option_type_title engine=innodb;
      41. alter table catalog_product_option_type_value engine=innodb;
      42. alter table catalog_product_super_attribute engine=innodb;
      43. alter table catalog_product_super_attribute_label engine=innodb;
      44. alter table catalog_product_super_attribute_pricing engine=innodb;
      45. alter table catalog_product_super_link engine=innodb;
      46. alter table catalog_product_website engine=innodb;
      47. alter table catalogindex_eav engine=innodb;
      48. alter table catalogindex_minimal_price engine=innodb;
      49. alter table catalogindex_price engine=innodb;
      50. alter table cataloginventory_stock engine=innodb;
      51. alter table cataloginventory_stock_item engine=innodb;
      52. alter table catalogrule engine=innodb;
      53. alter table catalogrule_product engine=innodb;
      54. alter table catalogrule_product_price engine=innodb;
      55. alter table catalogsearch_query engine=innodb;
      56. alter table checkout_agreement engine=innodb;
      57. alter table checkout_agreement_store engine=innodb;
      58. alter table cms_block engine=innodb;
      59. alter table cms_block_store engine=innodb;
      60. alter table cms_page engine=innodb;
      61. alter table cms_page_store engine=innodb;
      62. alter table core_config_data engine=innodb;
      63. alter table core_email_template engine=innodb;
      64. alter table core_layout_link engine=innodb;
      65. alter table core_layout_update engine=innodb;
      66. alter table core_resource engine=innodb;
      67. alter table core_session engine=innodb;
      68. alter table core_store engine=innodb;
      69. alter table core_store_group engine=innodb;
      70. alter table core_translate engine=innodb;
      71. alter table core_url_rewrite engine=innodb;
      72. alter table core_website engine=innodb;
      73. alter table cron_schedule engine=innodb;
      74. alter table customer_address_entity engine=innodb;
      75. alter table customer_address_entity_datetime engine=innodb;
      76. alter table customer_address_entity_decimal engine=innodb;
      77. alter table customer_address_entity_int engine=innodb;
      78. alter table customer_address_entity_text engine=innodb;
      79. alter table customer_address_entity_varchar engine=innodb;
      80. alter table customer_entity engine=innodb;
      81. alter table customer_entity_datetime engine=innodb;
      82. alter table customer_entity_decimal engine=innodb;
      83. alter table customer_entity_int engine=innodb;
      84. alter table customer_entity_text engine=innodb;
      85. alter table customer_entity_varchar engine=innodb;
      86. alter table customer_group engine=innodb;
      87. alter table dataflow_batch engine=innodb;
      88. alter table dataflow_batch_export engine=innodb;
      89. alter table dataflow_batch_import engine=innodb;
      90. alter table dataflow_import_data engine=innodb;
      91. alter table dataflow_profile engine=innodb;
      92. alter table dataflow_profile_history engine=innodb;
      93. alter table dataflow_session engine=innodb;
      94. alter table design_change engine=innodb;
      95. alter table directory_country engine=innodb;
      96. alter table directory_country_format engine=innodb;
      97. alter table directory_country_region engine=innodb;
      98. alter table directory_country_region_name engine=innodb;
      99. alter table directory_currency_rate engine=innodb;
      100. alter table eav_attribute engine=innodb;
      101. alter table eav_attribute_group engine=innodb;
      102. alter table eav_attribute_option engine=innodb;
      103. alter table eav_attribute_option_value engine=innodb;
      104. alter table eav_attribute_set engine=innodb;
      105. alter table eav_entity engine=innodb;
      106. alter table eav_entity_attribute engine=innodb;
      107. alter table eav_entity_datetime engine=innodb;
      108. alter table eav_entity_decimal engine=innodb;
      109. alter table eav_entity_int engine=innodb;
      110. alter table eav_entity_store engine=innodb;
      111. alter table eav_entity_text engine=innodb;
      112. alter table eav_entity_type engine=innodb;
      113. alter table eav_entity_varchar engine=innodb;
      114. alter table gift_message engine=innodb;
      115. alter table googlecheckout_api_debug engine=innodb;
      116. alter table newsletter_problem engine=innodb;
      117. alter table newsletter_queue engine=innodb;
      118. alter table newsletter_queue_link engine=innodb;
      119. alter table newsletter_queue_store_link engine=innodb;
      120. alter table newsletter_subscriber engine=innodb;
      121. alter table newsletter_template engine=innodb;
      122. alter table paygate_authorizenet_debug engine=innodb;
      123. alter table paypal_api_debug engine=innodb;
      124. alter table paypaluk_api_debug engine=innodb;
      125. alter table poll engine=innodb;
      126. alter table poll_answer engine=innodb;
      127. alter table poll_store engine=innodb;
      128. alter table poll_vote engine=innodb;
      129. alter table product_alert_price engine=innodb;
      130. alter table rating engine=innodb;
      131. alter table rating_entity engine=innodb;
      132. alter table rating_option engine=innodb;
      133. alter table rating_option_vote engine=innodb;
      134. alter table rating_option_vote_aggregated engine=innodb;
      135. alter table rating_store engine=innodb;
      136. alter table rating_title engine=innodb;
      137. alter table report_event engine=innodb;
      138. alter table report_event_types engine=innodb;
      139. alter table review engine=innodb;
      140. alter table review_detail engine=innodb;
      141. alter table review_entity engine=innodb;
      142. alter table review_entity_summary engine=innodb;
      143. alter table review_status engine=innodb;
      144. alter table review_store engine=innodb;
      145. alter table sales_counter engine=innodb;
      146. alter table sales_discount_coupon engine=innodb;
      147. alter table sales_flat_order_item engine=innodb;
      148. alter table sales_flat_quote engine=innodb;
      149. alter table sales_flat_quote_address engine=innodb;
      150. alter table sales_flat_quote_address_item engine=innodb;
      151. alter table sales_flat_quote_item engine=innodb;
      152. alter table sales_flat_quote_item_option engine=innodb;
      153. alter table sales_flat_quote_payment engine=innodb;
      154. alter table sales_flat_quote_shipping_rate engine=innodb;
      155. alter table sales_giftcert engine=innodb;
      156. alter table sales_order engine=innodb;
      157. alter table sales_order_datetime engine=innodb;
      158. alter table sales_order_decimal engine=innodb;
      159. alter table sales_order_entity engine=innodb;
      160. alter table sales_order_entity_datetime engine=innodb;
      161. alter table sales_order_entity_decimal engine=innodb;
      162. alter table sales_order_entity_int engine=innodb;
      163. alter table sales_order_entity_text engine=innodb;
      164. alter table sales_order_entity_varchar engine=innodb;
      165. alter table sales_order_int engine=innodb;
      166. alter table sales_order_tax engine=innodb;
      167. alter table sales_order_text engine=innodb;
      168. alter table sales_order_varchar engine=innodb;
      169. alter table sales_quote engine=innodb;
      170. alter table sales_quote_address engine=innodb;
      171. alter table sales_quote_address_decimal engine=innodb;
      172. alter table sales_quote_address_int engine=innodb;
      173. alter table sales_quote_address_text engine=innodb;
      174. alter table sales_quote_address_varchar engine=innodb;
      175. alter table sales_quote_decimal engine=innodb;
      176. alter table sales_quote_entity engine=innodb;
      177. alter table sales_quote_entity_datetime engine=innodb;
      178. alter table sales_quote_entity_decimal engine=innodb;
      179. alter table sales_quote_entity_int engine=innodb;
      180. alter table sales_quote_entity_text engine=innodb;
      181. alter table sales_quote_entity_varchar engine=innodb;
      182. alter table sales_quote_int engine=innodb;
      183. alter table sales_quote_item engine=innodb;
      184. alter table sales_quote_item_decimal engine=innodb;
      185. alter table sales_quote_item_int engine=innodb;
      186. alter table sales_quote_item_text engine=innodb;
      187. alter table sales_quote_item_varchar engine=innodb;
      188. alter table sales_quote_rule engine=innodb;
      189. alter table sales_quote_text engine=innodb;
      190. alter table sales_quote_varchar engine=innodb;
      191. alter table salesrule engine=innodb;
      192. alter table salesrule_customer engine=innodb;
      193. alter table shipping_tablerate engine=innodb;
      194. alter table sitemap engine=innodb;
      195. alter table tag engine=innodb;
      196. alter table tag_relation engine=innodb;
      197. alter table tag_summary engine=innodb;
      198. alter table tax_calculation engine=innodb;
      199. alter table tax_calculation_rate engine=innodb;
      200. alter table tax_calculation_rate_title engine=innodb;
      201. alter table tax_calculation_rule engine=innodb;
      202. alter table tax_class engine=innodb;
      203. alter table tax_rate engine=innodb;
      204. alter table tax_rate_data engine=innodb;
      205. alter table tax_rate_type engine=innodb;
      206. alter table tax_rule engine=innodb;
      207. alter table wishlist engine=innodb;
      208. alter table wishlist_item engine=innodb;
      Magento Hosting | Cloud Server | Shopware Hosting | Elasticsearch Hosting
      Unsere Hosting-Lösungen nutzen ultraschnelle SSDs und sind jederzeit skalierbar.