Inventory save errors

[allromz]

Whenever someone dies/zones on my server Camelot 2003 the inventory disappears. Does anyone know how to correct this issue?

[Kroeg]

That is a little vague to be offering support on.. could you possibly include what db you are using along with any other configuration information as to base an answer from? :)

[theobeo92]

I have the same problem, even #zone makes the items disappear, but the texture and look of armor is still on my character.

I'm running:

5.2 Version
MW_051_052_alpha1 DB


What Do I need?

[allromz]

The only thing that I know because I am new to this is that I use mysql-3.23.38 8) tcs051_052db.sql Database 8) and as for config...I don't really know...I followed instructions from

http://www.everquestserver.com/forums/viewtopic.php?t=11423&highlight=compile&sid=c98a6a03cfa19bfcca5641ddc750c952

I don't know if that helps any but I can't put up the server without knowing how to fix the item poofing problem :(

[Edgar1898]

paste any errors that appear in your zone.exe console window, I suspect that you didnt run the 5.2 update sql file.

[allromz]

[Error] SaveInventory query 'REPLACE INTO inventory <charid,slotid,itemid,charges,color> VALUES<1,30,11000,1,0>': #1054: Unknown colom 'color' in 'field list'

[Edgar1898]

yup, you didnt run the 5.2 update sql file....

[allromz]

How do I run the update and where do I find it?