80 lines
19 MiB
MySQL
80 lines
19 MiB
MySQL
|
-- MySQL dump 10.13 Distrib 8.0.26, for Win64 (x86_64)
|
|||
|
|
--
|
|||
|
|
-- Host: 121.48.165.167 Database: portal
|
|||
|
|
-- ------------------------------------------------------
|
|||
|
|
-- Server version 5.7.33-0ubuntu0.16.04.1
|
|||
|
|
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|||
|
|
/*!50503 SET NAMES utf8 */;
|
|||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `sys_log_error`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `sys_log_error`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `sys_log_error` (
|
|||
|
|
`id` bigint(20) NOT NULL COMMENT 'id',
|
|||
|
|
`module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模块名称，如：sys',
|
|||
|
|
`request_uri` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求URI',
|
|||
|
|
`request_method` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求方式',
|
|||
|
|
`request_params` text COLLATE utf8mb4_unicode_ci COMMENT '请求参数',
|
|||
|
|
`user_agent` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户代理',
|
|||
|
|
`ip` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作IP',
|
|||
|
|
`error_info` text COLLATE utf8mb4_unicode_ci COMMENT '异常信息',
|
|||
|
|
`creator` bigint(20) DEFAULT NULL COMMENT '创建者',
|
|||
|
|
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
KEY `idx_module` (`module`),
|
|||
|
|
KEY `idx_create_date` (`create_date`)
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='异常日志';
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping data for table `sys_log_error`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
LOCK TABLES `sys_log_error` WRITE;
|
|||
|
|
/*!40000 ALTER TABLE `sys_log_error` DISABLE KEYS */;
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437668881144688642,'sys','/sys/user','POST',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36','218.194.35.170','org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deserialize value of type `java.lang.Long` from String \"user\": not a valid Long value; nested exception is com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type `java.lang.Long` from String \"user\": not a valid Long value\n at [Source: (PushbackInputStream); line: 1, column: 225] (through reference chain: com.dkha.dto.SysUserDTO[\"roleIdList\"]->java.util.ArrayList[0])\n at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.readJavaType(AbstractJackson2HttpMessageConverter.java:245)\n at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.read(AbstractJackson2HttpMessageConverter.java:227)\n at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodArgumentResolver.readWithMessageConverters(AbstractMessageConverterMethodArgumentResolver.java:205)\n at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.readWithMessageConverters(RequestResponseBodyMethodProcessor.java:158)\n at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.resolveArgument(RequestResponseBodyMethodProcessor.java:131)\n at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)\n at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:167)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationF
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437793322830868481,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\",\"currentPage\":\"1 AND EXTRACTVALUE(6314,CONCAT(0x5c,0x7178766271,(SELECT (ELT(6314=6314,1))),0x7162707871))\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.validation.BindException: org.springframework.validation.BeanPropertyBindingResult: 1 errors\nField error in object \'searchQuery\' on field \'currentPage\': rejected value [1 AND EXTRACTVALUE(6314,CONCAT(0x5c,0x7178766271,(SELECT (ELT(6314=6314,1))),0x7162707871))]; codes [typeMismatch.searchQuery.currentPage,typeMismatch.currentPage,typeMismatch.java.lang.Integer,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [searchQuery.currentPage,currentPage]; arguments []; default message [currentPage]]; default message [Failed to convert property value of type \'java.lang.String\' to required type \'java.lang.Integer\' for property \'currentPage\'; nested exception is java.lang.NumberFormatException: For input string: \"1ANDEXTRACTVALUE(6314,CONCAT(0x5c,0x7178766271,(SELECT(ELT(6314=6314,1))),0x7162707871))\"]\n at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:164)\n at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)\n at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:167)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\n at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437793383069462530,'portal','/portal/article/search','GET','{\"pageSize\":\"10\';SELECT DBMS_PIPE.RECEIVE_MESSAGE(CHR(115)||CHR(112)||CHR(111)||CHR(67),5) FROM DUAL--\",\"keyword\":\"hh\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.validation.BindException: org.springframework.validation.BeanPropertyBindingResult: 1 errors\nField error in object \'searchQuery\' on field \'pageSize\': rejected value [10\';SELECT DBMS_PIPE.RECEIVE_MESSAGE(CHR(115)||CHR(112)||CHR(111)||CHR(67),5) FROM DUAL--]; codes [typeMismatch.searchQuery.pageSize,typeMismatch.pageSize,typeMismatch.java.lang.Integer,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [searchQuery.pageSize,pageSize]; arguments []; default message [pageSize]]; default message [Failed to convert property value of type \'java.lang.String\' to required type \'java.lang.Integer\' for property \'pageSize\'; nested exception is java.lang.NumberFormatException: For input string: \"10\';SELECTDBMS_PIPE.RECEIVE_MESSAGE(CHR(115)||CHR(112)||CHR(111)||CHR(67),5)FROMDUAL--\"]\n at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:164)\n at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)\n at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:167)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\n at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at or
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794445314699266,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\' or content like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\' or content like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\' or content like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\' or content like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\' or content like \'%hh%\' AND 4209=(SELECT (CASE WHEN (4209=4131) THEN 4209 ELSE (SELECT 4131 UNION SELECT 6203) END))-- crxV%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at j
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794456278609921,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\' or content like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\' or content like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\' or content like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\' or content like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\' or content like \'%hh\' AND MAKE_SET(7513=2885,2885) AND \'riYB\'=\'riYB%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInte
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794508678049793,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\' or content like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\' or content like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\' or content like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\' or content like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\' or content like \'%hh\',(SELECT (CASE WHEN (4014=4014) THEN 1 ELSE 4014*(SELECT 4014 FROM INFORMATION_SCHEMA.PLUGINS) END))-- kXdw%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMeth
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794518874402818,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\' or content like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\' or content like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\' or content like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\' or content like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, part alway false condition not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\' or content like \'%hh%\' AND (SELECT 4927 FROM(SELECT COUNT(*),CONCAT(0x717a707871,(SELECT (ELT(4927=4927,1))),0x71626a6a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND \'fdBH%\'=\'fdBH%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.sp
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794571240288257,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'itle like \'%hh\')) AND 6684=CONVERT(\', expect RPAREN, actual RPAREN pos 82, line 1, column 82, token RPAREN : select title, content, path, update_time from tb_article where (title like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\' or content like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\' or content like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'itle like \'%hh\')) AND 6684=CONVERT(\', expect RPAREN, actual RPAREN pos 82, line 1, column 82, token RPAREN : select title, content, path, update_time from tb_article where (title like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\' or content like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :\'itle like \'%hh\')) AND 6684=CONVERT(\', expect RPAREN, actual RPAREN pos 82, line 1, column 82, token RPAREN : select title, content, path, update_time from tb_article where (title like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\' or content like \'%hh\')) AND 6684=CONVERT(INT,(SELECT CHAR(113)+CHAR(122)+CHAR(112)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (6684=6684) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(106)+CHAR(106)+CHAR(113))) AND ((\'oeKM\'=\'oeKM%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'itle like \'%hh\')) AND 6684=CONVERT(\', expect RPAREN, actual RPAREN pos 82, line 1, column 82, token RPAREN : select title, content, path, update_time from tb_article
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794581612802050,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, const case condition : select title, content, path, update_time from tb_article where (title like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\' or content like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\' or content like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, const case condition : select title, content, path, update_time from tb_article where (title like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\' or content like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, const case condition : select title, content, path, update_time from tb_article where (title like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\' or content like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, const case condition : select title, content, path, update_time from tb_article where (title like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\' or content like \'%hh\') AND 3920=(\'qzpxq\'||(SELECT CASE 3920 WHEN 3920 THEN 1 ELSE 0 END FROM RDB$DATABASE)||\'qbjjq\') AND (\'dwVF\' LIKE \'dwVF%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.M
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794633349541889,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: TODO. pos 99, line 1, column 92, token IDENTIFIER ANALYSE : select title, content, path, update_time from tb_article where (title like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\' or content like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\' or content like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: TODO. pos 99, line 1, column 92, token IDENTIFIER ANALYSE : select title, content, path, update_time from tb_article where (title like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\' or content like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: TODO. pos 99, line 1, column 92, token IDENTIFIER ANALYSE : select title, content, path, update_time from tb_article where (title like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\' or content like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: TODO. pos 99, line 1, column 92, token IDENTIFIER ANALYSE : select title, content, path, update_time from tb_article where (title like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\' or content like \'%hh\') PROCEDURE ANALYSE(EXTRACTVALUE(9135,CONCAT(0x5c,0x717a707871,(SELECT (CASE WHEN (9135=9135) THEN 1 ELSE 0 END)),0x71626a6a71)),1) AND (\'mWRq\' LIKE \'mWRq%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.tran
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794644565110786,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\\\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: error : pos 151, line 1, column 151, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\' or content like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\' or content like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: error : pos 151, line 1, column 151, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\' or content like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: error : pos 151, line 1, column 151, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\' or content like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: error : pos 151, line 1, column 151, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\' or content like \'%hh\"));CREATE OR REPLACE FUNCTION SLEEP(int) RETURNS int AS \'/lib/libc.so.6\',\'sleep\' language \'C\' STRICT; SELECT sleep(5)--%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMeth
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794696889053186,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\' or content like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\' or content like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\' or content like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\' or content like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, comment not allow : select title, content, path, update_time from tb_article where (title like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\' or content like \'%hh%\' AND (SELECT 4929 FROM (SELECT(SLEEP(5)))qrPO)#%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.pro
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794749879889921,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual LITERAL_INT pos 97, line 1, column 97, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\' or content like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\' or content like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual LITERAL_INT pos 97, line 1, column 97, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\' or content like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, expect RPAREN, actual LITERAL_INT pos 97, line 1, column 97, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\' or content like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual LITERAL_INT pos 97, line 1, column 97, token LITERAL_INT : select title, content, path, update_time from tb_article where (title like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\' or content like \'%hh) WAITFOR DELAY \'0:0:5\' AND (8375=8375%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794761405837313,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"-4999\' ORDER BY 1#\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual ORDER pos 89, line 1, column 84, token ORDER : select title, content, path, update_time from tb_article where (title like \'%-4999\' ORDER BY 1#%\' or content like \'%-4999\' ORDER BY 1#%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%-4999\' ORDER BY 1#%\' or content like \'%-4999\' ORDER BY 1#%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual ORDER pos 89, line 1, column 84, token ORDER : select title, content, path, update_time from tb_article where (title like \'%-4999\' ORDER BY 1#%\' or content like \'%-4999\' ORDER BY 1#%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, expect RPAREN, actual ORDER pos 89, line 1, column 84, token ORDER : select title, content, path, update_time from tb_article where (title like \'%-4999\' ORDER BY 1#%\' or content like \'%-4999\' ORDER BY 1#%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual ORDER pos 89, line 1, column 84, token ORDER : select title, content, path, update_time from tb_article where (title like \'%-4999\' ORDER BY 1#%\' or content like \'%-4999\' ORDER BY 1#%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.spri
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794823561228290,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\",\"currentPage\":\"1\') AND 6939=1457#\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.validation.BindException: org.springframework.validation.BeanPropertyBindingResult: 1 errors\nField error in object \'searchQuery\' on field \'currentPage\': rejected value [1\') AND 6939=1457#]; codes [typeMismatch.searchQuery.currentPage,typeMismatch.currentPage,typeMismatch.java.lang.Integer,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [searchQuery.currentPage,currentPage]; arguments []; default message [currentPage]]; default message [Failed to convert property value of type \'java.lang.String\' to required type \'java.lang.Integer\' for property \'currentPage\'; nested exception is java.lang.NumberFormatException: For input string: \"1\')AND6939=1457#\"]\n at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:164)\n at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)\n at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:167)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\n at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(F
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437794886031192065,'portal','/portal/article/search','GET','{\"pageSize\":\"10\",\"keyword\":\"hh\",\"currentPage\":\"1\' AND MAKE_SET(9520=4838,4838) AND \'jQPV\'=\'jQPV\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.validation.BindException: org.springframework.validation.BeanPropertyBindingResult: 1 errors\nField error in object \'searchQuery\' on field \'currentPage\': rejected value [1\' AND MAKE_SET(9520=4838,4838) AND \'jQPV\'=\'jQPV]; codes [typeMismatch.searchQuery.currentPage,typeMismatch.currentPage,typeMismatch.java.lang.Integer,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [searchQuery.currentPage,currentPage]; arguments []; default message [currentPage]]; default message [Failed to convert property value of type \'java.lang.String\' to required type \'java.lang.Integer\' for property \'currentPage\'; nested exception is java.lang.NumberFormatException: For input string: \"1\'ANDMAKE_SET(9520=4838,4838)AND\'jQPV\'=\'jQPV\"]\n at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:164)\n at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)\n at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:167)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\n at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\n at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilt
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1437797376877342721,'portal','/portal/article/search','GET','{\"pageSize\":\"100\",\"keyword\":\"1\' anandd \'1\'=\'1\",\"currentPage\":\"1\"}','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36','127.0.0.1','org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 86, line 1, column 80, token IDENTIFIER anandd : select title, content, path, update_time from tb_article where (title like \'%1\' anandd \'1\'=\'1%\' or content like \'%1\' anandd \'1\'=\'1%\') and is_deleted = 0 and is_history = 0\n### The error may exist in com/dkha/dao/IArticleDao.java (best guess)\n### The error may involve com.dkha.dao.IArticleDao.searchArticle\n### The error occurred while executing a query\n### SQL: select title, content, path, update_time from tb_article where (title like \'%1\' anandd \'1\'=\'1%\' or content like \'%1\' anandd \'1\'=\'1%\') and is_deleted = 0 and is_history = 0\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 86, line 1, column 80, token IDENTIFIER anandd : select title, content, path, update_time from tb_article where (title like \'%1\' anandd \'1\'=\'1%\' or content like \'%1\' anandd \'1\'=\'1%\') and is_deleted = 0 and is_history = 0\n; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 86, line 1, column 80, token IDENTIFIER anandd : select title, content, path, update_time from tb_article where (title like \'%1\' anandd \'1\'=\'1%\' or content like \'%1\' anandd \'1\'=\'1%\') and is_deleted = 0 and is_history = 0; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 86, line 1, column 80, token IDENTIFIER anandd : select title, content, path, update_time from tb_article where (title like \'%1\' anandd \'1\'=\'1%\' or content like \'%1\' anandd \'1\'=\'1%\') and is_deleted = 0 and is_history = 0\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy153.selectList(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy162.searchArticle(Unknown Source)\n at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)\n at org.springframework.aop.framework.Refle
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1441066076103299074,'portal','/portal/module','GET',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36','127.0.0.1','java.lang.NullPointerException\r\n at com.dkha.service.impl.ModuleServiceImpl.dealTo1ModuleDtos(ModuleServiceImpl.java:24)\r\n at com.dkha.service.impl.ModuleServiceImpl.dealTo1ModuleDtos(ModuleServiceImpl.java:25)\r\n at com.dkha.service.impl.ModuleServiceImpl.queryDtoList(ModuleServiceImpl.java:35)\r\n at com.dkha.controller.ModuleController.allModules(ModuleController.java:26)\r\n at sun.reflect.GeneratedMethodAccessor185.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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\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:1040)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)\r\n at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)\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:53)\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.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)\r\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)\r\n at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)\r\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\r\n at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118)\r\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\r\n at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)\r\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\r\n at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)\r\n at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)\r\n at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158)\r\n at org.springframework.security.web.FilterChainProxy
|
|||
|
|
INSERT INTO `sys_log_error` VALUES (1441252221651238913,'portal','/portal/module/insert','POST',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36','127.0.0.1','org.springframework.dao.DataIntegrityViolationException: \n### Error updating database. Cause: java.sql.SQLException: Field \'route_name\' doesn\'t have a default value\n### The error may exist in com/dkha/dao/IModuleDao.java (best guess)\n### The error may involve com.dkha.dao.IModuleDao.insert-Inline\n### The error occurred while setting parameters\n### SQL: insert into tb_module(name, path, priority, status, parent_id) values (?, ?, ?, ?, ?)\n### Cause: java.sql.SQLException: Field \'route_name\' doesn\'t have a default value\n; Field \'route_name\' doesn\'t have a default value; nested exception is java.sql.SQLException: Field \'route_name\' doesn\'t have a default value\n at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)\n at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)\n at com.sun.proxy.$Proxy154.insert(Unknown Source)\n at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)\n at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)\n at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)\n at com.sun.proxy.$Proxy161.insert(Unknown Source)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy162.insert(Unknown Source)\n at com.dkha.service.impl.ModuleServiceImpl.insertInfo(ModuleServiceImpl.java:71)\n at com.dkha.controller.ModuleController.insert(ModuleController.java:50)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.lang.reflect.Method.invoke(Method.java:498)\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)\n at org.springframework.web.servlet.DispatcherServlet.doDispatch
|
|||
|
|
/*!40000 ALTER TABLE `sys_log_error` ENABLE KEYS */;
|
|||
|
|
UNLOCK TABLES;
|
|||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|||
|
|
|
|||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|||
|
|
|
|||
|
|
-- Dump completed on 2021-12-13 19:22:09
|