Delta Virtual Airlines

  • Our Airline
    • Home
    • Login
    • NOTAMs
    • Airline News
    • Fleet Gallery
    • Image Gallery
    • Delta FLY!
    • Online Flights
    • Logged In Users
    • Our Partners
    • Issue Tracker
  • Pilot's Lounge
    • Academy Graduates
    • Online Events
    • Flight Tours
    • Water Cooler
  • Our People
    • Join Us
    • Pilot Roster
    • Pilot Locations
    • View Logbooks
    • Pilot Accomplishments
    • Century Club
  • ACARS
    • Live ACARS Map
    • Google Earth
    • ACARS Flights
    • Dispatch Schedule
    • Top Dispatchers
  • Statistics
    • Airline Totals
    • Flight Statistics
    • Online Statistics
    • Simulator Versions
    • Passenger Statistics
    • Landing Statistics
    • Optimal Landings
    • Challenging Runways
    • Server Statistics
  • Contact Us
    • Corporate Offices
    • Our Staff
    • Password Reset
    • Privacy Policy
    • Career Opportunities
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
Airlines Air France Virtual, Delta Virtual Airlines
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.
 
Progress Spinner

Delta Virtual Airlines 2006 (Golgotha v12.4) Copyright © 2004 - 2026 Global Virtual Airlines Group. All Rights Reserved. (Build 993.1)
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.