zone crashes on entry

[trevius]

[04.27. - 08:06:38] [WORLD__CLIENT] New client from 192.168.0.102:50687
[04.27. - 08:06:38] [NET__STRUCTS] Wrong size on outbound OP_CharInventory: Got 0, expected multiple of 8

That should mean that there is an issue either with your tables in MySQL. Are you sure you sourced the database completely? I am not exactly sure why this would happen, but it might if you had a table problem. Did you delete all of the info in your starting items table by chance? Have you don't anything special at all after following the setup guide? Made any changes at all? If you haven't made any changes yet, then it sounds like you need to check your tables.

Are you sure you are using a retail copy of Titanium?

[covou]

erm ok...

Definately using Titanium, as i can log into other servers fine.
I did alter some tables in the database... Emptied, Npc_types, spawns, grids, and items.

made an sql dump of my DB. and going to resource again... the DB im using is angelox 3.10d if that helps at all...

[trevius]

Emptying those tables is definitely what caused it then. Most likely it was emptying the items table. If you left other tables that rely on items existing in tact and deleted all items, it is going to cause a crash like that.

You would definitely need to at least empty the starting items table. But, with all of that stuff completely empty, it is going to be quite a pain for you to build a server completely from scratch. Possible, but a TON of work.

I highly recommend that you get everything running 100% before you start to modify anything. That way you can easily figure out what is causing a problem if you change anything.

[covou]

OK thanks.... the only thing i want to do is build a server from the floor up... just as a hobby... not really for release anytime soon... but we shell see.


Thanks for your help

[covou]

OK so resourcing the database works...


Now for another question if i can. How would i go about emptying all removing all data to start from scratch?... or is it not possible?

[trevius]

I think that all depends on what you are wanting to do. If you just want to start with all empty zones and no items on your chars, you should be able to just empty the spawn2 table and the starting_items table. That should clear everything out. Then, you can just leave everything else and add to those tables. I am sure you could clear out most tables if you really wanted to, but it wouldn't be required for making the server essentially from scratch.