HC 问题:GET /callComponent/menu/getMenus 500 2054.273 ms - 48

HC
问题:GET /callComponent/menu/getMenus 500 2054.273 ms - 48
答案:这个getMenus老是返回500的错误
重新导入数据、重启orderServicele.
问题:this is incompatible with sql_mode=only_full_group_by(这个错误发生在mysql 5.7 版本及以上版本会出现的问题)
答案:select @@GLOBAL.sql_mode;
set @@GLOBAL.sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION;
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION;
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;

posted on 2022-04-15 13:31  阿释密达  阅读(35)  评论(0编辑  收藏  举报

导航