biilybob Posted July 24, 2010 Posted July 24, 2010 Geia sas pedia exw ena provlima me enan interlude server pataw registerGameServer (p bgazei to hex id) k m bgazei t parakatw [pre]INFO : loading login config INFO : MLog clients using log4j logging. INFO : Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; tra ce: 10] INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acq uireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCom mitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcqui reFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge1398a1lyxav183f6ic|1b09468, debugUnreturnedConnectionStack Traces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, fact oryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityTo ken -> 1hge1398a1lyxav183f6ic|1b09468, idleConnectionTestPeriod -> 60, initialPo olSize -> 3, jdbcUrl -> jdbc:mysql://localhost/l2jdb, lastAcquisitionFailureDefa ultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleT ime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize -> 1, numHelperThreads -> 20, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, propert ies -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheck in -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] INFO : Loaded 127 server names WARN : SQL Error: 1146, SQLState: 42S02 ERROR : Table 'l2jdb.gameservers' doesn't exist Exception in thread "main" org.hibernate.exception.SQLGrammarException: could no t execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2214) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095) at org.hibernate.loader.Loader.list(Loader.java:2090) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja va:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java :172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at net.sf.l2j.loginserver.dao.impl.GameserversDAOHib.findAllOrderById(Ga meserversDAOHib.java:96) at net.sf.l2j.loginserver.dao.impl.GameserversDAOHib.getAllGameservers(G ameserversDAOHib.java:89) at net.sf.l2j.loginserver.services.GameserversServices.getAllGameservers (GameserversServices.java:62) at net.sf.l2j.loginserver.services.GameserversServices$$FastClassByCGLIB $$862bd22.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio n.invokeJoinpoint(Cglib2AopProxy.java:675) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.in voke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc eptor.intercept(Cglib2AopProxy.java:616) at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$ $8b978db4.getAllGameservers(<generated>) at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag er.java:209) at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan ager.java:112) at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ erManager.java:83) at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j ava:50) Caused by: java.sql.SQLException: Table 'l2jdb.gameservers' doesn't exist at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2978) at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:933) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1027) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr oxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1778) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2211) ... 22 more Πιέστε ένα πλήκτρο για συνέχεια. . .[/pre] Quote
0 Vampirenios Posted July 24, 2010 Posted July 24, 2010 1on wrong section 2on checkare an eine ola sosta.. Quote
0 Nightw0lf Posted July 27, 2010 Posted July 27, 2010 WARN : SQL Error: 1146, SQLState: 42S02 ERROR : Table 'l2jdb.gameservers' doesn't exist edw sou leei oti psaxnei gia table stin database pou legete l2jdb.gameservers an thes dimiourgise to i apla kane reinstall oli tin database apo tin arxi gia na strwsei giati mporei na sou vgalei kai alla provlimata paromoia error Quote
Question
biilybob
Geia sas pedia exw ena provlima me enan interlude server pataw registerGameServer (p bgazei to hex id) k m bgazei t parakatw
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.