Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2006, 06:31 AM
jumbodogs
Fire Beetle
 
Join Date: Dec 2005
Posts: 17
Default 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.
Reply With Quote
  #2  
Old 01-04-2006, 02:05 PM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

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;

__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #3  
Old 01-04-2006, 03:20 PM
jumbodogs
Fire Beetle
 
Join Date: Dec 2005
Posts: 17
Smile

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

Thanks again
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:15 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3