报错SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp.ip.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mo
MySQL 5.7以后自行手动调整
解决方法
打开mysql配置文件,在[mysqld]下添加如下一行:sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES