No items in game
 

I can't summon any items in the game and mobs don't have items. I am running 0.6.1 eqemu. I created a database and used the files load_system.sql and load_empty_users.sql. My db.ini matches the database I made.

When I load world.exe I see this
[Status] Starting Log: logs/eqemu_world_4084.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Status] EMuShareMem loaded
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
23621064
18249717
[Status] Loading items from database: count=46073
[Error] Starting Log: logs/eqemu_error_world_4084.log
[Error] DBLoadItems query 'select serialization,itemclass,name,lore,idfile,id,we
ight,norent,nodrop,size,slots,price,icon,UNK012,UN K013,benefitflag,tradeskills,c
r,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,h p,mana,ac,deity,skillmodvalue,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime_,reqlevel,bardtyp
e,bardvalue,light,delay,reclevel,recskill,elemdmgt ype,elemdmgamt,range,damage,co
lor,classes,races,UNK054,maxcharges,itemtype,mater ial,sellrate,UNK059,casttime,U
NK061,procrate,combateffects,shielding,stunresist, strikethrough,extradmgskill,ex
tradmgamt,spellshield,avoidance,accuracy,charmfile id,factionmod1,factionmod2,fac
tionmod3,factionmod4,factionamt1,factionamt2,facti onamt3,factionamt4,charmfile,a
ugtype,augslot1type,augslot2type,augslot3type,augs lot4type,augslot5type,ldonthem
e,ldonprice,ldonsold,bagtype,bagslots,bagsize,bagw r,book,booktype,filename,baned
mgraceamt,augrestrict,loreflag,pendingloreflag,art ifactflag,summonedflag,favor,f
vnodrop,endur,dotshielding,attack,regen,manaregen, haste,damageshield,recastdelay
,recasttype,guildfavor,augdistiller,UNK117,UNK118, attuneable,nopet,UNK121,pointt
ype,potionbelt,UNK124,clickeffect,clicktype,clickl evel,UNK129,proceffect,proctyp
e,proclevel,UNK133,worneffect,worntype,wornlevel,U NK137,focuseffect,focustype,fo
cuslevel,UNK141,scrolleffect,scrolltype,scrollleve l,UNK145,stacksize,updated fro
m items order by id', #1054: Unknown column 'attuneable' in 'field list'
[Error] If you got boat loads of errors, make sure you sourced: utils/items-0.6.
0-DR2-0.6.1-DR1-convert.sql <------(I did this)

Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Formatting drive C:
TCP listening on: 127.0.0.1:9000
Starting factory Reader
Starting factory Writer
World server listening on: 127.0.0.1:9000
Setting World to MiniLogin Server type
Connected to LoginServer: 127.0.0.1:5999
325984 New TCP connection: 127.0.0.1:16777343
325984 New TCP connection: 127.0.0.1:16777343
325984 New TCP connection: 127.0.0.1:16777343
325984 New TCP connection: 127.0.0.1:16777343
325984 New TCP connection: 127.0.0.1:16777343
New zoneserver: #1 127.0.0.1:1227
New zoneserver: #2 127.0.0.1:1231
New zoneserver: #3 127.0.0.1:1230
New zoneserver: #4 127.0.0.1:1229
New zoneserver: #5 127.0.0.1:1228
Zoneserver SetConnectInfo: 127.0.0.1:1228: 127.0.0.1:8783
Zoneserver SetConnectInfo: 127.0.0.1:1229: 127.0.0.1:8781
Zoneserver SetConnectInfo: 127.0.0.1:1230: 127.0.0.1:8782
Zoneserver SetConnectInfo: 127.0.0.1:1231: 127.0.0.1:8780
Zoneserver SetConnectInfo: 127.0.0.1:1227: 127.0.0.1:8784
505187 New client from ip: 127.0.0.1 port: 1242
Logged in: (CharSel) Account #1: jumbodogs
[Debug] Starting Log: logs/eqemu_debug_world_4084.log
[Debug] Unable to convert EQ opcode 0x071e to an emu opcode.
Received unknown opcode: 0x0000 size:0 bytes

I also get this error from minilogin but I can still login not sure what it is

LoginServer.ini read.
[Status] Loading opcodes..
Opcode OP_LoginServerDisconnect is missing from opcodes.conf
[Error] Loading opcodes failed. I cant live like this!
Server mode: MiniLogin
Login server listening on port:5999
Starting factory Reader
Starting factory Writer
8203 New Server connection: 127.0.0.1 port: 48900
435500 New client from ip: 127.0.0.1 port: 1240
494422 New client from ip: 127.0.0.1 port: 1241
Unknown packet: 0: 00 05 00 00 00 00 00 00 - 00 00 00 | .....
......

another thing that seems strange is that if I look in minmysqladmin window and look at the databases is that I only see test but if I login and type use eq it changes to the database I put in.

Thanks for any help I can get on this.

The 'attuneable' field is missing in your version of the items table.

Add it with the following at a mysql (not DOS command -- mysql command) prompt:

ALTER TABLE items ADD attuneable int(11) NOT NULL default 0;

Wow can't thank you enough .... put that in and everything seems great so far

Thanks again :)