西瓜同城到家插件导入作者提供的默认默认导入数据报错#1364 - Field `nocheck``tuij` doesn't have a default value解决办法

admin · 发表于 2023-7-22 18:19:29

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

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

×

西瓜同城到家插件导入作者提供的默认默认导入数据报错#1364 - Field `nocheck`、`tuij`、`hidelevel`、`hideyg`、`hidetext`、`hidepic`、`pubtype` doesn't have a default value解决办法：

原因：`nocheck`、`tuij`、`hidelevel`、`hideyg`、`hidetext`、`hidepic`、`pubtype`这些字段没有指定默认值，在最新的X3.5 utf8mb4数据库格式里面会报错：

优化后的默认导入数据请粘贴：

delete from pre_xigua_ho_nav;
delete from pre_xigua_ho_cat;
INSERT INTO `pre_xigua_ho_nav` (`id`, `pid`, `name`, `icon`, `icon2`, `adimage`, `adlink`, `ts`, `o`, `pushtype`, `price`, `tag`, `placehoder`, `endtime`, `cat_ids`, `miao`, `qiang`, `goodindex`, `telprice`, `stids`, `aprice`, `iconname`, `up`, `highlight`, `type`) VALUES
(1, 0, '首页', 'source/plugin/xigua_ho/static/img/i1.png', 'source/plugin/xigua_ho/static/img/i2.png', '', 'plugin.php?id=xigua_ho', 1574218716, 0, '', '0.00', '', '', 0, '', 0, 0, 0, '0.00', '', '0.00', '', 0, '', ''),
(2, 0, '服务', 'source/plugin/xigua_ho/static/img/i3.png', 'source/plugin/xigua_ho/static/img/i4.png', '', 'plugin.php?id=xigua_ho&ac=cat', 1574218716, 0, '', '0.00', '', '', 0, '', 0, 0, 0, '0.00', '', '0.00', '', 0, '', ''),
(4, 0, '需求', 'source/plugin/xigua_ho/static/img/i5.png', 'source/plugin/xigua_ho/static/img/i6.png', '', 'plugin.php?id=xigua_ho&ac=needs&inmap=0', 1574221447, 0, '', '0.00', '', '', 0, '', 0, 0, 0, '0.00', '', '0.00', '', 0, '', ''),
(5, 0, '我的', 'source/plugin/xigua_ho/static/img/i7.png', 'source/plugin/xigua_ho/static/img/i8.png', '', 'plugin.php?id=xigua_ho&ac=my', 1574221447, 0, '', '0.00', '', '', 0, '', 0, 0, 0, '0.00', '', '0.00', '', 0, '', '');
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `nocheck` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `tuij` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `hidelevel` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `hideyg` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `hidetext` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `hidepic` INT DEFAULT 0;
ALTER TABLE `pre_xigua_ho_cat` MODIFY COLUMN `pubtype` INT DEFAULT 0;
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插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
本站信息来自网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
如有侵权请邮件与我们联系处理:discuz-x@qq.com（手机随时接收邮件）并出示相关证明以便删除。敬请谅解！