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...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock