Skip to content

Getting errors in console when trying to warn #668

@Sheena413

Description

@Sheena413

I apologize in advance if this is a me thing. The error I received in my console told me to come here and report the issue. I just tried warning an offline player but am not able to. I feel like I used to be able to do that and that that is why I have this plugin, but I could be wrong, so I apologize if this plugin does not support offline warns. Any information is absolutely appreciated. Thank you so much for your time in advance! Here is the error I get when I issue an offline warn:

What the console shows:

[18:58:45 INFO]: Sheena5920 issued server command: /warn thorin330 For looting and gathering in Tartaria. Please use the resource worlds by doing /wild and choosing the options on the RIGHT. Please read /rules.
[18:58:45 INFO]: [AdvancedBan] An unexpected error has occurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report this error in: https://github.com/DevLeoko/AdvancedBan/issues
[18:58:45 INFO]: [AdvancedBan] An unexpected error has occurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report this error in: https://github.com/DevLeoko/AdvancedBan/issues
[18:58:45 INFO]: [AdvancedBan] !! Not able to update ID of punishment! Please restart the server to resolve this issue!
[18:58:45 INFO]: [AdvancedBan] !! Failed at: Punishment(name=thorin330, uuid=408d6acdc8834d1f9994a0de1bb56c4c, operator=Sheena5920, calculation=, start=1769885925295, end=-1, type=WARNING, reason=For looting and gathering in Tartaria. Please use the resource worlds by doing /wild and choosing the options on the RIGHT. Please read /rules., id=-1)

The Latest Log from AdvancedBan:

[18:58:45] An unexpected error has occurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report this error in: https://github.com/DevLeoko/AdvancedBan/issues
[18:58:45] Query:
INSERT INTO PunishmentHistory (name, uuid, reason, operator, punishmentType, start, end, calculation) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[18:58:45] java.sql.SQLDataException: data exception: string data, right truncation; table: PUNISHMENTHISTORY column: REASON
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:122)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:107)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:92)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Punishment.create(Punishment.java:81)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Punishment.create(Punishment.java:46)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.commands.PunishmentProcessor.accept(PunishmentProcessor.java:73)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.commands.PunishmentProcessor.accept(PunishmentProcessor.java:19)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Command.execute(Command.java:552)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.CommandManager.lambda$onCommand$0(CommandManager.java:46)
at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:78)
at org.bukkit.craftbukkit.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: me.leoko.advancedban.shaded.org.hsqldb.HsqlException: data exception: string data, right truncation; table: PUNISHMENTHISTORY column: REASON
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.enforceTypeLimits(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.generateAndCheckData(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.insertSingleRow(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementInsert.getResult(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementDMQL.execute(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Session.execute(Unknown Source)
... 19 more
Caused by: me.leoko.advancedban.shaded.org.hsqldb.HsqlException: data exception: string data, right truncation
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source)
... 27 more

[18:58:45] An unexpected error has occurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report this error in: https://github.com/DevLeoko/AdvancedBan/issues
[18:58:45] Query:
INSERT INTO Punishments (name, uuid, reason, operator, punishmentType, start, end, calculation) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[18:58:45] java.sql.SQLDataException: data exception: string data, right truncation; table: PUNISHMENTS column: REASON
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:122)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:107)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.DatabaseManager.executeStatement(DatabaseManager.java:92)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Punishment.create(Punishment.java:85)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Punishment.create(Punishment.java:46)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.commands.PunishmentProcessor.accept(PunishmentProcessor.java:73)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.commands.PunishmentProcessor.accept(PunishmentProcessor.java:19)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.utils.Command.execute(Command.java:552)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.manager.CommandManager.lambda$onCommand$0(CommandManager.java:46)
at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:78)
at org.bukkit.craftbukkit.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: me.leoko.advancedban.shaded.org.hsqldb.HsqlException: data exception: string data, right truncation; table: PUNISHMENTS column: REASON
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.enforceTypeLimits(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.generateAndCheckData(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Table.insertSingleRow(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementInsert.getResult(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.StatementDMQL.execute(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.Session.execute(Unknown Source)
... 19 more
Caused by: me.leoko.advancedban.shaded.org.hsqldb.HsqlException: data exception: string data, right truncation
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.error.Error.error(Unknown Source)
at AdvancedBan-Bundle-2.3.0-RELEASE.jar//me.leoko.advancedban.shaded.org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source)
... 27 more

[18:58:45] !! Not able to update ID of punishment! Please restart the server to resolve this issue!
[18:58:45] !! Failed at: Punishment(name=thorin330, uuid=408d6acdc8834d1f9994a0de1bb56c4c, operator=Sheena5920, calculation=, start=1769885925295, end=-1, type=WARNING, reason=For looting and gathering in Tartaria. Please use the resource worlds by doing /wild and choosing the options on the RIGHT. Please read /rules., id=-1)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions