Friday, October 29th, 2021 | System
Last Modified: 2024-04-26
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
Input Action Output
A collection of snippets and links that have proven useful for development, programming, ColdFusion, Javascript, jQuery, PHP, Python, Dell, Minecraft, Apple, Mac, Windows, LINUX, Raspberry Pi, Adobe, CSS, and HTML.
©2024 Input Action Output