代码拉下来，执行完相关表sql后，发现无法登录，请求报错缺失相关表数据，请问有完整SQL文件吗，SQL中缺失了Port_Dept建表语句和初始化语句 · Issue #I8XFYC · 济南驰骋公司/Ruoyi-JFlow - 木兰确实

/ 详情

待办的

任务

创建于

2024-01-19 13:38

报错日志：  @Param: Num=1, No=admin(String)
  @异常信息: Table 'yln_jflow.WF_Emp' doesn't exist
12:12:08.853 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.901 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.926 [http-nio-8080-exec-4] ERROR bp.da.Log - [RunSQLReturnTable_200705_MySQL,2504] - @运行查询在(RunSQLReturnTable_200705_MySQL)出错。
  @SQL:  SELECT    Port_Emp.No, Port_Emp.UserID, Port_Emp.Name, Port_Emp.PinYin, Port_Emp.FK_Dept, Port_Dept_FK_Dept.Name AS FK_DeptText, Port_Emp.Tel, Port_Emp.Email, Port_Emp.Leader, Port_Emp.LeaderName, Port_Emp.OrgNo,IFNULL(Port_Emp.EmpSta,0)   EmpSta,IFNULL(Port_Emp.Idx,0)   Idx FROM Port_Emp LEFT JOIN Port_Dept AS Port_Dept_FK_Dept ON Port_Emp.FK_Dept=Port_Dept_FK_Dept.No WHERE (1=1)  AND Port_Emp.No=:No
  @Param: Num=1, No=admin(String)
  @异常信息: Table 'yln_jflow.Port_Emp' doesn't exist
12:12:08.950 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.988 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:09.001 [http-nio-8080-exec-4] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType mysql, druid-1.2.16, sql : Port_Emp
com.alibaba.druid.sql.parser.ParserException: not supported.pos 8, line 1, column 1, token IDENTIFIER Port_Emp

请问有完整SQL文件吗，SQL中缺失了Port_Dept建表语句和初始化语句

报错日志：  @Param: Num=1, No=admin(String)
  @异常信息: Table 'yln_jflow.WF_Emp' doesn't exist
12:12:08.853 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.901 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.926 [http-nio-8080-exec-4] ERROR bp.da.Log - [RunSQLReturnTable_200705_MySQL,2504] - @运行查询在(RunSQLReturnTable_200705_MySQL)出错。
  @SQL:  SELECT    Port_Emp.No, Port_Emp.UserID, Port_Emp.Name, Port_Emp.PinYin, Port_Emp.FK_Dept, Port_Dept_FK_Dept.Name AS FK_DeptText, Port_Emp.Tel, Port_Emp.Email, Port_Emp.Leader, Port_Emp.LeaderName, Port_Emp.OrgNo,IFNULL(Port_Emp.EmpSta,0)   EmpSta,IFNULL(Port_Emp.Idx,0)   Idx FROM Port_Emp LEFT JOIN Port_Dept AS Port_Dept_FK_Dept ON Port_Emp.FK_Dept=Port_Dept_FK_Dept.No WHERE (1=1)  AND Port_Emp.No=:No
  @Param: Num=1, No=admin(String)
  @异常信息: Table 'yln_jflow.Port_Emp' doesn't exist
12:12:08.950 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:08.988 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0
12:12:09.001 [http-nio-8080-exec-4] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType mysql, druid-1.2.16, sql : Port_Emp
com.alibaba.druid.sql.parser.ParserException: not supported.pos 8, line 1, column 1, token IDENTIFIER Port_Emp

请问有完整SQL文件吗，SQL中缺失了Port_Dept建表语句和初始化语句

创建了任务

修改了标题

修改了描述

原值

报错日志：  @Param: Num=1, No=admin(String)

  @异常信息: Table 'yln_jflow.WF_Emp' doesn't exist

12:12:08.853 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.901 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.926 [http-nio-8080-exec-4] ERROR bp.da.Log - [RunSQLReturnTable_200705_MySQL,2504] - @运行查询在(RunSQLReturnTable_200705_MySQL)出错。

  @SQL:  SELECT    Port_Emp.No, Port_Emp.UserID, Port_Emp.Name, Port_Emp.PinYin, Port_Emp.FK_Dept, Port_Dept_FK_Dept.Name AS FK_DeptText, Port_Emp.Tel, Port_Emp.Email, Port_Emp.Leader, Port_Emp.LeaderName, Port_Emp.OrgNo,IFNULL(Port_Emp.EmpSta,0)   EmpSta,IFNULL(Port_Emp.Idx,0)   Idx FROM Port_Emp LEFT JOIN Port_Dept AS Port_Dept_FK_Dept ON Port_Emp.FK_Dept=Port_Dept_FK_Dept.No WHERE (1=1)  AND Port_Emp.No=:No

  @Param: Num=1, No=admin(String)

  @异常信息: Table 'yln_jflow.Port_Emp' doesn't exist

12:12:08.950 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.988 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:09.001 [http-nio-8080-exec-4] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType mysql, druid-1.2.16, sql : Port_Emp

com.alibaba.druid.sql.parser.ParserException: not supported.pos 8, line 1, column 1, token IDENTIFIER Port_Emp

新值

报错日志：  @Param: Num=1, No=admin(String)

  @异常信息: Table 'yln_jflow.WF_Emp' doesn't exist

12:12:08.853 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.901 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.926 [http-nio-8080-exec-4] ERROR bp.da.Log - [RunSQLReturnTable_200705_MySQL,2504] - @运行查询在(RunSQLReturnTable_200705_MySQL)出错。

  @SQL:  SELECT    Port_Emp.No, Port_Emp.UserID, Port_Emp.Name, Port_Emp.PinYin, Port_Emp.FK_Dept, Port_Dept_FK_Dept.Name AS FK_DeptText, Port_Emp.Tel, Port_Emp.Email, Port_Emp.Leader, Port_Emp.LeaderName, Port_Emp.OrgNo,IFNULL(Port_Emp.EmpSta,0)   EmpSta,IFNULL(Port_Emp.Idx,0)   Idx FROM Port_Emp LEFT JOIN Port_Dept AS Port_Dept_FK_Dept ON Port_Emp.FK_Dept=Port_Dept_FK_Dept.No WHERE (1=1)  AND Port_Emp.No=:No

  @Param: Num=1, No=admin(String)

  @异常信息: Table 'yln_jflow.Port_Emp' doesn't exist

12:12:08.950 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:08.988 [http-nio-8080-exec-4] INFO  bp.da.Log - [RunSQL_200705_MySQL,1536] - Num=0

12:12:09.001 [http-nio-8080-exec-4] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType mysql, druid-1.2.16, sql : Port_Emp

com.alibaba.druid.sql.parser.ParserException: not supported.pos 8, line 1, column 1, token IDENTIFIER Port_Emp

请问有完整SQL文件吗，SQL中缺失了Port_Dept建表语句和初始化语句

展开全部操作日志

登录后才可以发表评论

状态

负责人

项目

里程碑

Pull Requests

关联的 Pull Requests 被合并后可能会关闭此 issue

分支

开始日期 - 截止日期

-

置顶选项

优先级

预计工期（小时）

参与者（2）