L2PICK.com — Lineage 2 Private Server List

Login Server Problem

Followers

Th3On3

Members

OfflineStatus
MembersGroup
396Posts
0Solutions
0Reputation
13,448Member No
0Days Won
10/09/2007Joined
Offline Status
Members Group
396 posts
0 Badges
0 Reputation
13,448 Member No
0 Days Won
10/09/2007 Joined

N/A 0 0 0

December 18, 200718 yr

WARN : Object of class [net.sf.l2j.loginserver.beans.Accounts] with identifier [
larry]: not found
WARN : SQL Error: 1364, SQLState: HY000
ERROR : Field 'Email' doesn't have a default value
ERROR : Could not synchronize database state with session org.hibernate.exceptio
n.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:562)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:654)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:624)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:307)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:117)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
        at net.sf.l2j.loginserver.services.AccountsServices$$EnhancerByCGLIB$$89
efadb5.addOrUpdateAccount(<generated>)
        at net.sf.l2j.loginserver.manager.LoginManager.handleAccountNotFound(Log
inManager.java:630)
        at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:507)
        at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:471)
        at net.sf.l2j.loginserver.manager.LoginManager.tryAuthLogin(LoginManager
.java:295)
        at net.sf.l2j.loginserver.clientpackets.RequestAuthLogin.run(RequestAuth
Login.java:122)
        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)
Caused by: java.sql.BatchUpdateException: Field 'Email' doesn't have a default v
alue
        at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedSta
tement.java:647)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 23 more

Exception in thread "pool-1-thread-4" org.springframework.orm.hibernate3.Hiberna
teJdbcException: JDBC exception on Hibernate data access; nested exception is or
g.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC
batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:562)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:654)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:624)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:307)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:117)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
        at net.sf.l2j.loginserver.services.AccountsServices$$EnhancerByCGLIB$$89
efadb5.addOrUpdateAccount(<generated>)
        at net.sf.l2j.loginserver.manager.LoginManager.handleAccountNotFound(Log
inManager.java:630)
        at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:507)
        at net.sf.l2j.loginserver.manager.LoginManager.loginValid(LoginManager.j
ava:471)
        at net.sf.l2j.loginserver.manager.LoginManager.tryAuthLogin(LoginManager
.java:295)
        at net.sf.l2j.loginserver.clientpackets.RequestAuthLogin.run(RequestAuth
Login.java:122)
        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)
Caused by: java.sql.BatchUpdateException: Field 'Email' doesn't have a default v
alue
        at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedSta
tement.java:647)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 23 more
WARN : Object of class [net.sf.l2j.loginserver.beans.Accounts] with identifier [
larry]: not found

OK well that massive ammount of code above me is an error in my login server. Its very wierd... I have read it a few times and can not seem to centralize an error. It occurs when someone tries to make a new account, either on the website or just auto account creation...

What i was wondering is; can i fix this? I am using L2J EMU and need to know if i will have to go into java or what? ???

I also just thought about downloading a new loginserver , but i am not sure if it will cause errors with the rest of my server seeing as i have done extensive editing to the entire server code.

Thx for the help

Th3On3

anath3ma

Members

OfflineStatus
MembersGroup
597Posts
0Solutions
0Reputation
4,535Member No
0Days Won
06/06/2006Joined
Offline Status
Members Group
597 posts
0 Badges
0 Reputation
4,535 Member No
0 Days Won
06/06/2006 Joined

N/A 0 0 0

December 20, 200718 yr

i don't know i got the same problem

Create an account or sign in to comment

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 · 48 minutes ago48 min
😅[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 · 1 hour ago1 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 · 3 hours ago3 hr
NPC Temples Pack with Effects (Interlude).7z

any suggestions regarding my last post ?!

By d1ctatorTV · 3 hours ago3 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 · 4 hours ago4 hr

Login Server Problem

Featured Replies

Create an account or sign in to comment

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)