马上注册,免费下载更多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个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,得到更好的正版服务。 您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。 如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解!
|