L2PICK.com — Lineage 2 Private Server List

[HELP] Gameserver Error

Followers

Vicer

Members

OfflineStatus
MembersGroup
32Posts
0Solutions
1Reputation
27,390Member No
0Days Won
20/08/2008Joined
Offline Status
Members Group
32 posts
0 Badges
1 Reputation
27,390 Member No
0 Days Won
20/08/2008 Joined

N/A 0 0 0

October 7, 200818 yr

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

Legendary Member

OfflineStatus
Legendary MemberGroup
2,996Posts
0Solutions
0Reputation
4,965Member No
0Days Won
29/06/2006Joined
Offline Status
Legendary Member Group
3k posts
0 Badges
0 Reputation
4,965 Member No
0 Days Won
29/06/2006 Joined

N/A 0 0 0

October 7, 200818 yr

Table 'l2jdb.topic' doesn't exist

I think it's pretty clear.

Frank

Legendary Member

OfflineStatus
Legendary MemberGroup
5,653Posts
0Solutions
40Reputation
14,925Member No
12Days Won
CalmCurrent mood
CEFTACountry
MaleGender
18/11/2007Joined
Offline Status
Legendary Member Group
5.7k posts
9 Badges
40 Reputation
14,925 Member No
12 Days Won
18/11/2007 Joined

100% 14 0 0

Gender:
Male
Current mood:
Calm
Country:
CEFTA

October 7, 200818 yr

Table 'l2jdb.topic' doesn't exist

I think it's pretty clear.

/aggree

Solution: Just create your DB again and install your SQL

Create an account or sign in to comment

Followers

Go to topic listing

L2 Editor Pro - Lineage II Client Editor

This tool is at most 4 hours work with Claude and what takes so long is actually you testing it, sorry bro

By xdem · 1 hour ago1 hr
Black Box on Login Screen.

Replace the L2Font.Skins.start_logo texture with a transparent one (containing an alpha channel).
It is important to consider which localization version is being used; choose the appropriate filename accordingly—for example, L2Font-ru.Skins.start_logo_ru or L2Font_eu.Skins.start_logo_eu.

By AlhimN1 · 5 hours ago5 hr
Black Box on Login Screen.

I tried installing 3 version of Grand Crusade p110 chronicle. This happens to all of them, any ideas what's wrong and how to fix it?

By MiReEn · 6 hours ago6 hr
NPC Temples Pack with Effects (Interlude).7z

Yes, but for first send crash log from client... also 821 seems to be encryption

By NevesOma · 9 hours ago9 hr
😅[FREE RELEASE + SOURCE CODE] hAuthD GX Modified😅

— L2OFF Authentication Server
Today, I want to share my modified version of hAuthD with the entire community, completely FREE and including the full Delphi source code.
This version includes several improvements focused on security, performance, account management, and compatibility with L2OFF servers.
Main Features
Anti-DDoS / AntiFlood: Application-level protection against connection floods, abusive requests, and excessive connections per IP.
AntiBrute: Protection against repeated failed login attempts, including configurable temporary IP blocking.
PreAuth Packet Pool: Optimized authentication initialization to reduce server workload during large bursts of incoming connections.
Account Registration: Players can create accounts directly from a compatible GX client, including email registration.
Password Change: Players can change their passwords directly through a compatible client.
Proxy Support: Dynamic GameServer IP routing through SQL Server, allowing customized proxy configurations.
L2OFF Compatibility: L2OFF authentication support, including C4 mode and different GameServer connection configurations.
SQL Server Integration: Account management, authentication, bans, and database operations.
Fully Configurable: Security settings, connection limits, logging, and additional features through hAuthD.ini.
Full Source Code: Complete Delphi sources included, allowing any developer to study, modify, and compile their own versions.
Security protections are configurable and help mitigate application-level attacks. Proper network-level protection is still required against large-scale volumetric DDoS attacks.
PRICE: $0 — COMPLETELY FREE!
One last thing...
Some people seem to forget that contributing to a community isn't about having a fancy title, special privileges, or an administrator badge next to your name.
I've contributed more to this community without a single special privilege than some of the people running this forum have throughout their entire time here.
And I want to make something perfectly clear:
NOBODY is going to stop me from releasing my work for free. ABSOLUTELY NOBODY.
While others are busy protecting their little positions of power, selling closed files, or deciding who deserves recognition, I'll keep doing what I've always done: developing, improving, and sharing real work with the community.
Respect isn't earned through administrator permissions. It's earned through contributions.
You can have all the administrator privileges in the world, but that doesn't automatically mean you've done anything meaningful for the people you're supposed to represent.
I don't need a title. I don't need special privileges. And I certainly don't need anyone's approval to keep contributing.
One final warning to the entire community...
Make sure you download my free releases while you still can.
Most of you already know perfectly well that there's a certain administrator on this forum who has repeatedly deleted my free releases and banned my previous accounts.
And let's be realistic: he'll probably do it again within a few days.
That's exactly why I always recommend downloading everything I share as soon as possible. My posts could disappear at any moment, and this account will probably end up banned, just like my previous ones.
Everyone knows exactly who I'm talking about. There's no need to mention his name.
From what I've seen over all this time, it seems like his only activity on this forum is showing up to delete my contributions and ban my accounts. Meanwhile, I'm still waiting to see him make a genuinely useful contribution to this community.
But here's the funniest part:
You can delete my posts. You can ban my accounts. But you can't erase the work I've already shared with thousands of people, and you certainly can't stop me from continuing to develop and contribute.
Because at the end of the day, whenever someone downloads my source code, learns from it, modifies it, or improves their own server thanks to my work, my contribution has already served its purpose.
And no administrator can erase that.
Some people need administrator privileges to feel important. All I need is my source code.
The difference is simple: they might control a forum, but they can't control what I'm capable of developing or what I choose to share with the community for free.

MediaFire
hAuthD-main-new

— GX-Ext

By guytis123 · 9 hours ago9 hr

[HELP] Gameserver Error

Featured Replies

Create an account or sign in to comment

Posts

L2 Editor Pro - Lineage II Client Editor

Black Box on Login Screen.

Black Box on Login Screen.

NPC Temples Pack with Effects (Interlude).7z

😅[FREE RELEASE + SOURCE CODE] hAuthD GX Modified😅

Topics

Black Box on Login Screen.

😅[FREE RELEASE + SOURCE CODE] hAuthD GX Modified😅

L2 Editor Pro - Lineage II Client Editor

Ψάχνω να μπω σαν staff gm στον σέρβερ σου.

Lineage 2 rust client c4

Important Information

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)