What The gell is wrong with CaptainHerlock

06/04/2011 15:29 modi12#1
pleas can any 1 tell me what should i do with this ?
[Only registered and activated users can see links. Click Here To Register...]
and thanks alot
06/04/2011 15:38 thatThing#2
i'm guessing it happened after you've added the mob spawns fix
first try to restore all the DB (maybe you've changed something),
if that doesn't work, try:

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

GO


DELETE FROM [Telecaster].[dbo].[State]

GO


i think credits go to trusted1234
sorry if i'm mistaken
see if that helps
06/04/2011 15:43 modi12#3
ok thanks alot
but can u explane more ?^^ pleas
06/04/2011 15:51 modi12#4
please any help
06/04/2011 16:18 thatThing#5
its an sql query....
06/04/2011 19:23 modi12#6
i need more explenation
a photo explination
___
if u can speac arabic
اإشرحلي كيف احل مشكلتها لخمتني
06/04/2011 19:29 harmbasi#7
Again it comes down to you not wanting to learn. You want to be spoon fed. Please no one help him. They just keep coming back for more then.
06/05/2011 08:07 modi12#8
haw the hell that well be gon ?
06/05/2011 11:59 ~kau~#9
modi pls stop spamm...
I can only see that the server crash... also you must do anything...
Restore the db and run again.
if the error come back your files or your pc are to old xD
06/05/2011 18:29 modi12#10
what os spamm ??
ook ty i fixed it
06/06/2011 07:55 wisp66#11
pc age has nothing to do with this error. you could run this server on a p3 not recomended but.. you could the issue is sometimes the gameserver just goes bad try replaceing herlock and auth excutables with a fresh copy.
db should be fine.
this is being worked on its rather difficult to fix as present as theres no source code avail so it's become rather tedious.
it will be fixed tho ^^ just not sure how soon
06/07/2011 01:37 cranK337#12
Try to restore database.
06/27/2011 02:28 OtakuTxie#13
Quote:
Originally Posted by modi12 View Post
pleas can any 1 tell me what should i do with this ?
[Only registered and activated users can see links. Click Here To Register...]
and thanks alot
Delete everything in Telecaster/dbo.Auction
06/27/2011 08:13 wisp66#14
ahh that issue the problem is u need to delte every entry in dbo.item that was back before inventory was rewritten which before to many items in wh,inventory,auction house would crash game server.
its fixed now just not released yet so for now just delete all entrys in telecaster>>dbo.item
it wont delete the actual inventory just free up the db memory so its no its not creating an overflow
06/27/2011 12:50 GeneraL_SchnitzeL#15
did you have spend gold in the altar??