Ошибка логин сервера

[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

Помогите, люди не могут зарегистрироваться!
Как исправить?

[Aquanox]

Код:

ALTER TABLE `accounts` ALTER COLUMN `accounts`.`answer` SET DEFAULT '';

[vokforever]

Код:

ALTER TABLE `accounts` ALTER COLUMN `accounts`.`answer` SET DEFAULT '';

вот что выдаёт phpmyadmin на этот запрос

Код:

#1101 - BLOB/TEXT column 'answer' can't have a default value

Вообщем это всё происходит при автореге в игре с сайта (модуль DLE Linage 1.5) все регистрирутся без проблем.

[incognito]

Field 'answer' doesn't have a default value

тебе нао просто найти sql в которой есть колонка answer и поставить ей дефолтное значение=)
примерно так
`answer` varchar(45) NOT NULL default '',

[vokforever]

тебе нао просто найти sql в которой есть колонка answer и поставить ей дефолтное значение=)
примерно так
`answer` varchar(45) NOT NULL default '',

Напиши полностью запрос.
У меня ругается постоянно.

Код:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(45) NOT NULL default ''' at line 1

[Aquanox]

Напиши полностью запрос.
У меня ругается постоянно.

Код:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(45) NOT NULL default ''' at line 1

Код:

ALTER TABLE `accounts` CHANGE `answer` `answer` varchar(255) NOT NULL default '';