Why server keeps crashing (what i think)

[lapta]

Think the m2server can no longer handle all the data from the database. These files were never made for a server to get to this size.

The many problem is user items and trade merchant database, it's huge.

Will spend the day clearing it out off all the old maps, cords, and spawn tables, to see if that will sort out the problem.

server crashed this time for the following reason

[28/10/2008 20:39:33] Access violation at address 005F510A in module 'M2Server.exe'. Read of address 00000002

[Orphan]

Lapta can I ask what engine is the database using? Or is it a customized engine made just for Mir?

[FrankLeeMad]

ok thanks for telling us didnt make sence to me but i am just a human....

[Wackit]

so does that mean server is down till u spent the day sorting it?

[Sakura]

is their anyway you can decrease the time items are allowed in TM for?

e.g. After 14 days the items will be deleted..?

[Orphan]

Or maybe put a limit on how many items you can consign in the TM, like 10 or 15 items at one time.

[Sakura]

Euro only had 5 didnt it..

maybe do that instead

[lapta]

use SQL 2000.

the database can hanndle it.

The m2server (the program that runs everything) cant handle it, too much data to load at once.

Things like the database that control the movement form one map to another is doubled up, so clearing that up might free up stuff.

There is no way to limit the amount of items in the TM that i know of, will look in to it.

[Orphan]

No no, only being able to consign 5 items at a time is not enough!

[Bell]

Euro only had 5 didnt it..

maybe do that instead

nooooooo lol

make it 15 items and 14 days in there after 14 days there a way to put unsold items back into store??