BlackDeath 0 Опубликовано 30 декабря, 2012 (изменено) Не запускается гейм сервер l2nextgen, выдаёт вот такую ошибочку (смотрим ниже), я думаю что ошибка может быть в базе данных. Желаюшие помогите с решением. Есть исходники (реву не знаю). Спасибо за рание. И с наступающим!!! 22:29:29.320 Loading gameserver config. 22:29:29.341 Loading: ./config/gameserver.ini. 22:29:29.360 Loading: ./config/developer.ini. 22:29:29.361 Loading: ./config/fame.ini. 22:29:29.361 Loading: ./config/gameserver.ini. 22:29:29.448 Loading: ./config/clan.ini. 22:29:29.451 Loading: ./config/residence.ini. 22:29:29.452 Loading: ./config/game_telnet.ini. 22:29:29.452 Loading: ./config/rate.ini. 22:29:29.454 Loading: ./config/wedding.ini. 22:29:29.454 Loading: ./config/lottery.ini. 22:29:29.456 Loading: ./config/walker.ini. 22:29:29.456 Loading: ./config/chat.ini. 22:29:29.457 Loading: ./config/other.ini. 22:29:29.458 Loading: ./config/spoil.ini. 22:29:29.458 Loading: ./config/commands.ini. 22:29:29.459 Loading: ./config/manor.ini. 22:29:29.460 Loading: ./config/alternative.ini. 22:29:29.462 Loading: ./config/vitality.ini. 22:29:29.463 Loading: ./config/boss.ini. 22:29:29.464 Loading: ./config/olympiad_option.ini. 22:29:29.464 Loading: ./config/services.ini. 22:29:29.485 Loading: ./config/karma.ini. 22:29:29.485 Loading: ./config/ai.ini. 22:29:29.486 Loading: ./config/siege.ini. 22:29:29.487 Loading: ./config/hexid.txt. 22:29:29.487 Loading: ./config/events.ini. 22:29:29.496 Loading: ./config/pccafe_system.ini. 22:29:29.496 Loading: ./config/community_board.ini. 22:29:29.500 Loading: ./config/geodata.ini. 22:29:29.500 Loading: ./config/enchant.ini. 22:29:29.502 Loading: ./config/skills.ini. 22:29:29.505 Loading: ./config/champion.ini. 22:29:29.506 Loading: ./config/protection.ini. 22:29:29.506 Loading: ./config/vipchar.ini. 22:29:29.507 VIP system: loaded 0 VIP chars, 7 VIP skills 22:29:29.507 Loading: ./config/territorywar.ini. 22:29:29.507 Loading: ./config/instances.ini. 22:29:29.507 Loading: ./config/hellbound.ini. 22:29:29.508 Loading: ./config/item_auction.ini. 22:29:29.511 Obscene: Loaded 36 abuse words. 22:29:29.512 Indecent: Loaded 32 abuse words. 22:29:29.512 Shout: Loaded 5 abuse words. 22:29:29.540 loading xml GMAccess 22:29:29.722 ConnectingPoolDBCP: initialized GameServer connection pool. 22:29:30.495 DbUtils: Database tables have been repaired. 22:29:30.710 DbUtils: Database tables have been checked. 22:29:30.720 DbUtils: Database tables have been analyzed. 22:29:30.780 DbUtils: Database tables have been optimized. 22:29:30.781 22:29:30.781 |=====================COPYRIGHT=========================| 22:29:30.781 | Powered by L2NextGen (C) 2008-2011. 22:29:30.781 | Version: V35-Epilogue. 22:29:30.781 | Revision: exported. 22:29:30.781 | Build Date: 2012.12.29 15:16. 22:29:30.781 |=====================COPYRIGHT=========================| 22:29:30.781 22:29:30.781 |=======================OWNER===========================| 22:29:30.781 | name: undefined. 22:29:30.781 | e-mail: undefined. 22:29:30.782 | icq: undefined. 22:29:30.782 |=======================OWNER===========================| 22:29:30.782 22:29:30.782 |=================CONTACT INFORMATION===================| 22:29:30.782 | ICQ: 290974. 22:29:30.782 | Website: www.l2nextgen.ru 22:29:30.782 |=================CONTACT INFORMATION===================| 22:29:30.782 22:29:30.782 |==================SYSTEM INFORMATION===================| 22:29:30.783 | MySQL Server: 5.1.49-3. 22:29:30.783 | Operating System: Linux Build: 2.6.32-5-amd64, arch: amd64 22:29:30.784 | Avaible CPU(s): 4 22:29:30.784 | CPU Identifier: null 22:29:30.784 | JMV: OpenJDK 64-Bit Server VM Build: 1.6.0_18-b18 22:29:30.784 |==================SYSTEM INFORMATION===================| 22:29:30.784 22:29:30.786 Used memory: 22 Mb 22:29:30.793 Loaded 414 translit entrys 22:29:30.795 Clear characters online status and accesslevel. 22:29:30.822 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bonus.login' in 'IN/ALL/ANY subquery' 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:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1749) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1666) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at l2n.database.FiltredStatement.executeUpdate(FiltredStatement.java:23) at l2n.game.idfactory.Tasks$ClearQuery.run(Tasks.java:130) at l2n.game.idfactory.IdFactory.cleanUpDB(IdFactory.java:60) at l2n.game.idfactory.IdFactory.(IdFactory.java:31) at l2n.game.idfactory.BitSetIDFactory.(BitSetIDFactory.java:31) at l2n.game.idfactory.IdFactory.(IdFactory.java:26) at l2n.game.GameServer.(GameServer.java:196) at l2n.game.GameServer.main(GameServer.java:567) Server exiting [status=0] / Reason: IdFactory::DBCleaner::DELETE FROM bonus WHERE bonus.login NOT IN (SELECT account_name FROM characters); Изменено 30 декабря, 2012 пользователем BlackDeath Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
xuser 122 Опубликовано 31 декабря, 2012 В таблице bonus нет столбца login Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты