Erro no MYSQL

 

[23:32:28.999] > Loading time: 63.572 seconds.

[23:32:36.811] [Error - LuaInterface::loadFile] cannot open data/npc/scripts/Seymour.lua: No such file or directory

[23:32:36.811] [Warning - NpcEvents::NpcEvents] Cannot load script: data/npc/scripts/Seymour.lua

[23:32:36.811] cannot open data/npc/scripts/Seymour.lua: No such file or directory

[23:32:36.827] [Error - LuaInterface::loadFile] cannot open data/npc/scripts/Tom.lua: No such file or directory

[23:32:36.827] [Warning - NpcEvents::NpcEvents] Cannot load script: data/npc/scripts/Tom.lua

[23:32:36.827] cannot open data/npc/scripts/Tom.lua: No such file or directory

[23:32:39.090] [Warning - Houses::loadFromXml] House entry not set for: Thais # Custom House # (2385)

[23:32:39.091] > Parsing time: 10.092 seconds.

[23:33:03.322] > Synchronization time: 24.23 seconds.

[23:33:03.830] > Unserialization time: 0.508 seconds.

[23:33:04.032] >> Checking world type... Open PvP

[23:33:04.032] >> Starting to dominate the world... done.

[23:33:04.032] >> Initializing game state and binding services...

[23:33:35.056] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_items WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM player_items WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 1) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[23:33:35.056] > WARNING: MYSQL Lost connection, attempting to reconnect...

[23:34:06.507] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_depotitems WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM player_depotitems WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 1) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[23:34:06.579] > WARNING: MYSQL Lost connection, attempting to reconnect...

[23:34:36.637] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_items WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM player_depotitems WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 0) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[23:34:36.649] > WARNING: MYSQL Lost connection, attempting to reconnect...

[23:35:06.866] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_items WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM tile_items WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 0) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[23:35:06.866] > WARNING: MYSQL Lost connection, attempting to reconnect...

[23:35:37.326] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_depotitems WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM tile_items WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 0) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[23:35:37.TMI] >> Item Tracker: 0 duplicated items have been deleted...

[23:35:37.510] > WARNING: MYSQL Lost connection, attempting to reconnect...

 

 

 

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

[--] Data in MyISAM tables: 34K (Tables: 14)

[--] Data in InnoDB tables: 9M (Tables: 36)

[!!] Total fragmented tables: 36

 

 

tablesToCheck = {"player_items", "player_depotitems"}

 

function onStartup()

local text, final = "", ""

local filex = "data/logs/duplicated.txt"

local f = io.open(filex, "a+")

for i = 1, table.maxn(tablesToCheck) do

local query = db.getResult("SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM " .. tablesToCheck .. " WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FROM 18) FROM " .. tablesToCheck .. " WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 1)")

local duplicated = {}

if query:getID() ~= -1 then

while(true) do

text = "[!] -> Deleting item with duplicated serial: [Player: " .. getPlayerNameByGUID(query:getDataInt("player_id")) .. ", Item: " .. query:getDataInt("itemtype") .. ", Count: " .. query:getDataInt("count") .. ", Serial: " .. query:getDataString("track") .."]... "

local delete = db.executeQuery("delete from " .. tablesToCheck .. " where SUBSTRING(CONVERT(attributes USING latin1) FROM 18) = " .. db.escapeString(query:getDataString("track")) .. ";")

if delete then

text = text .. "Success!"

else

text = text .. "Failed!"

end

final = final .. (final ~= "" and "\n" or "") .. text

print(text)

if not query:next() then break end

end

if f ~= nil then

f:write(os.date() .. "\n" .. final .. "\n\n")

f:close()

else

print("[!] -> Cannot save info to file!")

end

else

print("[!] -> Cannot get info, table is empty, there are not items with duplicated serial or you have a problem on the query syntax: " .. tablesToCheck .. ".")

end

end

return true

end

 

 

mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_items WHERE SUBSTRING(CONVERT(attributes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin1) FR OM 18) FROM player_items WHERE CONVERT(attributes USING latin1) LIKE '%serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING COUNT(*) > 1 ) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[!] -> Cannot get info, table is empty, there are not items with duplicated seri al or you have a problem on the query syntax: player_items.

[22:46:17.709] > WARNING: MYSQL Lost connection, attempting to reconnect...

[22:46:27.709] mysql_real_query(): SELECT *, SUBSTRING(CONVERT(attributes USING latin1) FROM 18) AS 'track' FROM player_depotitems WHERE SUBSTRING(CONVERT(attri butes USING latin1) FROM 18) IN (SELECT SUBSTRING(CONVERT(attributes USING latin 1) FROM 18) FROM player_depotitems WHERE CONVERT(attributes USING latin1) LIKE ' %serial%' GROUP BY SUBSTRING(CONVERT(attributes USING latin1) FROM 18) HAVING CO UNT(*) > 1) - MYSQL ERROR: Lost connection to MySQL server during query (2013)

[!] -> Cannot get info, table is empty, there are not items with duplicated seri al or you have a problem on the query syntax: player_depotitems.

[22:46:27.709] > WARNING: MYSQL Lost connection, attempting to reconnect...