Error Database Mysql

[leandrovp 135]

Alguem sabe arrumar isso?

[WarW0lf 347]

Voce esta usando sqlite ou mysql?

[leandrovp 135]

mysql... estou apenas fazendo uns tests antes de passa meu servidor pro dedicado, ai deu esse error na database de nao salvar

[WarW0lf 347]

Tenta trocar a linha do script shop.lua no globalevents por essa:

<globalevent name="shop" interval="10000" script="shop.lua"/>

GLOBALEVENTS.XML

[leandrovp 135]

<?xml version="1.0" encoding="UTF-8"?>

<globalevents>

<globalevent name="clean" interval="7200000" event="script" value="clean.lua"/>

<globalevent name="save" interval="1800000" event="script" value="save.lua"/>

<globalevent name="serverstart" type="start" event="script" value="start.lua"/>

<globalevent name="playersrecord" type="record" event="script" value="record.lua"/>

<globalevent name="tiles" interval="2000" script="tiles.lua"/>

     <globalevent name="m1" interval="3600000" script="m1.lua"/>

        <globalevent name="shop" interval="10000" script="shop.lua"/> 

<globalevent name="history" interval="60000" event="script" value="history.lua"/>

     <globalevent name="lottery" interval="10800000" event="script" value="lottery.lua"/>


<!-- DB Clean -->

<globalevent name="dbcleaner" type="startup" event="script" value="dbcleaner.lua"/>



<globalevent name="woe" interval="60000" event="script" value="woe.lua"/>

<globalevent name="start_woe" interval="30000" event="script" value="start_woe.lua"/>

<globalevent name="guardias" interval="1000" event="script" value="guardias.lua"/>

      <globalevent name="zombieevent" time="02:26" event="script" value="zombievent.lua"/>


<!-- <globalevent name="timer_example" time="21:35" event="script" value="my_script.lua"/>

-->

</globalevents>

<!-- DB Clean -->

<globalevent name="dbcleaner" type="startup" event="script" value="dbcleaner.lua"/>

Essa linha nao está causando esse error? olhe a foto de novo WarW0lf

[WarW0lf 347]

Sim, mas se voce remove-la os items do shop do site não serão entregues.

Tente trocar o seu script que está em globalevents/scripts/shop.lua por esse:

local SHOP_MSG_TYPE = MESSAGE_EVENT_ORANGE

local SQL_interval = 30

function onThink(interval, lastExecution)

	    local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")

	    if(result_plr:getID() ~= -1) then

			    while(true) do

					    local id = tonumber(result_plr:getDataInt("id"))

					    local action = tostring(result_plr:getDataString("action"))

					    local delete = tonumber(result_plr:getDataInt("delete_it"))

					    local cid = getCreatureByName(tostring(result_plr:getDataString("name")))

					    if isPlayer(cid) then

							    local itemtogive_id = tonumber(result_plr:getDataInt("param1"))

							    local itemtogive_count = tonumber(result_plr:getDataInt("param2"))

							    local container_id = tonumber(result_plr:getDataInt("param3"))

							    local container_count = tonumber(result_plr:getDataInt("param4"))

							    local add_item_type = tostring(result_plr:getDataString("param5"))

							    local add_item_name = tostring(result_plr:getDataString("param6"))

							    local received_item = 0

							    local full_weight = 0

							    if add_item_type == 'container' then

									    container_weight = getItemWeightById(container_id, 1)

									    if isItemRune(itemtogive_id) == TRUE then

											    items_weight = container_count * getItemWeightById(itemtogive_id, 1)

									    else

											    items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)

									    end

									    full_weight = items_weight + container_weight

							    else

									    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)

									    if isItemRune(itemtogive_id) == TRUE then

											    full_weight = getItemWeightById(itemtogive_id, 1)

									    else

											    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)

									    end

							    end

							    local free_cap = getPlayerFreeCap(cid)

							    if full_weight <= free_cap then

									    if add_item_type == 'container' then

											    local new_container = doCreateItemEx(container_id, 1)

											    local iter = 0

											    while iter ~= container_count do

													    doAddContainerItem(new_container, itemtogive_id, itemtogive_count)

													    iter = iter + 1

											    end

											    received_item = doPlayerAddItemEx(cid, new_container)

									    else

											    local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)

											    doItemSetAttribute(new_item, "description", "This item can only be used by the player ".. getPlayerName(cid) .."!")

											    doItemSetAttribute(new_item, "aid", getPlayerGUID(cid)+10000)

											    received_item = doPlayerAddItemEx(cid, new_item)

									    end

									    if received_item == RETURNVALUE_NOERROR then

											    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'Você recebeu >> '.. add_item_name ..' << do shop Even Global, faça um bom uso e divirta-se.')

											    db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")

											    db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")

									    else

											    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')

									    end

							    else

									    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')

							    end

					    end

					    if not(result_plr:next()) then

							    break

					    end

			    end

			    result_plr:free()

	    end

	    return true

end