| | |
| | | /* |
| | | Navicat Premium Data Transfer |
| | | Navicat Premium Dump SQL |
| | | |
| | | Source Server : 127.0.0.1 |
| | | Source Server Type : MySQL |
| | | Source Server Version : 50637 |
| | | Source Server Version : 50637 (5.6.37-log) |
| | | Source Host : localhost:3306 |
| | | Source Schema : kytravel |
| | | |
| | | Target Server Type : MySQL |
| | | Target Server Version : 50637 |
| | | Target Server Version : 50637 (5.6.37-log) |
| | | File Encoding : 65001 |
| | | |
| | | Date: 15/02/2023 15:37:02 |
| | | Date: 31/03/2025 11:37:00 |
| | | */ |
| | | |
| | | SET NAMES utf8mb4; |
| | |
| | | `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '具体消息', |
| | | `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录ip', |
| | | PRIMARY KEY (`id`) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 2487 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录记录' ROW_FORMAT = COMPACT; |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 2491 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录记录' ROW_FORMAT = COMPACT; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of sys_login_log |
| | |
| | | INSERT INTO `sys_login_log` VALUES (2484, '登录日志', 1, '2023-01-31 13:17:51', '成功', NULL, '127.0.0.1'); |
| | | INSERT INTO `sys_login_log` VALUES (2485, '登录日志', 1, '2023-02-10 09:49:34', '成功', NULL, '127.0.0.1'); |
| | | INSERT INTO `sys_login_log` VALUES (2486, '登录日志', 1, '2023-02-10 09:59:44', '成功', NULL, '127.0.0.1'); |
| | | INSERT INTO `sys_login_log` VALUES (2487, '登录日志', 1, '2025-03-31 10:23:55', '成功', NULL, '192.168.110.85'); |
| | | INSERT INTO `sys_login_log` VALUES (2488, '登录日志', 1, '2025-03-31 10:31:16', '成功', NULL, '192.168.110.85'); |
| | | INSERT INTO `sys_login_log` VALUES (2489, '退出日志', 1, '2025-03-31 10:46:20', '成功', NULL, '192.168.110.85'); |
| | | INSERT INTO `sys_login_log` VALUES (2490, '登录日志', 1, '2025-03-31 10:46:26', '成功', NULL, '192.168.110.85'); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for sys_menu |
| | |
| | | INSERT INTO `sys_menu` VALUES (243, 'notice_update', 'notice', '[0],[system],[notice],', '修改通知', NULL, '/notice/update', 243, 3, 0, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (244, 'notice_delete', 'notice', '[0],[system],[notice],', '删除通知', NULL, '/notice/delete', 244, 3, 0, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (245, 'userManage', '0', '[0],', '用户管理', 'fa-bars', '#', 300, 1, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (548764, 'tOrderPrivateCar_orderTrack', 'tOrderPrivateCar', '[0],[travelManage],[tOrderPrivateCar],', '订单轨迹', '', '/tOrderPrivateCar/orderTrack', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (6545645, 'tOrderPrivateCar_deleteOrder', 'tOrderPrivateCar', '[0],[travelManage],[tOrderPrivateCar],', '删除记录', '', '/tOrderPrivateCar/deleteOrder', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (56156165, 'tOrderPrivateCar_cancelOrder', 'tOrderPrivateCar', '[0],[travelManage],[tOrderPrivateCar],', '取消订单', '', '/tOrderPrivateCar/cancelOrder', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (414515616, 'tOrderPrivateCar_list', 'tOrderPrivateCar', '[0],[travelManage],[tOrderPrivateCar],', '专车订单列表', '', '/tOrderPrivateCar/list', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (561561156, 'tOrderPrivateCar_orderDetail', 'tOrderPrivateCar', '[0],[travelManage],[tOrderPrivateCar],', '订单详情', '', '/tOrderPrivateCar/orderDetail', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (615611511, 'tOrderPrivateCar', 'travelManage', '[0],[travelManage],', '专车订单', '', '/tOrderPrivateCar', 1, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1267362239285878786, 'tUser', 'userManage', '[0],[userManage],', '用户管理', '', '/tUser', 301, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1267362239285878787, 'tUser_list', 'tUser', '[0],[userManage],[tUser],', '用户管理列表', '', '/tUser/list', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1267362239285878788, 'tUser_userDetail', 'tUser', '[0],[userManage],[tUser],', '用户详情', '', '/tUser/userDetail', 99, 3, 0, NULL, 1, 0); |
| | |
| | | INSERT INTO `sys_menu` VALUES (1308686944210812933, 'tOrderCrossCity_track', 'tOrderCrossCity', '[0],[travelManage],[tOrderCrossCity],', '订单轨迹', '', '/tOrderCrossCity/track', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308686944210812934, 'tOrderCrossCity_delete', 'tOrderCrossCity', '[0],[travelManage],[tOrderCrossCity],', '删除记录', '', '/tOrderCrossCity/delete', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308686944210812935, 'changeManage', '0', '[0],', '改派管理', 'fa-bars', '#', 350, 1, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (1308690277738774529, 'tReassign', 'changeManage', '[0],[changeManage],', '专车改派管理', '', '/tReassign', 1, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308690277738774530, 'tReassign_list', 'tReassign', '[0],[changeManage],[tReassign],', '专车改派管理列表', '', '/tReassign/list', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308690277738774531, 'tReassign_refused', 'tReassign', '[0],[changeManage],[tReassign],', '拒绝改派', '', '/tReassign/refused', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308690277738774532, 'tReassign_update', 'tReassign', '[0],[changeManage],[tReassign],', '立即改派', '', '/tReassign/reassignment', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308690277738774533, 'tReassign_delete', 'tReassign', '[0],[changeManage],[tReassign],', '取消订单', '', '/tReassign/cancel', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308693386556923905, 'tReassignCross', 'changeManage', '[0],[changeManage],', '跨城改派管理', '', '/tReassign/cross', 2, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308693386556923906, 'tReassign_listCross', 'tReassignCross', '[0],[changeManage],[tReassignCross],', '跨城改派管理列表', '', '/tReassign/listCross', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308693386556923907, 'tReassign_refusedCross', 'tReassignCross', '[0],[changeManage],[tReassignCross],', '拒绝改派', '', '/tReassign/refusedCross', 99, 3, 0, NULL, 1, 0); |
| | |
| | | INSERT INTO `sys_menu` VALUES (1308698188288417799, 'tLine_thaw', 'tLine', '[0],[lineManage],[tLine],', '解冻', '', '/tLine/thaw', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308698188288417800, 'tLine_addCompany', 'tLine', '[0],[lineManage],[tLine],', '分配企业', '', '/tLine/addCompany', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308698188288417801, 'carModelSet', '0', '[0],', '车型设置', 'fa-bars', '#', 352, 1, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (1308701049940402178, 'tServerCarmodel', 'carModelSet', '[0],[carModelSet],', '专车车型设置', '', '/tServerCarmodel', 1, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308701049940402179, 'tServerCarmodel_list', 'tServerCarmodel', '[0],[carModelSet],[tServerCarmodel],', '专车车型设置列表', '', '/tServerCarmodel/list', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308701049940402180, 'tServerCarmodel_add', 'tServerCarmodel', '[0],[carModelSet],[tServerCarmodel],', '添加', '', '/tServerCarmodel/add', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308701049940402181, 'tServerCarmodel_no', 'tServerCarmodel', '[0],[carModelSet],[tServerCarmodel],', '禁用', '', '/tServerCarmodel/no', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308701049940402182, 'tServerCarmodel_yes', 'tServerCarmodel', '[0],[carModelSet],[tServerCarmodel],', '启用', '', '/tServerCarmodel/yes', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308702304670638081, 'tServerCarmodelAcrossCity', 'carModelSet', '[0],[carModelSet],', '跨城车型设置', '', '/tServerCarmodel/acrossCity', 2, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308702304670638082, 'tServerCarmodel_listAcrossCity', 'tServerCarmodelAcrossCity', '[0],[carModelSet],[tServerCarmodelAcrossCity],', '跨城车型设置列表', '', '/tServerCarmodel/listAcrossCity', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308702304670638083, 'tServerCarmodel_addAcrossCity', 'tServerCarmodelAcrossCity', '[0],[carModelSet],[tServerCarmodelAcrossCity],', '添加', '', '/tServerCarmodel/addAcrossCity', 99, 3, 0, NULL, 1, 0); |
| | |
| | | INSERT INTO `sys_menu` VALUES (1308939095893929988, 'tServerCarmodel_noCharter', 'tServerCarmodelCharter', '[0],[carModelSet],[tServerCarmodelCharter],', '启用', '', '/tServerCarmodel/noCharter', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308939095893929989, 'tServerCarmodel_yesCharter', 'tServerCarmodelCharter', '[0],[carModelSet],[tServerCarmodelCharter],', '禁用', '', '/tServerCarmodel/yesCharter', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308939095893929990, 'priceSet', '0', '[0],', '价格设置', 'fa-bars', '#', 353, 1, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344706, 'tSystemPrice', 'priceSet', '[0],[priceSet],', '专车价格设置', '', '/tSystemPrice/special', 1, 2, 1, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344707, 'tSystemPrice_listSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '专车价格设置列表', '', '/tSystemPrice/listSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344708, 'tSystemPrice_addSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '添加', '', '/tSystemPrice/addSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344709, 'tSystemPrice_updateSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '修改', '', '/tSystemPrice/updateSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344710, 'tSystemPrice_deleteSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '删除', '', '/tSystemPrice/deleteSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344711, 'tSystemPrice_freezeSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '冻结', '', '/tSystemPrice/freezeSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344712, 'tSystemPrice_thawSpecial', 'tSystemPrice', '[0],[priceSet],[tSystemPrice],', '解冻', '', '/tSystemPrice/thawSpecial', 99, 3, 0, NULL, 1, 0); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344713, 'small', 'priceSet', '[0],[priceSet],', '小件物流价格设置', 'fa-bars', '/tSystemPrice/small', 2, 2, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (1308947296710344714, 'dispatchManage', '0', '[0],', '调度管理', 'fa-bars', '#', 354, 1, 1, NULL, 1, NULL); |
| | | INSERT INTO `sys_menu` VALUES (1308952578060500993, 'tDispatch', 'dispatchManage', '[0],[dispatchManage],', '调度管理', '', '/tDispatch', 1, 2, 1, NULL, 1, 0); |
| | |
| | | `succeed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否成功', |
| | | `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', |
| | | PRIMARY KEY (`id`) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 725 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志' ROW_FORMAT = COMPACT; |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 732 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志' ROW_FORMAT = COMPACT; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of sys_operation_log |
| | |
| | | INSERT INTO `sys_operation_log` VALUES (722, '异常日志', '', 1, NULL, NULL, '2023-02-10 10:00:08', '失败', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n### The error may exist in file [E:\\IDEA Workspaces\\KYTravel\\ManagementOKTravel\\guns-admin\\target\\classes\\com\\stylefeng\\guns\\modular\\system\\dao\\mapping\\TPubWithdrawalMapper.xml]\r\n### The error may involve com.stylefeng.guns.modular.system.dao.TPubWithdrawalMapper.getWithdrawalList-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT * FROM (SELECT case when pw.userType = 1 then uu.nickName when pw.userType = 2 then dd.`name` else \'\' end as userName, case when pw.userType = 1 then uu.phone when pw.userType = 2 then dd.phone else \'\' end as userPhone, case when pw.userType = 1 then cc.name when pw.userType = 2 then ee.name else \'\' end as company, pw.* FROM t_pub_withdrawal as pw LEFT JOIN t_user as uu on uu.id = pw.userId left join t_company cc on cc.id = uu.companyId LEFT JOIN t_driver as dd on dd.id = pw.userId left join t_company ee on ee.id = dd.companyId ) as o WHERE o.flag != 3 and (cc.name LIKE CONCAT(\'%\',?,\'%\') or ee.name LIKE CONCAT(\'%\',?,\'%\')) order by o.id desc\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)\r\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n at com.sun.proxy.TProxy100.selectList(Unknown Source)\r\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:238)\r\n at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)\r\n at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)\r\n at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n at com.sun.proxy.TProxy164.getWithdrawalList(Unknown Source)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImpl.getWithdrawalList(TPubWithdrawalServiceImpl.java:26)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTFastClassBySpringCGLIBTTba11c9b4.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTEnhancerBySpringCGLIBTT68d49b16.getWithdrawalList(<generated>)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalController.list(TPubWithdrawalController.java:96)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTFastClassBySpringCGLIBTTa0f94dc0.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTEnhancerBySpringCGLIBTT60096ceb.list(<generated>)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\nCaused by: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)\r\n at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)\r\n at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:619)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)\r\n at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)\r\n at com.sun.proxy.TProxy223.execute(Unknown Source)\r\n at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)\r\n at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)\r\n at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)\r\n at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)\r\n at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy220.query(Unknown Source)\r\n at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n ... 98 more\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (723, '异常日志', '', 1, NULL, NULL, '2023-02-10 10:00:09', '失败', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n### The error may exist in file [E:\\IDEA Workspaces\\KYTravel\\ManagementOKTravel\\guns-admin\\target\\classes\\com\\stylefeng\\guns\\modular\\system\\dao\\mapping\\TPubWithdrawalMapper.xml]\r\n### The error may involve com.stylefeng.guns.modular.system.dao.TPubWithdrawalMapper.getWithdrawalList-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT * FROM (SELECT case when pw.userType = 1 then uu.nickName when pw.userType = 2 then dd.`name` else \'\' end as userName, case when pw.userType = 1 then uu.phone when pw.userType = 2 then dd.phone else \'\' end as userPhone, case when pw.userType = 1 then cc.name when pw.userType = 2 then ee.name else \'\' end as company, pw.* FROM t_pub_withdrawal as pw LEFT JOIN t_user as uu on uu.id = pw.userId left join t_company cc on cc.id = uu.companyId LEFT JOIN t_driver as dd on dd.id = pw.userId left join t_company ee on ee.id = dd.companyId ) as o WHERE o.flag != 3 and (cc.name LIKE CONCAT(\'%\',?,\'%\') or ee.name LIKE CONCAT(\'%\',?,\'%\')) order by o.id desc\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)\r\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n at com.sun.proxy.TProxy100.selectList(Unknown Source)\r\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:238)\r\n at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)\r\n at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)\r\n at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n at com.sun.proxy.TProxy164.getWithdrawalList(Unknown Source)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImpl.getWithdrawalList(TPubWithdrawalServiceImpl.java:26)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTFastClassBySpringCGLIBTTba11c9b4.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTEnhancerBySpringCGLIBTT68d49b16.getWithdrawalList(<generated>)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalController.list(TPubWithdrawalController.java:96)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTFastClassBySpringCGLIBTTa0f94dc0.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTEnhancerBySpringCGLIBTT60096ceb.list(<generated>)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\nCaused by: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)\r\n at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)\r\n at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:619)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)\r\n at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)\r\n at com.sun.proxy.TProxy223.execute(Unknown Source)\r\n at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)\r\n at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)\r\n at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)\r\n at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)\r\n at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy220.query(Unknown Source)\r\n at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n ... 98 more\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (724, '异常日志', '', 1, NULL, NULL, '2023-02-10 10:00:09', '失败', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n### The error may exist in file [E:\\IDEA Workspaces\\KYTravel\\ManagementOKTravel\\guns-admin\\target\\classes\\com\\stylefeng\\guns\\modular\\system\\dao\\mapping\\TPubWithdrawalMapper.xml]\r\n### The error may involve com.stylefeng.guns.modular.system.dao.TPubWithdrawalMapper.getWithdrawalList-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT * FROM (SELECT case when pw.userType = 1 then uu.nickName when pw.userType = 2 then dd.`name` else \'\' end as userName, case when pw.userType = 1 then uu.phone when pw.userType = 2 then dd.phone else \'\' end as userPhone, case when pw.userType = 1 then cc.name when pw.userType = 2 then ee.name else \'\' end as company, pw.* FROM t_pub_withdrawal as pw LEFT JOIN t_user as uu on uu.id = pw.userId left join t_company cc on cc.id = uu.companyId LEFT JOIN t_driver as dd on dd.id = pw.userId left join t_company ee on ee.id = dd.companyId ) as o WHERE o.flag != 3 and (cc.name LIKE CONCAT(\'%\',?,\'%\') or ee.name LIKE CONCAT(\'%\',?,\'%\')) order by o.id desc\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)\r\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n at com.sun.proxy.TProxy100.selectList(Unknown Source)\r\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:238)\r\n at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)\r\n at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)\r\n at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n at com.sun.proxy.TProxy164.getWithdrawalList(Unknown Source)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImpl.getWithdrawalList(TPubWithdrawalServiceImpl.java:26)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTFastClassBySpringCGLIBTTba11c9b4.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)\r\n at com.stylefeng.guns.modular.system.service.impl.TPubWithdrawalServiceImplTTEnhancerBySpringCGLIBTT68d49b16.getWithdrawalList(<generated>)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalController.list(TPubWithdrawalController.java:96)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTFastClassBySpringCGLIBTTa0f94dc0.invoke(<generated>)\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)\r\n at com.stylefeng.guns.modular.system.controller.general.TPubWithdrawalControllerTTEnhancerBySpringCGLIBTT60096ceb.list(<generated>)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\nCaused by: java.sql.SQLSyntaxErrorException: Unknown column \'cc.name\' in \'where clause\'\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)\r\n at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)\r\n at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)\r\n at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)\r\n at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:619)\r\n at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)\r\n at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)\r\n at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)\r\n at com.sun.proxy.TProxy223.execute(Unknown Source)\r\n at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)\r\n at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy221.query(Unknown Source)\r\n at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)\r\n at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)\r\n at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)\r\n at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)\r\n at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)\r\n at com.sun.proxy.TProxy220.query(Unknown Source)\r\n at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n ... 98 more\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (725, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:25:21', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValues(RedisUtil.java:103)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getSumData(HomeController.java:150)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (726, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:26:25', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValue(RedisUtil.java:82)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getDriverPosition(HomeController.java:400)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (727, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:26:34', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValues(RedisUtil.java:103)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getSumData(HomeController.java:150)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (728, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:32:41', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValues(RedisUtil.java:103)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getSumData(HomeController.java:150)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (729, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:32:49', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValue(RedisUtil.java:82)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getDriverPosition(HomeController.java:400)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | INSERT INTO `sys_operation_log` VALUES (730, '业务日志', '配置权限', 1, 'com.stylefeng.guns.modular.system.controller.system.RoleController', 'setAuthority', '2025-03-31 10:46:15', '成功', '角色名称=超级管理员,资源名称=首页,系统管理,平台管理员,用户列表,添加用户,修改用户,删除用户,重置密码,冻结用户,解除冻结用户,分配角色,分配角色跳转,编辑用户跳转,角色管理,角色列表,添加角色,修改角色,删除角色,配置权限,修改角色跳转,角色分配跳转,菜单管理,菜单列表,添加菜单,修改菜单,删除菜单,菜单编辑跳转,部门管理,部门列表,添加部门,修改部门,删除部门,部门详情,修改部门跳转,登录日志,登录日志列表,清空登录日志,业务日志,日志列表,日志详情,清空日志,监控管理,用户管理,专车订单,订单轨迹,删除记录,取消订单,专车订单列表,订单详情'); |
| | | INSERT INTO `sys_operation_log` VALUES (731, '异常日志', '', 1, NULL, NULL, '2025-03-31 10:47:53', '失败', 'java.lang.NullPointerException\r\n at com.stylefeng.guns.modular.system.util.RedisUtil.getValues(RedisUtil.java:103)\r\n at com.stylefeng.guns.modular.system.controller.general.HomeController.getSumData(HomeController.java:150)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:498)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.stylefeng.guns.core.xss.XssFilter.doFilter(XssFilter.java:31)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:800)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1471)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:624)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:748)\r\n'); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for sys_relation |
| | |
| | | `menuid` bigint(20) NULL DEFAULT NULL COMMENT '菜单id', |
| | | `roleid` int(11) NULL DEFAULT NULL COMMENT '角色id', |
| | | PRIMARY KEY (`id`) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 22483 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = COMPACT; |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 22794 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = COMPACT; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of sys_relation |
| | |
| | | INSERT INTO `sys_relation` VALUES (19031, 1271615006909194270, 3); |
| | | INSERT INTO `sys_relation` VALUES (19032, 1271615006909194271, 3); |
| | | INSERT INTO `sys_relation` VALUES (19033, 1271615006909194272, 3); |
| | | INSERT INTO `sys_relation` VALUES (21494, 2, 1); |
| | | INSERT INTO `sys_relation` VALUES (21495, 100, 1); |
| | | INSERT INTO `sys_relation` VALUES (21496, 101, 1); |
| | | INSERT INTO `sys_relation` VALUES (21497, 102, 1); |
| | | INSERT INTO `sys_relation` VALUES (21498, 103, 1); |
| | | INSERT INTO `sys_relation` VALUES (21499, 104, 1); |
| | | INSERT INTO `sys_relation` VALUES (21500, 105, 1); |
| | | INSERT INTO `sys_relation` VALUES (21501, 106, 1); |
| | | INSERT INTO `sys_relation` VALUES (21502, 107, 1); |
| | | INSERT INTO `sys_relation` VALUES (21503, 108, 1); |
| | | INSERT INTO `sys_relation` VALUES (21504, 109, 1); |
| | | INSERT INTO `sys_relation` VALUES (21505, 110, 1); |
| | | INSERT INTO `sys_relation` VALUES (21506, 111, 1); |
| | | INSERT INTO `sys_relation` VALUES (21507, 120, 1); |
| | | INSERT INTO `sys_relation` VALUES (21508, 121, 1); |
| | | INSERT INTO `sys_relation` VALUES (21509, 122, 1); |
| | | INSERT INTO `sys_relation` VALUES (21510, 123, 1); |
| | | INSERT INTO `sys_relation` VALUES (21511, 124, 1); |
| | | INSERT INTO `sys_relation` VALUES (21512, 125, 1); |
| | | INSERT INTO `sys_relation` VALUES (21513, 126, 1); |
| | | INSERT INTO `sys_relation` VALUES (21514, 127, 1); |
| | | INSERT INTO `sys_relation` VALUES (21515, 130, 1); |
| | | INSERT INTO `sys_relation` VALUES (21516, 131, 1); |
| | | INSERT INTO `sys_relation` VALUES (21517, 132, 1); |
| | | INSERT INTO `sys_relation` VALUES (21518, 133, 1); |
| | | INSERT INTO `sys_relation` VALUES (21519, 134, 1); |
| | | INSERT INTO `sys_relation` VALUES (21520, 135, 1); |
| | | INSERT INTO `sys_relation` VALUES (21521, 140, 1); |
| | | INSERT INTO `sys_relation` VALUES (21522, 141, 1); |
| | | INSERT INTO `sys_relation` VALUES (21523, 142, 1); |
| | | INSERT INTO `sys_relation` VALUES (21524, 143, 1); |
| | | INSERT INTO `sys_relation` VALUES (21525, 144, 1); |
| | | INSERT INTO `sys_relation` VALUES (21526, 145, 1); |
| | | INSERT INTO `sys_relation` VALUES (21527, 146, 1); |
| | | INSERT INTO `sys_relation` VALUES (21528, 200, 1); |
| | | INSERT INTO `sys_relation` VALUES (21529, 201, 1); |
| | | INSERT INTO `sys_relation` VALUES (21530, 202, 1); |
| | | INSERT INTO `sys_relation` VALUES (21531, 210, 1); |
| | | INSERT INTO `sys_relation` VALUES (21532, 211, 1); |
| | | INSERT INTO `sys_relation` VALUES (21533, 212, 1); |
| | | INSERT INTO `sys_relation` VALUES (21534, 213, 1); |
| | | INSERT INTO `sys_relation` VALUES (21535, 220, 1); |
| | | INSERT INTO `sys_relation` VALUES (21536, 1282644332165259272, 1); |
| | | INSERT INTO `sys_relation` VALUES (21537, 245, 1); |
| | | INSERT INTO `sys_relation` VALUES (21538, 1267362239285878786, 1); |
| | | INSERT INTO `sys_relation` VALUES (21539, 1267362239285878787, 1); |
| | | INSERT INTO `sys_relation` VALUES (21540, 1267362239285878788, 1); |
| | | INSERT INTO `sys_relation` VALUES (21541, 1267362239285878789, 1); |
| | | INSERT INTO `sys_relation` VALUES (21542, 1267362239285878790, 1); |
| | | INSERT INTO `sys_relation` VALUES (21543, 1267362239285878791, 1); |
| | | INSERT INTO `sys_relation` VALUES (21544, 1267362239285878792, 1); |
| | | INSERT INTO `sys_relation` VALUES (21545, 1282644332165259270, 1); |
| | | INSERT INTO `sys_relation` VALUES (21546, 1282644332165259271, 1); |
| | | INSERT INTO `sys_relation` VALUES (21547, 1267362239285878793, 1); |
| | | INSERT INTO `sys_relation` VALUES (21548, 1267362239285878794, 1); |
| | | INSERT INTO `sys_relation` VALUES (21549, 1267391018611814401, 1); |
| | | INSERT INTO `sys_relation` VALUES (21550, 1267398696432078850, 1); |
| | | INSERT INTO `sys_relation` VALUES (21551, 1267625625340907521, 1); |
| | | INSERT INTO `sys_relation` VALUES (21552, 1267627733750448129, 1); |
| | | INSERT INTO `sys_relation` VALUES (21553, 1267628529682546690, 1); |
| | | INSERT INTO `sys_relation` VALUES (21554, 1267628757521334273, 1); |
| | | INSERT INTO `sys_relation` VALUES (21555, 1267628989072080897, 1); |
| | | INSERT INTO `sys_relation` VALUES (21556, 1267631028544000001, 1); |
| | | INSERT INTO `sys_relation` VALUES (21557, 1267631028544000002, 1); |
| | | INSERT INTO `sys_relation` VALUES (21558, 1267631028544000003, 1); |
| | | INSERT INTO `sys_relation` VALUES (21559, 1267631028544000004, 1); |
| | | INSERT INTO `sys_relation` VALUES (21560, 1267631028544000005, 1); |
| | | INSERT INTO `sys_relation` VALUES (21561, 1267631028544000006, 1); |
| | | INSERT INTO `sys_relation` VALUES (21562, 1267631028544000007, 1); |
| | | INSERT INTO `sys_relation` VALUES (21563, 1277087450839248898, 1); |
| | | INSERT INTO `sys_relation` VALUES (21564, 1277087450839248899, 1); |
| | | INSERT INTO `sys_relation` VALUES (21565, 1282644332165259273, 1); |
| | | INSERT INTO `sys_relation` VALUES (21566, 1309014874136809487, 1); |
| | | INSERT INTO `sys_relation` VALUES (21567, 1309014874136809488, 1); |
| | | INSERT INTO `sys_relation` VALUES (21568, 1309014874136809493, 1); |
| | | INSERT INTO `sys_relation` VALUES (21569, 1267631028544000008, 1); |
| | | INSERT INTO `sys_relation` VALUES (21570, 1267662351509766146, 1); |
| | | INSERT INTO `sys_relation` VALUES (21571, 1267662351509766147, 1); |
| | | INSERT INTO `sys_relation` VALUES (21572, 1267662351509766148, 1); |
| | | INSERT INTO `sys_relation` VALUES (21573, 1267662351509766149, 1); |
| | | INSERT INTO `sys_relation` VALUES (21574, 1267662351509766150, 1); |
| | | INSERT INTO `sys_relation` VALUES (21575, 1267662351509766151, 1); |
| | | INSERT INTO `sys_relation` VALUES (21576, 1268476453249400834, 1); |
| | | INSERT INTO `sys_relation` VALUES (21577, 1268476453249400835, 1); |
| | | INSERT INTO `sys_relation` VALUES (21578, 1268476453249400836, 1); |
| | | INSERT INTO `sys_relation` VALUES (21579, 1268476453249400837, 1); |
| | | INSERT INTO `sys_relation` VALUES (21580, 1268476453249400838, 1); |
| | | INSERT INTO `sys_relation` VALUES (21581, 1268503736945254402, 1); |
| | | INSERT INTO `sys_relation` VALUES (21582, 1268503736945254403, 1); |
| | | INSERT INTO `sys_relation` VALUES (21583, 1268503736945254404, 1); |
| | | INSERT INTO `sys_relation` VALUES (21584, 1268503736945254405, 1); |
| | | INSERT INTO `sys_relation` VALUES (21585, 1268503736945254406, 1); |
| | | INSERT INTO `sys_relation` VALUES (21586, 1268503736945254407, 1); |
| | | INSERT INTO `sys_relation` VALUES (21587, 1268503736945254408, 1); |
| | | INSERT INTO `sys_relation` VALUES (21588, 1268503736945254409, 1); |
| | | INSERT INTO `sys_relation` VALUES (21589, 1268503736945254410, 1); |
| | | INSERT INTO `sys_relation` VALUES (21590, 1268503736945254411, 1); |
| | | INSERT INTO `sys_relation` VALUES (21591, 1268503736945254412, 1); |
| | | INSERT INTO `sys_relation` VALUES (21592, 1268503736945254413, 1); |
| | | INSERT INTO `sys_relation` VALUES (21593, 1277087450839248900, 1); |
| | | INSERT INTO `sys_relation` VALUES (21594, 1268503736945254414, 1); |
| | | INSERT INTO `sys_relation` VALUES (21595, 1268782708379693057, 1); |
| | | INSERT INTO `sys_relation` VALUES (21596, 1268782708379693058, 1); |
| | | INSERT INTO `sys_relation` VALUES (21597, 1268782708379693059, 1); |
| | | INSERT INTO `sys_relation` VALUES (21598, 1268782708379693060, 1); |
| | | INSERT INTO `sys_relation` VALUES (21599, 1268782708379693061, 1); |
| | | INSERT INTO `sys_relation` VALUES (21600, 1268792536825081857, 1); |
| | | INSERT INTO `sys_relation` VALUES (21601, 1268792536825081858, 1); |
| | | INSERT INTO `sys_relation` VALUES (21602, 1268792536825081859, 1); |
| | | INSERT INTO `sys_relation` VALUES (21603, 1268792536825081860, 1); |
| | | INSERT INTO `sys_relation` VALUES (21604, 1268792536825081861, 1); |
| | | INSERT INTO `sys_relation` VALUES (21605, 1268836258119962626, 1); |
| | | INSERT INTO `sys_relation` VALUES (21606, 1268836258128351233, 1); |
| | | INSERT INTO `sys_relation` VALUES (21607, 1268836258128351234, 1); |
| | | INSERT INTO `sys_relation` VALUES (21608, 1268836258128351235, 1); |
| | | INSERT INTO `sys_relation` VALUES (21609, 1268836258128351236, 1); |
| | | INSERT INTO `sys_relation` VALUES (21610, 1268836258128351237, 1); |
| | | INSERT INTO `sys_relation` VALUES (21611, 1268836258128351238, 1); |
| | | INSERT INTO `sys_relation` VALUES (21612, 1309014874136809480, 1); |
| | | INSERT INTO `sys_relation` VALUES (21613, 1309014874136809481, 1); |
| | | INSERT INTO `sys_relation` VALUES (21614, 1309014874136809482, 1); |
| | | INSERT INTO `sys_relation` VALUES (21615, 1309014874136809483, 1); |
| | | INSERT INTO `sys_relation` VALUES (21616, 1268836258128351239, 1); |
| | | INSERT INTO `sys_relation` VALUES (21617, 1269075485671837698, 1); |
| | | INSERT INTO `sys_relation` VALUES (21618, 1269075485671837699, 1); |
| | | INSERT INTO `sys_relation` VALUES (21619, 1269075485671837700, 1); |
| | | INSERT INTO `sys_relation` VALUES (21620, 1269075485671837701, 1); |
| | | INSERT INTO `sys_relation` VALUES (21621, 1269075485671837702, 1); |
| | | INSERT INTO `sys_relation` VALUES (21622, 1269075485671837703, 1); |
| | | INSERT INTO `sys_relation` VALUES (21623, 1269075485671837704, 1); |
| | | INSERT INTO `sys_relation` VALUES (21624, 1269187383113371650, 1); |
| | | INSERT INTO `sys_relation` VALUES (21625, 1269187383113371651, 1); |
| | | INSERT INTO `sys_relation` VALUES (21626, 1269187383113371652, 1); |
| | | INSERT INTO `sys_relation` VALUES (21627, 1269187383113371653, 1); |
| | | INSERT INTO `sys_relation` VALUES (21628, 1269187383113371654, 1); |
| | | INSERT INTO `sys_relation` VALUES (21629, 1269187383113371655, 1); |
| | | INSERT INTO `sys_relation` VALUES (21630, 1269187383113371656, 1); |
| | | INSERT INTO `sys_relation` VALUES (21631, 1308686944210812929, 1); |
| | | INSERT INTO `sys_relation` VALUES (21632, 1308686944210812930, 1); |
| | | INSERT INTO `sys_relation` VALUES (21633, 1308686944210812931, 1); |
| | | INSERT INTO `sys_relation` VALUES (21634, 1308686944210812932, 1); |
| | | INSERT INTO `sys_relation` VALUES (21635, 1308686944210812933, 1); |
| | | INSERT INTO `sys_relation` VALUES (21636, 1308686944210812934, 1); |
| | | INSERT INTO `sys_relation` VALUES (21637, 1309014874136809474, 1); |
| | | INSERT INTO `sys_relation` VALUES (21638, 1309014874136809475, 1); |
| | | INSERT INTO `sys_relation` VALUES (21639, 1309014874136809476, 1); |
| | | INSERT INTO `sys_relation` VALUES (21640, 1309014874136809477, 1); |
| | | INSERT INTO `sys_relation` VALUES (21641, 1309014874136809479, 1); |
| | | INSERT INTO `sys_relation` VALUES (21642, 1269817907586584583, 1); |
| | | INSERT INTO `sys_relation` VALUES (21643, 1270155331579760641, 1); |
| | | INSERT INTO `sys_relation` VALUES (21644, 1270155331579760642, 1); |
| | | INSERT INTO `sys_relation` VALUES (21645, 1270155331579760645, 1); |
| | | INSERT INTO `sys_relation` VALUES (21646, 1270155331579760646, 1); |
| | | INSERT INTO `sys_relation` VALUES (21647, 1270166469340102658, 1); |
| | | INSERT INTO `sys_relation` VALUES (21648, 1270166469340102659, 1); |
| | | INSERT INTO `sys_relation` VALUES (21649, 1270166469340102660, 1); |
| | | INSERT INTO `sys_relation` VALUES (21650, 1270166469340102661, 1); |
| | | INSERT INTO `sys_relation` VALUES (21651, 1270187720196505602, 1); |
| | | INSERT INTO `sys_relation` VALUES (21652, 1270187720196505603, 1); |
| | | INSERT INTO `sys_relation` VALUES (21653, 1270187720196505604, 1); |
| | | INSERT INTO `sys_relation` VALUES (21654, 1270187720196505606, 1); |
| | | INSERT INTO `sys_relation` VALUES (21655, 1270187720196505607, 1); |
| | | INSERT INTO `sys_relation` VALUES (21656, 1270200095003930626, 1); |
| | | INSERT INTO `sys_relation` VALUES (21657, 1270230075494756355, 1); |
| | | INSERT INTO `sys_relation` VALUES (21658, 1270287371570556930, 1); |
| | | INSERT INTO `sys_relation` VALUES (21659, 1270287371570556931, 1); |
| | | INSERT INTO `sys_relation` VALUES (21660, 1270287371570556932, 1); |
| | | INSERT INTO `sys_relation` VALUES (21661, 1270287371570556934, 1); |
| | | INSERT INTO `sys_relation` VALUES (21662, 1270287371570556935, 1); |
| | | INSERT INTO `sys_relation` VALUES (21663, 1270230075494756354, 1); |
| | | INSERT INTO `sys_relation` VALUES (21664, 1270287371570556936, 1); |
| | | INSERT INTO `sys_relation` VALUES (21665, 1270321112590364674, 1); |
| | | INSERT INTO `sys_relation` VALUES (21666, 1270321112590364675, 1); |
| | | INSERT INTO `sys_relation` VALUES (21667, 1270321112590364676, 1); |
| | | INSERT INTO `sys_relation` VALUES (21668, 1270321112590364678, 1); |
| | | INSERT INTO `sys_relation` VALUES (21669, 1270321112590364679, 1); |
| | | INSERT INTO `sys_relation` VALUES (21670, 1270542445643317250, 1); |
| | | INSERT INTO `sys_relation` VALUES (21671, 1270542445643317251, 1); |
| | | INSERT INTO `sys_relation` VALUES (21672, 1270542445643317252, 1); |
| | | INSERT INTO `sys_relation` VALUES (21673, 1270542855032553473, 1); |
| | | INSERT INTO `sys_relation` VALUES (21674, 1270542855032553474, 1); |
| | | INSERT INTO `sys_relation` VALUES (21675, 1270542855032553475, 1); |
| | | INSERT INTO `sys_relation` VALUES (21676, 1275629819595452417, 1); |
| | | INSERT INTO `sys_relation` VALUES (21677, 1275629819595452418, 1); |
| | | INSERT INTO `sys_relation` VALUES (21678, 1275629819595452419, 1); |
| | | INSERT INTO `sys_relation` VALUES (21679, 1270542855032553476, 1); |
| | | INSERT INTO `sys_relation` VALUES (21680, 1270617046482214913, 1); |
| | | INSERT INTO `sys_relation` VALUES (21681, 1270617046482214914, 1); |
| | | INSERT INTO `sys_relation` VALUES (21682, 1270617046482214915, 1); |
| | | INSERT INTO `sys_relation` VALUES (21683, 1270617046482214916, 1); |
| | | INSERT INTO `sys_relation` VALUES (21684, 1270617046482214917, 1); |
| | | INSERT INTO `sys_relation` VALUES (21685, 1270626371560824834, 1); |
| | | INSERT INTO `sys_relation` VALUES (21686, 1270626371560824835, 1); |
| | | INSERT INTO `sys_relation` VALUES (21687, 1270626371560824836, 1); |
| | | INSERT INTO `sys_relation` VALUES (21688, 1270626371560824837, 1); |
| | | INSERT INTO `sys_relation` VALUES (21689, 1270626371560824838, 1); |
| | | INSERT INTO `sys_relation` VALUES (21690, 1270626371560824839, 1); |
| | | INSERT INTO `sys_relation` VALUES (21691, 1270626371560824840, 1); |
| | | INSERT INTO `sys_relation` VALUES (21692, 1270667884395245569, 1); |
| | | INSERT INTO `sys_relation` VALUES (21693, 1270667884395245570, 1); |
| | | INSERT INTO `sys_relation` VALUES (21694, 1270667884395245571, 1); |
| | | INSERT INTO `sys_relation` VALUES (21695, 1270667884395245573, 1); |
| | | INSERT INTO `sys_relation` VALUES (21696, 1270667884395245574, 1); |
| | | INSERT INTO `sys_relation` VALUES (21697, 1270682932433928193, 1); |
| | | INSERT INTO `sys_relation` VALUES (21698, 1271615006909194251, 1); |
| | | INSERT INTO `sys_relation` VALUES (21699, 1271615006909194247, 1); |
| | | INSERT INTO `sys_relation` VALUES (21700, 1271615006909194248, 1); |
| | | INSERT INTO `sys_relation` VALUES (21701, 1271615006909194249, 1); |
| | | INSERT INTO `sys_relation` VALUES (21702, 1271615006909194250, 1); |
| | | INSERT INTO `sys_relation` VALUES (21703, 1271615006909194252, 1); |
| | | INSERT INTO `sys_relation` VALUES (21704, 1271615006909194253, 1); |
| | | INSERT INTO `sys_relation` VALUES (21705, 1271615006909194254, 1); |
| | | INSERT INTO `sys_relation` VALUES (21706, 1271615006909194255, 1); |
| | | INSERT INTO `sys_relation` VALUES (21707, 1271615006909194256, 1); |
| | | INSERT INTO `sys_relation` VALUES (21708, 1271615006909194257, 1); |
| | | INSERT INTO `sys_relation` VALUES (21709, 1271615006909194258, 1); |
| | | INSERT INTO `sys_relation` VALUES (21710, 1271615006909194259, 1); |
| | | INSERT INTO `sys_relation` VALUES (21711, 1271615006909194260, 1); |
| | | INSERT INTO `sys_relation` VALUES (21712, 1271615006909194261, 1); |
| | | INSERT INTO `sys_relation` VALUES (21713, 1271615006909194262, 1); |
| | | INSERT INTO `sys_relation` VALUES (21714, 1271615006909194263, 1); |
| | | INSERT INTO `sys_relation` VALUES (21715, 1271615006909194264, 1); |
| | | INSERT INTO `sys_relation` VALUES (21716, 1271615006909194266, 1); |
| | | INSERT INTO `sys_relation` VALUES (21717, 1271615006909194267, 1); |
| | | INSERT INTO `sys_relation` VALUES (21718, 1271615006909194268, 1); |
| | | INSERT INTO `sys_relation` VALUES (21719, 1271615006909194269, 1); |
| | | INSERT INTO `sys_relation` VALUES (21720, 1271615006909194270, 1); |
| | | INSERT INTO `sys_relation` VALUES (21721, 1271615006909194271, 1); |
| | | INSERT INTO `sys_relation` VALUES (21722, 1271615006909194272, 1); |
| | | INSERT INTO `sys_relation` VALUES (21723, 1308686944210812935, 1); |
| | | INSERT INTO `sys_relation` VALUES (21724, 1308693386556923905, 1); |
| | | INSERT INTO `sys_relation` VALUES (21725, 1308693386556923906, 1); |
| | | INSERT INTO `sys_relation` VALUES (21726, 1308693386556923907, 1); |
| | | INSERT INTO `sys_relation` VALUES (21727, 1308693386556923908, 1); |
| | | INSERT INTO `sys_relation` VALUES (21728, 1308693386556923909, 1); |
| | | INSERT INTO `sys_relation` VALUES (21729, 1309014874136809494, 1); |
| | | INSERT INTO `sys_relation` VALUES (21730, 1309014874136809495, 1); |
| | | INSERT INTO `sys_relation` VALUES (21731, 1309014874136809496, 1); |
| | | INSERT INTO `sys_relation` VALUES (21732, 1309014874136809497, 1); |
| | | INSERT INTO `sys_relation` VALUES (21733, 1308693386556923910, 1); |
| | | INSERT INTO `sys_relation` VALUES (21734, 1308694555895324673, 1); |
| | | INSERT INTO `sys_relation` VALUES (21735, 1308694555895324674, 1); |
| | | INSERT INTO `sys_relation` VALUES (21736, 1308694555895324675, 1); |
| | | INSERT INTO `sys_relation` VALUES (21737, 1308694555895324676, 1); |
| | | INSERT INTO `sys_relation` VALUES (21738, 1308694555895324677, 1); |
| | | INSERT INTO `sys_relation` VALUES (21739, 1308694555895324678, 1); |
| | | INSERT INTO `sys_relation` VALUES (21740, 1308694555895324679, 1); |
| | | INSERT INTO `sys_relation` VALUES (21741, 1308698188288417793, 1); |
| | | INSERT INTO `sys_relation` VALUES (21742, 1308698188288417794, 1); |
| | | INSERT INTO `sys_relation` VALUES (21743, 1308698188288417795, 1); |
| | | INSERT INTO `sys_relation` VALUES (21744, 1308698188288417796, 1); |
| | | INSERT INTO `sys_relation` VALUES (21745, 1308698188288417797, 1); |
| | | INSERT INTO `sys_relation` VALUES (21746, 1308698188288417798, 1); |
| | | INSERT INTO `sys_relation` VALUES (21747, 1308698188288417799, 1); |
| | | INSERT INTO `sys_relation` VALUES (21748, 1308698188288417800, 1); |
| | | INSERT INTO `sys_relation` VALUES (21749, 1308698188288417801, 1); |
| | | INSERT INTO `sys_relation` VALUES (21750, 1308702304670638081, 1); |
| | | INSERT INTO `sys_relation` VALUES (21751, 1308702304670638082, 1); |
| | | INSERT INTO `sys_relation` VALUES (21752, 1308702304670638083, 1); |
| | | INSERT INTO `sys_relation` VALUES (21753, 1308702304670638084, 1); |
| | | INSERT INTO `sys_relation` VALUES (21754, 1308702304670638085, 1); |
| | | INSERT INTO `sys_relation` VALUES (21755, 1309014874136809484, 1); |
| | | INSERT INTO `sys_relation` VALUES (21756, 1308939095893929990, 1); |
| | | INSERT INTO `sys_relation` VALUES (21757, 1308947296710344713, 1); |
| | | INSERT INTO `sys_relation` VALUES (21758, 1308947296710344714, 1); |
| | | INSERT INTO `sys_relation` VALUES (21759, 1308952578060500993, 1); |
| | | INSERT INTO `sys_relation` VALUES (21760, 1308952578060500994, 1); |
| | | INSERT INTO `sys_relation` VALUES (21761, 1308952578060500995, 1); |
| | | INSERT INTO `sys_relation` VALUES (21762, 1308952578060500996, 1); |
| | | INSERT INTO `sys_relation` VALUES (21763, 1308952578060500997, 1); |
| | | INSERT INTO `sys_relation` VALUES (21764, 1308952578060500998, 1); |
| | | INSERT INTO `sys_relation` VALUES (21765, 1308952578060500999, 1); |
| | | INSERT INTO `sys_relation` VALUES (21766, 1308952578060501000, 1); |
| | | INSERT INTO `sys_relation` VALUES (21767, 1308956024717230081, 1); |
| | | INSERT INTO `sys_relation` VALUES (21768, 1308956024717230082, 1); |
| | | INSERT INTO `sys_relation` VALUES (21769, 1308956024717230083, 1); |
| | | INSERT INTO `sys_relation` VALUES (21770, 1308956024717230084, 1); |
| | | INSERT INTO `sys_relation` VALUES (21771, 1308956024717230085, 1); |
| | | INSERT INTO `sys_relation` VALUES (21772, 1308956024717230086, 1); |
| | | INSERT INTO `sys_relation` VALUES (21773, 1308956024717230087, 1); |
| | | INSERT INTO `sys_relation` VALUES (21774, 1308956024717230088, 1); |
| | | INSERT INTO `sys_relation` VALUES (21775, 1308958374009815041, 1); |
| | | INSERT INTO `sys_relation` VALUES (21776, 1308958374009815042, 1); |
| | | INSERT INTO `sys_relation` VALUES (21777, 1308958374009815043, 1); |
| | | INSERT INTO `sys_relation` VALUES (21778, 1308958374009815044, 1); |
| | | INSERT INTO `sys_relation` VALUES (21779, 1309014874136809489, 1); |
| | | INSERT INTO `sys_relation` VALUES (21780, 1309014874136809490, 1); |
| | | INSERT INTO `sys_relation` VALUES (21781, 1309014874136809491, 1); |
| | | INSERT INTO `sys_relation` VALUES (22298, 2, 2); |
| | | INSERT INTO `sys_relation` VALUES (22299, 100, 2); |
| | | INSERT INTO `sys_relation` VALUES (22300, 200, 2); |
| | |
| | | INSERT INTO `sys_relation` VALUES (22480, 1309014874136809489, 2); |
| | | INSERT INTO `sys_relation` VALUES (22481, 1309014874136809490, 2); |
| | | INSERT INTO `sys_relation` VALUES (22482, 1309014874136809491, 2); |
| | | INSERT INTO `sys_relation` VALUES (22483, 2, 1); |
| | | INSERT INTO `sys_relation` VALUES (22484, 100, 1); |
| | | INSERT INTO `sys_relation` VALUES (22485, 101, 1); |
| | | INSERT INTO `sys_relation` VALUES (22486, 102, 1); |
| | | INSERT INTO `sys_relation` VALUES (22487, 103, 1); |
| | | INSERT INTO `sys_relation` VALUES (22488, 104, 1); |
| | | INSERT INTO `sys_relation` VALUES (22489, 105, 1); |
| | | INSERT INTO `sys_relation` VALUES (22490, 106, 1); |
| | | INSERT INTO `sys_relation` VALUES (22491, 107, 1); |
| | | INSERT INTO `sys_relation` VALUES (22492, 108, 1); |
| | | INSERT INTO `sys_relation` VALUES (22493, 109, 1); |
| | | INSERT INTO `sys_relation` VALUES (22494, 110, 1); |
| | | INSERT INTO `sys_relation` VALUES (22495, 111, 1); |
| | | INSERT INTO `sys_relation` VALUES (22496, 120, 1); |
| | | INSERT INTO `sys_relation` VALUES (22497, 121, 1); |
| | | INSERT INTO `sys_relation` VALUES (22498, 122, 1); |
| | | INSERT INTO `sys_relation` VALUES (22499, 123, 1); |
| | | INSERT INTO `sys_relation` VALUES (22500, 124, 1); |
| | | INSERT INTO `sys_relation` VALUES (22501, 125, 1); |
| | | INSERT INTO `sys_relation` VALUES (22502, 126, 1); |
| | | INSERT INTO `sys_relation` VALUES (22503, 127, 1); |
| | | INSERT INTO `sys_relation` VALUES (22504, 130, 1); |
| | | INSERT INTO `sys_relation` VALUES (22505, 131, 1); |
| | | INSERT INTO `sys_relation` VALUES (22506, 132, 1); |
| | | INSERT INTO `sys_relation` VALUES (22507, 133, 1); |
| | | INSERT INTO `sys_relation` VALUES (22508, 134, 1); |
| | | INSERT INTO `sys_relation` VALUES (22509, 135, 1); |
| | | INSERT INTO `sys_relation` VALUES (22510, 140, 1); |
| | | INSERT INTO `sys_relation` VALUES (22511, 141, 1); |
| | | INSERT INTO `sys_relation` VALUES (22512, 142, 1); |
| | | INSERT INTO `sys_relation` VALUES (22513, 143, 1); |
| | | INSERT INTO `sys_relation` VALUES (22514, 144, 1); |
| | | INSERT INTO `sys_relation` VALUES (22515, 145, 1); |
| | | INSERT INTO `sys_relation` VALUES (22516, 146, 1); |
| | | INSERT INTO `sys_relation` VALUES (22517, 200, 1); |
| | | INSERT INTO `sys_relation` VALUES (22518, 201, 1); |
| | | INSERT INTO `sys_relation` VALUES (22519, 202, 1); |
| | | INSERT INTO `sys_relation` VALUES (22520, 210, 1); |
| | | INSERT INTO `sys_relation` VALUES (22521, 211, 1); |
| | | INSERT INTO `sys_relation` VALUES (22522, 212, 1); |
| | | INSERT INTO `sys_relation` VALUES (22523, 213, 1); |
| | | INSERT INTO `sys_relation` VALUES (22524, 220, 1); |
| | | INSERT INTO `sys_relation` VALUES (22525, 1282644332165259272, 1); |
| | | INSERT INTO `sys_relation` VALUES (22526, 245, 1); |
| | | INSERT INTO `sys_relation` VALUES (22527, 1267362239285878786, 1); |
| | | INSERT INTO `sys_relation` VALUES (22528, 1267362239285878787, 1); |
| | | INSERT INTO `sys_relation` VALUES (22529, 1267362239285878788, 1); |
| | | INSERT INTO `sys_relation` VALUES (22530, 1267362239285878789, 1); |
| | | INSERT INTO `sys_relation` VALUES (22531, 1267362239285878790, 1); |
| | | INSERT INTO `sys_relation` VALUES (22532, 1267362239285878791, 1); |
| | | INSERT INTO `sys_relation` VALUES (22533, 1267362239285878792, 1); |
| | | INSERT INTO `sys_relation` VALUES (22534, 1282644332165259270, 1); |
| | | INSERT INTO `sys_relation` VALUES (22535, 1282644332165259271, 1); |
| | | INSERT INTO `sys_relation` VALUES (22536, 1267362239285878793, 1); |
| | | INSERT INTO `sys_relation` VALUES (22537, 1267362239285878794, 1); |
| | | INSERT INTO `sys_relation` VALUES (22538, 1267391018611814401, 1); |
| | | INSERT INTO `sys_relation` VALUES (22539, 1267398696432078850, 1); |
| | | INSERT INTO `sys_relation` VALUES (22540, 1267625625340907521, 1); |
| | | INSERT INTO `sys_relation` VALUES (22541, 1267627733750448129, 1); |
| | | INSERT INTO `sys_relation` VALUES (22542, 1267628529682546690, 1); |
| | | INSERT INTO `sys_relation` VALUES (22543, 1267628757521334273, 1); |
| | | INSERT INTO `sys_relation` VALUES (22544, 1267628989072080897, 1); |
| | | INSERT INTO `sys_relation` VALUES (22545, 1267631028544000001, 1); |
| | | INSERT INTO `sys_relation` VALUES (22546, 1267631028544000002, 1); |
| | | INSERT INTO `sys_relation` VALUES (22547, 1267631028544000003, 1); |
| | | INSERT INTO `sys_relation` VALUES (22548, 1267631028544000004, 1); |
| | | INSERT INTO `sys_relation` VALUES (22549, 1267631028544000005, 1); |
| | | INSERT INTO `sys_relation` VALUES (22550, 1267631028544000006, 1); |
| | | INSERT INTO `sys_relation` VALUES (22551, 1267631028544000007, 1); |
| | | INSERT INTO `sys_relation` VALUES (22552, 1277087450839248898, 1); |
| | | INSERT INTO `sys_relation` VALUES (22553, 1277087450839248899, 1); |
| | | INSERT INTO `sys_relation` VALUES (22554, 1282644332165259273, 1); |
| | | INSERT INTO `sys_relation` VALUES (22555, 1309014874136809487, 1); |
| | | INSERT INTO `sys_relation` VALUES (22556, 1309014874136809488, 1); |
| | | INSERT INTO `sys_relation` VALUES (22557, 1309014874136809493, 1); |
| | | INSERT INTO `sys_relation` VALUES (22558, 1267631028544000008, 1); |
| | | INSERT INTO `sys_relation` VALUES (22559, 1267662351509766146, 1); |
| | | INSERT INTO `sys_relation` VALUES (22560, 1267662351509766147, 1); |
| | | INSERT INTO `sys_relation` VALUES (22561, 1267662351509766148, 1); |
| | | INSERT INTO `sys_relation` VALUES (22562, 1267662351509766149, 1); |
| | | INSERT INTO `sys_relation` VALUES (22563, 1267662351509766150, 1); |
| | | INSERT INTO `sys_relation` VALUES (22564, 1267662351509766151, 1); |
| | | INSERT INTO `sys_relation` VALUES (22565, 1268476453249400834, 1); |
| | | INSERT INTO `sys_relation` VALUES (22566, 1268476453249400835, 1); |
| | | INSERT INTO `sys_relation` VALUES (22567, 1268476453249400836, 1); |
| | | INSERT INTO `sys_relation` VALUES (22568, 1268476453249400837, 1); |
| | | INSERT INTO `sys_relation` VALUES (22569, 1268476453249400838, 1); |
| | | INSERT INTO `sys_relation` VALUES (22570, 1268503736945254402, 1); |
| | | INSERT INTO `sys_relation` VALUES (22571, 1268503736945254403, 1); |
| | | INSERT INTO `sys_relation` VALUES (22572, 1268503736945254404, 1); |
| | | INSERT INTO `sys_relation` VALUES (22573, 1268503736945254405, 1); |
| | | INSERT INTO `sys_relation` VALUES (22574, 1268503736945254406, 1); |
| | | INSERT INTO `sys_relation` VALUES (22575, 1268503736945254407, 1); |
| | | INSERT INTO `sys_relation` VALUES (22576, 1268503736945254408, 1); |
| | | INSERT INTO `sys_relation` VALUES (22577, 1268503736945254409, 1); |
| | | INSERT INTO `sys_relation` VALUES (22578, 1268503736945254410, 1); |
| | | INSERT INTO `sys_relation` VALUES (22579, 1268503736945254411, 1); |
| | | INSERT INTO `sys_relation` VALUES (22580, 1268503736945254412, 1); |
| | | INSERT INTO `sys_relation` VALUES (22581, 1268503736945254413, 1); |
| | | INSERT INTO `sys_relation` VALUES (22582, 1277087450839248900, 1); |
| | | INSERT INTO `sys_relation` VALUES (22583, 1268503736945254414, 1); |
| | | INSERT INTO `sys_relation` VALUES (22584, 1268782708379693057, 1); |
| | | INSERT INTO `sys_relation` VALUES (22585, 1268782708379693058, 1); |
| | | INSERT INTO `sys_relation` VALUES (22586, 1268782708379693059, 1); |
| | | INSERT INTO `sys_relation` VALUES (22587, 1268782708379693060, 1); |
| | | INSERT INTO `sys_relation` VALUES (22588, 1268782708379693061, 1); |
| | | INSERT INTO `sys_relation` VALUES (22589, 1268792536825081857, 1); |
| | | INSERT INTO `sys_relation` VALUES (22590, 1268792536825081858, 1); |
| | | INSERT INTO `sys_relation` VALUES (22591, 1268792536825081859, 1); |
| | | INSERT INTO `sys_relation` VALUES (22592, 1268792536825081860, 1); |
| | | INSERT INTO `sys_relation` VALUES (22593, 1268792536825081861, 1); |
| | | INSERT INTO `sys_relation` VALUES (22594, 1268836258119962626, 1); |
| | | INSERT INTO `sys_relation` VALUES (22595, 1268836258128351233, 1); |
| | | INSERT INTO `sys_relation` VALUES (22596, 1268836258128351234, 1); |
| | | INSERT INTO `sys_relation` VALUES (22597, 1268836258128351235, 1); |
| | | INSERT INTO `sys_relation` VALUES (22598, 1268836258128351236, 1); |
| | | INSERT INTO `sys_relation` VALUES (22599, 1268836258128351237, 1); |
| | | INSERT INTO `sys_relation` VALUES (22600, 1268836258128351238, 1); |
| | | INSERT INTO `sys_relation` VALUES (22601, 1309014874136809480, 1); |
| | | INSERT INTO `sys_relation` VALUES (22602, 1309014874136809481, 1); |
| | | INSERT INTO `sys_relation` VALUES (22603, 1309014874136809482, 1); |
| | | INSERT INTO `sys_relation` VALUES (22604, 1309014874136809483, 1); |
| | | INSERT INTO `sys_relation` VALUES (22605, 1268836258128351239, 1); |
| | | INSERT INTO `sys_relation` VALUES (22606, 1269075485671837698, 1); |
| | | INSERT INTO `sys_relation` VALUES (22607, 1269075485671837699, 1); |
| | | INSERT INTO `sys_relation` VALUES (22608, 1269075485671837700, 1); |
| | | INSERT INTO `sys_relation` VALUES (22609, 1269075485671837701, 1); |
| | | INSERT INTO `sys_relation` VALUES (22610, 1269075485671837702, 1); |
| | | INSERT INTO `sys_relation` VALUES (22611, 1269075485671837703, 1); |
| | | INSERT INTO `sys_relation` VALUES (22612, 1269075485671837704, 1); |
| | | INSERT INTO `sys_relation` VALUES (22613, 1269187383113371650, 1); |
| | | INSERT INTO `sys_relation` VALUES (22614, 1269187383113371651, 1); |
| | | INSERT INTO `sys_relation` VALUES (22615, 1269187383113371652, 1); |
| | | INSERT INTO `sys_relation` VALUES (22616, 1269187383113371653, 1); |
| | | INSERT INTO `sys_relation` VALUES (22617, 1269187383113371654, 1); |
| | | INSERT INTO `sys_relation` VALUES (22618, 1269187383113371655, 1); |
| | | INSERT INTO `sys_relation` VALUES (22619, 1269187383113371656, 1); |
| | | INSERT INTO `sys_relation` VALUES (22620, 615611511, 1); |
| | | INSERT INTO `sys_relation` VALUES (22621, 548764, 1); |
| | | INSERT INTO `sys_relation` VALUES (22622, 6545645, 1); |
| | | INSERT INTO `sys_relation` VALUES (22623, 56156165, 1); |
| | | INSERT INTO `sys_relation` VALUES (22624, 414515616, 1); |
| | | INSERT INTO `sys_relation` VALUES (22625, 561561156, 1); |
| | | INSERT INTO `sys_relation` VALUES (22626, 1308686944210812929, 1); |
| | | INSERT INTO `sys_relation` VALUES (22627, 1308686944210812930, 1); |
| | | INSERT INTO `sys_relation` VALUES (22628, 1308686944210812931, 1); |
| | | INSERT INTO `sys_relation` VALUES (22629, 1308686944210812932, 1); |
| | | INSERT INTO `sys_relation` VALUES (22630, 1308686944210812933, 1); |
| | | INSERT INTO `sys_relation` VALUES (22631, 1308686944210812934, 1); |
| | | INSERT INTO `sys_relation` VALUES (22632, 1309014874136809474, 1); |
| | | INSERT INTO `sys_relation` VALUES (22633, 1309014874136809475, 1); |
| | | INSERT INTO `sys_relation` VALUES (22634, 1309014874136809476, 1); |
| | | INSERT INTO `sys_relation` VALUES (22635, 1309014874136809477, 1); |
| | | INSERT INTO `sys_relation` VALUES (22636, 1309014874136809479, 1); |
| | | INSERT INTO `sys_relation` VALUES (22637, 1269817907586584583, 1); |
| | | INSERT INTO `sys_relation` VALUES (22638, 1270155331579760641, 1); |
| | | INSERT INTO `sys_relation` VALUES (22639, 1270155331579760642, 1); |
| | | INSERT INTO `sys_relation` VALUES (22640, 1270155331579760645, 1); |
| | | INSERT INTO `sys_relation` VALUES (22641, 1270155331579760646, 1); |
| | | INSERT INTO `sys_relation` VALUES (22642, 1270166469340102658, 1); |
| | | INSERT INTO `sys_relation` VALUES (22643, 1270166469340102659, 1); |
| | | INSERT INTO `sys_relation` VALUES (22644, 1270166469340102660, 1); |
| | | INSERT INTO `sys_relation` VALUES (22645, 1270166469340102661, 1); |
| | | INSERT INTO `sys_relation` VALUES (22646, 1270187720196505602, 1); |
| | | INSERT INTO `sys_relation` VALUES (22647, 1270187720196505603, 1); |
| | | INSERT INTO `sys_relation` VALUES (22648, 1270187720196505604, 1); |
| | | INSERT INTO `sys_relation` VALUES (22649, 1270187720196505606, 1); |
| | | INSERT INTO `sys_relation` VALUES (22650, 1270187720196505607, 1); |
| | | INSERT INTO `sys_relation` VALUES (22651, 1270200095003930626, 1); |
| | | INSERT INTO `sys_relation` VALUES (22652, 1270230075494756355, 1); |
| | | INSERT INTO `sys_relation` VALUES (22653, 1270287371570556930, 1); |
| | | INSERT INTO `sys_relation` VALUES (22654, 1270287371570556931, 1); |
| | | INSERT INTO `sys_relation` VALUES (22655, 1270287371570556932, 1); |
| | | INSERT INTO `sys_relation` VALUES (22656, 1270287371570556934, 1); |
| | | INSERT INTO `sys_relation` VALUES (22657, 1270287371570556935, 1); |
| | | INSERT INTO `sys_relation` VALUES (22658, 1270230075494756354, 1); |
| | | INSERT INTO `sys_relation` VALUES (22659, 1270287371570556936, 1); |
| | | INSERT INTO `sys_relation` VALUES (22660, 1270321112590364674, 1); |
| | | INSERT INTO `sys_relation` VALUES (22661, 1270321112590364675, 1); |
| | | INSERT INTO `sys_relation` VALUES (22662, 1270321112590364676, 1); |
| | | INSERT INTO `sys_relation` VALUES (22663, 1270321112590364678, 1); |
| | | INSERT INTO `sys_relation` VALUES (22664, 1270321112590364679, 1); |
| | | INSERT INTO `sys_relation` VALUES (22665, 1270542445643317250, 1); |
| | | INSERT INTO `sys_relation` VALUES (22666, 1270542445643317251, 1); |
| | | INSERT INTO `sys_relation` VALUES (22667, 1270542445643317252, 1); |
| | | INSERT INTO `sys_relation` VALUES (22668, 1270542855032553473, 1); |
| | | INSERT INTO `sys_relation` VALUES (22669, 1270542855032553474, 1); |
| | | INSERT INTO `sys_relation` VALUES (22670, 1270542855032553475, 1); |
| | | INSERT INTO `sys_relation` VALUES (22671, 1275629819595452417, 1); |
| | | INSERT INTO `sys_relation` VALUES (22672, 1275629819595452418, 1); |
| | | INSERT INTO `sys_relation` VALUES (22673, 1275629819595452419, 1); |
| | | INSERT INTO `sys_relation` VALUES (22674, 1270542855032553476, 1); |
| | | INSERT INTO `sys_relation` VALUES (22675, 1270617046482214913, 1); |
| | | INSERT INTO `sys_relation` VALUES (22676, 1270617046482214914, 1); |
| | | INSERT INTO `sys_relation` VALUES (22677, 1270617046482214915, 1); |
| | | INSERT INTO `sys_relation` VALUES (22678, 1270617046482214916, 1); |
| | | INSERT INTO `sys_relation` VALUES (22679, 1270617046482214917, 1); |
| | | INSERT INTO `sys_relation` VALUES (22680, 1270626371560824834, 1); |
| | | INSERT INTO `sys_relation` VALUES (22681, 1270626371560824835, 1); |
| | | INSERT INTO `sys_relation` VALUES (22682, 1270626371560824836, 1); |
| | | INSERT INTO `sys_relation` VALUES (22683, 1270626371560824837, 1); |
| | | INSERT INTO `sys_relation` VALUES (22684, 1270626371560824838, 1); |
| | | INSERT INTO `sys_relation` VALUES (22685, 1270626371560824839, 1); |
| | | INSERT INTO `sys_relation` VALUES (22686, 1270626371560824840, 1); |
| | | INSERT INTO `sys_relation` VALUES (22687, 1270667884395245569, 1); |
| | | INSERT INTO `sys_relation` VALUES (22688, 1270667884395245570, 1); |
| | | INSERT INTO `sys_relation` VALUES (22689, 1270667884395245571, 1); |
| | | INSERT INTO `sys_relation` VALUES (22690, 1270667884395245573, 1); |
| | | INSERT INTO `sys_relation` VALUES (22691, 1270667884395245574, 1); |
| | | INSERT INTO `sys_relation` VALUES (22692, 1270682932433928193, 1); |
| | | INSERT INTO `sys_relation` VALUES (22693, 1271615006909194251, 1); |
| | | INSERT INTO `sys_relation` VALUES (22694, 1271615006909194247, 1); |
| | | INSERT INTO `sys_relation` VALUES (22695, 1271615006909194248, 1); |
| | | INSERT INTO `sys_relation` VALUES (22696, 1271615006909194249, 1); |
| | | INSERT INTO `sys_relation` VALUES (22697, 1271615006909194250, 1); |
| | | INSERT INTO `sys_relation` VALUES (22698, 1271615006909194252, 1); |
| | | INSERT INTO `sys_relation` VALUES (22699, 1271615006909194253, 1); |
| | | INSERT INTO `sys_relation` VALUES (22700, 1271615006909194254, 1); |
| | | INSERT INTO `sys_relation` VALUES (22701, 1271615006909194255, 1); |
| | | INSERT INTO `sys_relation` VALUES (22702, 1271615006909194256, 1); |
| | | INSERT INTO `sys_relation` VALUES (22703, 1271615006909194257, 1); |
| | | INSERT INTO `sys_relation` VALUES (22704, 1271615006909194258, 1); |
| | | INSERT INTO `sys_relation` VALUES (22705, 1271615006909194259, 1); |
| | | INSERT INTO `sys_relation` VALUES (22706, 1271615006909194260, 1); |
| | | INSERT INTO `sys_relation` VALUES (22707, 1271615006909194261, 1); |
| | | INSERT INTO `sys_relation` VALUES (22708, 1271615006909194262, 1); |
| | | INSERT INTO `sys_relation` VALUES (22709, 1271615006909194263, 1); |
| | | INSERT INTO `sys_relation` VALUES (22710, 1271615006909194264, 1); |
| | | INSERT INTO `sys_relation` VALUES (22711, 1271615006909194266, 1); |
| | | INSERT INTO `sys_relation` VALUES (22712, 1271615006909194267, 1); |
| | | INSERT INTO `sys_relation` VALUES (22713, 1271615006909194268, 1); |
| | | INSERT INTO `sys_relation` VALUES (22714, 1271615006909194269, 1); |
| | | INSERT INTO `sys_relation` VALUES (22715, 1271615006909194270, 1); |
| | | INSERT INTO `sys_relation` VALUES (22716, 1271615006909194271, 1); |
| | | INSERT INTO `sys_relation` VALUES (22717, 1271615006909194272, 1); |
| | | INSERT INTO `sys_relation` VALUES (22718, 1308686944210812935, 1); |
| | | INSERT INTO `sys_relation` VALUES (22719, 1308690277738774529, 1); |
| | | INSERT INTO `sys_relation` VALUES (22720, 1308690277738774530, 1); |
| | | INSERT INTO `sys_relation` VALUES (22721, 1308690277738774531, 1); |
| | | INSERT INTO `sys_relation` VALUES (22722, 1308690277738774532, 1); |
| | | INSERT INTO `sys_relation` VALUES (22723, 1308690277738774533, 1); |
| | | INSERT INTO `sys_relation` VALUES (22724, 1308693386556923905, 1); |
| | | INSERT INTO `sys_relation` VALUES (22725, 1308693386556923906, 1); |
| | | INSERT INTO `sys_relation` VALUES (22726, 1308693386556923907, 1); |
| | | INSERT INTO `sys_relation` VALUES (22727, 1308693386556923908, 1); |
| | | INSERT INTO `sys_relation` VALUES (22728, 1308693386556923909, 1); |
| | | INSERT INTO `sys_relation` VALUES (22729, 1309014874136809494, 1); |
| | | INSERT INTO `sys_relation` VALUES (22730, 1309014874136809495, 1); |
| | | INSERT INTO `sys_relation` VALUES (22731, 1309014874136809496, 1); |
| | | INSERT INTO `sys_relation` VALUES (22732, 1309014874136809497, 1); |
| | | INSERT INTO `sys_relation` VALUES (22733, 1308693386556923910, 1); |
| | | INSERT INTO `sys_relation` VALUES (22734, 1308694555895324673, 1); |
| | | INSERT INTO `sys_relation` VALUES (22735, 1308694555895324674, 1); |
| | | INSERT INTO `sys_relation` VALUES (22736, 1308694555895324675, 1); |
| | | INSERT INTO `sys_relation` VALUES (22737, 1308694555895324676, 1); |
| | | INSERT INTO `sys_relation` VALUES (22738, 1308694555895324677, 1); |
| | | INSERT INTO `sys_relation` VALUES (22739, 1308694555895324678, 1); |
| | | INSERT INTO `sys_relation` VALUES (22740, 1308694555895324679, 1); |
| | | INSERT INTO `sys_relation` VALUES (22741, 1308698188288417793, 1); |
| | | INSERT INTO `sys_relation` VALUES (22742, 1308698188288417794, 1); |
| | | INSERT INTO `sys_relation` VALUES (22743, 1308698188288417795, 1); |
| | | INSERT INTO `sys_relation` VALUES (22744, 1308698188288417796, 1); |
| | | INSERT INTO `sys_relation` VALUES (22745, 1308698188288417797, 1); |
| | | INSERT INTO `sys_relation` VALUES (22746, 1308698188288417798, 1); |
| | | INSERT INTO `sys_relation` VALUES (22747, 1308698188288417799, 1); |
| | | INSERT INTO `sys_relation` VALUES (22748, 1308698188288417800, 1); |
| | | INSERT INTO `sys_relation` VALUES (22749, 1308698188288417801, 1); |
| | | INSERT INTO `sys_relation` VALUES (22750, 1308701049940402178, 1); |
| | | INSERT INTO `sys_relation` VALUES (22751, 1308701049940402179, 1); |
| | | INSERT INTO `sys_relation` VALUES (22752, 1308701049940402180, 1); |
| | | INSERT INTO `sys_relation` VALUES (22753, 1308701049940402181, 1); |
| | | INSERT INTO `sys_relation` VALUES (22754, 1308701049940402182, 1); |
| | | INSERT INTO `sys_relation` VALUES (22755, 1308702304670638081, 1); |
| | | INSERT INTO `sys_relation` VALUES (22756, 1308702304670638082, 1); |
| | | INSERT INTO `sys_relation` VALUES (22757, 1308702304670638083, 1); |
| | | INSERT INTO `sys_relation` VALUES (22758, 1308702304670638084, 1); |
| | | INSERT INTO `sys_relation` VALUES (22759, 1308702304670638085, 1); |
| | | INSERT INTO `sys_relation` VALUES (22760, 1309014874136809484, 1); |
| | | INSERT INTO `sys_relation` VALUES (22761, 1308939095893929990, 1); |
| | | INSERT INTO `sys_relation` VALUES (22762, 1308947296710344706, 1); |
| | | INSERT INTO `sys_relation` VALUES (22763, 1308947296710344707, 1); |
| | | INSERT INTO `sys_relation` VALUES (22764, 1308947296710344708, 1); |
| | | INSERT INTO `sys_relation` VALUES (22765, 1308947296710344709, 1); |
| | | INSERT INTO `sys_relation` VALUES (22766, 1308947296710344710, 1); |
| | | INSERT INTO `sys_relation` VALUES (22767, 1308947296710344711, 1); |
| | | INSERT INTO `sys_relation` VALUES (22768, 1308947296710344712, 1); |
| | | INSERT INTO `sys_relation` VALUES (22769, 1308947296710344713, 1); |
| | | INSERT INTO `sys_relation` VALUES (22770, 1308947296710344714, 1); |
| | | INSERT INTO `sys_relation` VALUES (22771, 1308952578060500993, 1); |
| | | INSERT INTO `sys_relation` VALUES (22772, 1308952578060500994, 1); |
| | | INSERT INTO `sys_relation` VALUES (22773, 1308952578060500995, 1); |
| | | INSERT INTO `sys_relation` VALUES (22774, 1308952578060500996, 1); |
| | | INSERT INTO `sys_relation` VALUES (22775, 1308952578060500997, 1); |
| | | INSERT INTO `sys_relation` VALUES (22776, 1308952578060500998, 1); |
| | | INSERT INTO `sys_relation` VALUES (22777, 1308952578060500999, 1); |
| | | INSERT INTO `sys_relation` VALUES (22778, 1308952578060501000, 1); |
| | | INSERT INTO `sys_relation` VALUES (22779, 1308956024717230081, 1); |
| | | INSERT INTO `sys_relation` VALUES (22780, 1308956024717230082, 1); |
| | | INSERT INTO `sys_relation` VALUES (22781, 1308956024717230083, 1); |
| | | INSERT INTO `sys_relation` VALUES (22782, 1308956024717230084, 1); |
| | | INSERT INTO `sys_relation` VALUES (22783, 1308956024717230085, 1); |
| | | INSERT INTO `sys_relation` VALUES (22784, 1308956024717230086, 1); |
| | | INSERT INTO `sys_relation` VALUES (22785, 1308956024717230087, 1); |
| | | INSERT INTO `sys_relation` VALUES (22786, 1308956024717230088, 1); |
| | | INSERT INTO `sys_relation` VALUES (22787, 1308958374009815041, 1); |
| | | INSERT INTO `sys_relation` VALUES (22788, 1308958374009815042, 1); |
| | | INSERT INTO `sys_relation` VALUES (22789, 1308958374009815043, 1); |
| | | INSERT INTO `sys_relation` VALUES (22790, 1308958374009815044, 1); |
| | | INSERT INTO `sys_relation` VALUES (22791, 1309014874136809489, 1); |
| | | INSERT INTO `sys_relation` VALUES (22792, 1309014874136809490, 1); |
| | | INSERT INTO `sys_relation` VALUES (22793, 1309014874136809491, 1); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for sys_role |