search

ahmedsuffian / aionxemu

Automatically exported from code.google.com/p/aionxemu
0 stars 0 forks source link

Error executing select query java.sql.SQLException: Cannot convert value '0000-00-00 #90

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
[WARN] 2011-03-13 22:00:59 - Error executing select query 
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 2 
to TIMESTAMP.
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 2 
to TIMESTAMP.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1339)
    at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:129)
    at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6754)
    at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6073)
    at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6111)
    at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
    at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300)
    at mysql5.MySQL5PlayerDAO$2.handleRead(MySQL5PlayerDAO.java from JavaSourceFromFile:362)
    at com.aionemu.commons.database.DB.select(DB.java:185)
    at com.aionemu.commons.database.DB.select(DB.java:163)
    at mysql5.MySQL5PlayerDAO.setCreationDeletionTime(MySQL5PlayerDAO.java from JavaSourceFromFile:352)
    at gameserver.services.AccountService.loadAccount(AccountService.java:138)
    at gameserver.services.AccountService.getAccount(AccountService.java:68)
    at gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:217)
    at gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:89)
    at gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:46)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Value '[B@18d25ff1' can not be represented as 
java.sql.Timestamp
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1037)
    ... 20 more

Original issue reported on code.google.com by felipe.wipe3 on 14 Mar 2011 at 1:26

GoogleCodeExporter commented 9 years ago 
That happens inside the players table, look at the DELETION_DATE column, if it 
has 0000-00-00 then empty it. It should work afterwards.

Original comment by alejsimp...@gmail.com on 14 Mar 2011 at 1:27

GoogleCodeExporter commented 9 years ago 
The Aion Server itself should not make column updates like this. Did you try to 
restore a player manually? Anyway if you want to ignore the error for the 
deletion date apply this fix.

Original comment by ZeroSign...@gmail.com on 15 Mar 2011 at 2:24

Attachments:

GoogleCodeExporter commented 9 years ago 
Thanks zero!

Original comment by felipe.wipe3 on 15 Mar 2011 at 8:46

GoogleCodeExporter commented 9 years ago 
Committed Revision 271.

Original comment by ZeroSign...@gmail.com on 27 Apr 2011 at 2:17