The line in "my.ini" isn't the same as the default sql_mode in MySQL 5.7.
1 = default mode
2 = default my.ini in wamp
1 = ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
2 = NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER , STRICT_ALL_TABLES
For me, that works (as I need to disable "ONLY FULL GROUP BY" anyway). I was just wondering why wampserver changes the defaults?
p.s. how do you include code in a post like you did?
Edited 2 time(s). Last edit at 11/29/2015 03:09PM by enorog.