12-22-2010, 05:15 PM
вот такая ошибка
я в таблице олимпа поставил на колонку чарнейм вместо latin utf8
как исправить кто подскажет?
Код:
16:50:48.179 FourSepulchersManager: Entry time: Wed Dec 22 16:55:48 YEKT 2010
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:1072)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2261)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at l2p.database.FiltredPreparedStatement.executeQuery(FiltredPreparedStatement.java:20)
at l2p.gameserver.communitybbs.Manager.TeleportBBSManager.AddTp(TeleportBBSManager.java:244)
at l2p.gameserver.communitybbs.Manager.TeleportBBSManager.parsecmd(TeleportBBSManager.java:69)
at l2p.gameserver.communitybbs.CommunityBoard.handleCommands(CommunityBoard.java:99)
at l2p.gameserver.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:51)
at l2p.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:47)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
17:50:48.211 FourSepulchersManager: Entry time: Wed Dec 22 17:55:48 YEKT 2010
18:00:50.263 Olympiad System: Olympiad Game Started
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at l2p.util.GCSArray.RangeCheck(GCSArray.java:210)
at l2p.util.GCSArray.remove(GCSArray.java:118)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.nextOpponents(OlympiadManager.java:164)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.prepareBattles(OlympiadManager.java:100)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.run(OlympiadManager.java:44)
at java.lang.Thread.run(Unknown Source)
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at l2p.util.GCSArray.RangeCheck(GCSArray.java:210)
at l2p.util.GCSArray.remove(GCSArray.java:118)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.nextOpponents(OlympiadManager.java:164)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.prepareBattles(OlympiadManager.java:100)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.run(OlympiadManager.java:44)
at java.lang.Thread.run(Unknown Source)
18:50:48.243 FourSepulchersManager: Entry time: Wed Dec 22 18:55:48 YEKT 2010
java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
at l2p.util.GCSArray.RangeCheck(GCSArray.java:210)
at l2p.util.GCSArray.remove(GCSArray.java:118)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.nextOpponents(OlympiadManager.java:164)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.prepareBattles(OlympiadManager.java:100)
at l2p.gameserver.model.entity.olympiad.OlympiadManager.run(OlympiadManager.java:44)
at java.lang.Thread.run(Unknown Source)
как исправить кто подскажет?