[wp-trac] [WordPress Trac] #26847: MySQL 5.6 default install can break WordPress

[WordPress Trac]

#26847: MySQL 5.6 default install can break WordPress
------------------------------------+------------------
 Reporter:  pento                   |       Owner:
     Type:  defect (bug)            |      Status:  new
 Priority:  normal                  |   Milestone:  3.9
Component:  Database                |     Version:  2.7
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:
------------------------------------+------------------

Comment (by morgantocker):

 It might be worth adding `ONLY_FULL_GROUP_BY` to the list of unsupported
 sql-modes.  I am running with it on my blog, and receiving some errors:

     [Mon Jan 27 12:27:56 2014] [error] [client 99.232.156.151] WordPress
 database error 'wordpress_tockerca.wp_posts.post_date' isn't in 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 require('wp-blog-header.php'), require_once('wp-includes
 /template-loader.php'), include('/themes/twentytwelve/single.php'),
 get_sidebar, locate_template, load_template,
 require_once('/themes/twentytwelve/sidebar.php'), dynamic_sidebar,
 call_user_func_array, WP_Widget->display_callback,
 WP_Widget_Archives->widget, wp_get_archives, referer:
 http://www.tocker.ca/categories/books

--
Ticket URL: <https://core.trac.wordpress.org/ticket/26847#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform