#b42 multiplayer server crashes because of SQLITE tables

3 messages · Page 1 of 1 (latest)

calm zealot
#
ERROR: General      f:0, t:1765642352467, st:146,359,552> 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)
Exception in thread "main" LOG  : General      f:0, t:1765642352472, st:146,359,557> java.lang.RuntimeException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: role)
LOG  : General      f:0, t:1765642352473, st:146,359,558>     at zombie.network.ServerWorldDatabase.loadRoles(ServerWorldDatabase.java:904)
LOG  : General      f:0, t:1765642352473, st:146,359,558>     at zombie.characters.Roles.init(Roles.java:36)
LOG  : General      f:0, t:1765642352473, st:146,359,558>     at zombie.network.GameServer.main(GameServer.java:742)
LOG  : General      f:0, t:1765642352473, st:146,359,558> Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: role)
LOG  : General      f:0, t:1765642352473, st:146,359,559>     at org.sqlite.core.DB.newSQLException(DB.java:1179)
LOG  : General      f:0, t:1765642352474, st:146,359,559>     at org.sqlite.core.DB.newSQLException(DB.java:1190)
LOG  : General      f:0, t:1765642352474, st:146,359,559>     at org.sqlite.core.DB.throwex(DB.java:1150)
LOG  : General      f:0, t:1765642352475, st:146,359,560>     at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
LOG  : General      f:0, t:1765642352475, st:146,359,560>     at org.sqlite.core.NativeDB.prepare(NativeDB.java:135)
LOG  : General      f:0, t:1765642352475, st:146,359,560>     at org.sqlite.core.DB.prepare(DB.java:264)
LOG  : General      f:0, t:1765642352475, st:146,359,561>     at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:46)
LOG  : General      f:0, t:1765642352476, st:146,359,561>     at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:32)
LOG  : General      f:0, t:1765642352476, st:146,359,561>     at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25)
LOG  : General      f:0, t:1765642352476, st:146,359,561>     at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34)
LOG  : General      f:0, t:1765642352476, st:146,359,561>     at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:225)
LOG  : General      f:0, t:1765642352476, st:146,359,562>     at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
LOG  : General      f:0, t:1765642352477, st:146,359,562>     at zombie.network.ServerWorldDatabase.loadRoles(ServerWorldDatabase.java:859)
LOG  : General      f:0, t:1765642352477, st:146,359,562>     ... 2 more
LOG  : General      f:0, t:1765642352478, st:146,359,563> Shutdown handling started
LOG  : Network      f:0, t:1765642352479, st:146,359,564> Server exited

this is a clean install, so I assume the server should had created the tables accordingly.

harsh harness
#

Go to “%UserProfile%\Zomboid” and delete the "db" folder.

spiral ember
#

when you first started it did it ask you to set a new password forthe new database?
if not, could it be trying to open an existing one?