[fraise]

Hi !

Since several weeks, my server crash everytime a sql request is done on the end map.
On my log, i get "SQL error happen, bla bla bla" or "Database connexion lost".
Do you have the same problem ? Do you know how to solve it ? Maybe a way to stop SQL request when map change on pre hook ?

I search a lot about this problem but i didn't found a solution for this

Thanks !

[I am inevitable]

what plugin is causing this error, and can you link the source code

[fraise]

Main plugins is Store by zephirus, which make sql request on Map End, and one of mine too, which do the same. I didn't have the log fro the moment but i'll add it asap.

[fraise]

Here a log :

PHP Code:

L 06/21/2019 - 18:27:15: [mapchooser_extended.smx] Loaded map list for csgo.
L 06/21/2019 - 18:27:15: server_cvar: "sm_nextmap" "ba_jail_minecraftparty_v6"
L 06/21/2019 - 18:27:15: server_cvar: "sv_tags" "SM Hosties v2.2"
L 06/21/2019 - 18:27:16: [store.smx] SQL error happened.
Query: UPDATE store_players SET `credits`=MAX(`credits`+0,0), `date_of_last_join`=1561134422, `name`='Tonio76 -Toutouille-' WHERE `id`=2
Error: Driver is unloading 


[iluvit9887]

delete cookies and check tcp/ip settings

Originally Posted by fraise Here a log : PHP Code: L 06/21/2019 - 18:27:15: [mapchooser_extended.smx] Loaded map list for csgo. L 06/21/2019 - 18:27:15: server_cvar: "sm_nextmap" "ba_jail_minecraftparty_v6" L 06/21/2019 - 18:27:15: server_cvar: "sv_tags" "SM Hosties v2.2" L 06/21/2019 - 18:27:16: [store.smx] SQL error happened. Query: UPDATE store_players SET `credits`=MAX(`credits`+0,0), `date_of_last_join`=1561134422, `name`='Tonio76 -Toutouille-' WHERE `id`=2 Error: Driver is unloading

[fraise]

Checked, nothing change. I found this error too when srcds crashes : Host_Error: Index error writing string table baseline downloadables

[8guawong]

Originally Posted by fraise Checked, nothing change. I found this error too when srcds crashes : Host_Error: Index error writing string table baseline downloadables

so the crash is not related to sql
its because you are not precaching OnMapStart

[fraise]

ow... ok, is there a way to know what isn't precached ?

[8guawong]

Originally Posted by fraise ow... ok, is there a way to know what isn't precached ?

look through your plugins and see what is precached not in onmapstart and change it to onmapstart