epvp help

09/06/2012 21:34 OyunPozitifRappelz#1
2012/09/06 22:20:06 DB COM ERROR(Thread:2, HRESULT:80040E31, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Query timeout expired
2012/09/06 22:21:07 DB COM ERROR(Thread:3, HRESULT:80040E31, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 184930) : Query timeout expired
2012/09/06 22:21:07 DB COM ERROR(Thread:0, HRESULT:80040E31, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 184993) : Query timeout expired


#####
server crash
help
09/06/2012 21:36 cs189#2
too many items some lag and a ram 4gb or less thiese are your probs bro
09/06/2012 21:53 OyunPozitifRappelz#3
Quote:
Originally Posted by cs189 View Post
too many items some lag and a ram 4gb or less thiese are your probs bro
what?
fix help
09/06/2012 22:49 91ervans#4
Use this SQL-Query

delete from Telecaster.dbo.item where owner_id = 0 and auction_id = 0 and summon_id = 0 and account_id = 0 and keeping_id = 0

deletes all the items without owners