Jump to content

Help! error in aion database?


Recommended Posts

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)

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now


×
×
  • Create New...