Lost connection to MySQL server during query

[xurre]

anyone know how to fix it?
aid

 

[Hard]

wrong thread.

 

[xurre]

wtf?

 

[Limos]

http://otland.net/forums/support.16/
Also use different title.
http://otland.net/threads/updated-rules-for-the-support-board.217087/

 

[Hard]

wtf?

post your error in "support" here is wrong in the jobs.

 

[Limos]

When and how often does this happen?
You can try to increase max_allowed_packet in my.ini (uniformserver/xampp) and set all time outs to 0 in config.lua.

 

[xurre]

3hours DDoS attacks are not or yes?

 

[LucasFerraz]

Config.lua

sqlKeepAlive = 10

mysqlReadTimeout = 60000
mysqlWriteTimeout = 60000

Check !sellhouses. If you leave a house and HOUSE_ITENS_COUNT > DP_SLOTS_COUNT then it may causes sql errors.
Check timeout from mysql.
Check mailbox limit.

All I remember for now

 

[xurre]

is not error sources?

 

[xurre]

Config.lua

sqlKeepAlive = 10

mysqlReadTimeout = 60000
mysqlWriteTimeout = 60000

Check !sellhouses. If you leave a house and HOUSE_ITENS_COUNT > DP_SLOTS_COUNT then it may causes sql errors.
Check timeout from mysql.
Check mailbox limit.

All I remember for now

mailboxDisabledTowns = ""

I should put ?

 

[Cronox]

You this error On make Server save? any times get frezz and stop work mysql?

 

[xurre]

yes happens at times

 

[Cronox]

Up your GIGAS (RAM) PC...

 

[xurre]

Up your GIGAS (RAM) PC...

ok thx

 

[LucasFerraz]

Post your obsidian knife and blessed wooden stake scripts

 

[xurre]

local SKINS = {
[5908] = {
-- Minotaurs
[2830] = {25000, 5878},
[2871] = {25000, 5878},
[2866] = {25000, 5878},
[2876] = {25000, 5878},
[3090] = {25000, 5878},

-- Lizards
[4259] = {25000, 5876},
[4262] = {25000, 5876},
[4256] = {25000, 5876},

-- Dragons
[3104] = {25000, 5877},
[2844] = {25000, 5877},

-- Dragon Lords
[2881] = {25000, 5948},

-- Behemoths
[2931] = {25000, 5930, 90000, 5893},

-- Bone Beasts
[3031] = {25000, 5925}
},
[5942] = {
-- Demon
[2956] = {25000, 5905},

-- Vampire
[2916] = {25000, 5906}
}
}

function onUse(cid, item, fromPosition, itemEx, toPosition)
local skin = SKINS[item.itemid][itemEx.itemid]
if(skin == nil) then
doPlayerSendDefaultCancel(cid, RETURNVALUE_NOTPOSSIBLE)
return true
end

local random, effect = math.random(1, 100000), CONST_ME_MAGIC_GREEN
if(random <= skin[1]) then
doPlayerAddItem(cid, skin[2], 1)
elseif(skin[3] and random >= skin[3]) then
doPlayerAddItem(cid, skin[4], 1)
else
effect = CONST_ME_BLOCKHIT
end

doSendMagicEffect(toPosition, effect)
doTransformItem(itemEx.uid, itemEx.itemid + 1)
return true
end

<action itemid="5908;5942" event="script" value="tools/skinning.lua"/>

 

[xurre]

im change my save in globabalevents:

local config = {
broadcast = "yes"
}

config.broadcast = getBooleanFromString(config.broadcast)
local function executeSave(seconds)
if(seconds == 0) then
doSaveServer()
return true
end

if(seconds == 120 or seconds == 30) then
doBroadcastMessage("Full server save within " .. seconds .. " seconds, please stay in safe place!")
end

seconds = seconds - 30
if(seconds >= 0) then
addEvent(executeSave, 30 * 1000, seconds)
end
end

function onThink(interval, lastExecution, thinkInterval)
if(not config.broadcast) then
doSaveServer()
return true
end

executeSave(120)
return true
end

 

[xurre]

!bump