[wp-trac] [WordPress Trac] #8857: Make WP MySQL strict mode compliant

[WordPress Trac]

#8857: Make WP MySQL strict mode compliant
-------------------------+----------------------
 Reporter:  ghostks      |       Owner:  (none)
     Type:  enhancement  |      Status:  closed
 Priority:  lowest       |   Milestone:
Component:  Database     |     Version:  2.7
 Severity:  minor        |  Resolution:  wontfix
 Keywords:               |     Focuses:
-------------------------+----------------------

Comment (by helen):

 @nsinelnikov I suppose a user could create a database with an incompatible
 mode before installing WordPress, although WordPress itself attempts to
 set modes accordingly so it will function. This is not at all my area of
 expertise, only historical knowledge - I don't know if there's something
 you're doing that causes this or if it's something we should prevent, but
 that would be a separate ticket IMO.

 I do not remember off the top of my head what the symptoms are if somehow
 you've ended up in strict mode but my recollection is that from a user
 perspective there will be errors ranging from visual to very functional
 anywhere core is relying on a zero date - if you search core for
 "0000-00-00" you'll see the beginning of the scope of its impact. And
 again, WordPress sets the current SQL mode, so perhaps it's an issue of
 being outside of that context by either doing direct file inclusions or
 running before the mode is set.

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