Erro no MYSQL

[MyTrill 0]

Não sei se estar na area correta, se não tiver movam plx.

 

Meu servidor já tem 1 mês online e nunca deu nenhum problema. Hoje estava funcionando em perfeito estado depois ficou off de uma hora pra outra e o site tabém, quando fui olhar no SSH tava dando este erro.

 

Me ajudem por favor.

 

Imagem

 

 

[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...

 

 

 

Editado Junho 6, 2013 por MyTrill

[MyTrill 0]

 

Já ajudei, de diversas formas. (:

 

Faça seu trabalho e mova o tópico para a sessão correta.

 

Sim, beeki me ajudou bastante com um dos problemas...

[Alexclusive 687]

O X-Tibia agradece sua ajuda!

[Beeki 284]

agradecimento serão sempre bem vindos.

[MyTrill 0]

Executa isso aqui no mysql:

 

SELECT * , SUBSTRING( CONVERT( attributes
USING latin1 )
FROM 18 ) AS 'serial'
FROM player_items
WHERE CONVERT( attributes

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 6

 

Venho aqui avisar que já solucionei, pedir obrigado a todos que tentaram me ajudar.

 

O problema todo era no sistema de anti-clone/libs e Globaladvents.

Removi estes sistemas e estou testando outro..

[Alexclusive 687]

Resolvido, fechado e movido!