Jump to content
  • 0

How can i fix this error?


Question

Posted

[21:57:20] ERROR Error while restoring offline traders!

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2ft.character

_variables' doesn't exist

        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:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2155)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2450)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2371)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2355)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del

egatingPreparedStatement.java:105)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del

egatingPreparedStatement.java:105)

        at l2ft.gameserver.taskmanager.tasks.RestoreOfflineTraders.runImpl(Resto

reOfflineTraders.java:39)

        at l2ft.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

        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)

[21:57:20]  INFO Restored 0 offline traders

 

Thanks for help

 

 

1 answer to this question

Recommended Posts

  • 0
Posted

[21:57:20] ERROR Error while restoring offline traders!

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2ft.character

_variables' doesn't exist

        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:411)

        at com.mysql.jdbc.Util.getInstance(Util.java:386)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2155)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2450)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2371)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2355)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del

egatingPreparedStatement.java:105)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del

egatingPreparedStatement.java:105)

        at l2ft.gameserver.taskmanager.tasks.RestoreOfflineTraders.runImpl(Resto

reOfflineTraders.java:39)

        at l2ft.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

        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)

[21:57:20]  INFO Restored 0 offline traders

 

Thanks for help

 

 

 

go datapack/sql and find character_variables.sql and execute it into ur database

Guest
This topic is now closed to further replies.


×
×
  • Create New...