MrMix3r 1 Опубликовано 3 ноября, 2015 Нельзя создать русские ники пишет "Ник уже используеться" вот ошибка ГС [2015-11-03 10:00:15] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:00:40] INFO Tue Nov 03 10:00:40 EET 2015 Atk announce scheduled to 0.0 minute of this hour. [2015-11-03 10:01:03] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:08] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:09] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:26] INFO Olympiad System: Loaded 160 stadiums. [2015-11-03 10:01:28] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:29] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:29] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:43] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:44] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:45] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:45] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:45] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:01:45] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:02:37] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:02:37] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) [2015-11-03 10:02:37] ERROR Could not check existing charname: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846) at l2next.gameserver.engine.databaseengine.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20) at l2next.gameserver.datatables.sql.CharNameTable.doesCharNameExist(CharNameTable.java:205) at l2next.gameserver.network.game.clientpackets.RequestCharacterNameCreatable.runImpl(RequestCharacterNameCreatable.java:33) at l2next.gameserver.network.game.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:130) at l2next.gameserver.network.L2GameClient.run(L2GameClient.java:920) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Кастиэль 0 Опубликовано 8 ноября, 2015 latin1 стоит кодировка. На uft-8 поменяйте Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Staff 75 Опубликовано 8 ноября, 2015 (utf8_general_ci,COERCIBLE) for operation '=' Кодировку на utf-8 смени! Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты