Тема: accounts (FIXED)
Показать сообщение отдельно
Старый 04.02.2015, 17:45   #1
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию accounts (FIXED)

[16:57:42] INFO =================================================
[16:57:42] INFO Project Revision: ........ L2s [14244]
[16:57:42] INFO Build Revision: .......... 4076
[16:57:42] INFO Update: .................. Epic Tale of Aden: Ertheia
[16:57:42] INFO Build date: .............. 2015.01.27 17:59
[16:57:42] INFO Compiler version: ........ 1.7.0_71-b14 (Oracle Corporation)
[16:57:42] INFO =================================================

если в конфиге прописать

#Ban account if switches too many times (player on player login, make character to force disconnect), Disable = -1 (Retail should be enabled, but numbers are unknown)
#BanAccountIfExceedManyTimesCount = -1
BanAccountIfExceedManyTimesCount = 3

на линдвиоре все норм

таблица accounts находится в другой базе

3-5 ошибок в день

Код:
[17:31:10]  INFO Character KissMyAss bought 1 of 19574 igridients: Id: 19574 count: 1
[17:31:13]  INFO | eared | null | 94.20.219.203 | 8 |
[17:31:13]  INFO bad statement
[17:31:13] ERROR 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsertheia.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setTimesSwiched(GameClient.java:530)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:504)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    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:745)
[17:31:13] ERROR 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gsertheia.accounts' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at l2s.gameserver.network.l2.GameClient.updLogin(GameClient.java:610)
    at l2s.gameserver.network.l2.GameClient.setFirstAcoountSwitch(GameClient.java:591)
    at l2s.gameserver.network.l2.GameClient.checkTimesToSwitchAccounts(GameClient.java:505)
    at l2s.gameserver.network.authcomm.as2gs.PlayerAuthResponse.runImpl(PlayerAuthResponse.java:85)
    at l2s.gameserver.network.authcomm.ReceivablePacket.run(ReceivablePacket.java:43)
    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:745)
[17:31:34]  INFO Character KissMyAss bought 1 of 30193 igridients: Id: 30193 count: 1
[17:31:45]  INFO Character Огурец bought 300 of 37607 ingridients: ID: 37607 count: 1
l2gold вне форума