Emlog6.0 TagName错误

2016-11-4 Admin

Emlog6.0在MySQL5.x可能会出现不能添加标签错误 解决方法 执行SQL命令: ALTER TABLE `emlog_tag` CHANGE `gid` `gid` text COLLATE 'utf8_general_ci' NULL AFTER `tagname`;

阅读全文>>

评论(0) 浏览(815)

MySQL5.7.6+ Order By错误

2016-11-4 Admin

Expression #1 of ORDER BY clause is not in SELECT list, references column **' which is not in SELECT list; this is incompatible with DISTINCT 解决方法 在/etc/my.cnf中添加: sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

阅读全文>>

评论(0) 浏览(680)


Powered by emlog | Theme by BootStrap | Author by UbranGames | 苏ICP备14054908号-6 | sitemap | Load Time:2.98ms