jeecgboot / JeecgBoot

🔥「企业级低代码平台」前后端分离架构SpringBoot 2.x/3.x,SpringCloud,Ant Design&Vue3,Mybatis,Shiro,JWT。强大的代码生成器让前后端代码一键生成,无需写任何代码! 引领新的开发模式,引入AI模型能力 OnlineCoding->代码生成->手工MERGE,帮助Java项目解决70%重复工作,让开发更关注业务,既能快速提高效率,帮助公司节省成本,同时又不失灵活性。
http://www.jeecg.com
Apache License 2.0
40.63k stars 14.83k forks source link

使用Online表单开发功能,同步数据库后,验证测试页面打开报错 #5977

Closed df837860925 closed 7 months ago

df837860925 commented 8 months ago
版本号:3.6.3
前端版本:vue3
问题描述:使用Online表单开发功能,同步数据库后,验证测试页面打开报错,提示sql语句有问题,单复制改报错sql至数据库执行却能正常执行
截图&代码:
       **1  点击截图功能测试按钮**:

image 2跳转页面报错

image 3 报错具体代码如下: 数据库查询失败,nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT qyid,rcjgry,scdzhszfw,fzjg,qfr,fzrq,fzrq_start,fzrq_end,scdz,slh,ckdz,jgyjzc,fw,fwyw,bz,zs,cs,cp,cplb,cpmx,cz,dh,gg,jx,fj,wzyy,jsly,zt,ywlx,bbid,mkid,sjtb_gspt,sjtb_da,sjtb_xzsp,sjtb_gjj,sjtb_error,sjtb_gjj_time,sjtb_gspt_time,sjtb_da_time,sjtb_xzsp_time,ewm,ewm_lj,glzdb,lxryx,lxdh,qylx,ylzd1 ,id FROM cert_infos ORDER BY id desc ### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT qyid,rcjgry,scdzhszfw,fzjg,qfr,fzrq,fzrq_start,fzrq_end,scdz,slh,ckdz,jgyjzc,fw,fwyw,bz,zs,cs,cp,cplb,cpmx,cz,dh,gg,jx,fj,wzyy,jsly,zt,ywlx,bbid,mkid,sjtb_gspt,sjtb_da,sjtb_xzsp,sjtb_gjj,sjtb_error,sjtb_gjj_time,sjtb_gspt_time,sjtb_da_time,sjtb_xzsp_time,ewm,ewm_lj,glzdb,lxryx,lxdh,qylx,ylzd1 ,id FROM cert_infos ORDER BY id desc 4 将该报错内容的sql 在数据库中执行却是正常如下截图image

友情提示(为了提高issue处理效率):

df837860925 commented 8 months ago

补充说明:后台报错代码如下: 后台报错代码.txt

zhangdaiscott commented 8 months ago

重新步骤? 什么数据库?

zhangdaiscott commented 7 months ago

近期改过mybatsplus版本号导致,你更新下最新代码看看