Otázka na DBErrors

[TommyAnders 52]

Zdravim,

Server zrovna nejede u mě, ale máme tokový problém s DBErrors.log vypisuje až zajmavé bludy

příklad:

2008-05-08 12:31:56 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')

 

nebo co má znamenat toto:

2008-05-08 12:31:55 SQL: ROLLBACK
2008-05-08 12:31:55 SQL ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: START TRANSACTION

Tohle tam zaspamovalo celkem dost... přitom byl Server ONLINE a nic se neprojevilo.

 

Nebo zde, abych to nevypisoval po jednom:

2008-05-08 12:31:25 SQL: DELETE FROM character_queststatus_daily
2008-05-08 12:31:27 SQL: UPDATE uptime SET uptime = 88072, maxplayers = 29 WHERE starttime = 1210154615
2008-05-08 12:31:27 SQL ERROR: MySQL server has gone away
2008-05-08 12:31:27 SQL: UPDATE uptime SET uptime = 88072, maxplayers = 29 WHERE starttime = 1210154615
2008-05-08 12:31:27 SQL ERROR: MySQL server has gone away
2008-05-08 12:31:27 SQL: SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-UNIX_TIMESTAMP(time) > '1200' AND bones_flag = '1'
2008-05-08 12:31:55 SQL ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '79670' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '79675' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '79768' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '24690' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '24690' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '53976' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:55 SQL: SELECT position_x, position_y, position_z, orientation, model1, model2, waittime, emote, spell, text1, text2, text3, text4, text5 FROM creature_movement WHERE id = '53976' ORDER BY point
2008-05-08 12:31:55 query ERROR: MySQL server has gone away
2008-05-08 12:31:56 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
2008-05-08 12:31:56 SQL: UPDATE characters SET online = 0

 

To jsou chyby když je Server ONLINE

 

Zde když se zapne:

2008-05-08 16:33:27 Item (Entry: 600000) has wrong BuyCount value (0), set to default(1).
2008-05-08 16:33:27 Item (Entry: 600001) has wrong BuyCount value (0), set to default(1).
2008-05-08 16:33:27 Item (Entry: 600002) has wrong BuyCount value (0), set to default(1).
2008-05-08 16:33:27 Item (Entry: 600003) has wrong Subclass value (12) for class 12
2008-05-08 16:33:27 Item (Entry: 600003) has wrong BuyCount value (0), set to default(1).
2008-05-08 16:33:58 SQL: UPDATE guild_bank_eventlog SET LogGuid='1' WHERE guildid='8' AND LogGuid='0'
2008-05-08 16:33:58 SQL ERROR: Duplicate entry '8-1' for key 1

 

Můžete mi to stručne popsat, co to je asi za chyby? Ve hře se jen projevilo velký dmg do 20000 armor az 2500 dmg presto, ale to v errorech snad ani není.

 

Díky za rady