`#1215 – Cannot add foreign key constraint

In order to make the wp_posts(ID) a REFERENCE for the FOREIGN KEY, you should also set the wp_pageviews.ID‘s attributes as UNSIGNED and keep the same data type for the wp_pageviews.ID as (bigint) .

Let me know if this helps you.

Related Posts:

  1. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  2. MySQL string replace
  3. MySQL error 2006: mysql server has gone away
  4. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  7. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  8. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  9. what does “/index.php?admin/admin_dashboard” in my url mean
  10. How to join two tables by multiple columns in SQL?
  11. How to get size of mysql database?
  12. SQL – Update multiple records in one query
  13. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  14. MySQL: Invalid use of group function
  15. mysqladmin: connect to server at ‘localhost’ failed
  16. mysql update multiple columns with same now()
  17. Usage of MySQL’s “IF EXISTS”
  18. LAST_INSERT_ID() MySQL
  19. Generating a random & unique 8 character string using MySQL
  20. MySQL > Table doesn’t exist. But it does (or it should)
  21. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  22. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  23. mysql count duplicates
  24. How to create a foreign key in phpmyadmin
  25. Can’t create test file lower test start server mysql
  26. MySQL delete multiple rows in one query conditions unique to each row
  27. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  28. CAST to DECIMAL in MySQL
  29. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  30. MySql – HAVING vs WHERE 
  31. How to stop mysqld
  32. Failed to Connect to MySQL at localhost:3306 with user root
  33. How do you properly prepare a %LIKE% SQL statement?
  34. Optimize Multiple Taxonomy Term MySQL Query?
  35. WordPress MySQL & PHP Performance
  36. What specific database privileges does WordPress need?
  37. Using source control with WordPress
  38. SQL query to update post_date (one post = one single date & time)
  39. Updating User Meta with SQL Query
  40. wpdb prepare syntax
  41. How to run this SQL query of wp_terms database
  42. How to copy post titles to post slug in phpmyadmin
  43. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  44. How to add and SQL query of posts only published
  45. Slow Mysql Queries
  46. Database: Custom table: sprintf value for DateTime column
  47. What is the most secure way to set up the MySQL user in WPMU?
  48. WP_USE_EXT_MYSQL
  49. writing inner join in wpdb
  50. Distinction on meta value on pre_get_posts
  51. Unknown collation when I import a dump from an existing site into a development database?
  52. PHP script can’t connect to Database on port 3307
  53. MySQL Rank & $wpdb
  54. WordPress post_status is future, manually added
  55. How are multiple WordPress WPDB queries handled?
  56. How to translate this mySQL query to $wpdb query
  57. Regarding “Insert query error” in wordpress
  58. Separate DB by yearly archive of WordPress
  59. WordPress plugin overloading with tmp tables
  60. Site not responding error – taking long to load [closed]
  61. WordPress(wpdb class) and mysql stored procedures
  62. WordPress plugins for database queries
  63. Update MySQL query so that it functions again
  64. WordPress doesn’t display accents after migration
  65. Replace a character in all post titles and slugs
  66. Array Formation Issue
  67. Understanding custom php that reads from WP MYSQL
  68. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  69. $wpdb->get_var multiple queries in one database check
  70. List users with the most posts in the last 30 days
  71. Way to extract wordpress data from folder backup
  72. Data is not constatntly loading from custom wordpress table
  73. Mysql Server keeps crashing
  74. edit_user_created_user hook – using to update Groups
  75. How to search usermeta table
  76. How to add virtual column in wpdb get_result statement
  77. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  78. I want to share local developement and staging DB — Is this very smart or very stupid?
  79. Extract all users along with yoast metadata description
  80. WordPress asks to install, but is already installed?
  81. Deleting a table row through query
  82. Improving performance of SQL sub-queries in WordPress
  83. An SQL query to find orphaned image attachments and their meta
  84. Weird characters displayed when importing WordPress MySQL db
  85. Simple SQL Query in wordpress
  86. Saving custom term value to the database in new table
  87. How to restore: Database intact but folders deleted
  88. XML RPC post produces immediate revision with odd post_date_gmt
  89. MYSQL Join on meta key value?
  90. Woocommerce: Grab total revenue of a product over all orders
  91. Complicated MySQL Query
  92. problem with quotes on new post
  93. SQL Database Lost
  94. Where other than wp-config can database access details be defined?
  95. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  96. Why does the MySQL command line tool ignore the –port parameter?
  97. How can I show user’s privileges in MySQL?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?