L2PICK.com — Lineage 2 Private Server List

Create Character Fail

Followers

criss22

Members

OfflineStatus
MembersGroup
515Posts
0Solutions
1Reputation
92,266Member No
0Days Won
05/05/2011Joined
Offline Status
Members Group
515 posts
8 Badges
1 Reputation
92,266 Member No
0 Days Won
05/05/2011 Joined

N/A 0 0 0

April 21, 20188 yr

Could not insert char data: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'vip' in 'field list'

When i try to create character i get this error. Please help me ! :(

KillSwith

Members

OfflineStatus
MembersGroup
76Posts
0Solutions
1Reputation
66,485Member No
0Days Won
25/01/2010Joined
Offline Status
Members Group
76 posts
3 Badges
1 Reputation
66,485 Member No
0 Days Won
25/01/2010 Joined

N/A 0 0 0

April 21, 20188 yr

U need added in character the colun

Unknown column 'vip'

criss22

Members

OfflineStatus
MembersGroup
515Posts
0Solutions
1Reputation
92,266Member No
0Days Won
05/05/2011Joined
Offline Status
Members Group
515 posts
8 Badges
1 Reputation
92,266 Member No
0 Days Won
05/05/2011 Joined

N/A 0 0 0

April 21, 20188 yr

Author

and if i don't disturb with my question, how i can do that?

KillSwith

Members

OfflineStatus
MembersGroup
76Posts
0Solutions
1Reputation
66,485Member No
0Days Won
25/01/2010Joined
Offline Status
Members Group
76 posts
3 Badges
1 Reputation
66,485 Member No
0 Days Won
25/01/2010 Joined

N/A 0 0 0

April 22, 20188 yr

In your database, click with button right in table "character", and "Design Table" and before last table added "vip" Type INT Length 10 Decimals 0, and save.

criss22

Members

OfflineStatus
MembersGroup
515Posts
0Solutions
1Reputation
92,266Member No
0Days Won
05/05/2011Joined
Offline Status
Members Group
515 posts
8 Badges
1 Reputation
92,266 Member No
0 Days Won
05/05/2011 Joined

N/A 0 0 0

April 22, 20188 yr

Author

Thank you

1 year later...

xZuky

Members

OfflineStatus
MembersGroup
1Posts
0Solutions
0Reputation
227,657Member No
0Days Won
21/04/2020Joined
Offline Status
Members Group
1 posts
0 Badges
0 Reputation
227,657 Member No
0 Days Won
21/04/2020 Joined

N/A 0 0 0

April 21, 20206 yr

Can u help me? where do i create those tables...

Could not computate characters killing cycle winners: Table 'mega.character_kills_snapshot' doesn't exist
Table 'mega.character_kills_snapshot' doesn't exist
Could not computate characters killing cycle winners: Table 'mega.character_kills_snapshot' doesn't exist
Table 'mega.character_kills_snapshot' doesn't exist
Could not refresh characters killing snapshot: Table 'mega.character_kills_snapshot' doesn't exist
Table 'mega.character_kills_snapshot' doesn't exist
Could not create characters killing cycle: Table 'mega.character_kills_info' doesn't exist
Table 'mega.character_kills_info' doesn't exist

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 · 8 hours ago8 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

Create Character Fail

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)