易迁易平台问题集

2018/1/31 08:53
jimmy

1. 订单号空白

函数问题，重新生成一下：

DROP TABLE IF EXISTS e_sequence; 
CREATE TABLE e_sequence ( 
name VARCHAR(50) NOT NULL, 
current_value INT NOT NULL, 
increment INT NOT NULL DEFAULT 1, 
PRIMARY KEY (name) 
) ENGINE=InnoDB; 
INSERT INTO e_sequence VALUES ('OrderCodeSeq', 0, 1);


DROP FUNCTION IF EXISTS seq_currval; 
DELIMITER $ 
CREATE FUNCTION seq_currval (seq_name VARCHAR(50)) 
RETURNS INTEGER
LANGUAGE SQL 
DETERMINISTIC 
CONTAINS SQL 
SQL SECURITY DEFINER 
COMMENT ''
BEGIN
DECLARE value INTEGER; 
SET value = 0; 
SELECT current_value INTO value 
FROM e_sequence
WHERE name = seq_name; 
RETURN value; 
END
$ 
DELIMITER ; 


DROP FUNCTION IF EXISTS seq_nextval; 
DELIMITER $ 
CREATE FUNCTION seq_nextval (seq_name VARCHAR(50)) 
RETURNS INTEGER
LANGUAGE SQL 
DETERMINISTIC 
CONTAINS SQL 
SQL SECURITY DEFINER 
COMMENT ''
BEGIN
UPDATE e_sequence
SET current_value = current_value + increment 
WHERE name = seq_name; 
RETURN seq_currval(seq_name); 
END
$ 
DELIMITER ;

2. 远程服务器连接失败,错误代码：404

认证中心无法正常访问导致，检查nginx及认证中心端口

3. 正常登录后又自动退出

concurrent.maximum.logins=10 修改此值（logincontrol.properties）

4.修改配置不重启直接生效方法

删除work目录下文件，清除IE缓存

5. favicon无法显示

添加代码：