Problems after upgrading from June to current release

[gnode]

I upgraded from the june build to the Sep 2 build tonight.

I have the following problems:
1. Disciplines no longer work, but all other spells do.
2. PEQZONE no longer works, but I have the status for it set to 0. When I #peqzone, it says command not recognized.

Any idea?

[trevius]

Maybe you don't have all of the required SQL changes in. Also, why would you use the Sep 2 build? You should be using the SVN revisions found here:

http://code.google.com/p/projecteqemu/

There are hundreds of changes and updates in the SVN since that Sep 2 build, so it would be best to use it instead. Make sure you run the SQL updates in the /utils/sql/svn directory though.

I believe there was some changes to #peqzone in there at some point, but it should be working on the latest revisions from the SVN.

[gnode]

Sep 2 is just the latest one here:
http://www.eqemulator.net/download.php

So that is what I used. I will try the other stuff tonight I guess.

[cavedude]

Yep, the full version of #peqzone as used on TGC is only available on SVN. It is not in the ancient builds on the EQEmu page.

[gnode]

First thing first. I want to thank you all for all the effort you have put into this project. After reading through the changelog, I see just how much work you have put into this and I appreciate it.

Ok I reviewed the changelog and went through and did all sql updates I saw in the changelog and all that were referenced by the changelog that are on the SVN.

I fixed my perl (got the dll error and used search function )

When I tried to start the server, I get a ton of errors and a message in the log of:
If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql

I pulled that script from the SVN and ran it. The script itself gave a boatload of errors. Mainly like this:
Unknown column 'unknown021' in 'items'

It looks like it is trying to update the items table from a version other than the one I have. I suspect I may be missing some earlier changes that this script relies on.

Here is the error I got that prompted the mentioning of that SQL script:
[02.11. - 21:25:53] Starting Log: logs/eqemu_error_world_10016.log
[02.11. - 21:25:53] 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,augslot1visible,augslot2type,augslot2visible ,augslot3type,augslot3visible,augslot4type,augslot 4visible,augslot5type,augslot5visible,ldontheme,ld onprice,ldonsold,bagtype,bagslots,bagsize,bagwr,bo ok,booktype,filename,banedmgraceamt,augrestrict,lo regroup,pendingloreflag,artifactflag,summonedflag, favor,fvnodrop,endur,dotshielding,attack,regen,man aregen,enduranceregen,haste,damageshield,recastdel ay,recasttype,guildfavor,augdistiller,UNK123,UNK12 4,attuneable,nopet,UNK127,pointtype,potionbelt,pot ionbeltslots,stacksize,notransfer,stackable,UNK134 ,clickeffect,clicktype,clicklevel,clicklevel2,proc effect,proctype,proclevel,proclevel2,worneffect,wo rntype,wornlevel,wornlevel2,focuseffect,focustype, focuslevel,focuslevel2,scrolleffect,scrolltype,scr olllevel,scrolllevel2,updated from items order by id', #1054: Unknown column 'augslot1visible' in 'field list'



This is preventing zone.exe from loading. Also, if this helps, these errors are what happen when a character gets to char select:
[02.11. - 21:26:24] Warning: acctid 1158 has an invalid item_id 30088 in inventory slot 2500
[02.11. - 21:26:24] Warning: acctid 1158 has an invalid item_id 30096 in inventory slot 2501
[02.11. - 21:26:48] Warning: acctid 860 has an invalid item_id 17005 in inventory slot 2500
[02.11. - 21:26:48] Warning: acctid 860 has an invalid item_id 17005 in inventory slot 2501
[02.11. - 21:26:48] Warning: acctid 860 has an invalid item_id 17005 in inventory slot 2500
[02.11. - 21:26:48] Warning: acctid 860 has an invalid item_id 17005 in inventory slot 2501
[02.11. - 21:29:10] Warning: acctid 329 has an invalid item_id 17970 in inventory slot 2500
[02.11. - 21:29:10] Warning: acctid 329 has an invalid item_id 17969 in inventory slot 2501

[Andrew80k]

You haven't applied all the updates. This one is in 292_augslots.sql in the svn. You may have appled them and then overwrote them with a database or something.