Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”

Related Posts:

1. WordPress (MyISAM) database is slow, should I switch to InnoDB?
2. Does WordPress use the InnoDB engine for MySQL by default?
3. Performance Gains of Relational DB Setup
4. Large database causes slow load
5. Is it safe to convert tables from MyISAM to InnoDB?
6. Is MariaDB’s Aria storage engine suitable for WordPress?
7. Bulk Updating Post Date in 1 day Increments
8. change the year on all of my custom post types?
9. Exclude Statement in SQL
10. Is it fine to have foreign key as primary key?
11. Custom form that store input in database
12. Restoring WordPress posts from database only
13. Can a post ID be 0?
14. Issue with wp_insert_post and post_content field error Could not update post in the database
15. wp_posts – guid update
16. what is the wp_5_posts table in the database?
17. Migrating data between local and development server
18. WordPress Database Charset/Collate
19. store simple data in get_option()
20. What is the database table for pages?
21. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
22. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
23. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
24. storing database in version control
25. Is deleting orphaned wp_options entries safe?
26. How to build a movie database with wordpress?
27. Sub-domain or 2nd, temporary different domain?
28. Hook to be used when creating a database table
29. Delete all post meta except featured image
30. Where is custom template file chosen for a post stored in the DB?
31. How do i get user data from a custom table in the wordpress database by user ID?
32. Converting WordPress into Android or iPhone app
33. Safe way to find last inserted id in a table?
34. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
35. WooCommerce sku location in DB
36. How to insert data into MySQL database from the form created in WordPress site
37. WordPress DATABASE Update Manually?
38. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
39. Multiple postmeta with same name for one post in wp_postmeta table
40. Which is more efficient? Using usermeta, or creating a new MySQL table?
41. Can I have multiple database users within WordPress?
42. A field with dashes in the slug [closed]
43. Modify Database in Multi-Site wp_usermeta table
44. Structure of postmeta meta_value for woocommerce product download
45. $wpdb doesn’t like to store arrays
46. Connect to a remote database for wordpress in my own hosting server
47. Handling large N data in WordPress
48. How to replicate a user plugin made table value, to this user’s custom meta table value?
49. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
50. WordPress returns to an old version
51. data (html) migration to posts
52. Super slow queries from author archive pages killing my database
53. localize elements in database
54. WordPress running SQL query to update database from form
55. How to fix database error duplicate entry
56. WPDB SQL query with prepare() returning variable, not db value
57. Get value form wordpress database
58. Moving to another server database connection error [closed]
59. Why this query is not showing any result on wordpresss home page?
60. Best practice to limit results in get_row()?
61. How to display content from external db with relevant urls
62. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
63. Connect to another WP install and grab post based on custom field
64. Which table (and column) has the content of configured get_post_meta?
65. Serialize data before inserting into the DB
66. Pages from custom table
67. content disappearing minutes after it’s published
68. What is the most efficient way to reset a WordPress site?
69. Add pdf to a website
70. Optimizing function that automatically creates internal links based on post title string
71. Can I customised default WP table
72. Woocommerce – Check product stock availability from external database
73. WordPress where clauses in db select
74. How to display data from db in select list [closed]
75. Will adding & modifying default WordPress table index break future WordPress update
76. echo site_url() returns a different value than what is in the database siteurl field
77. Native timestamp on wp_options option
78. _wp_attachment_metadata is not being added to database when PDF files uploaded
79. SELECT rows between two datetimes when the range is dynamic [closed]
80. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
81. adding user_id and name to a separate table whenever a user register based on role
82. How do I loop/iterate through posts to edit all img tags?
83. error establishing a database connection 3
84. How to edit posts/pages without making the change live?
85. Correct and secure way to access a custom SQL database in a custom PHP template file
86. How to optimise this database query?
87. How to retrieve user data based on role using SQL?
88. Does WordPress Support Using Named Pipes on the Windows Operating System?
89. Missing latest posts and options after DB migration via phpMyAdmin
90. Store id from database query in cookie
91. Split database on large site?
92. Store the wordpress “featured image” under »wp_posts« Database table
93. Custom metabox does not store data
94. What WordPress file is saving new users to database
95. wordpress database error
96. How do i get value from wp_postmeta?
97. Local host to server import problem
98. featured image not showing up with mysql_connect
99. Options of accessing wordpress data from mobile app
100. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment