Skip to content

SQL error for World name with spaces #244

@KenRen98

Description

@KenRen98

Plugin Version:
3.6.13

Describe The Bug:
SQL Error with world name that has spaces in between

How To Reproduce:
A world that has name with spaces in between

Expected Behavior:
SQL Error in log

Screenshots/Error Log:

[03:51:01 ERROR]: [BetterRTP] Unable to retrieve connection
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "Server": syntax error)
        at org.sqlite.core.DB.newSQLException(DB.java:1179) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.DB.newSQLException(DB.java:1190) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.DB.throwex(DB.java:1150) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.NativeDB.prepare_utf8(Native Method) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.NativeDB.prepare(NativeDB.java:126) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.DB.prepare(DB.java:264) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:46) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:32) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:206) ~[sqlite-jdbc-3.41.2.2.jar:?]
        at me.SuperRonanCraft.BetterRTP.references.database.SQLite.initialize(SQLite.java:214) ~[BetterRTP-3.6.13.jar:?]
        at me.SuperRonanCraft.BetterRTP.references.database.SQLite.lambda$load$0(SQLite.java:98) ~[BetterRTP-3.6.13.jar:?]
        at me.SuperRonanCraft.BetterRTP.versions.AsyncHandler.lambda$async$0(AsyncHandler.java:11) ~[BetterRTP-3.6.13.jar:?]
        at me.SuperRonanCraft.BetterRTP.lib.folialib.impl.SpigotImplementation.lambda$runAsync$1(SpigotImplementation.java:51) ~[BetterRTP-3.6.13.jar:?]
        at org.bukkit.craftbukkit.v1_19_R3.scheduler.CraftTask.run(CraftTask.java:103) ~[paper-1.19.4.jar:git-Paper-550]
        at org.bukkit.craftbukkit.v1_19_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.19.4.jar:git-Paper-550]
        at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.19.4.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
        at java.lang.Thread.run(Thread.java:840) ~[?:?]

Additional Context:
Just need to add single quote in code caller for db. Thanks man!

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions