在Java项目中使用的是mysql5.7的版本,暂时只支持这个版本,如果是其他版本需要适配。就是使用MySQL5.7这个版本也有可能会遇到导入sql失败的问题,一下是一些可能出现的问题以及解决办法。
问题一:
[SQL] Query CRMEB_JAVA_v1.6 start
[ERR] 1067 - Invalid default value for 'end_time'
[ERR]
INSERT INTO `eb_template_message` VALUES (5, 1, 'OPENTM418209505', '订单配送通知', '{{first.DATA}}\r\n商品明细:{{keyword1.DATA}}\r\n下单时间:{{keyword2.DATA}}\r\n配送地址:{{keyword3.DATA}}\r\n配送人:{{keyword4.DATA}}\r\n联系电话:{{keyword5.DATA}}\r\n{{remark.DATA}}', 'zNHM36D-dK5bDCCzDoCdYB1lBKO_MYubVtwsn89tO78', 1, '2020-12-03 16:03:24', '2021-12-16 10:49:25');
INSERT INTO `eb_template_message` VALUES (6, 1, 'OPENTM400231951', '支付成功通知', '{{first.DATA}}\n订单号:{{keyword1.DATA}}\n商品名称:{{keyword2.DATA}}\n支付金额:{{keyword3.DATA}}\n下单人:{{keyword4.DATA}}\n订单支付时间:{{keyword5.DATA}}\n{{remark.DATA}}', 'U6MWDabPBoLbmvmjtrqqp-C4IdG5va9sYqQFFzT8ZB4', 1, '2021-01-28 11:43:51', '2022-11-02 15:20:37');
INSERT INTO `eb_template_message` VALUES (7, 1, 'OPENTM413386489', '订单收货通知', '{{first.DATA}}\r\n订单编号:{{keyword1.DATA}}\r\n订单状态:{{keyword2.DATA}}\r\n收货时间:{{keyword3.DATA}}\r\n商品详情:{{keyword4.DATA}}\r\n{{remark.DATA}}', 'BaqGct0EfmTw4wrdonPg3LbTHO_shrvvGqah8lGPb6s', 1, '2021-01-28 15:12:15', '2021-01-28 15:12:15');
INSERT INTO `eb_template_message` VALUES (8, 1, 'OPENTM410119152', '退款进度通知', '{{first.DATA}}\r\n订单编号:{{keyword1.DATA}}\r\n订单金额:{{keyword2.DATA}}\r\n下单时间:{{keyword3.DATA}}\r\n{{remark.DATA}}', NULL, 0, '2021-01-29 11:43:06', '2021-01-29 11:43:06');
INSERT INTO `eb_template_message` VALUES (9, 0, '1128', '订单配送通知', '商品信息\r\n{{thing8.DATA}}\r\n\r\n订单编号\r\n{{character_string1.DATA}}\r\n\r\n配送人\r\n{{name4.DATA}}\r\n\r\n配送员电话\r\n{{phone_number10.DATA}}', 'B4zbo-s0fS8PRJ62rquZd7-K0SUY3klSL2s2jN8ozcs', 1, '2021-03-05 16:19:50', '2021-12-16 11:03:27');
INSERT INTO `eb_template_message` VALUES (10, 0, '755', '充值成功通知', '交易单号\r\n{{character_string1.DATA}}\r\n\r\n充值金额\r\n{{amount3.DATA}}\r\n\r\n充值时间\r\n{{date5.DATA}}\r\n\r\n赠送金额\r\n{{amount6.DATA}}\r\n\r\n备注\r\n{{thing7.DATA}}', 'y8I_vSDMffsipRe3t-Zfz-DH862FPqQcE386XYW8964', 1, '2021-03-05 16:21:19', '2023-01-12 15:33:07');
INSERT INTO `eb_template_message` VALUES (11, 0, '1481', '确认收货通知', '订单编号\r\n{{character_string6.DATA}}\r\n\r\n收货时间\r\n{{date5.DATA}}\r\n\r\n订单商品\r\n{{thing2.DATA}}', 'd3n2rN9Kqw4uLBVTY-nD00eUEejXZkyHCbw5We1HzV4', 1, '2021-03-05 16:22:03', '2021-12-16 11:03:35');
INSERT INTO `eb_template_message` VALUES (12, 0, '3578', '订单支付成功通知', '订单编号\r\n{{character_string3.DATA}}\r\n\r\n订单金额\r\n{{amount9.DATA}}\r\n\r\n备注\r\n{{thing6.DATA}}', 'WBaA2jZ77wpq6_9u8PABmK_7Df8vHzLGEtae7EmQV8Q', 1, '2021-03-05 16:22:48', '2021-12-16 11:03:40');
INSERT INTO `eb_template_message` VALUES (13, 0, '2727', '砍价结果通知', '商品名称\r\n{{thing1.DATA}}\r\n\r\n底价\r\n{{amount2.DATA}}\r\n\r\n备注\r\n{{thing3.DATA}}', '1YkOIsB3ZUh731W9vd76-QXcjfKLxcoy1Am2Yh1NPxI', 1, '2021-03-05 16:23:26', '2021-12-16 11:03:44');
INSERT INTO `eb_template_message` VALUES (14, 0, '3098', '拼团成功提醒', '订单号\r\n{{character_string10.DATA}}\r\n\r\n商品名称\r\n{{thing7.DATA}}\r\n\r\n备注\r\n{{thing9.DATA}}', 'l_xoRSL9dC6fA9EmKmxWF8AJIq3ZhbbSQ-vISqKfl7w', 1, '2021-03-05 16:24:13', '2021-12-16 11:03:47');
INSERT INTO `eb_template_message` VALUES (15, 0, '1458', '订单发货提醒', '订单编号\r\n{{character_string7.DATA}}\r\n\r\n快递公司\r\n{{thing1.DATA}}\r\n\r\n快递单号\r\n{{character_string2.DATA}}\r\n\r\n备注\r\n{{thing8.DATA}}', 'p2bweRCLAOd90J8RjJvk6rxFsH9B2LpGTNtH_uo-fRM', 1, '2021-03-05 16:25:05', '2023-01-12 15:25:46');
-- ----------------------------
-- Table structure for eb_trading_day_record
-- ----------------------------
DROP TABLE IF EXISTS `eb_trading_day_record`;
CREATE TABLE `eb_trading_day_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日期',
`product_order_num` int(11) NULL DEFAULT NULL COMMENT '订单数量',
`product_order_pay_num` int(11) NULL DEFAULT NULL COMMENT '订单支付数量',
`product_order_pay_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '订单支付金额',
`product_order_refund_num` int(11) NULL DEFAULT NULL COMMENT '订单退款数量',
`product_order_refund_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '订单退款金额',
`recharge_order_num` int(11) NULL DEFAULT NULL COMMENT '充值订单数量',
`recharge_order_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '充值订单金额',
`balance_pay_fee` d
[SQL] Finished with error
解决办法:
将 end_time timestamp NOT NULL COMMENT'直播预计结束时间'
改为 end_time TIMESTAMP NULL COMMENT '直播预计结束时间'
问题二:
[SQL] Query CRMEB_JAVA_v1.6 start
[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--- 公测后添加
UPDATE `eb_system_form_temp` SET `name` = '支付宝支付'' at line 5
[ERR]
INSERT INTO `eb_template_message` VALUES (5, 1, 'OPENTM418209505', '订单配送通知', '{{first.DATA}}\r\n商品明细:{{keyword1.DATA}}\r\n下单时间:{{keyword2.DATA}}\r\n配送地址:{{keyword3.DATA}}\r\n配送人:{{keyword4.DATA}}\r\n联系电话:{{keyword5.DATA}}\r\n{{remark.DATA}}', 'zNHM36D-dK5bDCCzDoCdYB1lBKO_MYubVtwsn89tO78', 1, '2020-12-03 16:03:24', '2021-12-16 10:49:25');
INSERT INTO `eb_template_message` VALUES (6, 1, 'OPENTM400231951', '支付成功通知', '{{first.DATA}}\n订单号:{{keyword1.DATA}}\n商品名称:{{keyword2.DATA}}\n支付金额:{{keyword3.DATA}}\n下单人:{{keyword4.DATA}}\n订单支付时间:{{keyword5.DATA}}\n{{remark.DATA}}', 'U6MWDabPBoLbmvmjtrqqp-C4IdG5va9sYqQFFzT8ZB4', 1, '2021-01-28 11:43:51', '2022-11-02 15:20:37');
INSERT INTO `eb_template_message` VALUES (7, 1, 'OPENTM413386489', '订单收货通知', '{{first.DATA}}\r\n订单编号:{{keyword1.DATA}}\r\n订单状态:{{keyword2.DATA}}\r\n收货时间:{{keyword3.DATA}}\r\n商品详情:{{keyword4.DATA}}\r\n{{remark.DATA}}', 'BaqGct0EfmTw4wrdonPg3LbTHO_shrvvGqah8lGPb6s', 1, '2021-01-28 15:12:15', '2021-01-28 15:12:15');
INSERT INTO `eb_template_message` VALUES (8, 1, 'OPENTM410119152', '退款进度通知', '{{first.DATA}}\r\n订单编号:{{keyword1.DATA}}\r\n订单金额:{{keyword2.DATA}}\r\n下单时间:{{keyword3.DATA}}\r\n{{remark.DATA}}', NULL, 0, '2021-01-29 11:43:06', '2021-01-29 11:43:06');
INSERT INTO `eb_template_message` VALUES (9, 0, '1128', '订单配送通知', '商品信息\r\n{{thing8.DATA}}\r\n\r\n订单编号\r\n{{character_string1.DATA}}\r\n\r\n配送人\r\n{{name4.DATA}}\r\n\r\n配送员电话\r\n{{phone_number10.DATA}}', 'B4zbo-s0fS8PRJ62rquZd7-K0SUY3klSL2s2jN8ozcs', 1, '2021-03-05 16:19:50', '2021-12-16 11:03:27');
INSERT INTO `eb_template_message` VALUES (10, 0, '755', '充值成功通知', '交易单号\r\n{{character_string1.DATA}}\r\n\r\n充值金额\r\n{{amount3.DATA}}\r\n\r\n充值时间\r\n{{date5.DATA}}\r\n\r\n赠送金额\r\n{{amount6.DATA}}\r\n\r\n备注\r\n{{thing7.DATA}}', 'y8I_vSDMffsipRe3t-Zfz-DH862FPqQcE386XYW8964', 1, '2021-03-05 16:21:19', '2023-01-12 15:33:07');
INSERT INTO `eb_template_message` VALUES (11, 0, '1481', '确认收货通知', '订单编号\r\n{{character_string6.DATA}}\r\n\r\n收货时间\r\n{{date5.DATA}}\r\n\r\n订单商品\r\n{{thing2.DATA}}', 'd3n2rN9Kqw4uLBVTY-nD00eUEejXZkyHCbw5We1HzV4', 1, '2021-03-05 16:22:03', '2021-12-16 11:03:35');
INSERT INTO `eb_template_message` VALUES (12, 0, '3578', '订单支付成功通知', '订单编号\r\n{{character_string3.DATA}}\r\n\r\n订单金额\r\n{{amount9.DATA}}\r\n\r\n备注\r\n{{thing6.DATA}}', 'WBaA2jZ77wpq6_9u8PABmK_7Df8vHzLGEtae7EmQV8Q', 1, '2021-03-05 16:22:48', '2021-12-16 11:03:40');
INSERT INTO `eb_template_message` VALUES (13, 0, '2727', '砍价结果通知', '商品名称\r\n{{thing1.DATA}}\r\n\r\n底价\r\n{{amount2.DATA}}\r\n\r\n备注\r\n{{thing3.DATA}}', '1YkOIsB3ZUh731W9vd76-QXcjfKLxcoy1Am2Yh1NPxI', 1, '2021-03-05 16:23:26', '2021-12-16 11:03:44');
INSERT INTO `eb_template_message` VALUES (14, 0, '3098', '拼团成功提醒', '订单号\r\n{{character_string10.DATA}}\r\n\r\n商品名称\r\n{{thing7.DATA}}\r\n\r\n备注\r\n{{thing9.DATA}}', 'l_xoRSL9dC6fA9EmKmxWF8AJIq3ZhbbSQ-vISqKfl7w', 1, '2021-03-05 16:24:13', '2021-12-16 11:03:47');
INSERT INTO `eb_template_message` VALUES (15, 0, '1458', '订单发货提醒', '订单编号\r\n{{character_string7.DATA}}\r\n\r\n快递公司\r\n{{thing1.DATA}}\r\n\r\n快递单号\r\n{{character_string2.DATA}}\r\n\r\n备注\r\n{{thing8.DATA}}', 'p2bweRCLAOd90J8RjJvk6rxFsH9B2LpGTNtH_uo-fRM', 1, '2021-03-05 16:25:05', '2023-01-12 15:25:46');
-- ----------------------------
-- Table structure for eb_trading_day_record
-- ----------------------------
DROP TABLE IF EXISTS `eb_trading_day_record`;
CREATE TABLE `eb_trading_day_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日期',
`product_order_num` int(11) NULL DEFAULT NULL COMMENT '订单数量',
`product_order_pay_num` int(11) NULL DEFAULT NULL COMMENT '订单支付数量',
`product_order_pay_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '订单支付金额',
`product_order_refund_num` int(11) NULL DEFAULT NULL COMMENT '订单退款数量',
`product_order_refund_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '订单退款金额',
`recharge_order_num` int(11) NULL DEFAULT NULL COMMENT '充值订单数量',
`recharge_order_fee` decimal(8, 2) NULL DEFAULT NULL COMMENT '充值订单金额',
`balance_pay_fee` d
[SQL] Finished with error
解决办法:
只需要在sql里面搜一下"公测"然后改一下如下内容即可