Updating Database

[lethalllama]

SO how would i go about updating my World database so i could get Reflections Karazhan Mall thingy, im using some youtube repack Arcemu and i have already made many obsticle courses and whatnot

i want to be able to update my World.exe so my Creature_spawn will have the right amount of columns, so yeah help me out =P

[kreegoth]

Well updating your WorldDatabase doesnt have anything to do with how many columns you have.. you have to edit your database tables for Creature_spawns.. secondly you would get that persons Mall repack in a SQL file and execute it into your database

[lethalllama]

I did that, and i edited my Columns, If i made it have enough Columns for the Mall, The Server would not let me start up because Creature_spawns didnt have the right amount of columns, But if i had enough for the Repack to start up right, i didnt have enough for the Mall SQL

basically my DB is out of date

[kreegoth]

Well i suppose aside from updating your Revision.. you can modify the tables so you can run the Mall sql and then switch them back so the server loads..

[lethalllama]

If i did this Query:

ALTER TABLE creature_spawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_spawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

ALTER TABLE creature_staticspawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_staticspawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

While starting up World it would say

Major Error/Warning
One of your Creature_Spawns table has the wrong column count. arcemu has skipped loading the table to avoid crashing. Please correct this if you do not no spawns will show

If i didnt do the query, my server started without the error/warning. but i couldnt use the mall SQL

[kreegoth]

well you dont need the server running to load a SQL. just load Mysql and execute it into server and then fix the column count so server runs ....

[lethalllama]

the server starts up and runs fine, just the vendors arent there and half the stuff that shud be there isnt, cuz the server didnt load it cuz the columns were wrong so it "avoided a crash" VV

Major Error/Warning
One of your Creature_Spawns table has the wrong column count. arcemu has skipped loading the table to avoid crashing. Please correct this if you do not no spawns will show

[kreegoth]

ALTER TABLE creature_spawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_spawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

ALTER TABLE creature_staticspawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_staticspawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

Run that put in Mall then run

ALTER TABLE creature_spawns REMOVE bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

ALTER TABLE creature_staticspawns REMOVE bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

and start server..

[kreegoth]

Pretty much you need to remove the bytes1 column from creature_spawns then restart server..

[lethalllama]

and how do i update my revision without losing my obstacle courses and custom arenas

[lethalllama]

i tryd doing that and now when i try to run my query i get

1060 - Duplicate column name 'bytes0'

shud i delete bytes0? or would that **** up my server lol

[kreegoth]

What you query did was CHANGE the bytes column to bytes0 and added in bytes1..

leaving you with two columns for bytes.. When your emulator version is only looking for 1 column named bytes. so try removing the bytes1 column and rename bytes0 to bytes and start server

Ideally i would update your revision though IMO LOL..

[kreegoth]

Sorry missed your post about updating revision somehow LOL all you have to do to update your revision ( and it can be a pain i just revised form ascent to arcemu,,fun fun) is get new version of arcemu ... run the Sqls that come with it and make sure your database matches the column count for columns.. If you have any problems with that PM me and we can try to figure it out.

[lethalllama]

will updating my revision get rid of my obstacle courses? or no

[lethalllama]

and how do i go about deleteing Bytes1, if i hit remove record it does nothing.

i know im a super noob. lol