Support » Plugin: Editorial Calendar » Zero Dates and MySQL 8

  • Hi,

    I get “Incorrect DATETIME value: ‘0000%” if I open the calender. In
    wordpress/wp-content/plugins/editorial-calendar/edcal.php

    
     /* 
             * We add a WHERE clause to filter by calendar date and/or by whether
             * or not the posts have been scheduled to a specific date:
             * WHERE <code>post_date_gmt</code> = '0000-00-00 00:00:00'
             */
            add_filter( 'posts_where', array(&$this, 'edcal_filter_where' ));
            $myposts = query_posts($args);
            remove_filter( 'posts_where', array(&$this, 'edcal_filter_where' ));
    

    seems to be wrong. Zero dates are not allowed in MySQL 8 by default.

    Best regards

    • This topic was modified 9 months, 3 weeks ago by Ronny Harbich.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Zack Grossbart

    (@zgrossbart)

    We’ve seen a similar issue to this before. The problem was the where clause we were using. I know this works in some configurations of MySQL 8. Do you have any special configurations or settings in your MySQL?

    Thanks! My config seems to be default:

    sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

    According to https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html

    
    The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. 
    

    My config is somewhat less restrictive.

    
    mysql --version
    mysql  Ver 8.0.16 for Linux on x86_64 (MySQL Community Server - GPL)
    
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Zero Dates and MySQL 8’ is closed to new replies.