Always get creating a new table with foreign key

Your message_id is a BIGINT whereas the id of wp_ccwwhsh_sent_messages is INT. Replace BIGINT by INT and try again.

The error message, unfortunately, isn’t very helpful.

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. How does WordPress handle MySQL row lock errors?
  3. Search and replace text across all posts
  4. Can I explicitly specify ENGINE=InnoDB in WordPress?
  5. Bad Request (Invalid Hostname) on working server, database problem
  6. Changing BIGINT to INT
  7. greatest() function returns undefined property
  8. How to write one comment and publish on every post using database or plugin?
  9. How to determine what is generating large amount of database queries?
  10. Help With MySQL to WPDB Query Conversion
  11. How can I perform high-level database merging for WordPress within continues delivery?
  12. WordPress Backend HA (Automatic failover)
  13. Automatic switch to backup database on fail
  14. Migrating to WordPress Recipe Plugin and Some SQL Issues
  15. Multiple instance of data in plugin custom database table on plugin activation
  16. WordPress and a secondary database?
  17. plugin code is pulling information from database in one instance and not in other. What is wrong?
  18. Better ads plugin has 500.000 entries in wp_postmeta
  19. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  20. dbDelta not adding additional columns in plugin database update
  21. How to do database for download stats?
  22. DB Query not working in Plugin
  23. External wpdb connections in different plugins on single page
  24. WordPress plugin: efficient way to store large data
  25. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  26. Integrating Custom Database with WordPress
  27. How to display results from a data table with an encrypted user id?
  28. add_action for publish_post doesn’t work
  29. What database state changes happen after a post is manually “updated” with no changes?
  30. Cant create table on plugin activation
  31. Performing CRUD operations on front end in wordpress
  32. Store GravityForm data in phpmyadmin (mysql)
  33. Moving a few select DB tables to a new WP instance
  34. WordPress database problem wp_posts, primary key
  35. HyperDB failover Delay
  36. Write mysql credentials in plugin
  37. Using wp config to connect to a DB from a plugin
  38. How can I delete the options from DB when the plugin is deleted?
  39. Remove posts that start with similar words (like a delete duplicate posts plugin)
  40. Creating mySQL procedure with $wpdb
  41. DROP TABLE with uninstall hook not working
  42. How to check if tables in WordPress still exists after activations
  43. how to oauth1 Wp plug-in revoke/reset.?
  44. Prevent duplicate records in plugin table
  45. WpDataTables – View Image Directory
  46. get current date + 90 days and checking every day
  47. join 2 table orders wordpress plugin
  48. How do I run SQL queries on a WordPress web page? [closed]
  49. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  50. Delete query not working in plugin
  51. How to remove traces from widget during uninstallation
  52. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  53. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  54. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  55. Enabling WP_USE_EXT_MYSQL to support old plugin
  56. how to access all user dashboard on fronted page [closed]
  57. Insert data from .sql file in wordpress plugin
  58. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  59. How do I network enable a plugin for a multisite install via the database?
  60. import posts with dutch/special letters
  61. SQL to order by CPT results by user->display_name w/only user->ID known
  62. How can I change the meta_key for a particular piece of information?
  63. WordPress Integration with Google Groups
  64. Enabling plugin failed because MySQL user do not have CREATE permissions
  65. Create a table with wordpress plugin boilerplate
  66. WP Query. Is there a maximum size?
  67. wp_editor content in plugin options page
  68. WordPress page and plugin list using sql query
  69. WordPress plugin creating database in localhost but not on real host
  70. Why this function not working for install database on plugin activation
  71. WordPress Query wp-terms SLOW
  72. “Master” WordPress Multisite – Database Sync
  73. WP-DownloadManager – Query most download per week/month etc
  74. WooCommerce search products between price range using WP_Query
  75. How to create multiple database tables on plugin activation?
  76. Can I create a table on my DB without creating a plugin?
  77. WordPress : Explain Plugins & Theme string value in database
  78. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  79. Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
  80. Errors when trying to use a plugin to write to the database
  81. Creating a CSV with PHP inside the plugin directory
  82. _prime_post_caches in wordpress
  83. pagination on data fetched using SQL query
  84. Plugins in WP_Options but not Active
  85. Query multiple tables at once?
  86. Speeding SQL queries for a large database?
  87. How do i edit the plugin files in DataBase via phpMyAdmin?
  88. WordPress as a data-store?
  89. How to insert and call new data in wordpress website database through a plugin
  90. Cannot get wpdb data (Error in a simple fuction) [closed]
  91. Mass SQL WordPress Meta Key deletion
  92. Gathering and logging data from a plugin: how to do it without race conditions?
  93. How to pass the API key to the client from the database? [closed]
  94. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  95. WPDB: Update table
  96. correct validate and sql query
  97. Issue running db create table query from static method
  98. correct sql query
  99. SQL query, error
  100. Problem of encoding characters (apostrophes) in my posts publications