View Single Post
Author Message
SkiesOFF
Member
Join Date: Mar 2008
Old 06-24-2010 , 22:55   MySQL little random problems
Reply With Quote #1

Hello guys,

I don't know if you guys remember my topic, the one i said that my nvault had some bug and half of players had their level erased.

So i moved my database for mysql and i'm using it since than.

After 3 weeks using it, seems working flawless but i had some little bugs:

-> In this 3 weeks, my MySQL gots something like 3.000 new players registers. Only 3 people got their XP erased for a unknow reason.

-> Some rarely times, my server just pause, after 5 seconds unpases and than pause again (i have to do amx_rcon quit to stop)

-> Strange error log:

Quote:
L 06/24/2010 - 133:03: [superheromod.amxx] DEBUG: MySQL connect error: [2005] 'Unknown MySQL server host 'myserver.com' (2)' (myserver.com,myuser,mydb)
my cvars:

sh_xpsavedays 30
sh_endroundsave 0
sh_loadimmediate 0

one question, is good to set this cvar 1?
sh_mysql_persistent 0
SkiesOFF is offline