L2PICK.com — Lineage 2 Private Server List

[HELP]Error in GameServer Console

Followers

tuqei

Members

OfflineStatus
MembersGroup
4Posts
0Solutions
0Reputation
82,012Member No
0Days Won
11/11/2010Joined
Offline Status
Members Group
4 posts
0 Badges
0 Reputation
82,012 Member No
0 Days Won
11/11/2010 Joined

N/A 0 0 0

November 29, 201015 yr

Hello everyone. I have a problem when i spawn any NPCs. Could you help me to fix it. Thanks a lot .

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value for column 'id' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'id' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
        at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable.java:286)
        at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:246)
        at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:180)
        at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.runImpl(SendBypassBuildCmd.java:79)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:997)
        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)

Hardstyle

Members

OfflineStatus
MembersGroup
150Posts
0Solutions
0Reputation
40,255Member No
0Days Won
24/01/2009Joined
Offline Status
Members Group
150 posts
0 Badges
0 Reputation
40,255 Member No
0 Days Won
24/01/2009 Joined

N/A 0 0 0

December 1, 201015 yr

i have the same problem .... i think is cuz the server is trying to enter a number higher then integer value in spawnlis... but i don't know how to fix it.... if any one can help .. please do:D

i'v found a fix... check http://www.maxcheaters.com/forum/index.php?topic=185917.0

tuqei

Members

OfflineStatus
MembersGroup
4Posts
0Solutions
0Reputation
82,012Member No
0Days Won
11/11/2010Joined
Offline Status
Members Group
4 posts
0 Badges
0 Reputation
82,012 Member No
0 Days Won
11/11/2010 Joined

N/A 0 0 0

December 2, 201015 yr

Author

oh thank you very much.

WeirdSituation

Legendary Member

OfflineStatus
Legendary MemberGroup
7,464Posts
0Solutions
35Reputation
68,308Member No
2Days Won
22/02/2010Joined
Offline Status
Legendary Member Group
7.5k posts
8 Badges
35 Reputation
68,308 Member No
2 Days Won
22/02/2010 Joined

N/A 0 0 0

December 2, 201015 yr

oh thank you very much.

locked.

This topic is now closed to further replies.

Followers

Go to topic listing

NPC Temples Pack with Effects (Interlude).7z

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

By NevesOma · 2 hours ago2 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 · 2 hours ago2 hr
[NEW] V2. Lin2Web CMS - L2J & PTS (l2off)

Added new default design!! check
http://new.lin2web.com/
Home
Advanced Lineage 2 account panel for L2J and PTS servers with payments, starter packs, services and statistics.
and also Discount 20% until 15 december for Premium Plan

By Kenrix · 4 hours ago4 hr
NPC Temples Pack with Effects (Interlude).7z

any suggestions regarding my last post ?!

By d1ctatorTV · 4 hours ago4 hr
L2 Editor Pro - Lineage II Client Editor

L2 Editor Pro — Lineage II Client Editor

Import. Edit. Preview. Convert. Save.
L2 Editor Pro is an improved version of lordofdest's L2 Editor with fixes and separate plugins for animations, VertMeshes, effects, newer clients and package repair.
View all products, videos and prices

Basic Edition
Edit Lineage 2 textures, static meshes and packages with improved saving, exporting and dependency tools.

Fixed reported issues from the original free editor
Improved static mesh collision and geometry saving
Direct PNG/JPG texture import with conversion
Bulk texture renaming and built-in exporting
Automatic missing dependency search
Multiple package loading and safer validated saves

View Basic Edition

Animations Plugin
Import, edit and convert supported PSK, PSA and UKX animations with preview and AnimNotify support.

Import and export ActorX PSK/PSA files
Edit existing UKX packages and animation sequences
Edit and convert AnimNotifies
Preview skeletal meshes and animations
Include compatible linked textures, materials, sounds and effects
Convert supported assets for compatible older clients

View Animations Plugin

VertMeshes Plugin
Preview, edit and export supported Lineage 2 vertex meshes and save compatible packages.

Preview supported VertMeshes and animations
Inspect mesh properties and linked materials
Rename and repackage meshes
Include compatible dependencies
Export supported Unreal .3d assets

View VertMeshes Plugin

Effects Plugin
Preview and edit supported Lineage 2 particles, emitters and animation effects in real time.

Preview particles and sounds triggered by animations
Inspect and isolate individual emitters
Edit supported emitter properties with live feedback
Work with UnrealScript defaultproperties and .uc files
Save compatible effect packages as .u

View Effects Plugin

Clients Plugin
Open and prepare supported packages from newer Lineage 2 clients such as Fafurion, Samurai/P557 and RoseVain.

Prepare compatible newer package layouts for editing
Resolve supported dependencies
Keep original source files unchanged during preparation

View Clients Plugin

Repair Plugin
Repair supported obfuscated or damaged Lineage 2 packages without changing the original files.

Prepare compatible newer package layouts for editing
Resolve supported dependencies
Keep original source files unchanged during preparation

View Repair Plugin

Full Edition
Includes Basic Edition, Animations, VertMeshes, Effects, Clients and Repair, plus 15+ Lineage 2 client modding tutorials.
If you already own eligible L2 Editor Pro products, their value is automatically credited on your first Full Edition purchase.
Get Full Edition

Licensing and support
One-time purchases with no mandatory subscription
Lifetime access to the purchased functionality
Maintenance updates and bug fixes included
Major future plugins, expansions or client profiles may be sold separately

Compatibility depends on the client, package version, asset type and workflow. Contact us before purchasing if you need confirmation for a specific chronicle or package.

Products and demos: https://l2crypt.com/l2editor-pro/
Discord: https://discord.gg/aERmNJ3zJf
Contact: https://l2crypt.com/contact/

By Frank · 5 hours ago5 hr

[HELP]Error in GameServer Console

Featured Replies

Posts

NPC Temples Pack with Effects (Interlude).7z

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

[NEW] V2. Lin2Web CMS - L2J & PTS (l2off)

NPC Temples Pack with Effects (Interlude).7z

L2 Editor Pro - Lineage II Client Editor

Topics

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

L2 Editor Pro - Lineage II Client Editor

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

Lineage 2 rust client c4

L20FF GF DECOMPILED

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)