FastAdmin插件wanlshop出现报错问题的解决
时间：2023年04月27日
编辑：佚名
B2B2C多商家短视频直播种草阶梯拼团电商系统wanlshop使用出现的问题解决
一、控制台出现打不开，出现提示this is incompatible with sql_mode=only_full_group_by
解决方案三：通过配置文件永久修改sql_mode
mysql安装在服务器上和安装在本地，修改配置文件的方式有点区别。
1、Linux下修改配置文件
1）登录进入MySQL
使用命令 mysql -u username -p 进行登陆，然后输入密码，输入SQL：
show variables like ‘%sql_mode’;
2）编辑my.cnf文件
文件地址一般在：/etc/my.cnf，/etc/mysql/my.cnf
使用vim命令编辑文件，不知道vim命令怎么使用的，可以参考我的另外篇文章：Linux中使用vi工具进行文本编辑
找到sql-mode的位置，去掉ONLY_FULL_GROUP_BY
然后重启MySQL；
有的my.cnf中可能没有sql-mode，需要追加：
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
注意要加入到[mysqld]下面，如加入到其他地方，重启后也不生效，具体的如下图：
3）修改成功后重启MySQL服务
service mysql restart
重启好后，再登录mysql，输入SQL：show variables like ‘%sql_mode’; 如果没有ONLY_FULL_GROUP_BY，就说明已经成功了。
如果还不行，那么只保留STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION 即可
追加内容为：
sql-mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
2、window下修改配置文件
1）找到mysql安装目录，用记事本直接打开my.ini文件
2）编辑my.ini文件，在[mysql]标签下追加内容
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
3）重启mysql 服务
备注：
网上有些提供了sql_mode的值，却导致重启mysql服务启动不了
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
这时，只需要将sql_mode 值中 “NO_AUTO_CREATE_USER” 这个属性去掉即可。
二、店铺管理中的运费模板打不开，提示id不能为null
解决方法：fa_wanlshop_shop_freight表数据删除或者fa_wanlshop_shop_freight_data表添加两行对应的数据
DROP TABLE IF EXISTS `fa_wanlshop_shop_freight_data`;
CREATE TABLE `fa_wanlshop_shop_freight_data` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`shop_id` int(10) NOT NULL DEFAULT 0 COMMENT '管理員ID',
`freight_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '運費模板ID',
`province` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '省份',
`citys` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '城市',
`first` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '首件',
`first_fee` decimal(10, 2) UNSIGNED NOT NULL COMMENT '運費',
`additional` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '續件',
`additional_fee` decimal(10, 2) UNSIGNED NOT NULL COMMENT '續件運費',
`createtime` int(10) NULL DEFAULT NULL COMMENT '創建時間',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新時間',
`deletetime` int(10) NULL DEFAULT NULL COMMENT '刪除時間',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '狀態',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '運費模板數據表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of fa_wanlshop_shop_freight_data
-- ----------------------------
INSERT INTO `fa_wanlshop_shop_freight_data` VALUES (1, 1, 1, '北京', '北京', 0, 10.00, 0, 100.00, 1643081402, NULL, NULL, 'normal');
INSERT INTO `fa_wanlshop_shop_freight_data` VALUES (2, 2, 2, '上海', '上海', 0, 10.00, 0, 100.00, 1643081401, NULL, NULL, 'normal');
三、装修商城中的模板管理打不开，选择不了模板或者保存出现服务器内部错误
解决方法：给id加主键
DROP TABLE IF EXISTS `fa_wanlshop_page`;
CREATE TABLE `fa_wanlshop_page` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID(id=1首页)',
`page_token` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '页面Token',
`shop_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店铺ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '自定义页面' COMMENT '页面名称',
`cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '页面封面',
`type` enum('page','shop','index','systpl') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'page' COMMENT '页面类型:page=单页,shop=店铺,index=首页,systpl=首页模板',
`page` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '页面配置',
`item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '项目',
`createtime` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`deletetime` int(10) NULL DEFAULT NULL COMMENT '删除时间',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '自定义装修页面' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of fa_wanlshop_page
-- ----------------------------
INSERT INTO `fa_wanlshop_page` VALUES (1, '936MLnKpzQJFa5No', 0, 'App 1.1.1新版首页', '/assets/addons/wanlshop/img/show/page_tpl1.png', 'systpl', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff4632\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#f5f5f5\",\"pageBackgroundImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/main_bg3x.png\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"no-repeat\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"advertBanner\",\"style\":{\"color\":\"#000000\",\"margin\":\"8px 12.5px 0 12.5px\",\"border-radius\":\"10px\",\"overflow\":\"hidden\"},\"params\":{\"interval\":\"2800\",\"height\":\"115px\",\"banstyle\":\"1\"}},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"menuType\":\"image\",\"colfive\":\"5\",\"menuMarginTop\":\"0\",\"menuMarginBottom\":\"0\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuBorderRadius\":\"1000px\",\"menuTextSize\":\"12px\"},\"style\":{\"color\":\"#333333\",\"margin\":\"12.5px\"},\"data\":[{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/1.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/2.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/3.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/4.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/5.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/6.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/7.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/8.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/9.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/10.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/activity-top-bg3x.png\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-orange\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u62fc\\u56e2\\u7ec4\\u4ef6\",\"type\":\"groups\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"overflow\":\"hidden\",\"margin\":\"12.5px\"},\"params\":{\"groupsBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/grueps-top-bg3x.png\",\"colmargin\":\"25\",\"titleText\":\"\\u70ed\\u95e8\\u62fc\\u56e2\",\"titleColor\":\"#ad4e00\",\"titleFontSize\":\"14px\",\"infoText\":\"\\u62fc\\u7740\\u4e70\\uff0c\\u66f4\\u4fbf\\u5b9c~\",\"infoColor\":\"#c75a00\",\"infoFontSize\":\"12px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673735, 1629673735, NULL, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (2, 'xEl17TgF9YmUaDQS', 0, '原旧版首页', '/assets/addons/wanlshop/img/show/page_tpl2.png', 'systpl', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff6608\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#0d164a\",\"pageBackgroundImage\":\"https:\\/\\/apis.wanlshop.com\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_bg.jpg\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"#ffffff\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"banner\",\"style\":{\"color\":\"#000000\"},\"params\":{\"interval\":\"2800\",\"height\":\"145px\",\"banstyle\":\"1\"},\"data\":[{\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_page_swiper.png\",\"tips\":\"\\u5c3d\\u91cf\\u4f7f\\u7528\\u9ad8\\u50cf\\u7d20\\u7d20\\u6750\\uff0c\\u5426\\u5219\\u53ef\\u80fd\\u51fa\\u73b0\\u865a\\u5316\",\"link\":\"\"}]},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"colfive\":\"5\",\"menuMarginTop\":\"12.5px\",\"menuMarginBottom\":\"5px\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuTextSize\":\"12px\",\"menuType\":\"icon\",\"menuBorderRadius\":\"1000px\"},\"style\":{\"color\":\"#ffffff\",\"margin\":\"0 12.5px\",\"padding\":\"6px 0\"},\"data\":[{\"text\":\"\\u7c7b\\u76ee\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-redorange\",\"link\":\"\\/pages\\/product\\/category\\/category\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8ba2\\u5355\",\"icon\":\"wlIcon-pintuan\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/order\\/order\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\\u6392\\u884c\",\"icon\":\"wlIcon-tubiao309\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-yellow\",\"link\":\"\\/pages\\/user\\/signin\\/rank\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8db3\\u8ff9\",\"icon\":\"wlIcon-kanjia\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-green\",\"link\":\"\\/pages\\/user\\/footprint\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8d2d\\u7269\\u8f66\",\"icon\":\"wlIcon-miaosha\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/cart\\/cart\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u4f1a\\u5458\\u4e2d\\u5fc3\",\"icon\":\"wlIcon-huiyuanzhongxin\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-red\",\"link\":\"\\/pages\\/user\\/user\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\",\"icon\":\"wlIcon-qiandao\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-orange\",\"link\":\"\\/pages\\/user\\/signin\\/signin\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u6d3b\\u52a8\\u9875\",\"icon\":\"wlIcon-saoyisao-copy\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-purple\",\"link\":\"\\/pages\\/page\\/index?id=ArSxBYQPjDvOMzfU\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u667a\\u80fd\\u5c0f\\u871c\",\"icon\":\"wlIcon-unie737\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/service\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u5e2e\\u52a9\",\"icon\":\"wlIcon-bangzhu1\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-pink\",\"link\":\"\\/pages\\/user\\/help\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"}]},{\"name\":\"\\u56fe\\u7247\\u7ec4\\u4ef6\",\"type\":\"advertImage\",\"style\":{\"height\":\"100px\",\"width\":\"100%\"}},{\"name\":\"\\u5934\\u6761\\u7ec4\\u4ef6\",\"type\":\"headlines\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"0 12.5px\"},\"data\":[{\"title\":\"\\u7cfb\\u7edf\\u81ea\\u52a8\\u83b7\\u53d6-\\u5185\\u5bb9\\u7ba1\\u7406-\\u6587\\u7ae0\\u5217\\u8868-\\u9996\\u9875\\u6807\\u5fd7\",\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/article-default.png\",\"tips\":\"\\u53f3\\u4fa7\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5c3a\\u5bf8200x200\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-pip\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u5206\\u9694\\u7b26\",\"type\":\"division\",\"style\":{\"width\":\"100%\",\"padding\":\"12.5px\"},\"params\":{\"lineWidth\":\"60%\",\"lineHeight\":\"1px\",\"lineBackground\":\"#bababa\",\"lineText\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"lineTextColor\":\"#ffffff\",\"lineTextSize\":\"14px\",\"lineTextBackground\":\"#0d164a\",\"lineTextPadding\":\"0 9px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673752, 1629673752, NULL, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (3, '8zigwfG5L0Votujx', 0, 'App 发行首页', '', 'index', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff4632\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#f5f5f5\",\"pageBackgroundImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/main_bg3x.png\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"no-repeat\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"advertBanner\",\"style\":{\"color\":\"#000000\",\"margin\":\"8px 12.5px 0 12.5px\",\"border-radius\":\"10px\",\"overflow\":\"hidden\"},\"params\":{\"interval\":\"2800\",\"height\":\"115px\",\"banstyle\":\"1\"}},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/activity-top-bg3x.png\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-orange\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u62fc\\u56e2\\u7ec4\\u4ef6\",\"type\":\"groups\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"overflow\":\"hidden\",\"margin\":\"12.5px\"},\"params\":{\"groupsBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/grueps-top-bg3x.png\",\"colmargin\":\"25\",\"titleText\":\"\\u70ed\\u95e8\\u62fc\\u56e2\",\"titleColor\":\"#ad4e00\",\"titleFontSize\":\"14px\",\"infoText\":\"\\u62fc\\u7740\\u4e70\\uff0c\\u66f4\\u4fbf\\u5b9c~\",\"infoColor\":\"#c75a00\",\"infoFontSize\":\"12px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673780, 1682597738, 1682597738, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (4, '8zigwfG5L0Votujx', 0, '原旧版首页', NULL, 'index', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff6608\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#0d164a\",\"pageBackgroundImage\":\"https:\\/\\/apis.wanlshop.com\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_bg.jpg\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"#ffffff\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"banner\",\"style\":{\"color\":\"#000000\"},\"params\":{\"interval\":\"2800\",\"height\":\"145px\",\"banstyle\":\"1\"},\"data\":[{\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_page_swiper.png\",\"tips\":\"\\u5c3d\\u91cf\\u4f7f\\u7528\\u9ad8\\u50cf\\u7d20\\u7d20\\u6750\\uff0c\\u5426\\u5219\\u53ef\\u80fd\\u51fa\\u73b0\\u865a\\u5316\",\"link\":\"\"}]},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"colfive\":\"5\",\"menuMarginTop\":\"12.5px\",\"menuMarginBottom\":\"5px\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuTextSize\":\"12px\",\"menuType\":\"icon\",\"menuBorderRadius\":\"1000px\"},\"style\":{\"color\":\"#ffffff\",\"margin\":\"0 12.5px\",\"padding\":\"6px 0\"},\"data\":[{\"text\":\"\\u7c7b\\u76ee\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-redorange\",\"link\":\"\\/pages\\/product\\/category\\/category\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8ba2\\u5355\",\"icon\":\"wlIcon-pintuan\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/order\\/order\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\\u6392\\u884c\",\"icon\":\"wlIcon-tubiao309\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-yellow\",\"link\":\"\\/pages\\/user\\/signin\\/rank\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8db3\\u8ff9\",\"icon\":\"wlIcon-kanjia\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-green\",\"link\":\"\\/pages\\/user\\/footprint\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8d2d\\u7269\\u8f66\",\"icon\":\"wlIcon-miaosha\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/cart\\/cart\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u4f1a\\u5458\\u4e2d\\u5fc3\",\"icon\":\"wlIcon-huiyuanzhongxin\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-red\",\"link\":\"\\/pages\\/user\\/user\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\",\"icon\":\"wlIcon-qiandao\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-orange\",\"link\":\"\\/pages\\/user\\/signin\\/signin\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u6d3b\\u52a8\\u9875\",\"icon\":\"wlIcon-saoyisao-copy\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-purple\",\"link\":\"\\/pages\\/page\\/index?id=ArSxBYQPjDvOMzfU\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u667a\\u80fd\\u5c0f\\u871c\",\"icon\":\"wlIcon-unie737\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/service\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u5e2e\\u52a9\",\"icon\":\"wlIcon-bangzhu1\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-pink\",\"link\":\"\\/pages\\/user\\/help\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"}]},{\"name\":\"\\u56fe\\u7247\\u7ec4\\u4ef6\",\"type\":\"advertImage\",\"style\":{\"height\":\"100px\",\"width\":\"100%\"}},{\"name\":\"\\u5934\\u6761\\u7ec4\\u4ef6\",\"type\":\"headlines\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"0 12.5px\"},\"data\":[{\"title\":\"\\u7cfb\\u7edf\\u81ea\\u52a8\\u83b7\\u53d6-\\u5185\\u5bb9\\u7ba1\\u7406-\\u6587\\u7ae0\\u5217\\u8868-\\u9996\\u9875\\u6807\\u5fd7\",\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/article-default.png\",\"tips\":\"\\u53f3\\u4fa7\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5c3a\\u5bf8200x200\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-pip\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u5206\\u9694\\u7b26\",\"type\":\"division\",\"style\":{\"width\":\"100%\",\"padding\":\"12.5px\"},\"params\":{\"lineWidth\":\"60%\",\"lineHeight\":\"1px\",\"lineBackground\":\"#bababa\",\"lineText\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"lineTextColor\":\"#ffffff\",\"lineTextSize\":\"14px\",\"lineTextBackground\":\"#0d164a\",\"lineTextPadding\":\"0 9px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1682597738, 1682597738, NULL, 'normal');
四、模板启用后客户端h5页面中的api注册不了，提示1364 Field 'money' doesn't have a default value","time":"1682684458","data":
-- ----------------------------
-- Table structure for fa_user
-- ----------------------------
DROP TABLE IF EXISTS `fa_user`;
CREATE TABLE `fa_user` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '組別ID',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用戶名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '暱稱',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密碼',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密碼鹽',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '電子郵箱',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '手機號',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '頭像',
`level` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等級',
`gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性別',
`birthday` date NULL DEFAULT NULL COMMENT '生日',
`bio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '格言',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '餘額',
`score` int(10) NOT NULL DEFAULT 0 COMMENT '積分',
`successions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '連續登錄天數',
`maxsuccessions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最大連續登錄天數',
`prevtime` int(10) NULL DEFAULT NULL COMMENT '上次登錄時間',
`logintime` int(10) NULL DEFAULT NULL COMMENT '登錄時間',
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '登錄IP',
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失敗次數',
`joinip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '加入IP',
`jointime` int(10) NULL DEFAULT NULL COMMENT '加入時間',
`createtime` int(10) NULL DEFAULT NULL COMMENT '創建時間',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新時間',
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'Token',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '狀態',
`verification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '驗證',
`is_robot` int(2) NOT NULL DEFAULT 0 COMMENT '是否為機器人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `username`(`username`) USING BTREE,
INDEX `email`(`email`) USING BTREE,
INDEX `mobile`(`mobile`) USING BTREE,
INDEX `is_robot`(`is_robot`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 527 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '會員表' ROW_FORMAT = COMPACT;
原因：money 字段在建表时设置了非空
解决办法：将非空设置取消，或者给money字段设置一个默认值0.00
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '餘額',
一、控制台出现打不开，出现提示this is incompatible with sql_mode=only_full_group_by
解决方案三：通过配置文件永久修改sql_mode
mysql安装在服务器上和安装在本地，修改配置文件的方式有点区别。
1、Linux下修改配置文件
1）登录进入MySQL
使用命令 mysql -u username -p 进行登陆，然后输入密码，输入SQL：
show variables like ‘%sql_mode’;
2）编辑my.cnf文件
文件地址一般在：/etc/my.cnf，/etc/mysql/my.cnf
使用vim命令编辑文件，不知道vim命令怎么使用的，可以参考我的另外篇文章：Linux中使用vi工具进行文本编辑
找到sql-mode的位置，去掉ONLY_FULL_GROUP_BY
然后重启MySQL；
有的my.cnf中可能没有sql-mode，需要追加：
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
注意要加入到[mysqld]下面，如加入到其他地方，重启后也不生效，具体的如下图：
3）修改成功后重启MySQL服务
service mysql restart
重启好后，再登录mysql，输入SQL：show variables like ‘%sql_mode’; 如果没有ONLY_FULL_GROUP_BY，就说明已经成功了。
如果还不行，那么只保留STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION 即可
追加内容为：
sql-mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
2、window下修改配置文件
1）找到mysql安装目录，用记事本直接打开my.ini文件
2）编辑my.ini文件，在[mysql]标签下追加内容
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
3）重启mysql 服务
备注：
网上有些提供了sql_mode的值，却导致重启mysql服务启动不了
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
这时，只需要将sql_mode 值中 “NO_AUTO_CREATE_USER” 这个属性去掉即可。
二、店铺管理中的运费模板打不开，提示id不能为null
解决方法：fa_wanlshop_shop_freight表数据删除或者fa_wanlshop_shop_freight_data表添加两行对应的数据
DROP TABLE IF EXISTS `fa_wanlshop_shop_freight_data`;
CREATE TABLE `fa_wanlshop_shop_freight_data` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`shop_id` int(10) NOT NULL DEFAULT 0 COMMENT '管理員ID',
`freight_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '運費模板ID',
`province` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '省份',
`citys` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '城市',
`first` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '首件',
`first_fee` decimal(10, 2) UNSIGNED NOT NULL COMMENT '運費',
`additional` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '續件',
`additional_fee` decimal(10, 2) UNSIGNED NOT NULL COMMENT '續件運費',
`createtime` int(10) NULL DEFAULT NULL COMMENT '創建時間',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新時間',
`deletetime` int(10) NULL DEFAULT NULL COMMENT '刪除時間',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '狀態',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '運費模板數據表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of fa_wanlshop_shop_freight_data
-- ----------------------------
INSERT INTO `fa_wanlshop_shop_freight_data` VALUES (1, 1, 1, '北京', '北京', 0, 10.00, 0, 100.00, 1643081402, NULL, NULL, 'normal');
INSERT INTO `fa_wanlshop_shop_freight_data` VALUES (2, 2, 2, '上海', '上海', 0, 10.00, 0, 100.00, 1643081401, NULL, NULL, 'normal');
三、装修商城中的模板管理打不开，选择不了模板或者保存出现服务器内部错误
解决方法：给id加主键
DROP TABLE IF EXISTS `fa_wanlshop_page`;
CREATE TABLE `fa_wanlshop_page` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID(id=1首页)',
`page_token` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '页面Token',
`shop_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店铺ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '自定义页面' COMMENT '页面名称',
`cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '页面封面',
`type` enum('page','shop','index','systpl') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'page' COMMENT '页面类型:page=单页,shop=店铺,index=首页,systpl=首页模板',
`page` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '页面配置',
`item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '项目',
`createtime` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`deletetime` int(10) NULL DEFAULT NULL COMMENT '删除时间',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '自定义装修页面' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of fa_wanlshop_page
-- ----------------------------
INSERT INTO `fa_wanlshop_page` VALUES (1, '936MLnKpzQJFa5No', 0, 'App 1.1.1新版首页', '/assets/addons/wanlshop/img/show/page_tpl1.png', 'systpl', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff4632\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#f5f5f5\",\"pageBackgroundImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/main_bg3x.png\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"no-repeat\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"advertBanner\",\"style\":{\"color\":\"#000000\",\"margin\":\"8px 12.5px 0 12.5px\",\"border-radius\":\"10px\",\"overflow\":\"hidden\"},\"params\":{\"interval\":\"2800\",\"height\":\"115px\",\"banstyle\":\"1\"}},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"menuType\":\"image\",\"colfive\":\"5\",\"menuMarginTop\":\"0\",\"menuMarginBottom\":\"0\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuBorderRadius\":\"1000px\",\"menuTextSize\":\"12px\"},\"style\":{\"color\":\"#333333\",\"margin\":\"12.5px\"},\"data\":[{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/1.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/2.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/3.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/4.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/5.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/6.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/7.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/8.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/9.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"},{\"text\":\"\\u83dc\\u5355\\u4e00\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/10.png\",\"bgClass\":\"wanl-bg-transparent\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/activity-top-bg3x.png\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-orange\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u62fc\\u56e2\\u7ec4\\u4ef6\",\"type\":\"groups\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"overflow\":\"hidden\",\"margin\":\"12.5px\"},\"params\":{\"groupsBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/grueps-top-bg3x.png\",\"colmargin\":\"25\",\"titleText\":\"\\u70ed\\u95e8\\u62fc\\u56e2\",\"titleColor\":\"#ad4e00\",\"titleFontSize\":\"14px\",\"infoText\":\"\\u62fc\\u7740\\u4e70\\uff0c\\u66f4\\u4fbf\\u5b9c~\",\"infoColor\":\"#c75a00\",\"infoFontSize\":\"12px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673735, 1629673735, NULL, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (2, 'xEl17TgF9YmUaDQS', 0, '原旧版首页', '/assets/addons/wanlshop/img/show/page_tpl2.png', 'systpl', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff6608\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#0d164a\",\"pageBackgroundImage\":\"https:\\/\\/apis.wanlshop.com\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_bg.jpg\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"#ffffff\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"banner\",\"style\":{\"color\":\"#000000\"},\"params\":{\"interval\":\"2800\",\"height\":\"145px\",\"banstyle\":\"1\"},\"data\":[{\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_page_swiper.png\",\"tips\":\"\\u5c3d\\u91cf\\u4f7f\\u7528\\u9ad8\\u50cf\\u7d20\\u7d20\\u6750\\uff0c\\u5426\\u5219\\u53ef\\u80fd\\u51fa\\u73b0\\u865a\\u5316\",\"link\":\"\"}]},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"colfive\":\"5\",\"menuMarginTop\":\"12.5px\",\"menuMarginBottom\":\"5px\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuTextSize\":\"12px\",\"menuType\":\"icon\",\"menuBorderRadius\":\"1000px\"},\"style\":{\"color\":\"#ffffff\",\"margin\":\"0 12.5px\",\"padding\":\"6px 0\"},\"data\":[{\"text\":\"\\u7c7b\\u76ee\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-redorange\",\"link\":\"\\/pages\\/product\\/category\\/category\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8ba2\\u5355\",\"icon\":\"wlIcon-pintuan\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/order\\/order\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\\u6392\\u884c\",\"icon\":\"wlIcon-tubiao309\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-yellow\",\"link\":\"\\/pages\\/user\\/signin\\/rank\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8db3\\u8ff9\",\"icon\":\"wlIcon-kanjia\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-green\",\"link\":\"\\/pages\\/user\\/footprint\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8d2d\\u7269\\u8f66\",\"icon\":\"wlIcon-miaosha\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/cart\\/cart\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u4f1a\\u5458\\u4e2d\\u5fc3\",\"icon\":\"wlIcon-huiyuanzhongxin\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-red\",\"link\":\"\\/pages\\/user\\/user\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\",\"icon\":\"wlIcon-qiandao\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-orange\",\"link\":\"\\/pages\\/user\\/signin\\/signin\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u6d3b\\u52a8\\u9875\",\"icon\":\"wlIcon-saoyisao-copy\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-purple\",\"link\":\"\\/pages\\/page\\/index?id=ArSxBYQPjDvOMzfU\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u667a\\u80fd\\u5c0f\\u871c\",\"icon\":\"wlIcon-unie737\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/service\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u5e2e\\u52a9\",\"icon\":\"wlIcon-bangzhu1\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-pink\",\"link\":\"\\/pages\\/user\\/help\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"}]},{\"name\":\"\\u56fe\\u7247\\u7ec4\\u4ef6\",\"type\":\"advertImage\",\"style\":{\"height\":\"100px\",\"width\":\"100%\"}},{\"name\":\"\\u5934\\u6761\\u7ec4\\u4ef6\",\"type\":\"headlines\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"0 12.5px\"},\"data\":[{\"title\":\"\\u7cfb\\u7edf\\u81ea\\u52a8\\u83b7\\u53d6-\\u5185\\u5bb9\\u7ba1\\u7406-\\u6587\\u7ae0\\u5217\\u8868-\\u9996\\u9875\\u6807\\u5fd7\",\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/article-default.png\",\"tips\":\"\\u53f3\\u4fa7\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5c3a\\u5bf8200x200\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-pip\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u5206\\u9694\\u7b26\",\"type\":\"division\",\"style\":{\"width\":\"100%\",\"padding\":\"12.5px\"},\"params\":{\"lineWidth\":\"60%\",\"lineHeight\":\"1px\",\"lineBackground\":\"#bababa\",\"lineText\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"lineTextColor\":\"#ffffff\",\"lineTextSize\":\"14px\",\"lineTextBackground\":\"#0d164a\",\"lineTextPadding\":\"0 9px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673752, 1629673752, NULL, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (3, '8zigwfG5L0Votujx', 0, 'App 发行首页', '', 'index', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff4632\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#f5f5f5\",\"pageBackgroundImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/main_bg3x.png\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"no-repeat\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"advertBanner\",\"style\":{\"color\":\"#000000\",\"margin\":\"8px 12.5px 0 12.5px\",\"border-radius\":\"10px\",\"overflow\":\"hidden\"},\"params\":{\"interval\":\"2800\",\"height\":\"115px\",\"banstyle\":\"1\"}},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/activity-top-bg3x.png\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-orange\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u62fc\\u56e2\\u7ec4\\u4ef6\",\"type\":\"groups\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"overflow\":\"hidden\",\"margin\":\"12.5px\"},\"params\":{\"groupsBackground\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/grueps-top-bg3x.png\",\"colmargin\":\"25\",\"titleText\":\"\\u70ed\\u95e8\\u62fc\\u56e2\",\"titleColor\":\"#ad4e00\",\"titleFontSize\":\"14px\",\"infoText\":\"\\u62fc\\u7740\\u4e70\\uff0c\\u66f4\\u4fbf\\u5b9c~\",\"infoColor\":\"#c75a00\",\"infoFontSize\":\"12px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1629673780, 1682597738, 1682597738, 'normal');
INSERT INTO `fa_wanlshop_page` VALUES (4, '8zigwfG5L0Votujx', 0, '原旧版首页', NULL, 'index', '{\"params\":{\"navigationBarTitleText\":\"App \\u9996\\u9875\",\"share_title\":\"\\u5206\\u4eab\\u6807\\u9898\"},\"style\":{\"navigationBarTextStyle\":\"#ffffff\",\"navigationBarBackgroundColor\":\"#ff6608\",\"navigationBarBackgroundImage\":\"\",\"pageBackgroundColor\":\"#0d164a\",\"pageBackgroundImage\":\"https:\\/\\/apis.wanlshop.com\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_bg.jpg\",\"navigationBackgroundImage\":\"\",\"pageBackgroundRepeat\":\"#ffffff\"}}', '[{\"name\":\"\\u8f6e\\u64ad\\u7ec4\\u4ef6\",\"type\":\"banner\",\"style\":{\"color\":\"#000000\"},\"params\":{\"interval\":\"2800\",\"height\":\"145px\",\"banstyle\":\"1\"},\"data\":[{\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/show\\/old_page_swiper.png\",\"tips\":\"\\u5c3d\\u91cf\\u4f7f\\u7528\\u9ad8\\u50cf\\u7d20\\u7d20\\u6750\\uff0c\\u5426\\u5219\\u53ef\\u80fd\\u51fa\\u73b0\\u865a\\u5316\",\"link\":\"\"}]},{\"name\":\"\\u83dc\\u5355\\u7ec4\\u4ef6\",\"type\":\"menu\",\"params\":{\"colfive\":\"5\",\"menuMarginTop\":\"12.5px\",\"menuMarginBottom\":\"5px\",\"menuHeightWidth\":\"45px\",\"menuIconSize\":\"28px\",\"menuTextSize\":\"12px\",\"menuType\":\"icon\",\"menuBorderRadius\":\"1000px\"},\"style\":{\"color\":\"#ffffff\",\"margin\":\"0 12.5px\",\"padding\":\"6px 0\"},\"data\":[{\"text\":\"\\u7c7b\\u76ee\",\"icon\":\"wlIcon-leimu\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-redorange\",\"link\":\"\\/pages\\/product\\/category\\/category\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8ba2\\u5355\",\"icon\":\"wlIcon-pintuan\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/order\\/order\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\\u6392\\u884c\",\"icon\":\"wlIcon-tubiao309\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-yellow\",\"link\":\"\\/pages\\/user\\/signin\\/rank\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8db3\\u8ff9\",\"icon\":\"wlIcon-kanjia\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-green\",\"link\":\"\\/pages\\/user\\/footprint\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u8d2d\\u7269\\u8f66\",\"icon\":\"wlIcon-miaosha\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/cart\\/cart\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u4f1a\\u5458\\u4e2d\\u5fc3\",\"icon\":\"wlIcon-huiyuanzhongxin\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-red\",\"link\":\"\\/pages\\/user\\/user\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u7b7e\\u5230\",\"icon\":\"wlIcon-qiandao\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"wanl-bg-orange\",\"link\":\"\\/pages\\/user\\/signin\\/signin\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u6d3b\\u52a8\\u9875\",\"icon\":\"wlIcon-saoyisao-copy\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-purple\",\"link\":\"\\/pages\\/page\\/index?id=ArSxBYQPjDvOMzfU\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u667a\\u80fd\\u5c0f\\u871c\",\"icon\":\"wlIcon-unie737\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-blue\",\"link\":\"\\/pages\\/user\\/service\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"},{\"text\":\"\\u5e2e\\u52a9\",\"icon\":\"wlIcon-bangzhu1\",\"iconClass\":\"wanl-text-white\",\"bgClass\":\"bg-gradual-pink\",\"link\":\"\\/pages\\/user\\/help\",\"iconImage\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/video-default.png\"}]},{\"name\":\"\\u56fe\\u7247\\u7ec4\\u4ef6\",\"type\":\"advertImage\",\"style\":{\"height\":\"100px\",\"width\":\"100%\"}},{\"name\":\"\\u5934\\u6761\\u7ec4\\u4ef6\",\"type\":\"headlines\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"0 12.5px\"},\"data\":[{\"title\":\"\\u7cfb\\u7edf\\u81ea\\u52a8\\u83b7\\u53d6-\\u5185\\u5bb9\\u7ba1\\u7406-\\u6587\\u7ae0\\u5217\\u8868-\\u9996\\u9875\\u6807\\u5fd7\",\"image\":\"\\/assets\\/addons\\/wanlshop\\/img\\/page\\/article-default.png\",\"tips\":\"\\u53f3\\u4fa7\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5c3a\\u5bf8200x200\",\"link\":\"\"}]},{\"name\":\"\\u5206\\u7c7b\\u6a71\\u7a97\",\"type\":\"classify\",\"style\":{\"background-color\":\"#ffffff\",\"border-radius\":\"10px\",\"margin\":\"12.5px\",\"overflow\":\"hidden\"},\"params\":{\"colStyle\":\"col-2-2_1\",\"classifyBackground\":\"\"},\"data\":[{\"categoryId\":\"84\",\"textColor\":\"wanl-pip\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u65b0\\u54c1\\u5c1d\\u9c9c\"},{\"categoryId\":\"81\",\"textColor\":\"text-red\",\"describe\":\"30\\u5929\\u5305\\u9000 365\\u5929\\u5305\\u6362\",\"tags\":\"\\u540e\\u53f0\\u8c03\\u7528\"},{\"categoryId\":\"93\",\"textColor\":\"text-pink\",\"describe\":\"\\u5546\\u54c1\\u63a8\\u8350\",\"tags\":\"\"},{\"categoryId\":\"88\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u7279\\u60e0\",\"tags\":\"\"},{\"categoryId\":\"100\",\"textColor\":\"wanl-orange\",\"describe\":\"\\u540e\\u53f0\\u53ef\\u81ea\\u5b9a\\u4e49\\u6b64\\u9875\\u9762\",\"tags\":\"\"},{\"categoryId\":\"101\",\"textColor\":\"wanl-black\",\"describe\":\"\\u88c5\\u4fee\\u7ba1\\u7406\\u6b64\\u7ec4\\u4ef6\",\"tags\":\"\"},{\"categoryId\":\"91\",\"textColor\":\"wanl-pip\",\"describe\":\"\\u81ea\\u52a8\\u83b7\\u53d6\\u5546\\u54c1\",\"tags\":\"\"}]},{\"name\":\"\\u5206\\u9694\\u7b26\",\"type\":\"division\",\"style\":{\"width\":\"100%\",\"padding\":\"12.5px\"},\"params\":{\"lineWidth\":\"60%\",\"lineHeight\":\"1px\",\"lineBackground\":\"#bababa\",\"lineText\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"lineTextColor\":\"#ffffff\",\"lineTextSize\":\"14px\",\"lineTextBackground\":\"#0d164a\",\"lineTextPadding\":\"0 9px\"}},{\"name\":\"\\u731c\\u4f60\\u559c\\u6b22\",\"type\":\"likes\",\"style\":{\"background-color\":\"#f5f5f5\"},\"params\":{\"colthree\":\"2\",\"colmargin\":\"25\"}}]', 1682597738, 1682597738, NULL, 'normal');
四、模板启用后客户端h5页面中的api注册不了，提示1364 Field 'money' doesn't have a default value","time":"1682684458","data":
-- ----------------------------
-- Table structure for fa_user
-- ----------------------------
DROP TABLE IF EXISTS `fa_user`;
CREATE TABLE `fa_user` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '組別ID',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用戶名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '暱稱',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密碼',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密碼鹽',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '電子郵箱',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '手機號',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '頭像',
`level` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等級',
`gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性別',
`birthday` date NULL DEFAULT NULL COMMENT '生日',
`bio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '格言',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '餘額',
`score` int(10) NOT NULL DEFAULT 0 COMMENT '積分',
`successions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '連續登錄天數',
`maxsuccessions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最大連續登錄天數',
`prevtime` int(10) NULL DEFAULT NULL COMMENT '上次登錄時間',
`logintime` int(10) NULL DEFAULT NULL COMMENT '登錄時間',
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '登錄IP',
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失敗次數',
`joinip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '加入IP',
`jointime` int(10) NULL DEFAULT NULL COMMENT '加入時間',
`createtime` int(10) NULL DEFAULT NULL COMMENT '創建時間',
`updatetime` int(10) NULL DEFAULT NULL COMMENT '更新時間',
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'Token',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '狀態',
`verification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '驗證',
`is_robot` int(2) NOT NULL DEFAULT 0 COMMENT '是否為機器人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `username`(`username`) USING BTREE,
INDEX `email`(`email`) USING BTREE,
INDEX `mobile`(`mobile`) USING BTREE,
INDEX `is_robot`(`is_robot`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 527 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '會員表' ROW_FORMAT = COMPACT;
原因：money 字段在建表时设置了非空
解决办法：将非空设置取消，或者给money字段设置一个默认值0.00
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '餘額',
相关文章
猜你需要
