Skip to content

PvE KDA throws an error when it's being tried to access #25

@Jodsderechte

Description

@Jodsderechte

[22:17:42] [ForkJoinPool.commonPool-worker-18/ERROR]: [BattleTracker] Could not prepare statement SELECT * FROM bt_pve_overall ORDER BY CAST(kd_ratio AS REAL) DESC LIMIT ?
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: kd_ratio)

Server Log

Console22:17:42
	at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:46) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:32) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:225) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205) ~[sqlite-jdbc-3.46.1.3.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.util.shaded.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.util.shaded.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.getStatement(SqlSerializer.java:327) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:222) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:206) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:195) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:94) ~[BattleTracker.jar:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
ERROR22:17:42
[BattleTracker]: Could not execute query SELECT * FROM bt_pve_overall ORDER BY CAST(kd_ratio AS REAL) DESC LIMIT ?
Console22:17:42
java.lang.NullPointerException: Cannot invoke "java.sql.PreparedStatement.setQueryTimeout(int)" because "statement" is null
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:223) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:206) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:195) ~[BattleTracker.jar:?]
	at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:94) ~[BattleTracker.jar:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
ERROR22:17:42
[BattleTracker]: Failed to load top records!
Console22:17:42
java.lang.NullPointerException: Cannot invoke "org.battleplugins.tracker.sql.SqlSerializer$ResultSetConnection.rs()" because "connection" is null
	at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:96) ~[BattleTracker.jar:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
Full stack trace:

```
[21:44:46] [ForkJoinPool.commonPool-worker-75/ERROR]: [BattleTracker] Could not prepare statement SELECT * FROM bt_pvp_overall ORDER BY CAST(kd_ratio AS REAL) DESC LIMIT ?

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: kd_ratio)
at org.sqlite.core.DB.newSQLException(DB.java:1179) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.DB.newSQLException(DB.java:1190) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.DB.throwex(DB.java:1150) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.NativeDB.prepare_utf8(Native Method) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.NativeDB.prepare(NativeDB.java:132) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.DB.prepare(DB.java:264) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:46) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:32) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:25) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:225) ~[sqlite-jdbc-3.46.1.3.jar:?]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205) ~[sqlite-jdbc-3.46.1.3.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.util.shaded.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.util.shaded.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.getStatement(SqlSerializer.java:327) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:222) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:206) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:195) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:94) ~[BattleTracker.jar:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
[21:44:46] [ForkJoinPool.commonPool-worker-75/ERROR]: [BattleTracker] Could not execute query SELECT * FROM bt_pvp_overall ORDER BY CAST(kd_ratio AS REAL) DESC LIMIT ?
java.lang.NullPointerException: Cannot invoke "java.sql.PreparedStatement.setQueryTimeout(int)" because "statement" is null
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:223) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:206) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.SqlSerializer.executeQuery(SqlSerializer.java:195) ~[BattleTracker.jar:?]
at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:94) ~[BattleTracker.jar:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
[21:44:46] [ForkJoinPool.commonPool-worker-75/ERROR]: [BattleTracker] Failed to load top records!
java.lang.NullPointerException: Cannot invoke "org.battleplugins.tracker.sql.SqlSerializer$ResultSetConnection.rs()" because "connection" is null
at BattleTracker.jar/org.battleplugins.tracker.sql.TrackerSqlSerializer.lambda$getTopRecords$1(TrackerSqlSerializer.java:96) ~[BattleTracker.jar:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1812) ~[?:?]
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1804) ~[?:?]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458) ~[?:?]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034) ~[?:?]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189) ~[?:?]
```

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions