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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions