Changes between Initial Version and Version 1 of Ticket #54669, comment 4
- Timestamp:
- 12/09/2024 08:48:36 PM (2 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #54669, comment 4
initial v1 5 5 If we stop turning off ONLY_FULL_GROUP_BY we cause various plugins (among them WooCommerce) to start throwing 1140 errors as well as other group by errors. So we can't just take this out of core without breaking plugins. 6 6 7 A plugin or theme author who wants to remediate their legacy use of MySQL's nonstandard permissive GROUP BY functionality can test by using the 'incompatible_sql_modes'filter to remove the 'ONLY_FULL_GROUP_BY' element from the list of modes to turn off.7 A plugin or theme author who wants to remediate their legacy use of MySQL's nonstandard permissive GROUP BY functionality can test by using the [https://developer.wordpress.org/reference/hooks/incompatible_sql_modes/ 'incompatible_sql_modes'] filter to remove the 'ONLY_FULL_GROUP_BY' element from the list of modes to turn off. 8 8 9 9 But they'd best avoid leaving that filter in place when releasing their code.