net.avicus.quest.database.DatabaseException

tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • GitHub comment 182#122852154
    via GitHub by rasalbatros
    ,
    • net.avicus.quest.database.DatabaseException: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. at net.avicus.quest.model.ModelList.addRows(ModelList.java:31) at net.avicus.quest.model.ModelSelect.execute(ModelSelect.java:66) at net.avicus.hook.mysql.table.SessionTable.findLatest(SessionTable.java:19) at net.avicus.hook.friends.FriendCommands$1.run(FriendCommands.java:44) at net.avicus.hook.utils.Task$1.run(Task.java:91) at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:59) at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1337) at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127) at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6754) at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6073) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5029) at net.avicus.quest.query.Row.<init>(Row.java:18) at net.avicus.quest.model.ModelList.addRows(ModelList.java:29) ... 9 more Caused by: java.sql.SQLException: Value '[B@300710b6' can not be represented as java.sql.Timestamp at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1035) ... 15 more

    Users with the same issue

    mortalman7mortalman7
    1 times, last one,
    linxiaolonglinxiaolong
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    ivanszkypeterivanszkypeter
    490 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    146 more bugmates