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
, 4 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
, 4 months 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)
org.mariadb.jdbc.internal.util.dao.QueryException: 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 tip

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