升级到8.01 运行JP_UI的错误

bug反馈 未结 1 154
勇立潮头
勇立潮头 VIP3 2021-02-25 22:25:45
收藏
产品:vue 版本:8.01
springboot vue 8.01 ,jeeplus_console 启动正常,但是jp_ui 运行的时候报错如下, 内部错误,操作异常; ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'a.affix' in 'field list' ### The error may exist in file [D:\CHSS\JeePlus8.01\jp-console\jeeplus-platform\jeeplus-admin\target\classes\com\jeeplus\modules\sys\mapper\xml\MenuMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT a.id AS "id", a.parent_id AS "parent.id", a.parent_ids AS "parentIds", a.name, a.href, a.target, a.icon, a.sort, a.is_show AS "isShow", a.affix AS "affix", a.menu_type AS "type", a.permission, a.remarks, a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.del_flag AS "delFlag", p.name AS "parent.name" FROM sys_menu a LEFT JOIN sys_menu p ON p.id = a.parent_id WHERE a.del_flag = ? ORDER BY a.sort ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'a.affix' in 'field list' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'a.affix' in 'field list'。 数据库是使用8.01 下载包内的jeeplus-vue-base.sql 导入生成的。 img[/userfiles/fly/37f6f78d7a424e28875781443b13917d/files/1614263143754.] img[/userfiles/fly/37f6f78d7a424e28875781443b13917d/files/1614263065984.]
回帖
  • 2021-02-26 22:55:41
    已经解决了,数据库使用的老版本,改为8.01对应的数据库就好了。
    0 回复