Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Help needed with MySQL issue. #138

Open
RealTriassic opened this issue Sep 28, 2022 · 0 comments
Open

Help needed with MySQL issue. #138

RealTriassic opened this issue Sep 28, 2022 · 0 comments

Comments

@RealTriassic
Copy link

I am having an issue when voting. NuVotifier successfully passes the vote from the proxy server to backend, but when SuperbVote tries to give the player their rewards, it runs into a MySQL error for some reason despite never having manually changed anything in the database.

The error:

[10:20:36 WARN]: [SuperbVote] Plugin SuperbVote v0.5.5 generated an exception while executing task 11612
java.lang.RuntimeException: Unable to add vote for 135cf9c3-b3b4-4957-9ea8-288181d1c47c
        at io.minimum.minecraft.superbvote.storage.MysqlVoteStorage.addVote(MysqlVoteStorage.java:157) ~[SuperbVote-0.5.5.jar:?]
        at io.minimum.minecraft.superbvote.votes.SuperbVoteListener.processVote(SuperbVoteListener.java:105) ~[SuperbVote-0.5.5.jar:?]
        at io.minimum.minecraft.superbvote.votes.SuperbVoteListener.lambda$onVote$0(SuperbVoteListener.java:72) ~[SuperbVote-0.5.5.jar:?]
        at org.bukkit.craftbukkit.v1_19_R1.scheduler.CraftTask.run(CraftTask.java:101) ~[purpur-1.19.2.jar:git-Purpur-1796]
        at org.bukkit.craftbukkit.v1_19_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[purpur-1.19.2.jar:git-Purpur-1796]
        at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[purpur-1.19.2.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
        at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: java.sql.SQLException: Syntax error in JSON path in argument 2 to function 'json_set' at position 18
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) ~[mysql-connector-java-8.0.29.jar:8.0.29]
        at io.minimum.minecraft.superbvote.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[SuperbVote-0.5.5.jar:?]
        at io.minimum.minecraft.superbvote.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[SuperbVote-0.5.5.jar:?]
        at io.minimum.minecraft.superbvote.storage.MysqlVoteStorage.addVote(MysqlVoteStorage.java:152) ~[SuperbVote-0.5.5.jar:?]
        ... 8 more

If anybody has any idea how to fix this, thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant