java.sql.SQLSyntaxErrorException: Error preparing query: Table 'projectworlds.settings' doesn't exist

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by rockmacaca
, 1 year ago
Error preparing query: Table 'projectworlds.settings' doesn't exist
via GitHub by jtwebman
, 1 year ago
Table 'rancher.setting' doesn't exist
via GitHub by CalumMcCall
, 2 months ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 Query is : insert into `AutoInstall` (`namespace`,`pkg_name`,`device`) values ('default','ss','dec7388e-4466-428f-8f8a-4999f5ddbe45') on duplicate key update
via GitHub by StuAtGit
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '5 on duplicate key update counter = counter +' at line 1 Query is : insert into test_jdbi_bug (id, data, counters) values (1,'test',1)5 on duplicate key update counter = counter +
via Stack Overflow by Arkadiy Verman
, 1 month ago
Table 'hive.COMPLETED_COMPACTIONS' doesn't exist
via GitHub by cartman-2000
, 1 year ago
Specified key was too long; max key length is 767 bytes Query is : CREATE TABLE IF NOT EXISTS MUTES (UUID VARCHAR(256) PRIMARY KEY NOT NULL)
java.sql.SQLSyntaxErrorException: Error preparing query: Table 'projectworlds.settings' doesn't exist
at org.mariadb.jdbc.internal.packet.ComStmtPrepare.read(ComStmtPrepare.java:106)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.prepareAndExecute(AbstractQueryProtocol.java:510)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:365)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:323)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQuery(MariaDbServerPreparedStatement.java:304)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.gmail.trentech.pji.sql.SQLSettings.getWorld(SQLSettings.java:31)
at com.gmail.trentech.pji.EventManager.onLoadWorldEvent(EventManager.java:110)
at org.spongepowered.common.event.listener.LoadWorldEventListener_EventManager_onLoadWorldEvent55.handle(Unknown Source)
at org.spongepowered.common.event.RegisteredListener.handle(RegisteredListener.java:95)
at org.spongepowered.common.event.SpongeEventManager.post(SpongeEventManager.java:305)
at org.spongepowered.common.event.SpongeEventManager.post(SpongeEventManager.java:320)
at org.spongepowered.common.SpongeImpl.postEvent(SpongeImpl.java:140)
at org.spongepowered.common.world.WorldManager.createWorldFromProperties(WorldManager.java:813)
at org.spongepowered.common.world.WorldManager.loadAllWorlds(WorldManager.java:755)
at net.minecraft.server.MinecraftServer.func_71247_a(SourceFile:320)
at net.minecraft.server.dedicated.DedicatedServer.func_71197_b(SourceFile:228)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.