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;

[Derision]

That column (custom_data) was added by 2024_required_update.sql

I'm using an old DB that I have updated over time. Maybe that update is missing from PEQ r57 peqdb_rev2027.sql.gz if that is the DB you have installed.

EDIT: No, that column is there for a brand new install. Sounds like you missed this in the readme.txt:

4. Enter the updates folder, read the readme.txt there and be sure to source in any updates since the last time you updated.

You still need to source updates that affect 'player' tables, of which inventory is one.