| ERROR | org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist ### The error may exist in file [/home/newyongsan/www/WEB-INF/classes/egovframework/sqlmap/mysql/com/ecms/sql-archive.xml] ### The error may involve egovframework.com.ecms.archive.service.ArchiveMapper.selectArchiveCategoryByCatSlug-Inline ### The error occurred while setting parameters ### SQL: SELECT CAT_ID , CAT_NAME , CAT_SLUG , CAT_TEMPLATE , CAT_VIEW_TEMPLATE , CAT_ADMIN_LIST_SKIN , CAT_ADMIN_FORM_SKIN , CAT_CUSTOM_TYPE , CAT_PAGE_SIZE , CAT_META_CODE_1 , CAT_META_CODE_2 , CAT_META_CODE_3 , CAT_SORT_ORDER , CAT_SORT_DIRECTION , CAT_FORCE_NAME , ( SELECT COUNT(*) FROM ECMS_ARCHIVE_CATEGORY_REL WHERE CAT_ID = AC.CAT_ID ) AS CAT_ARCHIVE_COUNT FROM ECMS_ARCHIVE_CATEGORY AC WHERE CAT_SLUG = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist |
|---|---|
| MESSAGE | ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist ### The error may exist in file [/home/newyongsan/www/WEB-INF/classes/egovframework/sqlmap/mysql/com/ecms/sql-archive.xml] ### The error may involve egovframework.com.ecms.archive.service.ArchiveMapper.selectArchiveCategoryByCatSlug-Inline ### The error occurred while setting parameters ### SQL: SELECT CAT_ID , CAT_NAME , CAT_SLUG , CAT_TEMPLATE , CAT_VIEW_TEMPLATE , CAT_ADMIN_LIST_SKIN , CAT_ADMIN_FORM_SKIN , CAT_CUSTOM_TYPE , CAT_PAGE_SIZE , CAT_META_CODE_1 , CAT_META_CODE_2 , CAT_META_CODE_3 , CAT_SORT_ORDER , CAT_SORT_DIRECTION , CAT_FORCE_NAME , ( SELECT COUNT(*) FROM ECMS_ARCHIVE_CATEGORY_REL WHERE CAT_ID = AC.CAT_ID ) AS CAT_ARCHIVE_COUNT FROM ECMS_ARCHIVE_CATEGORY AC WHERE CAT_SLUG = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.ECMS_ARCHIVE_CATEGORY' doesn't exist |
| REQUEST_URI | /site/main/archive/post/category/%EC%88%98%EC%9D%98%EA%B3%84%EC%95%BD%EB%82%B4%EC%97%AD%EA%B3%B5%EA%B0%9C |
| STATUS_CODE | 200 |
| STACKTRACE |
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) com.sun.proxy.$Proxy97.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) com.sun.proxy.$Proxy106.selectArchiveCategoryByCatSlug(Unknown Source) egovframework.com.ecms.archive.service.impl.ArchiveServiceImpl.getArchiveCategoryByCatSlug(ArchiveServiceImpl.java:252) egovframework.com.ecms.archive.customtype.post.web.PostUserController.postCategoryGet(PostUserController.java:227) sun.reflect.GeneratedMethodAccessor756.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) javax.servlet.http.HttpServlet.service_whxwt___internal_javax_servlet_http_HttpServlet(HttpServlet.java:626) javax.servlet.http.HttpServlet.service(HttpServlet.java) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) javax.servlet.http.HttpServlet.service_whxwt___internal_javax_servlet_http_HttpServlet(HttpServlet.java:733) javax.servlet.http.HttpServlet.service(HttpServlet.java) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) egovframework.com.ecms.support.filter.XSSFilter.doFilter(XSSFilter.java:40) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198) net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:126) org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:64) org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:101) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:119) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter_whxwt___internal_org_apache_catalina_core_ApplicationFilterChain(ApplicationFilterChain.java:166) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:525) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:748) |