#1067 – Invalid default value for ‘post_date’ when trying to create a new column

This may not be the best solution. I am not an expert. But the following helped solve my problem and I can add columns using the PhpMyAdmin without getting any errors.

I went over to the SQL tab and then I ran the following query
show variables like 'sql_mode';
Then in order to remove i ran the following query
set global sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";

This helped solve my problem.

Related Posts:

  1. Why does changing Database Table Prefixes result in loss of content?
  2. DB prefix not updating
  3. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  4. Inserting Post Meta From SQL
  5. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  6. Delete all post meta except featured image
  7. How to execute mulitple statement SQL queries using $wpdb->query?
  8. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  9. Database with mixed collation (utf8mb4 & utf8_general_ci)
  10. Query WordPress database by registered date and role
  11. Set Display Name to first and last name (phpmyadmin SQL Query)
  12. Size article thumbnails and retrieve them directly from database
  13. Emojis getting converted to “?”
  14. Delete all post meta except featured image Using SQL
  15. wpdb_prepare with multiple or condition
  16. WordPress mysql table double prefixes
  17. SQL Error wp_commentmeta – incorrect table definition
  18. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  19. How do I get the posts within a certain year/date(with sql query)?
  20. WordPress database import: Row size too large
  21. WordPress Database Huge wp_usermeta Table
  22. Create table from array with prepare
  23. Query multiple tables at once?
  24. Changing root password in PHPMyAdmin for WordPress Database when going live
  25. Can’t update WordFence Options, clear data manually
  26. Why this query is not showing any result on wordpresss home page?
  27. How to migrate a database from a server to another
  28. SQL query to set posts in bulk based on the post content
  29. Files on Localhost, Database on Server
  30. $wpdb->get_var – What value is returned when zero records are found?
  31. Installing local to live WP into subdirectory
  32. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  33. How to edit custom table data in frontend
  34. How to map data on CSV to web pages?
  35. How to create index (sql) to a meta_key?
  36. Delete all users meta that named: user_avatar
  37. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  38. How to retrieve user data based on role using SQL?
  39. WordPress character set issue
  40. Missing latest posts and options after DB migration via phpMyAdmin
  41. Check if a database is well installed
  42. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  43. export individual posts to text files or a single csv file
  44. SQL query : Select a thumbnail for a media
  45. why you don’t Implement PDO for access every thing to database
  46. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  47. Have WordPress Use a Different Database for users
  48. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  49. Case statement in MySQL
  50. Oracle SQL query for Date format
  51. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  52. importing a CSV into phpmyadmin
  53. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  54. Using wpdb to connect to a separate database
  55. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  56. wpdb->insert multiple record at once
  57. WordPress for a very large website
  58. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  59. How to Join two tables from separate databases within WordPress
  60. Change SQL get_results to search for posts with custom term in custom taxonomy
  61. wpdb query on custom table not working [closed]
  62. stdObject stored in database. How does one convert it to usable format?
  63. Using table lock with wp_insert_post?
  64. Does WordPress ever need multiple databases?
  65. Why are no posts showing despite my apparently correct DB restoration?
  66. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  67. phpMyAdmin displays error when importing database
  68. WordPress database error – Error in SQL syntax – I can’t identify any error?
  69. Change WordPress prefix for only one table?
  70. Database Tables Lost Indexes? How to Recover?
  71. Migration: Copying database content to a different server
  72. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  73. Have working sql query… trying to adjust it to use $wpdb
  74. Remove empty rows from the database
  75. Custom WordPress Table wpdb
  76. how to encyrpt DB_PASSWORD in wp-config
  77. How can I detect right db type?
  78. Delete all posts that do NOT have a specific tag
  79. Changing order of db results when encoding to JSON
  80. Backing up WordPress database and files
  81. Link multiple user databases together?
  82. Sql query to get all metadata for a post
  83. Recovery – Restore Database after moving folder location locally
  84. Set a cron job to delete a specific database table table every midnight
  85. Job and Employee Performance Tracking with Product Safety
  86. Is there any defects for using same database prefix in WordPress for multiple sites?
  87. SQL database import #1046 error
  88. How to import products in host instead of database on wordpress?
  89. syntax error for changing user role from database
  90. I would like some help wth an SQL query to link posts with categories
  91. Where is the HTML-handler part in the wpdb class?
  92. next comment id number wordpress
  93. Merging development site with live site
  94. live site do not update after importing sql database
  95. MySQL Database User: Which Privileges are needed?
  96. Import Excel (or csv) Table with user-data as subscribers to wordpress
  97. Print output of Table Creation
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. WordPress database connection failed, while mysql client is working [closed]
  100. How to generate PDF dynamically based on values from the database in WordPress
tech