SQL Contraint Violation

[Ax3dGaming]

Describe the issue

It make impossible to create accounts, it occurs while the creation of an account

Exceptions & Other Logs

02bfbb85ec - Last occurred: 2024-08-15 Occurrences: 6
---- Context 5 ----
Plan v5.5 build 2461
Velocity 3.3.0-SNAPSHOT (git-09f687e5-b413)
Server v3.3.0-SNAPSHOT (git-09f687e5-b413)

Report this, there is an SQL Constraint Violation.
Transaction: class com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction
DB State: OPEN - fatal: false
Error code: 1364
INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,permission_level) VALUES (?,?,?,?)
Constraint Violation

---- Context 4 ----
Plan v5.5 build 2461
Velocity 3.3.0-SNAPSHOT (git-09f687e5-b413)
Server v3.3.0-SNAPSHOT (git-09f687e5-b413)

Report this, there is an SQL Constraint Violation.
Transaction: class com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction
DB State: OPEN - fatal: false
Error code: 1364
INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,permission_level) VALUES (?,?,?,?)
Constraint Violation

---- Context 3 ----
Plan v5.5 build 2461
Velocity 3.3.0-SNAPSHOT (git-09f687e5-b413)
Server v3.3.0-SNAPSHOT (git-09f687e5-b413)

Report this, there is an SQL Constraint Violation.
Transaction: class com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction
DB State: OPEN - fatal: false
Error code: 1364
INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,permission_level) VALUES (?,?,?,?)
Constraint Violation

---- Context 2 ----
Plan v5.5 build 2461
Velocity 3.3.0-SNAPSHOT (git-09f687e5-b413)
Server v3.3.0-SNAPSHOT (git-09f687e5-b413)

Report this, there is an SQL Constraint Violation.
Transaction: class com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction
DB State: OPEN - fatal: false
Error code: 1364
INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,permission_level) VALUES (?,?,?,?)
Constraint Violation

---- Context 1 ----
Plan v5.5 build 2461
Velocity 3.3.0-SNAPSHOT (git-09f687e5-b413)
Server v3.3.0-SNAPSHOT (git-09f687e5-b413)

Report this, there is an SQL grammar error.
Transaction: class com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction
DB State: OPEN - fatal: false
Error code: 1054
INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,permission_level) VALUES (?,?,?,?)
SQL Grammar error

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Unknown column 'permission_level' in 'field list'
   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 'permission_level' in 'field list'
   com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152)
   com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57)
   com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:214)
   com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction.performOperations(StoreWebUserTransaction.java:43)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:348)
   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:347)
   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 'permission_level' in 'field list'
   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.executeUpdateInternal(ClientPreparedStatement.java:1061)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
   plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:214)
   com.djrapitops.plan.storage.database.transactions.commands.StoreWebUserTransaction.performOperations(StoreWebUserTransaction.java:43)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:348)
   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:347)
   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)
   com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:337)
   com.djrapitops.plan.commands.subcommands.RegistrationCommands.registerUser(RegistrationCommands.java:162)
   com.djrapitops.plan.commands.subcommands.RegistrationCommands.registerUsingLegacy(RegistrationCommands.java:137)
   com.djrapitops.plan.commands.subcommands.RegistrationCommands.onRegister(RegistrationCommands.java:104)
   com.djrapitops.plan.commands.use.CommandWithSubcommands.executeCommand(CommandWithSubcommands.java:122)
   com.djrapitops.plan.commands.use.CommandWithSubcommands.onCommand(CommandWithSubcommands.java:99)
   com.djrapitops.plan.commands.use.VelocityCommand.lambda$execute$0(VelocityCommand.java:48)
   com.velocitypowered.proxy.scheduler.VelocityScheduler$VelocityTask.lambda$run$0(VelocityScheduler.java:285)
   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-5.5-build-2461

[AuroraLS3]

You have a 5.6 server installed on the network which has changed database structure in an incompatible way with 5.5 servers - update this server and the error will go away