Cannot add or update a child row: a foreign key constraint fails

You’re getting this error because you’re trying to add/update a row to table2 that does not have a valid value for the UserID field based on the values currently stored in table1. If you post some more code I can help you diagnose the specific cause.

Related Posts:

  1. Cannot add or update a child row: a foreign key constraint fails
  2. How to make MySQL table primary key auto increment with some prefix
  3. sql query with multiple where statements
  4. Cannot delete or update a parent row: a foreign key constraint fails
  5. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  6. Syntax error due to using a reserved word as a table or column name in MySQL
  7. MySQL root password change
  8. Installation of MySQL for Visual Studio 1.2.8 failed
  9. How do I import an SQL file using the command line in MySQL?
  10. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  11. Select from multiple tables without a join?
  12. SQL Query Where Field DOES NOT Contain $x
  13. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  14. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  15. mysqladmin: connect to server at ‘localhost’ failed
  16. Mysql command not found in OS X 10.7
  17. MySQL – UPDATE query based on SELECT Query
  18. grabbing first row in a mysql query only
  19. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  20. Order a MySQL table by two columns
  21. MySQL AS keyword
  22. Should I use the datetime or timestamp data type in MySQL?
  23. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  24. How do I change the data type for a column in MySQL?
  25. Unknown Column In Where Clause
  26. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  27. Cannot connect to Database server (mysql workbench)
  28. mysqld: Can’t change dir to data. Server doesn’t start
  29. How to solve “Error: MySQL shutdown unexpectedly”?
  30. How to create a foreign key in phpmyadmin
  31. Can you do a For Each Row loop using MySQL?
  32. Drop all databases in MySQL
  33. CAST to DECIMAL in MySQL
  34. How to properly create composite primary keys – MYSQL
  35. MySQL – count total number of rows in php
  36. How to get the count of each distinct value in a column?
  37. Data is not constantly loading from custom wordpress table
  38. How do you properly prepare a %LIKE% SQL statement?
  39. How to run WordPress across 2 VMs for high availability
  40. Mysqldump add drop table?
  41. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  42. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  43. #1115 – Unknown character set: ‘utf8mb4’
  44. WordPress Deadlock Error
  45. How to do a MySQL dump from production site without using a search and replace script for local development?
  46. How to bulk edit canonical url’s in SQL?
  47. Concurrent / simultaneous MySQL connections
  48. How to check for empty and not a failure
  49. Database: Custom table: sprintf value for DateTime column
  50. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  51. Keeping database within limits, please help!
  52. Best settings for MySQL to speed up site? [closed]
  53. WP_USE_EXT_MYSQL
  54. HTML Entities in Post Title
  55. Can’t find my wordpress DB in phpmyadmin
  56. Deprecated: mysql_connect():
  57. WordPress post_status is future, manually added
  58. $wpdb select all meta for each post
  59. Calculate average crossing post categories
  60. Replacing link URL ending strings via MySQL
  61. Many slow queries post_type = ‘attachment’;
  62. SQL command to convert all tags in lowercase?
  63. Problem with admin login after deployment
  64. Find out how many times the user has logged in
  65. WordPress plugins for database queries
  66. Is it possible to create a WordPress table using array and loop?
  67. Can’t run database query
  68. WordPress doesn’t display accents after migration
  69. How to stop $wpdb from prepending database name
  70. Match tag names with form titles
  71. Error missing MySQL extension
  72. Getting Error Trying to Create Table
  73. Best approach for a custom database filling in WP custom post types
  74. Why doesn’t custom mysql query return results? Is syntax correct?
  75. $wpdb->get_var multiple queries in one database check
  76. Insert two row in wordpress database
  77. SQL statement using placeholder is not returning results
  78. How to Bulk find and replace MySQL for post image url
  79. Data is not constatntly loading from custom wordpress table
  80. Mysql Server keeps crashing
  81. Wpdb query with dynamic table name
  82. How to add virtual column in wpdb get_result statement
  83. Regular XML-RPC timeouts
  84. update multiple rows in mysqli table base on two values
  85. How can I verify WordPress nonce from the following code?
  86. How to write in MySQL more characters in user_nicename
  87. $wpdb->get_var not returning count
  88. Custom user query – orderby meta_key (that may not exist)
  89. Weird characters displayed when importing WordPress MySQL db
  90. How to get Attachments(image) with specific width\height ratio
  91. What is the cron doing?
  92. Apache Redirect based on WordPress permissions
  93. SQL error on restoring database
  94. MySQL database gives blank page (white screen of death)
  95. Datatabase error: Commands out of sync
  96. optimise SQL wordpress call
  97. why is $wpdb->update() causing a DB error from within wp_set_password()
  98. Global MySQL replacing of text patterns/matches
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment