Empty Vendors, Empty Loot, No Quests

[cavedude]

http://eqemulator.net/forums/showthread.php?t=24731 will give you the answer. Look for my first post, 4 posts down.

[suprphrk]

Thanks for the quick reply, CaveDude.

I ran the sql command to change the mode, but I'm pretty sure I set it up non-strict (have a WIMP config that also runs WoW server). When I dropped and re-pop'd the db after running that, and after I restarted my server, I'm still having the same issues. Anything else it could be?

[suprphrk]

I just tried to do an #itemsearch with my gm character on the account, and any item id i put in doesn't work, at least with the ID from the item database. For instance, he's a pally, I'm trying to give him a Soulfire. I look in the db, find the soulfire as item 5504. I then go in and do #itemsearch 5504, and it gives me "Item #5504 not found".

[Theeper]

itemsearch looks for items by name and gives you the ID. Do #itemsearch soulfire and then do #si itemID. Or just do #si 5504 since you already know the ID.

[suprphrk]

I did #itemsearch soulfire and it gave back "0 items found". I did #si 5504, and it said "No such item: 5504". I think that the issue is that SOME tables are hitting ok, ie. the mobs are showing up, they have coin on them, but no items. Yet some tables, like loot, vendors, startitems, items aren't hitting.

[Theeper]

You should be able to see on the console when the server boots how many items get loaded right before it tells you to hit enter to continue loading. It will say something like "62,555 items loaded".

There are no tables called loot or vendors though.

[suprphrk]

Theeper-

Thanks for the point in the right direction. I saw it say that it loaded items from db 62256, but I didn't pay attention to what was right after it:

[Status] Loading items from database: count=62256
[Error] Starting Log: logs/eqemu_error_world_5128.log
[Error] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,no
rent,nodrop,size,slots,price,icon,UNK012,UNK013,benefitflag,tradeskills,cr,dr,pr
,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,UNK033,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime_,reqlevel,bardtyp
e,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,range,damage,co
lor,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UNK059,casttime,U
NK061,procrate,combateffects,shielding,stunresist,strikethrough,extradmgskill,ex
tradmgamt,spellshield,avoidance,accuracy,charmfileid,factionmod1,factionmod2,fac
tionmod3,factionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,a
ugtype,augslot1type,augslot1unk,augslot2type,augslot2unk,augslot3type,augslot3un
k,augslot4type,augslot4unk,augslot5type,augslot5unk,ldontheme,ldonprice,ldonsold
,bagtype,bagslots,bagsize,bagwr,book,booktype,filename,banedmgraceamt,augrestric
t,loregroup,pendingloreflag,artifactflag,summonedflag,favor,fvnodrop,endur,dotsh
ielding,attack,regen,manaregen,enduranceregen,haste,damageshield,recastdelay,rec
asttype,guildfavor,augdistiller,UNK123,UNK124,attuneable,nopet,UNK127,pointtype,
potionbelt,potionbeltslots,stacksize,notransfer,stackable,UNK134,clickeffect,cli
cktype,clicklevel,clicklevel2,proceffect,proctype,proclevel,proclevel2,worneffec
t,worntype,wornlevel,wornlevel2,focuseffect,focustype,focuslevel,focuslevel2,scr
olleffect,scrolltype,scrolllevel,scrolllevel2,updated from items order by id', #
1064: You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use near 'range,damage,color,
classes,races,UNK054,maxcharges,itemtype,material,sellrate,UN' at line 1
[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 don't have utils/items-06.0-DR2-0.6.1-DR1-convert.sql. I haven't searched the net for it yet, but further searching for the problem that it mentions in the error shows that "range" is a reserved word in SQL 5.1+. Will running this .sql script fix my problem if I find it? Or am I barking up the wrong tree with it?