Moin Stefan,
beim durchsehen des Logs vom Bot ist mir dies aufgefallen was schon etwas gespamt wird.
2019-11-14 22:29:22 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-14 22:29:22 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-14 22:29:22 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)
Gruß
Eiki
Einmal die komplette Bot Log über das Webinterface löschen.
Jo hab ich gemacht mal gucken wie sich das jetzt verhält.
Hatte das ja alles gelöscht als ich jetzt wieder nachgeschaut habe ist es wieder drin.
2019-11-15 14:19:50 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 14:19:50 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)
2019-11-15 14:19:50 LOGGER_SQL_ERROR Try to reconnect to MySQL server...
2019-11-15 14:19:50 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-15 14:19:50 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 14:19:50 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xF0\x9F\x90\x8D\xF0\x9F...' for column `tsbot`.`jts3servermod_log`.`message` at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.t.a(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.teamspeakActionPerformed(Unknown Source)
at de.stefan1200.jts3serverquery.JTS3ServerQuery$2.run(Unknown Source)
at java.base/java.lang.Thread.run(Thread.java:834)
2019-11-15 15:19:38 LOGGER_SQL_CONNECT Successfully connected to MySQL server for logging!
2019-11-15 15:25:26 LOGGER_SQL_ERROR Critical: Cannot write log entry to MySQL server!
2019-11-15 15:25:26 JTS3ServerMod 6.5.5 Hosting Edition (27.01.2019): EXCEPTION
Vermutlich ein Channel oder Client Namen, der ins Log geschrieben wird, dass die verwendete Tabellen Collation nicht unterstützt. Gerne mal eine andere UTF8 Collation für die Log Tabelle probieren.
Nutz die Collation utf8mb4_unicode_ci
Das Problem sind die Emoji's die man mittlerweile in Client oder Channel Namen verwenden kann, habs schon bei nem anderen Bot gehabt, dadurch ist mir das dann auch aufgefallen.