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

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..