去评论
dz插件网

【子木】同城分类信息前台报错1364 Field 'uniacid' doesn't have a...

admin
2020/09/08 10:33:19
【子木】同城分类信息前台报错 SQLSTATE[HY000]: General error: 1364 Field 'uniacid' 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_token` CHANGE `uniacid` `uniacid` INT(10) UNSIGNED NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_token` CHANGE `mobile` `mobile` CHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_token` CHANGE `money` `money` INT(10) UNSIGNED NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_token` CHANGE `refreshtime` `refreshtime` INT(10) UNSIGNED NULL DEFAULT NULL;
  1. ALTER TABLE `pre_zimu_fenlei_token` CHANGE `blacklist` `blacklist` TINYINT(1) UNSIGNED NULL DEFAULT NULL;