[NVM]TFS 0.3.1 Lost Connection with MySQL !?!?!?!!?

[Wiw3K]

this happening with my server and no one can play, i need to reboot my whole dedicated server...

anyone have solution?

these errors appear in console:

Error during getDataLong(expires).
mysql_real_query(): SELECT `player_id` FROM `player_deaths` WHERE `player_id` = 2534;: MYSQL ERROR: Malformed packet
Powsinoga has logged out.
Failed reconnecting to database - MYSQL ERROR: Lost connection to MySQL server during query
mysql_real_query(): SELECT `expires` FROM `bans` WHERE `type` = 1 AND ((2685470803 & 4294967295 & `param`) = (`value` & `param` & 429$
Brat Ediego'dorek has logged out.
Error while saving player: Brat Ediego'dorek
Sonic'x has logged out.
Error while saving player: Sonic'x

oh btw , i found a file called database in data/lib/database.lua , maybe i have something wrong with it , here it is:

if(result == nil) then
	print("> WARNING: Couldn't load database lib.")
	return
end

Result = createClass(nil)
Result:setAttributes({
	id = -1
})

function Result:getID()
	return self.id
end

function Result:setID(_id)
	self.id = _id
end

function Result:getRows(free)
	if(self:getID() == -1) then
		error("[Result:getRows]: Result not set!")
	end

	local c = 0
	repeat
		c = c + 1
	until not self:next()

	if(free) then
		self:free()
	end

	return c
end

function Result:getDataInt(s)
	if(self:getID() == -1) then
		error("[Result:getDataInt]: Result not set!")
	end

	return result.getDataInt(self:getID(), s)
end

function Result:getDataLong(s)
	if(self:getID() == -1) then
		error("[Result:getDataLong]: Result not set!")
	end

	return result.getDataLong(self:getID(), s)
end

function Result:getDataString(s)
	if(self:getID() == -1) then
		error("[Result:getDataString]: Result not set!")
	end

	return result.getDataString(self:getID(), s)
end

function Result:getDataStream(s)
	if(self:getID() == -1) then
		error("[Result:getDataStream]: Result not set!")
	end

	return result.getDataStream(self:getID(), s)
end

function Result:next()
	if(self:getID() == -1) then
		error("[Result:next]: Result not set!")
	end

	return result.next(self:getID())
end

function Result:free()
	if(self:getID() == -1) then
		error("[Result:free]: Result not set!")
	end

	local ret = result.free(self:getID())
	self:setID(-1)
	return ret
end

Result.numRows = Result.getRows
function db.getResult(query)
	if(type(query) ~= 'string') then
		return nil
	end

	local res = Result:new()
	res:setID(db.storeQuery(query))
	return res
end

 

[Sync]

I think whats happening is your Mysql is shutting off so it cant load the DB so it gets errors.

 

[Wiw3K]

Nevermind , changing TFS from 0.3.1 to 0.3.2

 

[Zonet]

No, the The Forgotten Server 0.3.1 loses connection, and it doesn't reconnect, so I prefer you to use 0.3.2.

 

[Wiw3K]

No, the The Forgotten Server 0.3.1 loses connection, and it doesn't reconnect, so I prefer you to use 0.3.2.

are you blind?,

Nevermind , changing TFS from 0.3.1 to 0.3.2