no posts showing up in calendar

Depending on how you did the import I’ve seen some cases where the new blog posts all came in with the same date. Do you posts show up with the correct dates when you look at them through the normal WordPress edit screen?

Dates all correct was a straight mysqldump and MySQL import. Which is why I don’t know how it could get messed up.

So the dates are all showing up correctly in the database. Do they show up correctly in the WordPress edit screens? If you make a new post does it show up correctly in the calendar? Did you change versions of MySQL during this migration?

Yep dates all correct, mysql version will have changed yes. Unsure what the old host used but that’s never been a problem in any site I’ve migrated before. To this host and others.

Making a new post with the plugin on the calendar page shows it on the screen once saved but if you refresh the page it goes away and doesn’t save it as a draft in WordPress.

Ah no sorry I tell a lie the draft posts do get created they just don’t show up on the calendar page.

Server logs are reporting this which looks to be the issue

PHP message: WordPress database error Incorrect DATETIME value: ‘0000%’ for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND post_date_gmt LIKE ‘0000%’ ORDER BY wp_posts.post_title DESC made by do_action(‘wp_ajax_edcal_posts’), WP_Hook->do_action, WP_Hook->apply_filters, EdCal->edcal_posts, query_posts, WP_Query->query, WP_Query->get_posts” while reading response header from upstream

The new site runs on PHP 7.1 is there any issues with the plugin and that version?

Which lead me to this post

https://www.ads-software.com/support/topic/zero-dates-and-mysql-8/

We are running Mysql 8 as well so that seems to be the root cause. How can we go about resolving it?

I’ve seen this issue a couple of times before. WordPress uses zero dates to indicate a post which is in draft status and not at a specific date. This does work with many configurations of MySQL 8.

This post indicates how to remove strict mode. You might try that: https://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime

Thanks, Zach appreciate your willingness to help but messing with a site database to get your plugin to work isn’t a feasible working solution in my book. So we’ve swapped to an alternative editorial calendar plugin that doesn’t suffer from this issue.

Thanks again