Jump to content
  • 0

[HELP] Gameserver Error


Question

Posted

I know why i have this error, because my Datebase is missing a Table.

But someone can share me the SQL for this Table ?

 

WARNING data error on Forum 3 :
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.topic' d
oesn'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:406)
       at com.mysql.jdbc.Util.getInstance(Util.java:381)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1737)
       at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1888)
       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
       at com.l2jfree.gameserver.communitybbs.bb.Forum.load(Forum.java:137)
       at com.l2jfree.gameserver.communitybbs.bb.Forum.getName(Forum.java:234)
       at com.l2jfree.gameserver.communitybbs.Manager.ForumsBBSManager.getForum
ByName(ForumsBBSManager.java:115)
       at com.l2jfree.gameserver.model.actor.instance.L2PcInstance.getMemo(L2Pc
Instance.java:6755)
       at com.l2jfree.gameserver.communitybbs.Manager.TopicBBSManager.parsecmd(
TopicBBSManager.java:176)
       at com.l2jfree.gameserver.communitybbs.CommunityBoard.handleCommands(Com
munityBoard.java:61)
       at com.l2jfree.gameserver.network.clientpackets.RequestBypassToServer.ru
nImpl(RequestBypassToServer.java:241)
       at com.l2jfree.gameserver.network.clientpackets.L2GameClientPacket.run(L
2GameClientPacket.java:78)
       at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrappe
r.java:40)
       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$301(Unknown Source)
       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)

WARNING data error on Forum 11 :
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.topic' d
oesn'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:406)
       at com.mysql.jdbc.Util.getInstance(Util.java:381)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1737)
       at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1888)
       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
       at com.l2jfree.gameserver.communitybbs.bb.Forum.load(Forum.java:137)
       at com.l2jfree.gameserver.communitybbs.bb.Forum.getName(Forum.java:234)
       at com.l2jfree.gameserver.communitybbs.bb.Forum.getChildByName(Forum.jav
a:266)
       at com.l2jfree.gameserver.model.actor.instance.L2PcInstance.getMemo(L2Pc
Instance.java:6755)
       at com.l2jfree.gameserver.communitybbs.Manager.TopicBBSManager.parsecmd(
TopicBBSManager.java:176)
       at com.l2jfree.gameserver.communitybbs.CommunityBoard.handleCommands(Com
munityBoard.java:61)
       at com.l2jfree.gameserver.network.clientpackets.RequestBypassToServer.ru
nImpl(RequestBypassToServer.java:241)
       at com.l2jfree.gameserver.network.clientpackets.L2GameClientPacket.run(L
2GameClientPacket.java:78)
       at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrappe
r.java:40)
       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$301(Unknown Source)
       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...