马上注册,免费下载更多dz插件网资源。
您需要 登录 才可以下载或查看,没有账号?立即注册
×
【西瓜】同城商圈导入默认行业分类初始数据报错#1364 - Field 'goodindex' doesn't have a default value的解决办法:
如图所示:
常见是DZ X3.5版本utf8mb4编码InnoDB引擎情况下默认字段类型没有定义造成的:
解决办法:
后台——站长——数据库——升级:
如果没有看到输入框,需要将 config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1。
提交语句:
然后重新导入默认导入数据:
- INSERT INTO `pre_xigua_hs_hangye` (`id`, `pid`, `name`, `icon`, `adimage`, `adlink`, `ts`, `o`, `pushtype`, `price`, `tag`, `placehoder`, `endtime`, `cat_ids`) VALUES
- (1, 0, '休闲娱乐', 'http://i1.bvimg.com/519162/42fcd20ec09ea6a2.png', '', '', 1501240370, 1, '', '0.00', '', '', 0, ''),
- (2, 1, '美容美发', '', '', '', 1501252631, 0, '', '0.00', '', '', 0, ''),
- (4, 1, '游戏电玩', '', '', '', 1501252749, 0, '', '0.00', '', '', 0, ''),
- (5, 1, '文体户外', '', '', '', 1501252981, 0, '', '0.00', '', '', 0, ''),
- (7, 0, '美食餐饮', 'http://i1.bvimg.com/519162/51d1d3cfb97480b4.png', '', '', 1501253005, 0, '', '0.00', '', '', 0, '31,20'),
- (9, 7, '早点早餐', '', '', '', 1501348388, 0, '', '0.00', '', '', 0, '31,20'),
- (10, 7, '饭店餐厅', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (11, 7, '快餐外卖', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (12, 7, '烤串烤肉', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (13, 7, '宵夜烧烤', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (14, 7, '火锅香锅', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (15, 7, '简餐西餐', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (16, 7, '甜品饮料', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (17, 7, '零食小吃', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (18, 7, '水果生鲜', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (19, 7, '肉类海鲜', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, '31,20'),
- (20, 1, '亲子活动', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (21, 1, '按摩养生', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (22, 1, '清吧网咖', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (23, 1, '游泳健身', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (24, 1, '足浴洗浴', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (25, 1, 'KTV酒吧', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (26, 1, '影院咖啡', '', '', '', 1502811540, 0, '', '0.00', '', '', 0, ''),
- (27, 0, '酒店旅游', 'http://i1.bvimg.com/519162/e374d2c37db7b436.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (28, 0, '生活服务', 'http://i1.bvimg.com/519162/3af8cf6182205680.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (29, 0, '汽车服务', 'http://i1.bvimg.com/519162/d0e34d37a11e507e.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (30, 0, '母婴专区', 'http://i1.bvimg.com/519162/9384c47fcaf139bd.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (31, 0, '婚纱摄影', 'http://i1.bvimg.com/519162/300df487b4c8541c.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (32, 0, '教育培训', 'http://i1.bvimg.com/519162/6c4a894f44f52136.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (33, 0, '家居建材', 'http://i1.bvimg.com/519162/c5129d560ae71aae.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (34, 0, '房产楼盘', 'http://i1.bvimg.com/519162/280044e74f3fdd28.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (35, 0, '商务服务', 'http://i1.bvimg.com/519162/befc19bad85596c0.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (36, 0, '农林牧渔', 'http://i1.bvimg.com/519162/60a67c9819e80ac8.png', '', '', 1502811676, 0, '', '0.00', '', '', 0, ''),
- (37, 0, '其他', 'http://i1.bvimg.com/519162/1faa5468ece65f4c.png', '', '', 1502811676, 1, '', '0.00', '', '', 0, ''),
- (38, 27, '民宿客栈', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (39, 27, '星级酒店', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (40, 27, '商务宾馆', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (41, 27, '旅游景点', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (42, 27, '旅行社', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (43, 27, '农家乐', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (44, 27, '度假村', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (45, 28, '家政服务', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (46, 28, '开锁修车', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (47, 28, '管道疏通', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (48, 28, '搬家物流', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (49, 28, '家电维修', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (50, 29, '驾校教练', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (51, 29, '汽配销售', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (52, 29, '维修保养', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (53, 29, '洗车美容', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (54, 29, '租赁销售', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (55, 30, '儿童玩具', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (56, 30, '母婴用品', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (57, 30, '母婴健康', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (58, 31, '婚庆公司', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (59, 31, '喜糖铺子', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (60, 31, '婚纱摄影', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (61, 31, '影视制作', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (62, 32, '幼儿园', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (63, 32, '特长培训', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (64, 32, '家教辅导', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (65, 32, '职业技能', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (66, 33, '五金建材', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (67, 33, '装修装饰', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (68, 33, '陶瓷卫浴', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (69, 33, '地板瓷砖', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (70, 33, '家居家私', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (71, 33, '智能家居', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (72, 33, '油漆涂料', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (73, 33, '灯具灯饰', '', '', '', 1502812027, 0, '', '0.00', '', '', 0, ''),
- (74, 34, '新房新盘', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (75, 34, '二手中介', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (76, 34, '房产评估', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (77, 35, '网络营销', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (78, 35, '印刷包装', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (79, 35, '广告传媒', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (80, 35, '工商注册', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (81, 35, '设计策划', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (82, 36, '农作物', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (83, 36, '园林花卉', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (84, 36, '畜禽养殖', '', '', '', 1502812148, 0, '', '0.00', '', '', 0, ''),
- (85, 37, '其他', '', '', '', 1502812148, 2, '', '0.00', '', '', 0, '');
复制代码
导入后体现效果:
后台 —— 插件 —— 西瓜商圈 —— 行业:
©DZ插件网所发布的一切资源仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。 网站部分内容来源于网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,得到更好的正版服务。 您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。 如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解!
|