[wp-trac] [WordPress Trac] #48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+

[WordPress Trac]

#48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+
--------------------------+-----------------------------
 Reporter:  jnylen0       |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:
--------------------------+-----------------------------

Comment (by jnylen0):

 Replying to [comment:5 kenjigarland]:
 > For any fellow WP + Digital Ocean managed database users out there who
 come across this ticket in the future, sometime after @jnylen0's comment
 above, Digital Ocean added a "Global SQL Mode" option to the Settings tab
 for managed db servers in their control panel, so now customers **can**
 change the default sql_mode.

 Thanks for the update @kenjigarland.

 > That setting came in handy for my agency, where my coworkers & I ran
 into a few issues with plugins that used custom queries containing double
 quotes. Turned out we still needed to explicitly disable `ANSI_QUOTES`,
 even though `ANSI` had been disabled by core.

 I have also seen this recently on a plugin, but we are going to fix the
 plugin instead.

 Another option would be to adapt the code I mentioned above
 (https://gist.github.com/nylen/abc5969a7bda5b3531edf84dfe9166ba) to
 disable `ANSI_QUOTES`, for me at least this would be better than requiring
 the database to have certain settings.

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