[HELP] Gameserver Error

[Vicer]

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)

[Hax0r]

Table 'l2jdb.topic' doesn't exist

I think it's pretty clear.

[Frank]

  On 10/7/2008 at 6:42 PM, Hax0r said:

Table 'l2jdb.topic' doesn't exist

I think it's pretty clear.

 

/aggree

 

Solution: Just create your DB again and install your SQL