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

11-16-2004, 02:53 AM
|
 |
Banned
|
|
Join Date: Nov 2004
Location: Lake Isabella
Posts: 90
|
|
#::EDITED::#
Ok i got this resolved not sure how but i did.
Code:
[Status] Loading items from database: count=36965, max id=77768
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclass,name,lore,idfile,id,weight,n
orent,nodrop,attuneable,size,slots,cost,icon,unknown018,unknown019,unknown020,tr
adeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,ski
llmodvalue,skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime2,haste
proclvl,reqlevel,bardtype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,el
emdmgamt,effecttype,range,damage,color,classes,races,unknown061,spellid,maxcharg
es,itemtype,material,sellrate,unknown067,casttime,unknown069,proc_rate_mod,focus
id,combateffects,shielding,stunresist,strikethrough,combatskill,combatskilldmg,s
pellshield,avoidance,accuracy,unknown081,factionmod1,factionmod2,factionmod3,fac
tionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,augtype,augsl
ot1type,augslot2type,augslot3type,augslot4type,augslot5type,ldonpointtheme,ldonp
ointcost,ldonsold,bagtype,bagslots,bagsize,bagwr,unknown105,booktype,filename,ba
nedmgamt2,augmentrestriction,loreflag,pendingloreflag,artifactflag,summonedflag,
tribute,gmflag,endur,dotshielding,attackbonus,hpregen,manaregen,hastepercent,dam
ageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'unknown008'
in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
|
 |
|
 |
 |
|
 |

02-08-2006, 08:01 AM
|
|
Fire Beetle
|
|
Join Date: Jan 2006
Posts: 13
|
|
Items DB trouble
Having more or less the same problem; this is what mine is saying now..
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'unknown10
7' in 'field list'
I tried using the tip from Cisyouc;
ALTER TABLE items ADD COLUMN `attuneable` tinyint(3) unsigned NOT NULL default '0';
changing the column name to unknown107, but it keeps giving me a syntax error. What am I missing here; I'm using the 5.8 classic db and trying to use the 5.5 EQEmu.
|
 |
|
 |

02-10-2006, 03:41 AM
|
|
Hill Giant
|
|
Join Date: Nov 2005
Posts: 145
|
|
Ummm
Any chance you could use Mysq Front to check and see what fields you have in your items table, appears as tho you are missing a whole pile of fields(all of them). Does the database you loaded even include items? If it doesnt you may want to load the 13thfloor items.
|
| Thread Tools |
|
|
| Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:01 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |