启动报错SQL

报错类 com.gitee.fsadmin.service.sys.UserPermissionService 第80行
![输入图片说明](https://foruda.gitee.com/images/1738995609522000492/d1880785_14050555.png "屏幕截图")
报错异常输出：
未知错误，URI：http://127.0.0.1:8089/sys/userperm/listCurrentUserMenu
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: 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 'ASC' at line 82
### The error may exist in SysResourceMapper.xml
### The error may involve com.gitee.fsadmin.dao.mapper.SysResourceMapper.list-Inline
### The error occurred while setting parameters
### SQL: SELECT                              t.`id` , t.`menu_type` , t.`title` , t.`name` , t.`path` , t.`component` , t.`rank` , t.`redirect` , t.`icon` , t.`extra_icon` , t.`enter_transition` , t.`leave_transition` , t.`active_path` , t.`auths` , t.`frame_src` , t.`frame_loading` , t.`keep_alive` , t.`hidden_tag` , t.`fixed_tag` , t.`show_link` , t.`show_parent` , t.`parent_id` , t.`is_deleted` , t.`add_time` , t.`update_time` , t.`add_by` , t.`update_by`                             FROM `sys_resource` t                                    WHERE                  id                 IN                 (                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 ,                     ?                 )                                                                                           AND                 menu_type                 =                 ?                                                                                                                     AND t.`is_deleted` = 0                                  ORDER BY rank ASC
### Cause: java.sql.SQLSyntaxErrorException: 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 'ASC' at line 82
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at org.apache.ibatis.solon.integration.MybatisSessionTemplate$SqlSessionInterceptor.invoke(MybatisSessionTemplate.java:170)
	at jdk.proxy2/jdk.proxy2.$Proxy18.selectList(Unknown Source)
	at org.apache.ibatis.solon.integration.MybatisSessionTemplate.selectList(MybatisSessionTemplate.java:78)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	at jdk.proxy2/jdk.proxy2.$Proxy31.list(Unknown Source)
	at com.gitee.fastmybatis.core.query.LambdaQuery.lambda$list$4(LambdaQuery.java:251)
	at com.gitee.fastmybatis.core.ext.MapperRunner.run(MapperRunner.java:33)
	at com.gitee.fastmybatis.core.query.LambdaQuery.list(LambdaQuery.java:251)
	at com.gitee.fsadmin.service.sys.UserPermissionService.listUserMenuTree(UserPermissionService.java:81)
	at com.gitee.fsadmin.controller.sys.UserPermissionController.listCurrentUserMenu(UserPermissionController.java:31)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at org.noear.solon.core.wrap.MethodWrap.invoke(MethodWrap.java:269)
	at org.noear.solon.core.wrap.MethodWrap.doIntercept(MethodWrap.java:258)
	at org.noear.solon.core.aspect.InterceptorEntity.doIntercept(InterceptorEntity.java:55)
	at org.noear.solon.core.aspect.Invocation.invoke(Invocation.java:115)
	at org.noear.solon.core.wrap.MethodWrap.invokeByAspect(MethodWrap.java:284)
	at org.noear.solon.core.mvc.ActionDefault.executeDo(ActionDefault.java:396)
	at org.noear.solon.core.mvc.ActionDefault.invokeMethodDo(ActionDefault.java:327)
	at org.noear.solon.core.mvc.ActionDefault.invokeHandleDo(ActionDefault.java:304)
	at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
	at org.noear.solon.core.mvc.ActionDefault.invokeFilterDo(ActionDefault.java:296)
	at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
	at org.noear.solon.core.mvc.ActionDefault.invoke(ActionDefault.java:270)
	at org.noear.solon.core.mvc.ActionDefault.handle(ActionDefault.java:247)
	at org.noear.solon.core.route.RouterHandler.handleMain(RouterHandler.java:51)
	at org.noear.solon.core.route.RouterHandler.handle1(RouterHandler.java:71)
	at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:54)
	at com.gitee.fsadmin.interceptor.AppRouterInterceptor.doIntercept(AppRouterInterceptor.java:21)
	at org.noear.solon.core.route.RouterInterceptorLimiter.doIntercept(RouterInterceptorLimiter.java:63)
	at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:52)
	at com.gitee.fsadmin.interceptor.LoginInterceptor.doIntercept(LoginInterceptor.java:40)
	at org.noear.solon.core.route.RouterInterceptorLimiter.doIntercept(RouterInterceptorLimiter.java:63)
	at org.noear.solon.core.route.RouterInterceptorChainImpl.doIntercept(RouterInterceptorChainImpl.java:52)
	at org.noear.solon.core.ChainManager.doIntercept(ChainManager.java:199)
	at org.noear.solon.core.route.RouterHandler.handle(RouterHandler.java:102)
	at org.noear.solon.core.handle.HandlerPipeline.handle(HandlerPipeline.java:53)
	at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:51)
	at org.noear.solon.logging.integration.XPluginImp.lambda$start$1(XPluginImp.java:71)
	at org.noear.solon.core.handle.FilterChainImpl.doFilter(FilterChainImpl.java:49)
	at org.noear.solon.core.ChainManager.doFilter(ChainManager.java:106)
	at org.noear.solon.SolonApp.tryHandle(SolonApp.java:511)
	at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.handleDo(SmHttpContextHandler.java:122)
	at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.handle0(SmHttpContextHandler.java:100)
	at org.noear.solon.boot.smarthttp.http.SmHttpContextHandler.lambda$handle$0(SmHttpContextHandler.java:85)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:840)

tanghc/fs-admin

内容风险标识

评论 (3)

tanghc/fs-admin .gitee-modal { width: 500px !important; }

内容风险标识