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

error reported in console #3368

Closed
tgoetzjr opened this issue Dec 17, 2023 · 1 comment
Closed

error reported in console #3368

tgoetzjr opened this issue Dec 17, 2023 · 1 comment
Labels
Bug Issues that contain unintended behavior

Comments

@tgoetzjr
Copy link

Describe the issue

in console:
[01:01:47 ERROR]: [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-8446086f7f.txt
[01:01:47 ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[01:01:47 ERROR]: [Plan] What to do: Report this, there is an SQL grammar error.

Exceptions & Other Logs

8446086f7f - Last occurred: 2023-12-17 Occurrences: 115
---- Context 5 ----
Plan v5.6 build 2614
Purpur git-Purpur-2076 (MC: 1.20.2)
Server v1.20.2-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1054
DELETE FROM plan_economy_tracker WHERE uuid=?
SQL Grammar error

---- Context 4 ----
Plan v5.6 build 2614
Purpur git-Purpur-2076 (MC: 1.20.2)
Server v1.20.2-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1054
DELETE FROM plan_economy_tracker WHERE uuid=?
SQL Grammar error

---- Context 3 ----
Plan v5.6 build 2614
Purpur git-Purpur-2076 (MC: 1.20.2)
Server v1.20.2-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1054
DELETE FROM plan_economy_tracker WHERE uuid=?
SQL Grammar error

---- Context 2 ----
Plan v5.6 build 2614
Purpur git-Purpur-2076 (MC: 1.20.2)
Server v1.20.2-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1054
DELETE FROM plan_economy_tracker WHERE uuid=?
SQL Grammar error

---- Context 1 ----
Plan v5.6 build 2614
Purpur git-Purpur-2076 (MC: 1.20.2)
Server v1.20.2-R0.1-SNAPSHOT

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1054
DELETE FROM plan_economy_tracker WHERE uuid=?
SQL Grammar error

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Unknown column 'uuid' in 'where clause'
   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: Unknown column 'uuid' in 'where clause'
   Plan-5.6-build-2614.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.queries.QueryAPIExecutable.execute(QueryAPIExecutable.java:48)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.query.QuerySvc$1.performOperations(QuerySvc.java:90)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:353)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:352)
   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: Unknown column 'uuid' in 'where clause'
   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.execute(ClientPreparedStatement.java:354)
   Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
   Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
   Economy-Analytics-1.0-SNAPSHOT.jar//me.simon44556.economyAnalytics.PlanQueryProvider.PlanQueryProvider.lambda$removePlayer$0(PlanQueryProvider.java:37)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.queries.QueryAPIExecutable.execute(QueryAPIExecutable.java:44)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.query.QuerySvc$1.performOperations(QuerySvc.java:90)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:353)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:352)
   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)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:342)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.query.QuerySvc.execute(QuerySvc.java:86)
   Economy-Analytics-1.0-SNAPSHOT.jar//me.simon44556.economyAnalytics.PlanQueryProvider.PlanQueryProvider.removePlayer(PlanQueryProvider.java:33)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.query.QuerySvc.lambda$playerRemoved$0(QuerySvc.java:109)
   java.base/java.lang.Iterable.forEach(Iterable.java:75)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.query.QuerySvc.playerRemoved(QuerySvc.java:107)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.upkeep.DBCleanTask.cleanOldPlayers(DBCleanTask.java:171)
   Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.upkeep.DBCleanTask.run(DBCleanTask.java:117)
   Plan-5.6-build-2614.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   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)

Plugin versions

Plan v5.6 build 2614

Additional information

server is survival slimefun at zero-bit.tech, I took over the server for Zeromaniac

@tgoetzjr tgoetzjr added the Bug Issues that contain unintended behavior label Dec 17, 2023
@AuroraLS3
Copy link
Collaborator

plan_economy_tracker

This is an SQL error caused by 3rd party plugin interacting with the Plan API

A column it is expecting doesn't exist in the selected column list of the SQL query at Economy-Analytics-1.0-SNAPSHOT.jar//me.simon44556.economyAnalytics.PlanQueryProvider.PlanQueryProvider.removePlayer(PlanQueryProvider.java:33)

@AuroraLS3 AuroraLS3 closed this as not planned Won't fix, can't repro, duplicate, stale Dec 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Issues that contain unintended behavior
Projects
None yet
Development

No branches or pull requests

2 participants