World.exe Crashing every 10 sec

[Fajo]

Anyone else haveing this problem ????? My world.exe keeps crashing every 10-70 sec seems to be happening when people log in and I cant figer out why would somethin I have done to the database : any input would be most grateful

BTW this is on a windows installation


Also this only started crashing this bad today (5-20-04)
before it used to crash just every once and a wile =(

[cofruben]

probally wrong inventory slots id,try deleting all inventory info.

[MrJag]

wrong inventory slot id ... happens when players put a item in a bag thats made wrong and logs out ,,, that crashes zone.exe not world.exe ... finding what bag is currupted is a bit tricky without the help from the players , i ended up having everyone use tinkerers bags and set all the rest to GM use only while i tested each one to find the currupted bag ,, found 1 that was made wrong forget its name now but deleted it from the database never did finish testing to see if ther was more

[cofruben]

Originally Posted by MrJag

wrong inventory slot id ... happens when players put a item in a bag thats made wrong and logs out ,,, that crashes zone.exe not world.exe ... finding what bag is currupted is a bit tricky without the help from the players , i ended up having everyone use tinkerers bags and set all the rest to GM use only while i tested each one to find the currupted bag ,, found 1 that was made wrong forget its name now but deleted it from the database never did finish testing to see if ther was more

Actually,it crashes the world.Tested it.

[MrJag]

was crashing zone on my server :/

[Richardo]

Sorry to say man but your going to have to do a full character whipe to get rid of all those problems with world.exe crashing... Heres to explain how it happened...

When the last CVS dumb was struggling with the dissappearing inventory. People would rebuy something/loot something and put an item back where they had lost their original item not knowing it would come back if they zoned, anyhow they would zone with this item on their invisible item and it would corrupt their character causing them to crash. And then whenever they even logged their account into the world it would crash you because even when people log into your server it still sends some type of character information from the client to the server to the database ect... So, that is mainly your problem, I hope I could help...

To character whipe, go into mysql and type the following>

mysql> use eq; (or whatever your database name is) eq is an example

mysql> delete all from character_;

and that may be wrong but it shoudl detele all characters ect...

[Baron Sprite]

wrong forum

[cofruben]

i think only inventory wipe is needed.