[daleGEND]

Hi Guys,

I have a very odd issue on my Zombie Escape server. I have no errors in the error log to explain why this happens and I have done testing on a few different versions of Sourcemod and Metamod as well. Unfortunately nothing has helped. Initially I had a clientprefs MySQL database and on the first round after a map change it would not load the clientprefs for various plugins that use them (Zombie:Reloaded and Credit Store). I tried moving from a MySQL database to SQlite to see if that fixed the issue...no luck. It's become fairly annoying and I have nothing to go on. I can only say that after the first round has come and gone, the data then loads properly and everything goes back to normal. It does create a side-effect that the zmarket property on Zombie:Reloaded is cleared and reset to the default options.

I have two other servers that use the Credit Store and clientprefs...and neither of them have this issue at all. If anyone wants to help me figure this issue out, please let me know what information you need. Thanks guys!

I have tested this issue on both 1.4.1-stable (Sourcemod) / 1.8.7-stable (Metamod) and 1.5.0-dev (Sourcemod) / 1.9.0-dev (Metamod).

sm plugins list

13:52:19 [SM] Listing 58 plugins: 01 "[UMC] Post-Played Exclusion" (3.3.1) by Sazpaimon and Steell 02 "Network Tools" (1.3) by Kyle Sanderson 03 "SMAC Rcon Locker" (0.7.7.1) by GoD-Tony, Kigen 04 "Players Votes" (1.5.0) by The Resident, pZv! 05 "Anti Bunny Hopping" (1.1) by Kyle Sanderson 06 "Basic Votes" (1.4.0-dev) by AlliedModders LLC 07 "Admin File Reader" (1.4.0-dev) by AlliedModders LLC 08 "Credit Store" (1.0.1) by Zephyrus 09 "Anti-Flood" (1.4.0-dev) by AlliedModders LLC 10 "UpdateRadar Fix" (fix) by GoD-Tony 11 "NoBlock" (1.4.2) by Otstrel.ru Team 12 "Admin Menu" (1.4.0-dev) by AlliedModders LLC 13 "SMAC Client Protection" (0.7.7.1) by GoD-Tony, psychonic, Kigen 14 "Server Hop" (0.8.1) by [GRAVE] rig0r 15 "[UMC] Random Cycle" (3.3.1r3) by Steell 16 "Sourcebans Checker" (1.0.0) by psychonic & Ca$h Munny 17 "Player Commands" (1.4.0-dev) by AlliedModders LLC 18 "Server Clean Up" (1.1.7) by Jamster 19 "Spawn with Armor" (0.1.0b) by fezh 20 "Basic Comm Control" (1.4.0-dev) by AlliedModders LLC 21 "[UMC] Admin Menu" (3.3.1r3) by Steell 22 "Show Damage" (1.0.7) by exvel 23 "Admin loggin" (1.0) by vIr-Dan 24 "Advanced admin commands" (0.16) by 3sigma 25 "[UMC] Ultimate Mapchooser Core" (3.3.1r3) by Steell 26 "SMAC AutoTrigger Detector" (0.7.7.1) by GoD-Tony 27 "gameME Plugin" (3.9) by TTS Oetzel & Goerz GmbH 28 "[UMC] End of Map Vote Warnings" (3.3.1r3) by Steell 29 "[UMC] Map Commands" (3.3.1r3) by Steell 30 "SMAC ConVar Checker" (0.7.7.1) by GoD-Tony, psychonic, Kigen 31 "Zombie:Reloaded" (3.0.0-b2) by Greyscale | Richard Helgeby 32 "AllChat" (1.1.1) by Frenzzy 33 "SMAC Eye Angle Test" (0.7.7.1) by GoD-Tony, psychonic 34 "[UMC] End of Map Vote" (3.3.1r3) by Steell 35 "Sound Commands" (1.4.0-dev) by AlliedModders LLC 36 "[UMC] Prefix Exclusion" (3.3.1r3) by Steell 37 "SM File/Folder Downloader and Precacher" (1.4) by SWAT_88 38 "SourceBans" (1.4.9) by SourceBans Development Team 39 "[UMC] Rock The Vote" (3.3.1r3) by Steell 40 "Anti-Ping Mask" (1.6.0M) by atom0s 41 "AdsQL Advertisements System" (1.7. by PharaohsPaw 42 "Admin Help" (1.4.0-dev) by AlliedModders LLC 43 "Updater" (1.1.3) by GoD-Tony 44 "[UMC] Echo Nextmap" (3.3.1r3) by Steell 45 "Basic Chat" (1.4.0-dev) by AlliedModders LLC 46 "SMAC Anti-Speedhack" (0.7.7.1) by GoD-Tony 47 "Immunity Reserve Slots [CONNECT]" (2.0.2) by Jamster 48 "Fun Votes" (1.4.0-dev) by AlliedModders LLC 49 "[Any] SteamTools Game Description Override" (1.0.1) by Dr. McKay 50 "SourceMod Anti-Cheat" (0.7.7.1) by GoD-Tony, psychonic 51 "Basic Info Triggers" (1.4.0-dev) by AlliedModders LLC 52 "[UMC] Nominations" (3.3.1r3) by Steell 53 "Spray Tracer" (5.8a) by Nican132, CptMoore, Lebson506th 54 "SMAC Command Monitor" (0.7.7.1) by GoD-Tony, psychonic, Kigen 55 "Basic Commands" (1.4.0-dev) by AlliedModders LLC 56 "Fun Commands" (1.4.0-dev) by AlliedModders LLC 57 "ExtendedComm" (3.0.5) by Twisted|Panda 58 "Nextmap" (1.4.0-dev) by AlliedModders LLC

sm exts list

13:53:05 [SM] Displaying 17 extensions: [01] Automatic Updater (1.5.0-dev): Updates SourceMod gamedata files [02] Webternet (1.5.0-dev): Extension for interacting with URLs [03] Server Secure - Files Only (1.0.0): The finest defence [04] CS:S Tools (1.5.0-dev): CS:S extended functionality [05] BinTools (1.5.0-dev): Low-level C/C++ Calling API [06] SDK Tools (1.5.0-dev): Source SDK Tools [07] Top Menus (1.5.0-dev): Creates sorted nested menus [08] Client Preferences (1.5.0-dev): Saves client preference settings [09] SQLite (1.5.0-dev): SQLite Driver [10] Regex (1.5.0-dev): Provides regex natives for plugins [11] SDK Hooks (2.1.0): Source SDK Hooks [12] Connect (1.0.0): [13] Socket (3.0.1): Socket extension for SourceMod [14] GeoIP (1.5.0-dev): Geographical IP information [15] SteamTools (0.8.2): SteamWorks for SourceMod. [16] cURL Extension (1.3.0.0): cURL Extension [17] MySQL-DBI (1.5.0-dev): MySQL driver implementation for DBI

[daleGEND]

I heard some theories that clientprefs has trouble loading on the first round if the server is under heavy usage. Is this true even with sqlite? If so, is there a way to fix this issue?

[daleGEND]

Hey guys, I don't think this is just clientprefs. It looks like it's a massive delay on first round when the server changes maps. It took away even admin for about 20-40 seconds then it all kicks back in. Not exactly sure what plugins out of the ones listed above could do something like that. Any ideas?

[Groger]

Originally Posted by daleGEND Hey guys, I don't think this is just clientprefs. It looks like it's a massive delay on first round when the server changes maps. It took away even admin for about 20-40 seconds then it all kicks back in. Not exactly sure what plugins out of the ones listed above could do something like that. Any ideas?

I had the same problem a few weeks back. Lots of plugin loaded only 40 seconds after the first round started.

[daleGEND]

Originally Posted by Groger I had the same problem a few weeks back. Lots of plugin loaded only 40 seconds after the first round started.

Hey Groger,

Did you do anything to help alleviate the issue?

[Groger]

I'm affraid not, I do have disabled clientprefs (to fix regular crashes). Maybe since than it stopped.

[daleGEND]

Originally Posted by Groger I'm affraid not, I do have disabled clientprefs (to fix regular crashes). Maybe since than it stopped.

I also have clientprefs disabled (at least the .smx file). If anyone else has experienced this issue as well.

[TnTSCS]

dale,

did you disable the clientprefs extension? clientprefs.ext.dll in the sourcemod\extensions folder. I'm not sure if disabling the extension will have any adverse affects though, but as long as none of your plugins use it since it looks like you're setup to use SQLite, you should be fine.

[daleGEND]

Originally Posted by TnTSCS dale, did you disable the clientprefs extension? clientprefs.ext.dll in the sourcemod\extensions folder. I'm not sure if disabling the extension will have any adverse affects though, but as long as none of your plugins use it since it looks like you're setup to use SQLite, you should be fine.

Hey there,

Actually I did not disable it because I use a bunch of plugins that require it. I have a store and I believe Zombie Reloaded requires it. Those plugins would no longer work.

[TnTSCS]

you say you have other servers that have no issue, I wonder if something happened to your database?

Or I wonder if the store and ZR are conflicting? Has Richard (from ZR) put in his $.02 yet?