Mac | MAMP Path Migrations and MySQL Fixes

Friday, October 29th, 2021 | System

MAMP Migration

 

sudo apachectl stop

 

  1. Convert ALL DateModified values to CURRENT_TIMESTAMP and NOT NULL
  2. Update ALL system paths from htdocs -> Sites

 

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


Comments


E19 Creative

Products | Community | Support | About | Contact | Login