Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”

Your MySQL table structure creates a reference and constraint relationship between your wp_product table and wp_posts. MySQL is doing exactly what you have instructed it to do. In this case, preventing you from deleting a record in wp_posts that is ‘related’ to records in your wp_product table.

In a nutshell, this is what foreign keys are supposed to do; maintain data integrity. Therefore you cannot delete a row in wp_posts while a corresponding/related record exists in wp_product.

I’d suggest taking a look at the MySQL documentation on Using FOREIGN KEY Constraints. Per your comments below I’d suggest looking at ‘Referential Actions’ to set the action to CASCADE.

Review the linked documentation to drill down to the specifics that match your requirements.

Related Posts:

  1. MySQL Query to Retrieve Category from wp_posts
  2. SQL Query for getting all posts in their latest revised state
  3. Search & Remove Specific Shortcode From All Posts
  4. Manually delete post from database
  5. How to force update all posts after import
  6. Query All users that has post
  7. Can’t publish new posts
  8. Manually removing revision post types
  9. Reset/Reorder posts ID in the MySQL wp_posts table
  10. How do I find which articles are missing a featured image in The WordPress database?
  11. Tags to Post-ID mysql query. Tag Search
  12. wp_insert_post – duration
  13. Get user categories with most posts in it
  14. MySql query to get posts with all meta and terms
  15. Custom order for Mysql array
  16. List authors with the last post title and order by last post date
  17. How to Mysql select a list of posts with meta_values AND all relevant categories?
  18. Remove a shortcode from all WordPress posts
  19. Order posts alphabetically: how to set order=asc in mysql query?
  20. What do these phpMyAdmin errors mean on my WordPress databaes?
  21. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  22. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  23. update image path with words starting uppercase to lowercase chars
  24. Queries take 120+ seconds on my large WordPress site
  25. Database hacked – random posts are modified
  26. Need to change all links in page content but not in post content
  27. Can’t update WordPress Page if post_content is Empty
  28. Restore woocommerce orders
  29. How to select particular month post from table and update the post status using MySQL?
  30. How do post IDs work in WordPress?
  31. Get author posts count after excluding a category
  32. get last post’s link with SQL query
  33. query for filtering published posts?
  34. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  35. Deleting post tags removes categories
  36. Return records between two meta datetimes saved as strings
  37. WP query taxonomy optimization
  38. MYSQL: Create SQL query to search for string and replace
  39. Query to fetch custom taxonomy along with post title
  40. Mysql update menu_order problem
  41. Bulk find & replace on WordPress posts/pages (minus image paths)
  42. WordPress MySQL Search and replace with wildcard?
  43. Add postmeta to all blog posts
  44. ‘posts’ table should not store the absolute image path
  45. Dev and prod on the same database- dev version active for IOS
  46. load post data into mysql
  47. SQL trigger failes with post_content
  48. Converting Posts to Pages
  49. How to change the publishing date of each posts?
  50. SQL query to remove first image in all posts
  51. Delete junk text from all the post using my sql command
  52. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  53. How to create a post based on data in a table?
  54. If meta_key exists then don’t select this post?
  55. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  56. How to manually delete post from database without causing conflicts?
  57. Force “Submit to review” when a post is updated
  58. What is the best / efficient way to get WordPress content by post id and why?
  59. Where can I find the code how wordpress parses a post?
  60. How to load post content on index page using ajax when post title in sidebar is clicked
  61. Custom Post Type Pagination Doesn’t Work in WordPress 3.4
  62. Get only modified posts
  63. Custom fields on a virtual page
  64. Are posts updated or built from revisions + autosaves?
  65. Adding footers to posts?
  66. Filter Custom Post Type by Category with Ajax
  67. Preserve term order per post in a non-hierarchical taxonomy
  68. Unautop / Sanitize content added to a post through a plugin
  69. WordPress programatically inserted post not showing in authors profile
  70. WP Remote Request not returning all of content via request
  71. Update all comments time to random dates?
  72. How can I get global $post to work for CPT and update user?
  73. How to copy posts from one site to another in real time (not multisite)
  74. Include sticky posts on the static page front page
  75. How can I setup a relationship using categories in WordPress?
  76. Editing 375 posts simultaneously? Maybe from the database?
  77. How Do I Get My Post Tags to Alphabetize?
  78. Changing default WP-Site creation date
  79. Delete post revisions only for a single post
  80. wp_set_object_terms NOT working on CPT, but wp_set_post_terms does
  81. Where to insert the other site image url for our wordpress post
  82. Get Users Post ID
  83. add_rewrite_rule and template redirect not working
  84. Automate post update for all posts?
  85. Allowing Users to Register Themselves and Post : Does WordPerss Handle these Problems?
  86. DEL media from the post but keep my featured image or post
  87. Set post title font size automatically according to number of words in post title
  88. Add view to admin menu to filter for specific criteria ( If post is child of specific Parent )
  89. How to make an image appear as a thumbnail in the blog post?
  90. How can i take all ids from untrash_post action?
  91. Can I Paginate Post after every 25 tag?
  92. How to show posts ordered by random [duplicate]
  93. Query posts from newest category
  94. Trim excerpt to first paragraph
  95. Adding div to WordPress page content
  96. WordPress loop uses unmodified posts array, why?
  97. How to display custom content in post with category XXX
  98. Display only posts with comments
  99. how to show all type of author posts in author page (SOLVED)
  100. WordPress Page Column Problem [closed]