Problems with DBDelta with FOREIGN key?

As a general rule, dbDelta does not yet support FOREIGN KEY, though I’ve been told it works on MySQL 5.1 (I can confirm it doesnt work on MySQL 5.5).

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. How to use mysqli_query() in PHP?
  3. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL ERROR 1290 (HY000) –secure-file-priv option
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. What does SQL Select symbol || mean?
  9. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  10. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  11. Duplicating a MySQL table, indices, and data
  12. mysql Foreign key constraint is incorrectly formed error
  13. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  14. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  15. SELECT * FROM multiple tables. MySQL
  16. mysql: SOURCE error 2?
  17. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  18. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  19. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  20. Data truncated for column?
  21. MySQL foreach loop
  22. MySQL IF NOT NULL, then display 1, else display 0
  23. MySQL date format DD/MM/YYYY select query?
  24. MySQL Calculate Percentage
  25. Repair all tables in one go
  26. How can I output MySQL query results in CSV format?
  27. Error: select command denied to user ‘‘@’‘ for table ‘‘
  28. Get the new record primary key ID from MySQL insert query?
  29. How to change collation of database, table, column?
  30. Failed building wheel for mysql-python
  31. MySQL Error 1215: Cannot add foreign key constraint
  32. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  33. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  34. Remove Primary Key in MySQL
  35. How to get the max of two values in MySQL?
  36. mysql: connection refused when trying to connect to localhost using remote IP
  37. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  38. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  39. Complex meta query with 3 keys
  40. How can I find the source of slow queries in WordPress?
  41. How to log mysql errors from wordpress core?
  42. $wpdb and MySQL Create Trigger
  43. Programmatically changing role information; editing role name and deleting
  44. Fulltext search in posts sorted by relevancy
  45. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  46. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  47. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  48. How can I make wordpress suppress mysql errors?
  49. How to bulk delete all WordPress subscribers?
  50. Error while importing database
  51. Changing Table Prefix for an Existing WordPresss Site
  52. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  53. Mysql SELECT posts
  54. Connect another DB and fetch records from some tables
  55. Can I restart MySQL engine when WordPress website is live?
  56. Error: MySQL shutdown unexpectedly [closed]
  57. #1115 – Unknown character set: ‘utf8mb4’
  58. Why my wordpress loopback traffic while socket is setup?
  59. Update or insert meta key value – On Duplicate key update
  60. Connect to MySQL using Windows Authentication
  61. Defining the same price to all WooCommerce Products
  62. Database Structure on Different Servers
  63. Changing MySQL password via WHM – does this affect WordPress?
  64. How to get INSERT errors from $wpdb?
  65. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  66. string literals in query
  67. Export Yoast Keywords from MySQL/phpMyAdmin
  68. Same database; different WordPress
  69. Create pages from MySQL database
  70. How to insert dash (-) into database using wpdb and new_to_publish hook?
  71. MySQL: How to change url in posts from xxx.com to yyy.org?
  72. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  73. Exporting completed webiste for another server
  74. Upgrade DB Loop – WordPress DB Version Conflict
  75. WordPress & MySQL , problem with use many array in meta_query
  76. Button writing to MYSQL database
  77. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  78. MySQL ‘duplicate entry’ error
  79. Find locations of all featured images of draft posts via SQL
  80. WordPress Dutch characters encoding problem
  81. How to show result of sql query in a page?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. How do I insert content of various MySQL fields in post?
  84. How to change link in all posts?
  85. Select latest 2 articles, but only from given category
  86. CONCAT_WS in custom sql query
  87. Query does not filter duplicate _sku numbers
  88. Ordering topics by most replies in X days using MYSQL statement
  89. MySQL Select within WP Page template
  90. wp_postmeta – lot of meta fields
  91. Running WordPress from MySQL Cluster with HAPRoxy
  92. Delete posts with word count less than x number of words
  93. MySQL: get post_tag items that are tags (not SEO keywords)
  94. $wpdb->get_var returns 0
  95. cannot log in to the mysql server (wamp and wordpress)
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. Why does the MySQL command line tool ignore the –port parameter?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?

Leave a Comment