ArcEmu Database problems

[roguesownu]

Every database I download for ArcEmu when I start up the server it says creature_spawns has the wrong column count and it wont load the creatures until this is fixed. Can someone either point me to a database they know works or instruct me on how to fix it?

Also with my logon database, I have an account setup but it doesn't let me log into the server, it just says that the information I have entered is not correct when I try to log in.

I am using the latest patch of WoW and the latest revision of ArcEmu.

Thanks in Advanced

+Rep for people whose advice is helpful

[Performer]

Try this

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;

And hit continue with error's if your using Navicat.

[roguesownu]

Thank you, this worked! +Rep

[Deafrunner]

Hey could you possibly say step by step in navicat what I am suppose to do I just got the same problem and I'm kinda a newb at such things and could use the help
thanx again and I am thankful for what your doing.

[latruwski]

Hey could you possibly say step by step in navicat what I am suppose to do I just got the same problem and I'm kinda a newb at such things and could use the help
thanx again and I am thankful for what your doing.

in navicat make a query and enter:

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;

and run it...

OR save that code with notepad as a SQL file then go to navicat, right click the DB -> execute batch file and select that SQL FILE

[Deafrunner]

thanx so much how do i pluss rep you?

[Lukas 45]

Press the little +Rep buttom under the sign. Chose number of rep(See your: Rep Power: x). Chose a reason to rep him(Fx: Thx for help ). And you can try with me xD

[Deafrunner]

hey one more question when i do that it comes up with alot of errors and its saying that in sqlyog it comes up with this message maybe this will help allitle with what i need i dont know

Error Code : 1054
Unknown column 'bytes' in 'creature_spawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

Error Code : 1054
Unknown column 'bytes' in 'creature_staticspawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

what should i do about that if anyone could inform me and possibly in detail again im sorry im kinda a newb like i said.

[joshvan14]

hey one more question when i do that it comes up with alot of errors and its saying that in sqlyog it comes up with this message maybe this will help allitle with what i need i dont know

Error Code : 1054
Unknown column 'bytes' in 'creature_spawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

Error Code : 1054
Unknown column 'bytes' in 'creature_staticspawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

what should i do about that if anyone could inform me and possibly in detail again im sorry im kinda a newb like i said.

if you guys could help us for this it would be fantastic.

[latruwski]

hey one more question when i do that it comes up with alot of errors and its saying that in sqlyog it comes up with this message maybe this will help allitle with what i need i dont know

Error Code : 1054
Unknown column 'bytes' in 'creature_spawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

Error Code : 1054
Unknown column 'bytes' in 'creature_staticspawns'
(0 ms taken)

Error Code : 1060
Duplicate column name 'bytes1'
(0 ms taken)

what should i do about that if anyone could inform me and possibly in detail again im sorry im kinda a newb like i said.

means you already have that update...

grtz

[Deafrunner]

so how do I get these error codes to go away
and keep all the npcs still there when the server restarts
sorry im just new to all this

[joshvan14]

what update does he need then if that one is not the right one?

[latruwski]

depends on the revision he is using....
check the arcemu SVN for updates you need

or post what revision you have here...

[joshvan14]

tyvm i will reply again and say if it worked or not

[Deafrunner]

Im not sure what rev it is but i know im using the total war repack if that helps