Skip to content

Velocity OperationExceptiom #4601

@Volcar144

Description

@Volcar144

Describe the issue

Report this, there is an SQL grammar error.

Exceptions & Other Logs

4b5e7dd2de - Last occurred: 2026-04-25 Occurrences: 1
---- Context 1 ----
Plan v5.7 build 3306
Velocity 3.5.0-SNAPSHOT (git-7e01491e-b574)
Server v3.5.0-SNAPSHOT (git-7e01491e-b574)

Report this, there is an SQL grammar error.
Error code: 1146
SELECT username FROM plan_security
SQL Grammar error

---- Stacktrace ----
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Table 'plan.plan_security' doesn't exist
   com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:160)
   com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:64)
   com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   com.djrapitops.plan.storage.database.SQLDB.lambda$query$0(SQLDB.java:293)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:293)
   com.djrapitops.plan.storage.database.Database.queryCollection(Database.java:85)
   com.djrapitops.plan.storage.database.Database.queryList(Database.java:77)
   com.djrapitops.plan.storage.database.queries.objects.WebUserQueries.lambda$fetchAllUsernames$0(WebUserQueries.java:211)
   com.djrapitops.plan.storage.database.SQLDB.lambda$query$0(SQLDB.java:293)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:293)
   com.djrapitops.plan.commands.TabCompleteCache.refreshUserIdentifiers(TabCompleteCache.java:103)
   com.djrapitops.plan.commands.TabCompleteCache.lambda$enable$0(TabCompleteCache.java:79)
   com.djrapitops.plan.processing.Processing.lambda$submitNonCritical$0(Processing.java:85)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
java.sql.SQLSyntaxErrorException: Table 'plan.plan_security' doesn't exist
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1058)
   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.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   com.djrapitops.plan.storage.database.SQLDB.lambda$query$0(SQLDB.java:293)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:293)
   com.djrapitops.plan.storage.database.Database.queryCollection(Database.java:85)
   com.djrapitops.plan.storage.database.Database.queryList(Database.java:77)
   com.djrapitops.plan.storage.database.queries.objects.WebUserQueries.lambda$fetchAllUsernames$0(WebUserQueries.java:211)
   com.djrapitops.plan.storage.database.SQLDB.lambda$query$0(SQLDB.java:293)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:293)
   com.djrapitops.plan.commands.TabCompleteCache.refreshUserIdentifiers(TabCompleteCache.java:103)
   com.djrapitops.plan.commands.TabCompleteCache.lambda$enable$0(TabCompleteCache.java:79)
   com.djrapitops.plan.processing.Processing.lambda$submitNonCritical$0(Processing.java:85)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
   java.base/java.lang.Thread.run(Thread.java:1583)

Plugin versions

Velocity Latest

Additional information

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugIssues that contain unintended behavior

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions