解决【西瓜】同城到家默认导入数据在DZ X3.5 utf8mb4编码InnoDB引擎报错doesn't have a default value的解决办法

admin · 发表于 2022-8-10 14:46:45

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

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

×

解决【西瓜】同城到家默认导入数据在DZ X3.5 utf8mb4编码InnoDB引擎报错#1364 - Field 'xxx' doesn't have a default value的解决办法：

也是DZ X3.5中遇到导入初始数据报错#1364 - Field 'xxx' doesn't have a default value的通用解决办法：

【请在遇到该类问题的时候使用，没有此类问题请勿使用！！！】

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

升级语句1：

游客，如果您要查看本帖隐藏内容请回复

操作后，再次执行导入就正常了：（同上编辑框里面输入以下内容即可）

delete from pre_xigua_ho_cat;
INSERT INTO `pre_xigua_ho_cat` (`id`, `pid`, `name`, `icon`, `adimage`, `adlink`, `ts`, `o`, `pushtype`, `price`, `tag`, `placehoder`, `endtime`, `fid`, `in_ad`, `in_adlnk`, `isshow`, `multiprice`, `tpl`, `telpri`, `groups`, `verify1`, `verify2`, `bao`, `maxdig`, `apprice`, `share_title`, `share_desc`, `share_pic`, `cat_link`, `zdprice`, `jiaobiao`, `color`) VALUES
(4, 0, '装修维修', 'source/plugin/xigua_ho/static/img/icon2.png', '', '', 1574678980, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', 'source/plugin/xigua_ho/static/img/a1.png', '', '', '', '#80caca'),
(5, 4, '管道疏通', 'source/plugin/xigua_ho/static/img/gd.png', '', '', 1574678988, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(6, 4, '空调清洗', 'source/plugin/xigua_ho/static/img/kt.png', '', '', 1574679006, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(7, 0, '保姆月嫂', 'source/plugin/xigua_ho/static/img/icon1.png', '', '', 1574679017, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', 'source/plugin/xigua_ho/static/img/a7.png', '', '', '', '#dd7b6d'),
(8, 7, '保姆', 'source/plugin/xigua_ho/static/img/bm.png', '', '', 1574679034, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(9, 4, '防水补漏', 'source/plugin/xigua_ho/static/img/fs.png', '', '', 1576040203, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(10, 4, '水路装修', 'source/plugin/xigua_ho/static/img/sl.png', '', '', 1576040203, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(11, 7, '钟点工', 'source/plugin/xigua_ho/static/img/zdg.png', '', '', 1576040203, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(12, 7, '月嫂', 'source/plugin/xigua_ho/static/img/ys.png', '', '', 1576040203, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(13, 7, '看护陪护', 'source/plugin/xigua_ho/static/img/kh.png', '', '', 1576040203, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(14, 4, '电路装修', 'source/plugin/xigua_ho/static/img/dl.png', '', '', 1576040289, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(15, 0, '家电维修', 'source/plugin/xigua_ho/static/img/icon3.png', '', '', 1576040325, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', 'source/plugin/xigua_ho/static/img/a8.png', '', '', '', '#bc7cec'),
(17, 0, '二手回收', 'source/plugin/xigua_ho/static/img/icon4.png', '', '', 1576040384, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', 'source/plugin/xigua_ho/static/img/a5.png', '', '', '', '#75aaef'),
(18, 0, '生活配送', 'source/plugin/xigua_ho/static/img/icon5.png', '', '', 1576040384, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', 'source/plugin/xigua_ho/static/img/a6.png', '', '', '', '#8fd6de'),
(19, 15, '电视维修', 'source/plugin/xigua_ho/static/img/ds.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(20, 15, '冰箱维修', 'source/plugin/xigua_ho/static/img/bx.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(21, 15, '热水维修', 'source/plugin/xigua_ho/static/img/rs.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(22, 15, '洗衣机维修', 'source/plugin/xigua_ho/static/img/xyj.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(23, 15, '家电安装', 'source/plugin/xigua_ho/static/img/jd.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(24, 15, '其他维修', '', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(25, 17, '家电回收', 'source/plugin/xigua_ho/static/img/jd.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(26, 17, '家具回收', 'source/plugin/xigua_ho/static/img/jj.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(27, 17, '办公回收', 'source/plugin/xigua_ho/static/img/bg.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(28, 17, '设备回收', 'source/plugin/xigua_ho/static/img/sb.png', '', '', 1577344079, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(29, 18, '桶装水', 'source/plugin/xigua_ho/static/img/tzs.png', '', '', 1577344130, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(30, 18, '液化气', 'source/plugin/xigua_ho/static/img/rq.png', '', '', 1577344130, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(31, 18, '跑腿服务', 'source/plugin/xigua_ho/static/img/pt.png', '', '', 1577344130, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', ''),
(32, 18, '派发传单', 'source/plugin/xigua_ho/static/img/cd.png', '', '', 1577344130, 0, '', '0.00', '', '', 0, '', '', '', 0, '', '', '0.00', '', 0, 0, 0, 0, '0.00', '', '', '', '', '', '', '');

复制代码

默认导入数据的效果体现位置：
后台——插件——到家插件——到家分类：
解决【西瓜】同城到家默认导入数据在DZ X3.5 utf8mb4编码InnoDB引擎报错doesn't have a default value的解决办法解决,西瓜,同城,到家,默认

后台——插件——到家插件——底部导航：

解决【西瓜】同城到家默认导入数据在DZ X3.5 utf8mb4编码InnoDB引擎报错doesn't have a default value的解决办法解决,西瓜,同城,到家,默认

©DZ插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
网站部分内容来源于网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。
如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解！