[SERVER] Lost database Connection

[Kippetjee]

My server lost some times database connection And then he wont save anymore

People cant login anymore...

Some one know maby how this can be happend?

 

[domelxp]

ye i know the problem ..... .... yo give ban for ip ... and when this ban is expire you lose conection ....
remember to dont give ban for ip

cya !

 

[Kippetjee]

Yee Right I Dont belive that

 

[Cykotitan]

so it's happening on linux too? then it must be something with TFS 0.4, but some people said it's because of a bad my.cnf

 

[domelxp]

its true ! i have this problem ....so i dont give more ban for ip ..

 

[Kippetjee]

i'm using rev 3777

 

[Kippetjee]

bring me up plase

 

[simkal]

try make a new database

 

[Kippetjee]

already did alot times

 

[domelxp]

function onStartup()
[COLOR="red"]	db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")[/COLOR]
	db.executeQuery("DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < " .. (os.time() - 2 * 86400) .. ";")
	db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")
	return true
end

globalevents\scripts\start.lua put this

and find player in ur database who have id 1991

 

[Kippetjee]

That dont help fix the lost connection to my db...

 

[domelxp]

and find player in ur database who have id 1991

 

[Kippetjee]

and then??

its evrey time a other one

 

[Kippetjee]

bring me up