[兼容解决]发布信息出现转圈问题【单/多】

[兼容解决]发布信息出现转圈问题【单/多】

这是由于sql大于5.6导致

只需一步简单解决,不是大问题不要惊慌

找到你发布异常的转圈的模型例如你在房产发布会出现这情况

只需要去后台执行下方sql即可【如果是招聘就把下方的my_fang换成my_zhaopin即可】

ALTER TABLE my_fang CHANGE pics pics TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
当然您可以全部都弄来执行一遍

例如

ALTER TABLE `my_fang` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_zhaopin` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_qiuzhi` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_che` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_bianmin` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_zhaosheng` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_jiaoyi` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_dianhua` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_jiaoyou` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';
ALTER TABLE `my_qita` CHANGE `pics` `pics` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片多图';