noctis

April 21, 2012

These are the errors I get when i start up the gs... Does anyone know how to fix?

[WARN] 2012-04-20 23:30:42 - Failed to execute IU query com.mysql.jdbc.exception
s.jdbc4.MySQLSyntaxErrorException: Unknown column 'online' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'onlin
e' 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:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        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:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:172)
        at mysql5.MySQL5PlayerDAO$7.handleInsertUpdate(MySQL5PlayerDAO.java]:487
)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:314)
        at com.aionemu.commons.database.DB.insertUpdate(DB.java:293)
        at mysql5.MySQL5PlayerDAO.setPlayersOffline(MySQL5PlayerDAO.java]:483)
        at gameserver.GameServer.main(GameServer.java:105)

[ERROR] 2012-04-20 18:55:38 - Unknown column 'players.exp' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playe
rs.exp' 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:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        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:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.j
ava]:393)
        at gameserver.services.AbyssRankingService.reloadRankings(AbyssRankingSe
rvice.java:150)
        at gameserver.services.AbyssRankingService.access$100(AbyssRankingServic
e.java:42)
        at gameserver.services.AbyssRankingService$3$2.run(AbyssRankingService.j
ava:140)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
[ERROR] 2012-04-20 18:55:38 - Unknown column 'players.exp' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playe
rs.exp' 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:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        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:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.j
ava]:393)
        at gameserver.services.AbyssRankingService.reloadRankings(AbyssRankingSe
rvice.java:151)
        at gameserver.services.AbyssRankingService.access$100(AbyssRankingServic
e.java:42)
        at gameserver.services.AbyssRankingService$3$2.run(AbyssRankingService.j
ava:140)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
[iNFO] 2012-04-20 18:55:38 - AbyssRankService: Rankings were reloaded!
[iNFO] 2012-04-20 19:15:05 - Legion WH update task started.
[iNFO] 2012-04-20 19:15:05 - Legion WH update: 28 ms, legions: 0.

Thx, >.<; (sorry if there's already a topic on this :s)

April 21, 2012

Do any of you know how to fix this error? Can't figure it out... :S

[ERROR] 2012-04-20 18:55:38 - Unknown column 'players.exp' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playe
rs.exp' 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:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        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:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.j
ava]:393)
        at gameserver.services.AbyssRankingService.reloadRankings(AbyssRankingSe
rvice.java:150)
        at gameserver.services.AbyssRankingService.access$100(AbyssRankingServic
e.java:42)
        at gameserver.services.AbyssRankingService$3$2.run(AbyssRankingService.j
ava:140)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
[ERROR] 2012-04-20 18:55:38 - Unknown column 'players.exp' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playe
rs.exp' 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:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        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:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
        at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.j
ava]:393)
        at gameserver.services.AbyssRankingService.reloadRankings(AbyssRankingSe
rvice.java:151)
        at gameserver.services.AbyssRankingService.access$100(AbyssRankingServic
e.java:42)
        at gameserver.services.AbyssRankingService$3$2.run(AbyssRankingService.j
ava:140)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:54)
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:39)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
[iNFO] 2012-04-20 18:55:38 - AbyssRankService: Rankings were reloaded!
[iNFO] 2012-04-20 19:15:05 - Legion WH update task started.
[iNFO] 2012-04-20 19:15:05 - Legion WH update: 28 ms, legions: 0.

Thx, >.<;

April 20, 2012

Hi! Okay so ive tried everything i could... but to no avail i still can't get past where i click ok to login. ive redone all the steps, deleted and made new gs an ls.. everything quadruple checked that all my ip's are correct... but it still wont let me even access servers or login it is just stuck in limbo.

Any help? >.<

version is 2.7 if that helps?

noctis

Posts

Credits

Joined

Last visited

Feedback

Content Type

Articles

Profiles

Forums

Store

Posts posted by noctis

Help! error in aion database?

Create Aion Server (Java) [Share]

[Guide]How to setup your own Aion Server!

Browse

Activity

Store