MySQL Strict Mode Comptatibility

When enabling hyperdb, wordpress starts throwing errors anytime invalid datetime values are used. This does not happen when using normal database connectivity. I’m using percona server 5.7 with strict mode enabled.

PHP message: WordPress database error Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘post_date_gmt’ at row 1 for query INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (6, ‘2020-01-13 19:57:36’, ‘0000-00-00 00:00:00’, ”, ”, ‘Auto Draft’, ”, ‘auto-draft’, ‘post’, ‘closed’, ‘open’, ”, ”, ”, ”, ‘2020-01-13 19:57:36’, ‘0000-00-00 00:00:00’, 0, 0, ”, ”) made by wp_insert_post

PHP message: WordPress database error Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘foo.wp_posts.post_date’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by for query SELECT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC made by wp_get_archives’, referer: https://foo

• This topic was modified 5 years, 2 months ago by nambrosch.
• This topic was modified 5 years, 2 months ago by nambrosch.