·设为首页收藏本站📧邮箱修改🎁免费下载专区💎积分✅卡密📒收藏夹👽聊天室
返回列表 发布新帖

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

199 4
发表于 2022-8-10 15:03:32 | 查看全部 阅读模式 | Chrome| Windows 10

马上注册,免费下载更多dz插件网资源。

您需要 登录 才可以下载或查看,没有账号?立即注册

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


如图所示:
【西瓜】同城商圈导入默认行业分类初始数据报错#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, '');
复制代码



导入后体现效果:
后台 —— 插件 —— 西瓜商圈 —— 行业:
【西瓜】同城商圈导入默认行业分类初始数据报错#1364 - Field 'goodindex' doesn't have a default value的解决办 西瓜,同城,商圈,导入,默认

我要说一句 收起回复
一花一世界,一叶一追寻。一曲一场叹,一生为一人。
创宇盾启航版免费网站防御网站加速服务

评论4

semh0086Lv.2 发表于 2022-8-23 01:09:58 | 查看全部 | Google Chrome | Windows 10
楼主发贴辛苦了,谢谢楼主分享!
这东西我收了!谢谢楼主!dz插件网真好!
我要说一句 收起回复
AnletonLv.2 发表于 2022-10-11 15:37:50 | 查看全部 | Google Chrome | Windows 10
商圈导入默认行业分类初
我要说一句 收起回复
fadpeaLv.2 发表于 2023-2-28 16:50:20 | 查看全部 | Google Chrome | Windows 10
导入默认行业分类初始数据报错#1364 - Field 'goodindex' does
我要说一句 收起回复
shangjinLv.2 发表于 2023-5-4 22:01:31 | 查看全部 | Google Chrome | Windows 10
这个要看一看的呢
我要说一句 收起回复

回复

 懒得打字嘛,点击右侧快捷回复【查看最新发布】   【应用商城享更多资源】
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

图文热点
创宇盾启航版免费网站防御网站加速服务
投诉/建议联系

discuzaddons@vip.qq.com

未经授权禁止转载,复制和建立镜像,
如有违反,按照公告处理!!!
  • 联系QQ客服
  • 添加微信客服

联系DZ插件网微信客服|最近更新|Archiver|手机版|小黑屋|DZ插件网! ( 鄂ICP备20010621号-1 )|网站地图 知道创宇云防御

您的IP:18.116.24.111,GMT+8, 2024-11-22 07:57 , Processed in 0.575092 second(s), 110 queries , Gzip On, Redis On.

Powered by Discuz! X5.0 Licensed

© 2001-2024 Discuz! Team.

关灯 在本版发帖
扫一扫添加微信客服
QQ客服返回顶部
快速回复 返回顶部 返回列表