AL 3.9 Password or ID does not match [2]

Results 1 to 4 of 4
  1. 03-07-13 #1
    illuminator
    Apprentice illuminator is offline
    MemberRank
    Jul 2013 Join Date
    22Posts

    AL 3.9 Password or ID does not match [2]

    I have this error when i try to create new account. This is my error.log :

    2013-07-03 23:35:33,965 Loading tasks failed:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_server_ls.tasks' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_21]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_21]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_21]
    at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_21]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) ~[mysql-connector-java-5.1.18.jar:na]
    at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
    at mysql5.MySQL5TaskFromDBDAO.getAllTasks(MySQL5TaskFromDBDAO.java]:53) ~[na:na]
    at com.aionemu.loginserver.taskmanager.TaskFromDBManager.<init>(TaskFromDBManager.java:36) [AL-Login.jar:na]
    at com.aionemu.loginserver.taskmanager.TaskFromDBManager.<init>(TaskFromDBManager.java:30) [AL-Login.jar:na]
    at com.aionemu.loginserver.taskmanager.TaskFromDBManager$SingletonHolder.<clinit>(TaskFromDBManager.java:79) [AL-Login.jar:na]
    at com.aionemu.loginserver.taskmanager.TaskFromDBManager.getInstance(TaskFromDBManager.java:71) [AL-Login.jar:na]
    at com.aionemu.loginserver.LoginServer.main(LoginServer.java:144) [AL-Login.jar:na]
    2013-07-03 23:38:34,632 Can't inser account
    java.sql.SQLException: Field 'email' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) ~[mysql-connector-java-5.1.18.jar:na]
    at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
    at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java]:190) ~[na:na]
    at com.aionemu.loginserver.controller.AccountController.createAccount(AccountController.java:319) [AL-Login.jar:na]
    at com.aionemu.loginserver.controller.AccountController.login(AccountController.java:176) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java:98) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:60) [AL-Login.jar:na]
    at com.aionemu.commons.network.PacketProcessor$DummyExecutor.execute(PacketProcessor.java:99) [al-commons-1.3.jar:na]
    at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:264) [al-commons-1.3.jar:na]
    at java.lang.Thread.run(Unknown Source) [na:1.7.0_21]
    2013-07-03 23:38:44,162 Can't inser account
    java.sql.SQLException: Field 'email' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) ~[mysql-connector-java-5.1.18.jar:na]
    at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
    at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java]:190) ~[na:na]
    at com.aionemu.loginserver.controller.AccountController.createAccount(AccountController.java:319) [AL-Login.jar:na]
    at com.aionemu.loginserver.controller.AccountController.login(AccountController.java:176) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java:98) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:60) [AL-Login.jar:na]
    at com.aionemu.commons.network.PacketProcessor$DummyExecutor.execute(PacketProcessor.java:99) [al-commons-1.3.jar:na]
    at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:264) [al-commons-1.3.jar:na]
    at java.lang.Thread.run(Unknown Source) [na:1.7.0_21]
    2013-07-03 23:59:25,679 Can't inser account
    java.sql.SQLException: Field 'email' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) ~[mysql-connector-java-5.1.18.jar:na]
    at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
    at mysql5.MySQL5AccountDAO.insertAccount(MySQL5AccountDAO.java]:190) ~[na:na]
    at com.aionemu.loginserver.controller.AccountController.createAccount(AccountController.java:319) [AL-Login.jar:na]
    at com.aionemu.loginserver.controller.AccountController.login(AccountController.java:176) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.clientpackets.CM_LOGIN.runImpl(CM_LOGIN.java:98) [AL-Login.jar:na]
    at com.aionemu.loginserver.network.aion.AionClientPacket.run(AionClientPacket.java:60) [AL-Login.jar:na]
    at com.aionemu.commons.network.PacketProcessor$DummyExecutor.execute(PacketProcessor.java:99) [al-commons-1.3.jar:na]
    at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:264) [al-commons-1.3.jar:na]
    at java.lang.Thread.run(Unknown Source) [na:1.7.0_21]
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    AL 3.9 Password or ID does not match [2]
  3. 04-07-13 #2
    sami37
    This is my title !!!! sami37 is offline
    MemberRank
    Jun 2010 Join Date
    287Posts

    Re: AL 3.9 Password or ID does not match [2]

    Quote Originally Posted by illuminator View Post
    I have this error when i try to create new account. This is my error.log :

    2013-07-03 23:35:33,965 Loading tasks failed:

    Table 'al_server_ls.tasks' doesn't exist
    Code:
    CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(5) NOT NULL,
  `task` varchar(50) NOT NULL,
  `type` enum('FIXED_IN_TIME') NOT NULL,
  `last_activation` timestamp NOT NULL DEFAULT '2009-12-31 23:00:00',
  `start_time` varchar(8) NOT NULL,
  `delay` int(10) NOT NULL,
  `param` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    try creating this table in you al_server_ls

    Quote Originally Posted by illuminator View Post
    Field 'email' doesn't have a default value
    Look into al_server_ls => account_data => structure
    Modify email column and set a Default value and check Null
    Reply With Quote Reply With Quote
  4. 04-07-13 #3
    illuminator
    Apprentice illuminator is offline
    MemberRank
    Jul 2013 Join Date
    22Posts

    Re: AL 3.9 Password or ID does not match [2]

    After i created the new table i have only this :

    2013-07-04 03:34:56,910 Can't inser account
    java.sql.SQLException: Field 'email' doesn't have a default value

    What is the default value for e-mail ?
    Reply With Quote Reply With Quote
  5. 04-07-13 #4
    lettus
    Valued Member lettus is offline
    MemberRank
    Aug 2007 Join Date
    Brasil - Rio deLocation
    120Posts

    Re: AL 3.9 Password or ID does not match [2]

    Quote Originally Posted by illuminator View Post
    After i created the new table i have only this :

    2013-07-04 03:34:56,910 Can't inser account
    java.sql.SQLException: Field 'email' doesn't have a default value

    What is the default value for e-mail ?
    sami37 answer you on the second post

    Look into al_server_ls => account_data => structure
    Modify email column and set a Default value and check Null
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement