ERROR | org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' 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.selectArchiveByArcId-Inline ### The error occurred while setting parameters ### SQL: SELECT AR.ARC_ID , AR.ARC_CUSTOM_TYPE , AR.ARC_TITLE , AR.ARC_SLUG , AR.ARC_TEMPLATE , AR.ARC_CONTENT_HTML , AR.ARC_PLAIN_TEXT , AR.ARC_EXCERPT , AR.ARC_CREATED , AR.ARC_LAST_UPDATED , AR.ARC_STATUS , AR.THUMB_FILE_ID , AR.ARC_HIT , AR.ARC_RECOMMEND , AR.ARC_SUPPORT_COMMENT , AR.ARC_META_CODE_1 , AR.ARC_META_CODE_2 , AR.ARC_META_CODE_3 , AR.ARC_SUB_TEXT , AR.ARC_NURI , AR.ARC_COMMENT_TOTAL , AR.ARC_FAQ_CATEGORY , AR.ARC_RECRUIT_START_DATE , AR.ARC_RECRUIT_END_DATE , AR.ARC_VIDEO_CATEGORY , AR.ARC_VIDEO_YOUTUBE_LINK , AR.ARC_OFFICIAL_ANNOUNCEMENT_ID , ? AS SITE_PREFIX , ME.MEM_ID , ME.MEM_PASSWORD , ME.MEM_LAST_NAME , ME.MEM_FIRST_NAME , ME.MEM_NAME , ME.MEM_ACTIVE , ME.MEM_EMAIL , ME.MEM_REGDATE , ME.MEM_ROLE , ME.MEM_LEVEL , ME.MEM_TEL1 , ME.MEM_TEL2 , ME.MEM_TEL3 , ME.MEM_MOBILE1 , ME.MEM_MOBILE2 , ME.MEM_MOBILE3 , ME.MEM_DUP_INFO , ME.MEM_MAILING , ME.MEM_SMS , ME.MEM_SIGN_UP_KEY , ME.MEM_SIGN_UP_KEY_CHECKED , ME.MEM_LAST_LOGIN_DATE , ME.MEM_TEL , ME.MEM_MOBILE , ME.MEM_GENDER , ME.MEM_BIRTHDAY , ME.MEM_BIRTHDAY_SOLAR , ME.MEM_ORGANIZATION , ME.MEM_DEPARTMENT , ME.MEM_POSITION , ME.MEM_FAX , ME.MEM_ADDRESS , ME.MEM_ADDRESS_SUB , ME.MEM_CITY_STATE , ME.MEM_COUNTRY , ME.MEM_ZIP_CODE , ME.MEM_SNS , ME.MEM_SNS_ID , ME.MEM_SNS_HOME , ME.TERM_CHECK_DATE , ME.TERM_CHECK_EMAIL_SENDED , ME.MEM_PW_LAST_UPDATED , FI.FILE_ID , FI.MEMBER_ID , FI.FILE_MODULE , FI.FILE_MODULE_ID , FI.FILE_MODULE_SUB , FI.FILE_MODULE_SUB_ID , FI.FILE_ORIGINAL_NAME , FI.FILE_PATH , FI.FILE_THUMBNAIL_PATH , FI.FILE_EXT , FI.FILE_MIME_TYPE , FI.FILE_MEDIA_TYPE , FI.FILE_SIZE , FI.FILE_REGDATE , FI.FILE_ALT_TEXT , FI.FILE_DOWNLOAD_COUNT , FI.FILE_UUID , FI.FILE_ORI_IMAGE_WIDTH , FI.FILE_ORI_IMAGE_HEIGHT FROM DREAM_ARCHIVE AR LEFT OUTER JOIN ECMS_MEMBER ME ON AR.MEM_ID = ME.MEM_ID LEFT OUTER JOIN DREAM_FILEINFO FI ON AR.THUMB_FILE_ID = FI.FILE_ID WHERE AR.ARC_ID = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' doesn't exist |
---|---|
MESSAGE | ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' 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.selectArchiveByArcId-Inline ### The error occurred while setting parameters ### SQL: SELECT AR.ARC_ID , AR.ARC_CUSTOM_TYPE , AR.ARC_TITLE , AR.ARC_SLUG , AR.ARC_TEMPLATE , AR.ARC_CONTENT_HTML , AR.ARC_PLAIN_TEXT , AR.ARC_EXCERPT , AR.ARC_CREATED , AR.ARC_LAST_UPDATED , AR.ARC_STATUS , AR.THUMB_FILE_ID , AR.ARC_HIT , AR.ARC_RECOMMEND , AR.ARC_SUPPORT_COMMENT , AR.ARC_META_CODE_1 , AR.ARC_META_CODE_2 , AR.ARC_META_CODE_3 , AR.ARC_SUB_TEXT , AR.ARC_NURI , AR.ARC_COMMENT_TOTAL , AR.ARC_FAQ_CATEGORY , AR.ARC_RECRUIT_START_DATE , AR.ARC_RECRUIT_END_DATE , AR.ARC_VIDEO_CATEGORY , AR.ARC_VIDEO_YOUTUBE_LINK , AR.ARC_OFFICIAL_ANNOUNCEMENT_ID , ? AS SITE_PREFIX , ME.MEM_ID , ME.MEM_PASSWORD , ME.MEM_LAST_NAME , ME.MEM_FIRST_NAME , ME.MEM_NAME , ME.MEM_ACTIVE , ME.MEM_EMAIL , ME.MEM_REGDATE , ME.MEM_ROLE , ME.MEM_LEVEL , ME.MEM_TEL1 , ME.MEM_TEL2 , ME.MEM_TEL3 , ME.MEM_MOBILE1 , ME.MEM_MOBILE2 , ME.MEM_MOBILE3 , ME.MEM_DUP_INFO , ME.MEM_MAILING , ME.MEM_SMS , ME.MEM_SIGN_UP_KEY , ME.MEM_SIGN_UP_KEY_CHECKED , ME.MEM_LAST_LOGIN_DATE , ME.MEM_TEL , ME.MEM_MOBILE , ME.MEM_GENDER , ME.MEM_BIRTHDAY , ME.MEM_BIRTHDAY_SOLAR , ME.MEM_ORGANIZATION , ME.MEM_DEPARTMENT , ME.MEM_POSITION , ME.MEM_FAX , ME.MEM_ADDRESS , ME.MEM_ADDRESS_SUB , ME.MEM_CITY_STATE , ME.MEM_COUNTRY , ME.MEM_ZIP_CODE , ME.MEM_SNS , ME.MEM_SNS_ID , ME.MEM_SNS_HOME , ME.TERM_CHECK_DATE , ME.TERM_CHECK_EMAIL_SENDED , ME.MEM_PW_LAST_UPDATED , FI.FILE_ID , FI.MEMBER_ID , FI.FILE_MODULE , FI.FILE_MODULE_ID , FI.FILE_MODULE_SUB , FI.FILE_MODULE_SUB_ID , FI.FILE_ORIGINAL_NAME , FI.FILE_PATH , FI.FILE_THUMBNAIL_PATH , FI.FILE_EXT , FI.FILE_MIME_TYPE , FI.FILE_MEDIA_TYPE , FI.FILE_SIZE , FI.FILE_REGDATE , FI.FILE_ALT_TEXT , FI.FILE_DOWNLOAD_COUNT , FI.FILE_UUID , FI.FILE_ORI_IMAGE_WIDTH , FI.FILE_ORI_IMAGE_HEIGHT FROM DREAM_ARCHIVE AR LEFT OUTER JOIN ECMS_MEMBER ME ON AR.MEM_ID = ME.MEM_ID LEFT OUTER JOIN DREAM_FILEINFO FI ON AR.THUMB_FILE_ID = FI.FILE_ID WHERE AR.ARC_ID = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'newyongsan.DREAM_ARCHIVE' doesn't exist |
REQUEST_URI | /site/dream/archive/post/%EB%AC%B8%ED%99%94%EC%9D%98%EC%A7%91-2022%EB%85%84-%EC%B2%AD%EC%86%8C%EB%85%84-%EB%9E%9C%EC%84%A0-%EB%B2%84%EC%8A%A4%ED%82%B9-in-%EC%9A%A9%EC%82%B0-%EA%B2%B0%EA%B3%BC%EB%B0%9C%ED%91%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.selectArchiveByArcId(Unknown Source) egovframework.com.ecms.archive.service.impl.ArchiveServiceImpl.getArchiveByArcSlug(ArchiveServiceImpl.java:80) egovframework.com.ecms.menu.service.impl.MenuServiceImpl.parseMenuInformationFromUrl(MenuServiceImpl.java:888) egovframework.com.ecms.interceptor.DesignInterceptor.preHandle(DesignInterceptor.java:96) org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:148) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1055) 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) 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) |