unable to load items

[Gregk]

Having an Issue loading items. DB is populated. it just doesn't to be communicating with the server. Everything was working till I upgraded. Like an idiot, I did both a server compile and a db drop, so I'm not sure which end the problem is. I don't know much about coding, so its mostly guess work fr me. Should I be focused on Opcodes, server compile....? restoring an old db version didn't seem to make a difference. could just be the way I did it though. All suggestions welcome, and appreciated.

[gibroni]

having same issue with newest compile of 2031. same db and items are there when i use older compile, so im sure its the new svn update not working correctly.

[Aeryn]

have you run the sql updates??? main one is 2024_required_update.sql
i'm guessing not, as that one changes the inventory table
so items prob wont show if you dont run it

[Gregk]

Many thanks.... I still have much to learn, and with my limited skills and knowledge, wasn't able to fix my item issue, I was able to fix and modify so much more. Thank you!!!

Back to my original issue... Is it possible that there is another possible issue that might be causing this problem?

Thanks again

[gibroni]

well since the db is 2027, didnt apply any updates as the last one is 2024 which should already be in there.

that update is in fact already in there. the issue is something else

[Derision]

Nothing in your logs ?

Rev 2031 loads items for me.

[gibroni]

[10.15. - 21:22:50] Starting Log: logs/eqemu_error_world_7644.log
[10.15. - 21:22:50] GetInventory query 'SELECT slotid,itemid,charges,color,augslot1,augslot2,augs lot3,augslot4,augslot5,instnodrop,custom_data FROM inventory INNER JOIN character_ ch ON ch.id=charid WHERE ch.name='Gibroni' AND ch.account_id=1 ORDER BY slotid' #1054: Unknown column 'custom_data' in 'field list'
[10.15. - 21:22:50] If you got an error related to the 'instnodrop' field, run the following SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;