Updating Database

[kreegoth]

Updating your revision wont get rid of anything as long as you make the changes needed to make your database compliant..

Ok.. well In navicat your going to click the table you want to edit which is Creature_spawns
Then near the top of the screen youll see Design TABLE tab..its underneath stored procedures.


Then when you have clicked design table you will see the fields listed in that table for Creature_spawns..

Scroll down til you see Bytes1..

highlight it and right click select delete field..

Accept...

Close saving changes..

Then try to restart server .. Let me know how you make out

[lethalllama]

ok i really messed this up, so ima just try and update my revision, what website do i go to for that

[kreegoth]

Under releases in the forums theres a post where there are the latest arcemu compiled versions...


What exactly did you mess up?.

[lethalllama]

i think i have a really early version of arcemu, cuz i have 17 columns in my Creature_spawns and the mall sql needs 20, so yeah, making 1 more bytes didnt even fix it

and even when the query is successful i cant execute the file

[kreegoth]

oh ok.. well unless you wanna design the table and make three blank columns at the end of the table with same values as column above it then run SQL then take out the columns again...

youll have to update the revision yeah...

Sorry wish i could have helped more

[ninjawarrior]

hey lethalllama are u using joveds? cuz i am too and i just ran into the same problem as you lol tried getting the mall n cant figure out how to update the database lol

so does any1 know a link to a guide that says how to update?