Support » Plugin: Editorial Calendar » no posts showing up in calendar

  • Chris

    (@rtwlabs)


    Hi, we’ve just migrated a site to a new web host and now none of the blogs posts/drafts show up in the calendar. Nothing changed in relation to the database content we just dumped it and imported at the new server.

    Do you happen to have any suggestions on how we can get it working again?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Zack Grossbart

    (@zgrossbart)

    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?

    Thread Starter Chris

    (@rtwlabs)

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

    Plugin Author Zack Grossbart

    (@zgrossbart)

    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?

    Thread Starter Chris

    (@rtwlabs)

    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.

    Thread Starter Chris

    (@rtwlabs)

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

    Thread Starter Chris

    (@rtwlabs)

    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?

    Thread Starter Chris

    (@rtwlabs)

    Which lead me to this post

    https://wordpress.org/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?

    Plugin Author Zack Grossbart

    (@zgrossbart)

    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

    Thread Starter Chris

    (@rtwlabs)

    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

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘no posts showing up in calendar’ is closed to new replies.