Login Server Problem

[Th3On3]

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]

i don't know i got the same problem