Cannot join lan dedicated server(banned)/SQL error when attempting to unban myself.

Store Page

Project Zomboid

All Discussions Screenshots Artwork Broadcasts Videos Workshop News Guides Reviews

Project Zomboid > Support > Topic Details

MAESA

Feb 23, 2022 @ 11:57pm

Cannot join lan dedicated server(banned)/SQL error when attempting to unban myself.

I've pretty much gotten the server to run and it has java running idle at about a gig of ram. Whenever I try and join, it says I'm banned. When I try and "unbanuser" myself, there's a ton of ERROR: General, finishing with an SQL error. I've reinstalled it two times, and the harddrive it's on has 18gbs of free space still left on it.

LOG : General , 1645688978943> 3,882,634> WorldDictionary: Checking diction ary... LOG : General , 1645688978995> 3,882,686> Loading WorldDictionary:C:\Users\ M3SA_server\Zomboid\Saves\Multiplayer\\M3SA'sDomain\WorldDictionary.bin LOG : General , 1645688979649> 3,883,340> IsoMetaGrid.Create: finished load ing in 3.802 seconds LOG : General , 1645688979667> 3,883,358> Calculate weather front strength = 0.21491052 LOG : General , 1645688979692> 3,883,383> Calculate weather front strength = 0.8426067 LOG : General , 1645688979698> 3,883,389> Calculate weather front strength = 0.09861678 LOG : General , 1645688979708> 3,883,399> Calculate weather front strength = 0.33777252 LOG : General , 1645688979716> 3,883,407> Calculate weather front strength = 0.70455956 LOG : General , 1645688979721> 3,883,412> Calculate weather front strength = 0.46010733 LOG : General , 1645688979729> 3,883,420> Calculate weather front strength = 0.8439923 LOG : General , 1645688979736> 3,883,427> Calculate weather front strength = 0.56354237 LOG : Lua , 1645688979742> 3,883,433> Loading: media/maps/Muldraugh, KY /objects.lua LOG : General , 1645688983199> 3,886,891> loading 19695 zones from map_zone .bin LOG : General , 1645688983446> 3,887,137> Max #ZONES on one chunk is 19 LOG : General , 1645688983697> 3,887,388> reanimate: loaded 0 zombies LOG : Network , 1645688983875> 3,887,566> Initialising RakNet... LOG : General , 1645688983876> 3,887,567> 1645688983876 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_Init LOG : General , 1645688983877> 3,887,569> 1645688983877 znet: g_peer = 0x27 02cb30 LOG : General , 1645688983879> 3,887,570> 1645688983879 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_SetMaximumIncomingConnections LOG : General , 1645688983880> 3,887,572> 1645688983880 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_SetServerPort LOG : General , 1645688983882> 3,887,574> 1645688983882 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_SetIncomingPassword LOG : General , 1645688983884> 3,887,575> 1645688983884 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_SetOccasionalPing LOG : General , 1645688983885> 3,887,576> 1645688983885 znet: Java_zombie_c ore_raknet_RakNetPeerInterface_Startup LOG : General , 1645688983886> 3,887,578> 1645688983886 znet: Zomboid Steam Server started, ports 8766 and 16261 must be open on the router LOG : General , 1645688983901> 3,887,592> 1645688983901 znet: OnRakPeerStar tup LOG : General , 1645688983903> 3,887,594> 1645688983903 znet: RakNet-throug h-Steam mode activated LOG : Network , 1645688983907> 3,887,599> RakNet.Startup() return code: 0 ( 0 means success) LOG : General , 1645688983910> 3,887,602> [VOICE MANAGER] VoiceInit LOG : General , 1645688983913> 3,887,604> 1645688983913 znet: Java_zombie_c ore_raknet_RakVoice_RVInitServer LOG : General , 1645688983915> 3,887,606> 1645688983915 znet: g_peer = 0x27 02cb30 LOG : Network , 1645688983918> 3,887,609> *** SERVER STARTED **** LOG : Network , 1645688983919> 3,887,610> *** Steam is enabled LOG : Network , 1645688983921> 3,887,612> server is listening on port [REDACTED] LOG : General , 1645688983923> 3,887,614> LuaNet: Initializing... LOG : General , 1645688983925> 3,887,617> LuaNet: Registering server listen er... LOG : General , 1645688983927> 3,887,619> LuaNet: Initialization [DONE], tr iggering events for 'LuaNet.onInitAdd'. LOG : Network , 1645688983929> 3,887,621> DISCORD: token not configured LOG : Network , 1645688983931> 3,887,622> *** DISCORD DISABLED **** LOG : General , 1645688983932> 3,887,624> ########## Server Steam ID [REDACTED] ########## LOG : General , 1645688986021> 3,889,712> 1645688986021 znet: OnPolicyRespo nse LOG : General , 1645688986022> 3,889,713> 1645688986022 znet: Zomboid Serve r is VAC Secure unbanuser M3SA LOG : General , 1645689040513> 3,944,203> unbanuser M3SA ERROR: General , 1645689040541> 3,944,232> org.sqlite.SQLiteException: [SQLI TE_ERROR] SQL error or missing database (no such table: whitelist) ERROR: General , 1645689040543> 3,944,233> at org.sqlite.core.DB.newSQLExce ption(DB.java:941) ERROR: General , 1645689040545> 3,944,236> at org.sqlite.core.DB.newSQLExce ption(DB.java:953) ERROR: General , 1645689040547> 3,944,237> at org.sqlite.core.DB.throwex(DB .java:918) ERROR: General , 1645689040548> 3,944,239> at org.sqlite.core.NativeDB.prep are_utf8(Native Method) ERROR: General , 1645689040552> 3,944,243> at org.sqlite.core.NativeDB.prep are(NativeDB.java:134) ERROR: General , 1645689040564> 3,944,254> at org.sqlite.core.DB.prepare(DB .java:257) ERROR: General , 1645689040565> 3,944,256> at org.sqlite.core.CorePreparedS tatement.<init>(CorePreparedStatement.java:47) ERROR: General , 1645689040567> 3,944,257> at org.sqlite.jdbc3.JDBC3Prepare dStatement.<init>(JDBC3PreparedStatement.java:30) ERROR: General , 1645689040568> 3,944,259> at org.sqlite.jdbc4.JDBC4Prepare dStatement.<init>(JDBC4PreparedStatement.java:19) ERROR: General , 1645689040569> 3,944,260> at org.sqlite.jdbc4.JDBC4Connect ion.prepareStatement(JDBC4Connection.java:35) ERROR: General , 1645689040574> 3,944,264> at org.sqlite.jdbc3.JDBC3Connect ion.prepareStatement(JDBC3Connection.java:241) ERROR: General , 1645689040577> 3,944,268> at org.sqlite.jdbc3.JDBC3Connect ion.prepareStatement(JDBC3Connection.java:205) ERROR: General , 1645689040580> 3,944,271> at zombie.network.ServerWorldDat abase.banUser(ServerWorldDatabase.java:975) ERROR: General , 1645689040583> 3,944,273> at zombie.commands.serverCommand s.UnbanUserCommand.Command(UnbanUserCommand.java:36) ERROR: General , 1645689040585> 3,944,275> at zombie.commands.CommandBase.E xecute(CommandBase.java:126) ERROR: General , 1645689040589> 3,944,280> at zombie.network.GameServer.han dleServerCommand(GameServer.java:1124) ERROR: General , 1645689040591> 3,944,282> at zombie.network.GameServer.mai n(GameServer.java:871) LOG : General , 1645689040593> 3,944,284> A SQL error occured LOG : General , 1645689402610> 4,306,295> 1645689402610 znet: OnP2PSessionR equest LOG : General , 1645689406013> 4,309,698> 1645689406013 znet: Client connec ting LOG : General , 1645689406014> 4,309,699> 1645689406014 znet: OnClientIniti ateConnection LOG : General , 1645689406015> 4,309,700> Steam client 76561198042533392 is initiating a connection. ERROR: General , 1645689406017> 4,309,702> org.sqlite.SQLiteException: [SQLI TE_ERROR] SQL error or missing database (no such table: bannedid) ERROR: General , 1645689406017> 4,309,703> at org.sqlite.core.DB.newSQLExce ption(DB.java:941) ERROR: General , 1645689406018> 4,309,704> at org.sqlite.core.DB.newSQLExce ption(DB.java:953) ERROR: General , 1645689406019> 4,309,704> at org.sqlite.core.DB.throwex(DB .java:918) ERROR: General , 1645689406020> 4,309,705> at org.sqlite.core.NativeDB.prep are_utf8(Native Method) ERROR: General , 1645689406021> 4,309,706> at org.sqlite.core.NativeDB.prep are(NativeDB.java:134) ERROR: General , 1645689406023> 4,309,708> at org.sqlite.core.DB.prepare(DB .java:257) ERROR: General , 1645689406026> 4,309,711> at org.sqlite.core.CorePreparedS tatement.<init>(CorePreparedStatement.java:47) ERROR: General , 1645689406027> 4,309,713> at org.sqlite.jdbc3.JDBC3Prepare dStatement.<init>(JDBC3PreparedStatement.java:30) ERROR: General , 1645689406029> 4,309,715> at org.sqlite.jdbc4.JDBC4Prepare dStatement.<init>(JDBC4PreparedStatement.java:19) ERROR: General , 1645689406031> 4,309,716> at org.sqlite.jdbc4.JDBC4Connect ion.prepareStatement(JDBC4Connection.java:35) ERROR: General , 1645689406032> 4,309,717> at org.sqlite.jdbc3.JDBC3Connect ion.prepareStatement(JDBC3Connection.java:241) ERROR: General , 1645689406033> 4,309,718> at org.sqlite.jdbc3.JDBC3Connect ion.prepareStatement(JDBC3Connection.java:205) ERROR: General , 1645689406036> 4,309,722> at zombie.network.ServerWorldDat abase.authClient(ServerWorldDatabase.java:737) ERROR: General , 1645689406037> 4,309,723> at zombie.core.znet.SteamUtils.c lientInitiateConnectionCallback(SteamUtils.java:220) ERROR: General , 1645689406038> 4,309,723> at zombie.core.znet.SteamUtils.n _RunLoop(Native Method) ERROR: General , 1645689406039> 4,309,725> at zombie.core.znet.SteamUtils.r unLoop(SteamUtils.java:143) ERROR: General , 1645689406041> 4,309,726> at zombie.network.GameServer.mai n(GameServer.java:1029) LOG : General , 1645689406042> 4,309,728> 1645689406042 znet: Sending ban m essage

< >

Showing 1-3 of 3 comments

Beard

Feb 24, 2022 @ 3:34am

I would probably just recommend deleting the database file and restarting the server at this point, then transfer any bans you had made there over again.