на сервер под уже созданными акк заходит норм,а создавать не хочет,пишет неправильный логин или пароль.
авто регистрация включена.
вот логи логин сервера:
[ERROR 2010-03-29 19:00:02] mysql5.MySQL5AccountDAO:167 - Can't inser account
java.sql.SQLException: Field 'email' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
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:2693)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java from JavaSourceFromFile:163)
at com.aionemu.loginserver.controller.AccountController.createAccount(AccountController.java:295)
at com.aionemu.loginserver.controller.AccountController.login(AccountController.java:179)
at com.aionemu.loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java:104)
at com.aionemu.loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:58)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:233)
at java.lang.Thread.run(Thread.java:619)
Добавлено через 6 минут
причину понял,это изза столбца email в бд,как её удалить?
авто регистрация включена.
вот логи логин сервера:
[ERROR 2010-03-29 19:00:02] mysql5.MySQL5AccountDAO:167 - Can't inser account
java.sql.SQLException: Field 'email' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
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:2693)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java from JavaSourceFromFile:163)
at com.aionemu.loginserver.controller.AccountController.createAccount(AccountController.java:295)
at com.aionemu.loginserver.controller.AccountController.login(AccountController.java:179)
at com.aionemu.loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java:104)
at com.aionemu.loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:58)
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:233)
at java.lang.Thread.run(Thread.java:619)
Добавлено через 6 минут
причину понял,это изза столбца email в бд,как её удалить?
