L2J Server

Code: Select all

 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	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:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	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:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	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:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character. 

Code: Select all

CREATE TABLE IF NOT EXISTS `character_instance_time` (  `charId` INT UNSIGNED NOT NULL DEFAULT '0',  `instanceId` int(3) NOT NULL DEFAULT '0',  `time` decimal(20) NOT NULL DEFAULT '0',  PRIMARY KEY (`charId`,`instanceId`));