出现问题:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ckshop.u.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql
解决方法:
在my.ini文件的
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #增加这行即可