Показать сообщение отдельно
Непрочитано 22.01.2009, 13:57   #1
Аватар для vokforever
Пользователь

Автор темы (Топик Стартер) Ошибка логин сервера

Здравствуйте!
Впервые возникла вот такая ошибка:
Код:
WARN : SQL Error: 1364, SQLState: HY000
ERROR : Field 'answer' 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 com.l2jfree.loginserver.services.AccountsServices$$EnhancerByCGLIB$$5
0fc42ba.addOrUpdateAccount(<generated>)
        at com.l2jfree.loginserver.manager.LoginManager.handleAccountNotFound(Lo
ginManager.java:654)
        at com.l2jfree.loginserver.manager.LoginManager.loginValid(LoginManager.
java:528)
        at com.l2jfree.loginserver.manager.LoginManager.loginValid(LoginManager.
java:492)
        at com.l2jfree.loginserver.manager.LoginManager.tryAuthLogin(LoginManage
r.java:296)
        at com.l2jfree.loginserver.clientpackets.RequestAuthLogin.run(RequestAut
hLogin.java:121)
        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 'answer' doesn't have a default
value
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:1669)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1085)
        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-1" 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 com.l2jfree.loginserver.services.AccountsServices$$EnhancerByCGLIB$$5
0fc42ba.addOrUpdateAccount(<generated>)
        at com.l2jfree.loginserver.manager.LoginManager.handleAccountNotFound(Lo
ginManager.java:654)
        at com.l2jfree.loginserver.manager.LoginManager.loginValid(LoginManager.
java:528)
        at com.l2jfree.loginserver.manager.LoginManager.loginValid(LoginManager.
java:492)
        at com.l2jfree.loginserver.manager.LoginManager.tryAuthLogin(LoginManage
r.java:296)
        at com.l2jfree.loginserver.clientpackets.RequestAuthLogin.run(RequestAut
hLogin.java:121)
        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 'answer' doesn't have a default
value
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:1669)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1085)
        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
Помогите, люди не могут зарегистрироваться!
Как исправить?
vokforever вне форума Ответить с цитированием