Gloria的博客

有的服务器上的MySQL会报如下的错误：SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bocai.bc_user_active.roomId' which...

有台centos服务器，LNMP环境，发现MySQL突然不能正常启动了，报错如下： 各种重启也不好使，百度了一堆，相关资料也不多。最终是因为系统文件都变成只读了，导致的问题。执行mount -o rw,remount /就正常了。...