KM报错原因？

【myApps/OBPM版本号】：4.4stable sp21
【浏览器类型】：Chrome
【技术QQ群】：182378297
【场景】：KM多次报错：org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ( SELECT * FROM KMS_FILE KF LEFT JOIN KMS_PREVIEW_FILE KPF ON KF.ID = KPF.FILE_ID where 1=1 AND DISK_ID IN (  SELECT ID FROM obpm2.KMS_DISK WHERE  TYPE = 1 OR  TYPE = 2 OR  TYPE = 8 )  AND KPF.PREVIEW_ID='7c211c48-beae-4857-b1b8-c51e38ee0799' GROUP BY KF.ID ORDER BY KPF.PREVIEW_TIME DESC ) AS TB  ORDER BY TB.LAST_VIEW_DATE DESC LIMIT 0,10]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'obpm2.KPF.PREVIEW_TIME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

【解决方法】：
在my.ini加上sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION