去评论
dz插件网

子木分类信息管理后台分类列表里面添加字段报错1364 Field ...

admin
2020/09/08 11:40:36
子木分类信息管理后台分类列表里面添加字段报错 SQLSTATE[HY000]: General error: 1364 Field 'extra' doesn't have a default value 的解决办法:
问题原因解决方案同:
[子木]同城分类信息后台报SQLSTATE[HY000]: General error: 1364 Field...
https://www.dz-x.net/t/1273/1/1.html
(出处: DZ插件网)


解决办法:
  1. ALTER TABLE `pre_zimu_fenlei_cat_diy` CHANGE `extra` `extra` VARCHAR(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_cat_diy` CHANGE `max` `max` SMALLINT(3) UNSIGNED NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_cat_diy` CHANGE `required` `required` TINYINT(1) UNSIGNED NULL DEFAULT NULL;