Lis911

столкнулся вот с такими проблемами при запуске сервера после копирования sql файлов в бд навикет. При запуске логин сервера : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireInc rement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnCl ose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailu re -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connec tionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSou rceName -> 302yw78w8ae3da1c3mo2b|71457184, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClas sLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 302yw78w8ae3da1c3mo2b|71457184, idleConnectionTestPeriod -> 3600, initialPoolSiz e -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb2, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, m axPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 100, minPool Size -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, p referredTestQuery -> null, properties -> {user=******, password=******}, propert yCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false , unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] ===========================================================-[ LoginController ] Cached 10 KeyPairs for RSA communication Stored 20 keys for Blowfish communication Loaded 127 server names java.sql.SQLException: Column 'server_id' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.j ava:2573) at com.l2jfrozen.gameserver.datatables.GameServerTable.loadRegisteredGam eServers(GameServerTable.java:182) at com.l2jfrozen.gameserver.datatables.GameServerTable.<init>(GameServer Table.java:90) at com.l2jfrozen.gameserver.datatables.GameServerTable.load(GameServerTa ble.java:74) at com.l2jfrozen.loginserver.L2LoginServer.<init>(L2LoginServer.java:141 ) at com.l2jfrozen.loginserver.L2LoginServer.main(L2LoginServer.java:53) Loaded 0 registered Game Servers Cached 10 RSA keys for Game Server communication. Listening for GameServers on 127.0.0.1:9014 Login Server ready on 127.0.0.1:2106 Loaded 2 IP Bans. Хоть и выдает что сервер ид не найден вроде логин серв запустился . а вот гейм сервер выдает : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireInc rement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnCl ose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailu re -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connec tionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSou rceName -> 302yw78w8dmn171tqfo59|582ed819, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClas sLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 302yw78w8dmn171tqfo59|582ed819, idleConnectionTestPeriod -> 3600, initialPoolSiz e -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb2, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, m axPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 100, minPool Size -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, p referredTestQuery -> null, properties -> {user=******, password=******}, propert yCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false , unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] L2DatabaseFactory: loaded. ===================================================================-[ Threads ] Cache : Running lazy cacheCache[Crest]: 0,000MB on 1 files loaded. (Forget Time: 300s , Capacity: 50) Initializing Script Engine Manager Script Engine: Mozilla Rhino 1.7 release 3 PRERELEASE - Language: ECMAScript - L anguage Version: 1.8 Script Engine: java 1.6 - Language: java - Language Version: 1.6 Script Engine: BeanShell Engine 1.1 - Language: BeanShell - Language Version: 2. 0b5 Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1 =====================================================================-[ World ] L2World: Setting up World Regions L2World: (87x128) World Region Grid set up. Announcements: Loaded 1 Announcements. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' i n 'order clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 2281) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr oxyPreparedStatement.java:76) at com.l2jfrozen.gameserver.handler.AutoAnnouncementHandler.restoreAnnou ncementData(AutoAnnouncementHandler.java:67) at com.l2jfrozen.gameserver.handler.AutoAnnouncementHandler.<init>(AutoA nnouncementHandler.java:52) at com.l2jfrozen.gameserver.handler.AutoAnnouncementHandler.getInstance( AutoAnnouncementHandler.java:146) at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:213) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'objec t_id' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1664) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1583) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat ement.java:64) at com.l2jfrozen.gameserver.idfactory.IdFactory.extractUsedObjectIDTable (IdFactory.java:239) at com.l2jfrozen.gameserver.idfactory.StackIDFactory.<init>(StackIDFacto ry.java:56) at com.l2jfrozen.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java: 116) at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:214) ID Factory could not be initialized correctly:com.mysql.jdbc.exceptions.jdbc4.My SQLSyntaxErrorException: Unknown column 'object_id' in 'field list' Could not read object IDs from DB. Please Check Your Data. Exception in thread "main" java.lang.Exception: Could not initialize the ID fact ory at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:217) Я Новичок в этом деле, но предполагаю что дело в sql таблицах или колонках. Можете детально обьяснить нубу что в каких колонках или файлах делать, чтоб исправить это дело ?)