去评论
dz插件网

【西瓜】同城商圈导入默认行业分类初始数据报错#1364 - Field 'goodindex' doesn't have a default value的解决办

admin
2022/08/10 15:03:32
【西瓜】同城商圈导入默认行业分类初始数据报错#1364 - Field 'goodindex' doesn't have a default value的解决办法：


如图所示：



常见是DZ X3.5版本utf8mb4编码InnoDB引擎情况下默认字段类型没有定义造成的：

解决办法：
后台——站长——数据库——升级：
如果没有看到输入框，需要将 config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1。


提交语句：
[此处包含隐藏内容，如果需要查看请回复]

然后重新导入默认导入数据：
  1. INSERT INTO `pre_xigua_hs_hangye` (`id`, `pid`, `name`, `icon`, `adimage`, `adlink`, `ts`, `o`, `pushtype`, `price`, `tag`, `placehoder`, `endtime`, `cat_ids`) VALUES
  2. (1, 0, '休闲娱乐', 'http://i1.bvimg.com/519162/42fcd20ec09ea6a2.png', '', '', 1501240370, 1, '', '0.00', '', '', 0, ''),
  3. (2, 1, '美容美发', '', '', '', 1501252631, 0, '', '0.00', '', '', 0, ''),
  4. (4, 1, '游戏电玩', '', '', '', 1501252749, 0, '', '0.00', '', '', 0, ''),
  5. (5, 1, '文体户外', '', '', '', 1501252981, 0, '', '0.00', '', '', 0, ''),
  6. (7, 0, '美食餐饮', 'http://i1.bvimg.com/519162/51d1d3cfb97480b4.png', '', '', 1501253005, 0, '', '0.00', '', '', 0, '31,20'),
  7. (9, 7, '早点早餐', '', '', '', 1501348388, 0, '', '0.00', '', '', 0, '31,20'),
  8. (10, 7, '饭店餐厅', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  9. (11, 7, '快餐外卖', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  10. (12, 7, '烤串烤肉', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  11. (13, 7, '宵夜烧烤', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  12. (14, 7, '火锅香锅', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  13. (15, 7, '简餐西餐', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  14. (16, 7, '甜品饮料', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  15. (17, 7, '零食小吃', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  16. (18, 7, '水果生鲜', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  17. (19, 7, '肉类海鲜', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
  18. (20, 1, '亲子活动', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  19. (21, 1, '按摩养生', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  20. (22, 1, '清吧网咖', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  21. (23, 1, '游泳健身', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  22. (24, 1, '足浴洗浴', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  23. (25, 1, 'KTV酒吧', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  24. (26, 1, '影院咖啡', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
  25. (27, 0, '酒店旅游', 'http://i1.bvimg.com/519162/e374d2c37db7b436.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  26. (28, 0, '生活服务', 'http://i1.bvimg.com/519162/3af8cf6182205680.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  27. (29, 0, '汽车服务', 'http://i1.bvimg.com/519162/d0e34d37a11e507e.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  28. (30, 0, '母婴专区', 'http://i1.bvimg.com/519162/9384c47fcaf139bd.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  29. (31, 0, '婚纱摄影', 'http://i1.bvimg.com/519162/300df487b4c8541c.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  30. (32, 0, '教育培训', 'http://i1.bvimg.com/519162/6c4a894f44f52136.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  31. (33, 0, '家居建材', 'http://i1.bvimg.com/519162/c5129d560ae71aae.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  32. (34, 0, '房产楼盘', 'http://i1.bvimg.com/519162/280044e74f3fdd28.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  33. (35, 0, '商务服务', 'http://i1.bvimg.com/519162/befc19bad85596c0.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  34. (36, 0, '农林牧渔', 'http://i1.bvimg.com/519162/60a67c9819e80ac8.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
  35. (37, 0, '其他', 'http://i1.bvimg.com/519162/1faa5468ece65f4c.png', '', '', 1502811676, 1, '', '0.00', '', '', 0, ''),
  36. (38, 27, '民宿客栈', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  37. (39, 27, '星级酒店', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  38. (40, 27, '商务宾馆', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  39. (41, 27, '旅游景点', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  40. (42, 27, '旅行社', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  41. (43, 27, '农家乐', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  42. (44, 27, '度假村', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  43. (45, 28, '家政服务', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  44. (46, 28, '开锁修车', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  45. (47, 28, '管道疏通', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  46. (48, 28, '搬家物流', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  47. (49, 28, '家电维修', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  48. (50, 29, '驾校教练', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  49. (51, 29, '汽配销售', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  50. (52, 29, '维修保养', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  51. (53, 29, '洗车美容', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  52. (54, 29, '租赁销售', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  53. (55, 30, '儿童玩具', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  54. (56, 30, '母婴用品', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  55. (57, 30, '母婴健康', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  56. (58, 31, '婚庆公司', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  57. (59, 31, '喜糖铺子', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  58. (60, 31, '婚纱摄影', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  59. (61, 31, '影视制作', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  60. (62, 32, '幼儿园', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  61. (63, 32, '特长培训', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  62. (64, 32, '家教辅导', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  63. (65, 32, '职业技能', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  64. (66, 33, '五金建材', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  65. (67, 33, '装修装饰', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  66. (68, 33, '陶瓷卫浴', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  67. (69, 33, '地板瓷砖', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  68. (70, 33, '家居家私', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  69. (71, 33, '智能家居', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  70. (72, 33, '油漆涂料', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  71. (73, 33, '灯具灯饰', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
  72. (74, 34, '新房新盘', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  73. (75, 34, '二手中介', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  74. (76, 34, '房产评估', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  75. (77, 35, '网络营销', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  76. (78, 35, '印刷包装', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  77. (79, 35, '广告传媒', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  78. (80, 35, '工商注册', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  79. (81, 35, '设计策划', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  80. (82, 36, '农作物', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  81. (83, 36, '园林花卉', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  82. (84, 36, '畜禽养殖', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
  83. (85, 37, '其他', '', '', '', 1502812148, 2, '', '0.00', '', '', 0, '');



导入后体现效果：
后台 —— 插件 —— 西瓜商圈 —— 行业：


进入原文参与互动