Prism - problém s DB

[Szarik95]

Zdravím,
testuji plugin Prism a vše funguje, pouze vykazuje chybu při použití nástroje inspect. Odkazuje na funkci v MySQL "any_value"
Rád bych se svým serverem přešel na verzi 1.15.2 i s tímto pluginem a potřebuji, aby fungoval.

Spoiler: zobrazit

[12:58:37 ERROR]: [Prism] Database connection error: FUNCTION 219260_mysql_db.any_value does not exist
[12:58:37 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION 219260_mysql_db.any_value does not exist
[12:58:37 WARN]: at sun.reflect.GeneratedConstructorAccessor79.newInstance(Unknown Source)
[12:58:37 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[12:58:37 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[12:58:37 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[12:58:37 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[12:58:37 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[12:58:37 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
[12:58:37 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
[12:58:37 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
[12:58:37 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
[12:58:37 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
[12:58:37 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
[12:58:37 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
[12:58:37 WARN]: at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[12:58:37 WARN]: at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[12:58:37 WARN]: at me.botsko.prism.database.sql.SQLSelectQueryBuilder.executeSelect(SQLSelectQueryBuilder.java:517)
[12:58:37 WARN]: at me.botsko.prism.actionlibs.ActionsQuery.lookup(ActionsQuery.java:81)
[12:58:37 WARN]: at me.botsko.prism.commands.NearCommand.lambda$handle$0(NearCommand.java:76)
[12:58:37 WARN]: at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftTask.run(CraftTask.java:84)
[12:58:37 WARN]: at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:54)
[12:58:37 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[12:58:37 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[12:58:37 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[12:58:37 WARN]: at java.lang.Thread.run(Unknown Source)
[13:02:18 INFO]: [Prism]: [InternalAffairs] Recorder is NOT active... checking database
[13:02:18 INFO]: [Prism]: [InternalAffairs] Pool returned NULL instead of a valid connection.

[nejento]

Problém je v tom, že se Prism snaží používat funkci novější verze MySQL databáze, kterou Doplňková služba MySQL nemá, jelikož je provozovaná na verzi 5.6.x. Buď bude potřeba zvolit jiný způsob ukládání dat pro Prism, nebo si vytvořit vlastní databázi.