[FIXED] B42 Multiplayer - Host Error: SQLiteException - No Mods

[Ator]

Hi,

While trying to use the "Host" option inside the gme or the "Project Zomboid Dedicated Server" i receive an error.

Prior to this error, i had another error that mentioned 1 mod. I unsubscribe from that mod and the error disappeared.

Now the error seems more serious and i dont know what to do:

[11-12-25 08:00:46.000] LOG : General f:0, t:1765450846000, st:92.788.789> SteamUtils initialised successfully.
[11-12-25 08:00:47.013] LOG : General f:0, t:1765450847013, st:92.789.802> LightingFPS set to 15.
[11-12-25 08:00:47.081] LOG : General f:0, t:1765450847081, st:92.789.871> Waiting for response from Steam servers.
[11-12-25 08:00:49.345] ERROR: General f:0, t:1765450849345, st:92.792.134> GameServer.main> Exception thrown
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (table [whitelist_new] already exists) at DB.newSQLException(DB.java:1179). Message:
Stack trace:
org.sqlite.core.DB.newSQLException(DB.java:1179)
org.sqlite.core.DB.newSQLException(DB.java:1190)
org.sqlite.core.DB.throwex(DB.java:1150)
org.sqlite.core.NativeDB._exec_utf8(Native Method)
org.sqlite.core.NativeDB._exec(NativeDB.java:99)
org.sqlite.jdbc3.JDBC3Statement.lambda$executeLargeUpdate$2(JDBC3Statement.java:139)
org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:458)
org.sqlite.jdbc3.JDBC3Statement.executeLargeUpdate(JDBC3Statement.java:126)
org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:113)
zombie.network.ServerWorldDatabase.create(ServerWorldDatabase.java:454)
zombie.network.GameServer.main(GameServer.java:737)
.
[11-12-25 08:00:49.348] LOG : General f:0, t:1765450849348, st:92.792.138> Exception in thread "main" .
[11-12-25 08:00:49.349] LOG : General f:0, t:1765450849349, st:92.792.138> java.lang.RuntimeException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: role).
[11-12-25 08:00:49.349] LOG : General f:0, t:1765450849349, st:92.792.138> at zombie.network.ServerWorldDatabase.loadRoles(ServerWorldDatabase.java:904).
[11-12-25 08:00:49.349] LOG : General f:0, t:1765450849349, st:92.792.139> at zombie.characters.Roles.init(Roles.java:36).
[11-12-25 08:00:49.350] LOG : General f:0, t:1765450849350, st:92.792.139> at zombie.network.GameServer.main(GameServer.java:742).
[11-12-25 08:00:49.350] LOG : General f:0, t:1765450849350, st:92.792.139> Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: role).
[11-12-25 08:00:49.350] LOG : General f:0, t:1765450849350, st:92.792.139> at org.sqlite.core.DB.newSQLException(DB.java:1179).
[11-12-25 08:00:49.350] LOG : General f:0, t:1765450849350, st:92.792.140> at org.sqlite.core.DB.newSQLException(DB.java:1190).
[11-12-25 08:00:49.351] LOG : General f:0, t:1765450849351, st:92.792.140> at org.sqlite.core.DB.throwex(DB.java:1150).
[11-12-25 08:00:49.351] LOG : General f:0, t:1765450849351, st:92.792.140> at org.sqlite.core.NativeDB.prepare_utf8(Native Method).
[11-12-25 08:00:49.351] LOG : General f:0, t:1765450849351, st:92.792.140> at org.sqlite.core.NativeDB.prepare(NativeDB.java:135).
[11-12-25 08:00:49.351] LOG : General f:0, t:1765450849351, st:92.792.140> at org.sqlite.core.DB.prepare(DB.java:264).
[11-12-25 08:00:49.351] LOG : General f:0, t:1765450849351, st:92.792.141> at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:46).
[11-12-25 08:00:49.352] LOG : General f:0, t:1765450849352, st:92.792.141> at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:32).
[11-12-25 08:00:49.352] LOG : General f:0, t:1765450849352, st:92.792.141> at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25).
[11-12-25 08:00:49.352] LOG : General f:0, t:1765450849352, st:92.792.141> at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34).
[11-12-25 08:00:49.352] LOG : General f:0, t:1765450849352, st:92.792.142> at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:225).
[11-12-25 08:00:49.353] LOG : General f:0, t:1765450849353, st:92.792.142> at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205).
[11-12-25 08:00:49.353] LOG : General f:0, t:1765450849353, st:92.792.142> at zombie.network.ServerWorldDatabase.loadRoles(ServerWorldDatabase.java:859).
[11-12-25 08:00:49.353] LOG : General f:0, t:1765450849353, st:92.792.142> ... 2 more.
[11-12-25 08:00:49.354] LOG : General f:0, t:1765450849354, st:92.792.143> Shutdown handling started.
[11-12-25 08:00:49.354] LOG : Network f:0, t:1765450849354, st:92.792.143> Server exited.
[11-12-25 08:00:49.355] LOG : General f:0, t:1765450849355, st:92.792.145> Exception in thread "Thread-0" .
[11-12-25 08:00:49.356] LOG : General f:0, t:1765450849355, st:92.792.145> java.lang.NullPointerException: Cannot invoke "zombie.iso.IsoMetaGrid.save()" because "this.grid" is null.
[11-12-25 08:00:49.356] LOG : General f:0, t:1765450849356, st:92.792.145> at zombie.network.ServerMap.SaveAll(ServerMap.java:75).
[11-12-25 08:00:49.356] LOG : General f:0, t:1765450849356, st:92.792.146> at zombie.network.ServerMap.QueuedSaveAll(ServerMap.java:696).
[11-12-25 08:00:49.356] LOG : General f:0, t:1765450849356, st:92.792.146> at zombie.network.ServerMap.QueuedQuit(ServerMap.java:664).
[11-12-25 08:00:49.356] LOG : General f:0, t:1765450849356, st:92.792.146> at zombie.network.GameServer$1.run(GameServer.java:374).

[Ator]

I tried deleting the servertest.ini files but it gets created with default settings and the error is the same.

[Ator]

Ok. I delete all files inside the the database folder (C:\Users\username\Zomboid\db) and is working

Regards

[Kaxology]

I have the same problem and can confirm this works, thanks

[Usmail]

Thanks a lot for this post. I had the same situation when adding multiplayer to the game.

[Solehyperion]

This was exactly the answer I was looking for. Thank you so much