Database Error
I'm using the database MW_057DR2_alpha_1.sql
this is my world.exe output: [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6 [Status] Loading variables.. [Status] Loading zones.. [Status] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=28731, max id=69304 [Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n orent,nodrop,size,slots,cost,icon,unknown018,unkno wn019,unknown020,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,casttime2,hasteproclvl,req level,bardtype,bardvalue,light,delay,reclevel,recs kill,elemdmgtype,elemdmgamt,ef fecttype,range,damage,color,classes,races,unknown0 61,spellid,maxcharges,itemtype ,material,sellrate,unknown067,casttime,unknown069, proc_rate_mod,focusid,combatef fects,shielding,stunresist,strikethrough,combatski ll,combatskilldmg,spellshield, avoidance,accuracy,unknown081,factionmod1,factionm od2,factionmod3,factionmod4,fa ctionamt1,factionamt2,factionamt3,factionamt4,char mfile,augtype,augslot1type,aug slot2type,augslot3type,augslot4type,augslot5type,l donpointtheme,ldonpointcost,ld onsold,bagtype,bagslots,bagsize,bagwr,unknown105,b ooktype,filename,banedmgamt2,a ugmentrestriction,loreflag,pendingloreflag,artifac tflag,summonedflag,tribute,gmf lag,endur,dotshielding,attackbonus,hpregen,manareg en,hastepercent,damageshield,m instatus FROM items ORDER BY id', #1054: Unknown column 'charges' in 'field list ' 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.. [Error] Could not load EQTime file ./eqtime.cfg [Error] Unable to load ./eqtime.cfg [Status] Reboot zone modes ON [Status] Deleted 0 stale player corpses from database [Status] Deleted 0 stale player backups from database Formatting drive C: TCP listening on: 99.99.999.999:9000 World server listening on: 99.99.999.999:9000 Connected to LoginServer: eqemulator.net:5995 |
I had that problem. I ran the following from mysql and it worked after that:
Code:
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0; |
WRONG. FORUM.
Moved to Win32 Support. Ask your goddamn server questions in Win32 server support. |
mysql> ALTER TABLE `npc_typs` ADD `AC` smallint(5) not null default 0;
ERROR 1146: Table 'eq2.npc_typs' doesn't exist |
I did what jimbox114 said to do but i still get this world.exe output:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6 [Status] Loading variables.. [Status] Loading zones.. [Status] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=28731, max id=69304 [Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n orent,nodrop,size,slots,cost,icon,unknown018,unkno wn019,unknown020,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,casttime2,hasteproclvl,req level,bardtype,bardvalue,light,delay,reclevel,recs kill,elemdmgtype,elemdmgamt,ef fecttype,range,damage,color,classes,races,unknown0 61,spellid,maxcharges,itemtype ,material,sellrate,unknown067,casttime,unknown069, proc_rate_mod,focusid,combatef fects,shielding,stunresist,strikethrough,combatski ll,combatskilldmg,spellshield, avoidance,accuracy,unknown081,factionmod1,factionm od2,factionmod3,factionmod4,fa ctionamt1,factionamt2,factionamt3,factionamt4,char mfile,augtype,augslot1type,aug slot2type,augslot3type,augslot4type,augslot5type,l donpointtheme,ldonpointcost,ld onsold,bagtype,bagslots,bagsize,bagwr,unknown105,b ooktype,filename,banedmgamt2,a ugmentrestriction,loreflag,pendingloreflag,artifac tflag,summonedflag,tribute,gmf lag,endur,dotshielding,attackbonus,hpregen,manareg en,hastepercent,damageshield,m instatus FROM items ORDER BY id', #1054: Unknown column 'charges' in 'field list ' 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.. [Error] Could not load EQTime file ./eqtime.cfg [Error] Unable to load ./eqtime.cfg [Status] Reboot zone modes ON [Status] Deleted 0 stale player corpses from database [Status] Deleted 0 stale player backups from database Abort/retry/cancel? TCP listening on: 99.99.999.999:9000 World server listening on: 99.99.999.999:9000 Connected to LoginServer: eqemulator.net:5995 |
no, you mispelled it. double check your shit, re-read it and copy and paste. refuse to help idiots )
ur using an incompatible items table for whatever source you're using. |
Cari which version of CVS are you using and I'm talking about date or site gathered from (ie. is this blastoma's and 7/31/04)?
I'm asking this because obviously from your output you did not use the itemtablechanges.sql from 7/31/04 source code which it adds "charges" a few others and updates a few. Just a thought but even with your typo's your not going to get the db up and running without the itmetablechanges.sql file found in the 7/31/04 source code. Darkwaters |
no cvs
|
Quote:
Didnt i give you the compiles that i made?? if you where using those, then its from 7/31 . if you got compiles from somewhere/someone else also then i dont know. |
All times are GMT -4. The time now is 11:54 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.