patch allowing wordpress to function normally on mysql strict servers
|Reported by:||WebDragon||Owned by:|
when the server is configured with sql-mode='ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY', installation and operation of wordpress fails, as it has not yet been modified to run in a strict environment.
This one-line patch to wp-db.php allows wordpress to function normally as it would on a default mysql install where strict is NOT enabled by default (we won't debate the merits of this horrifying decision by mysql developers)
you can preview it as a gist here: https://gist.github.com/WebDragon/6066884
and additionally I will attach it as a .patch
I've tested it here on my local system and all seems well (since it would die horribly otherwise)
Please consider adding this to core as a workaround for strict servers until such time as wordpress can be rewritten to function in a strict environment.