peq.items

[Kanlei]

I am just starting to create my own server to test and make sure that i can run one on the site before i shift to a minilogin and run just a local server. however I used Win cvs and downloaded the peq_db. I used the guide and got to the point for source Load_system.sql and it starts working fine. then when it gets to items.sql it starts an error message running and an beeps me to death saying peq.items table does not exist. I looked into my peq_db folder and there it is items.sql sitting in the folder plain as day with 32,269 KB of data in the file. But it will not source to mysql. i've tried to source that file only but does the exact same thing. every thing else sources fine just that one file. i've tried to remote checkout that file only. it downloads fine but i try to source it nothing by lines saying it doesn't exist. help please. i'm gonna try ax_classic_db to see if i can get the server up but was wondering what would cause that problem.

[techguy84]

Sounds like there may be a bug in the sql in side the items.sql file. It would be at the top regarding the creation of the Items table. Dont know for sure though. Maybe one of the PEQ team can comment on this one.

[Kanlei]

seems like for me both peq_db and Ax_classic db items is not sorucing correctly. can't seem to figure out why. I have server up and running logged in and everythig finally. i'm running mysql 6.0 and emu 1002. I've tried peq_db and ax_classic db now and both are giving items error. I've sourced peq_db and says items table doesn't exist but the file is there in peq_db. I sourced ax_classic and during the sourcing there were no errors. but when starting up world.exe causes items errors galore.

---------------------------------------------
[06.29. - 17:36:49] Starting Log: logs/eqemu_error_world_1904.log
[06.29. - 17:36:49] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,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,maxcharge s,itemtypselect source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,updated from items order by id

this one is interesting. however file doesn't exist.

[06.29. - 17:36:49] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql

please help if possible. still looking through threads to find solution. but search not helping.

[Kanlei]

I checked Mysql query browser and items show up in the database there unlike the peq_db where items.sql doesn't show up at all. not sure what to do exactly except try to drop the db and resource with the previous core update and see if that works.

[Kanlei]

I dropped the database and resourced. but still the same gonna try to dl the database for ax_peq and try that database to see if the items will finally work. not sure what's going on but both peq and ax classic items tables won't load on my server. I can login and run my server just fine but with no items what fun is that. anyway if anyone knows of any solutions feel free to reply and say HEY stupid! do this and this should fix your problem would be well appreciated.

[Angelox]

To start with, I would think you have the wrong version MySql (6x?) - you need to use an early version of MySql 5x. My Version is 5.0.24a, the Devs haven't really tried out or tested 6x versions.
What you are looking at in /source/utils (items-0.6.0-DR2-0.6.1-DR1-convert.sql), is not for a MySql version , but for converting an old database to a newer one, and you don't need it either, as My database is always up to date - and the installation is very simple. In fact, you shouldn't need to even look in /source/utils, unless you use a Linux box and compiled, then you would need to copy over a few things. But still you would never need the items-0.6.0-DR2-0.6.1-DR1-convert.sql , unless you have an old 6x eqemu database.
So, it appears you have a windows server - and if you are starting out, the install with the binaries is the way to go, tell you get the hang of it all.

[Kanlei]

OIC, K will try that and see if that's the problem. seems like everything else works for mysql 6.0.0 except the items tables. Will just try to use older version of mysql. right now i'm attempting what techyguy84 suggested in pm to check. thanks for the info. and I like what i seen of the world using your database exactly how i remember it from the old days. Good job Angelox =).

kan

[Kanlei]

Thanks Angelo that solved the issue. I am now running mysql 5.0.41 and did not give me the error. everything is appears stable and working great going to login and see how the world looks now. as for mysql 6.0.0, everything was working except for items tables for both ax and peq databases. so for anyone thinking that maybe the guide is behind the times a little bit and DL's the newest version of mysql stop thinking and just DL what the guide says. thanks for the input.

Kan