DEVELOPMENT ISSUE #7 - Posts still fail
Reported by Anthony Piasecki (DVA950) on 07/04/2005 21:44 ET
Assigned To Luke Kolin (DVA043)
Issue Status Fixed on 07/07/2005 21:32 ET
Issue Priority Medium
Security Public
Area Web Site
Issue Type Bug
Target Version 1.0
Issue Description Oops. Something bad happened. Really, really bad. This is the message:


Table 'dva.COOLER_POSTS' doesn't exist - org.deltava.dao.DAOException

This is the stack trace:

org.deltava.dao.DAOException: Table 'dva.COOLER_POSTS' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1957)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1880)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741)
at org.deltava.dao.DAO.executeUpdate(DAO.java:154)
at org.deltava.dao.SetCoolerMessage.writeMessage(SetCoolerMessage.java:41)
at org.deltava.commands.cooler.ThreadReplyCommand.execute(ThreadReplyCommand.java:65)
at org.deltava.servlet.CommandServlet.doGet(CommandServlet.java:132)
at org.deltava.servlet.CommandServlet.doPost(CommandServlet.java:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.deltava.servlet.filter.RequestWrapperFilter.doFilter(RequestWrapperFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.deltava.servlet.filter.SecurityCookieFilter.doFilter(SecurityCookieFilter.java:137)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.deltava.servlet.filter.FileUploadFilter.doFilter(FileUploadFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.deltava.servlet.filter.BrowserTypeFilter.doFilter(BrowserTypeFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Table 'dva.COOLER_POSTS' doesn't exist
... 54 more



--------------------------------------------------------------------------------
DVA2006 (Golgotha v1.0) Copyright © 2005 Luke J. Kolin. All Rights Reserved. (Build 3)
6 ISSUE COMMENTS
Luke Kolin (DVA043)
07/05/2005 00:02 ET		 Thanks for the heads-up. I'll see if I can fix that in the code release tomorrow.
Luke Kolin (DVA043)
07/05/2005 00:12 ET		 Looks like the DAO is not prefacing the database name in front of the table.
Luke Kolin (DVA043)
07/05/2005 10:15 ET		 I have fixed the code and pushed it, but not tested it yet.
Luke Kolin (DVA043)
07/05/2005 21:17 ET		 SyncThread is still failing - I think there's a typo with DEC instead of DESC.
Luke Kolin (DVA043)
07/07/2005 00:29 ET		 Now it's erroring out with updateThread.jsp not found.
Luke Kolin (DVA043)
07/07/2005 14:31 ET		 JSP named incorrectly in ThreadReplyCommand.
 

Delta Virtual Airlines 2006 (Golgotha v5.1) Copyright © 2004 - 2013 Global Virtual Airlines Group. All Rights Reserved. (Build 446)
For flight simulation purposes only. Not a commercial website. In no way are we affiliated with Delta Air Lines, its affiliates, or any other airline. All logos, images, and trademarks remain the property of their respective owners. Delta Virtual Airlines is a non-profit entity engaged in providing an avenue for flight simulation enthusiasts.