Friday, October 29th, 2021 | System
MAMP Migration
sudo apachectl stop
PATH Updates:
Applications/MAMP/htdocs
Users/*username*/Sites
####
MySQL ZERO DATE issue:
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session;
SET sql_mode = '';
SET GLOBAL sql_mode = '';
MySQL GROUP BY ISSUE:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','));
NOTE: Removed ‘ONLY_FULL_GROUP_BY,’ from the SQL MODE variable
https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc