MySQLSyntaxErrorException 解决方法
[ERROR 2009-08-09 20:19:06] mysql5.MySQL5GameTimeDAO:49 - Error loading last saved server time
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ae_server_gs.server_variables' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mysql5.MySQL5GameTimeDAO.load(MySQL5GameTimeDAO.java from JavaSourceFromFile:43)
at com.aionemu.gameserver.utils.gametime.GameTimeManager.<clinit>(GameTimeManager.java:38)
at com.aionemu.gameserver.GameServer.main(GameServer.java:88)
一般出现这个情况是数据库中少表,可以导入新的SQL Table 'ae_server_gs.server_variables' doesn't exist
