Exception when storing extension boolean value on MySQL [DEV release]

[AuroraLS3]

Exceptions & Other Logs

72ff831de4 - Last occurred: 2024-03-05 Occurrences: 15
---- Context 5 ----
Plan v5.6 build 2796
Velocity 3.3.0-SNAPSHOT (git-b9b11665-b343)
Server v3.3.0-SNAPSHOT (git-b9b11665-b343)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction
DB State: OPEN - fatal: false
Error code: 1064
SELECT unfulfilled.id FROM plan_extension_providers stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=stored.provided_condition AND stored.plugin_id=unfulfilled.plugin_id WHERE stored.id=(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1) AND stored.provided_condition IS NOT NULL
SQL Grammar error

---- Context 4 ----
Plan v5.6 build 2796
Velocity 3.3.0-SNAPSHOT (git-b9b11665-b343)
Server v3.3.0-SNAPSHOT (git-b9b11665-b343)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction
DB State: OPEN - fatal: false
Error code: 1064
SELECT unfulfilled.id FROM plan_extension_providers stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=CONCAT('not_', stored.provided_condition) AND stored.plugin_id=unfulfilled.plugin_id WHERE stored.id=(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1) AND stored.provided_condition IS NOT NULL
SQL Grammar error

---- Context 3 ----
Plan v5.6 build 2796
Velocity 3.3.0-SNAPSHOT (git-b9b11665-b343)
Server v3.3.0-SNAPSHOT (git-b9b11665-b343)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction
DB State: OPEN - fatal: false
Error code: 1064
SELECT unfulfilled.id FROM plan_extension_providers stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=CONCAT('not_', stored.provided_condition) AND stored.plugin_id=unfulfilled.plugin_id WHERE stored.id=(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1) AND stored.provided_condition IS NOT NULL
SQL Grammar error

---- Context 2 ----
Plan v5.6 build 2796
Velocity 3.3.0-SNAPSHOT (git-b9b11665-b343)
Server v3.3.0-SNAPSHOT (git-b9b11665-b343)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction
DB State: OPEN - fatal: false
Error code: 1064
SELECT unfulfilled.id FROM plan_extension_providers stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=stored.provided_condition AND stored.plugin_id=unfulfilled.plugin_id WHERE stored.id=(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1) AND stored.provided_condition IS NOT NULL
SQL Grammar error

---- Context 1 ----
Plan v5.6 build 2796
Velocity 3.3.0-SNAPSHOT (git-b9b11665-b343)
Server v3.3.0-SNAPSHOT (git-b9b11665-b343)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction
DB State: OPEN - fatal: false
Error code: 1064
SELECT unfulfilled.id FROM plan_extension_providers stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=CONCAT('not_', stored.provided_condition) AND stored.plugin_id=unfulfilled.plugin_id WHERE stored.id=(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1) AND stored.provided_condition IS NOT NULL
SQL Grammar error

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=C' at line 1
   java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
   java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1770)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)
Caused by:
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=C' at line 1
   com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152)
   com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:64)
   com.djrapitops.plan.storage.database.transactions.Transaction.query(Transaction.java:214)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.extractIds(StorePlayerBooleanResultTransaction.java:193)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.selectUnfulfilledProviderIds(StorePlayerBooleanResultTransaction.java:163)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.performOperations(StorePlayerBooleanResultTransaction.java:72)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)
Caused by:
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stored JOIN plan_extension_providers unfulfilled ON unfulfilled.condition_name=C' at line 1
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
   plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:72)
   com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:62)
   com.djrapitops.plan.storage.database.transactions.Transaction.query(Transaction.java:214)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.extractIds(StorePlayerBooleanResultTransaction.java:193)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.selectUnfulfilledProviderIds(StorePlayerBooleanResultTransaction.java:163)
   com.djrapitops.plan.extension.implementation.storage.transactions.results.StorePlayerBooleanResultTransaction.performOperations(StorePlayerBooleanResultTransaction.java:72)
... (25 lines left)