Problems after upgrading from June to current release

[gnode]

So, this is my game plan. Once I get the current PEQ db loaded and my recent backup db loaded, I am going to use this tool:
http://www.databasejournal.com/featu...l---SQLyog.htm

to bring my backup db's structure up to the same as the new peq db structure.

Then I am going to do all of the inserts in my existing db update script to fill in the necessary data from the updates.

Hope this works...

[Andrew80k]

You shouldn't need to upgrade your Mysql though. I've been using 5.0 for over a year and I've not had any issues. Let us know if we can help some way. Keep in mind it is hard for us to see what's going on so give as much detail as you can.

[gnode]

Upon further examination, I don't know if my db is the problem at all.

I straight up copied the current peq db right in and overwrote all my files just to see if it would get world to boot... it did not.

This is a syntax error, not a missing/wrong column error:
[02.12. - 21:50:31] 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', #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,itemtype,material,sellrate,UN' at line 1


I now suspect I have a bad program file somewhere. Can anyone check the source to see where this query is done?

[cavedude]

Which files exactly are you sourcing? What is the address you are getting them from?

[gnode]

Originally Posted by cavedude

Which files exactly are you sourcing? What is the address you are getting them from?

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


Featured download: Revision302.zip

That is the changelog I originally followed, also.

[Andrew80k]

I think cavedude means which database.

[gnode]

peqdb_1129Rev311.sql

Then all of the miscellaneous *.sql files that did not involve dropping tables.

Thanks for the help... going to bed tonight and will look at it later. I am about ready to zip my db up and send it to someone to make an update script for me for some $$ because this is getting kind of ridiculous.