Major Error/ Warning!

[George0wnz]

This is an error i get when i start ArcEmu-World.

*********************************************************************
* MAJOR ERROR/WARNING *
* =================== *
* One of your creature_spawns table has the wrong column count. *
* arcemu has skipped loading this table in order to avoid crashing. *
* Please correct this, if you do not no spawns will show. *
*********************************************************************

Extra info:
~ I am running ArcEmu for 2.4.3q.
~ I also use SQLyog Enterprise. (Navicat if needed.)
~Reflection's Karazhan Mall (2.4.3) and Reflection's Stormwind Vault Mall (2.4.3)
~ I know nothing about the Tool.Bat (even so i have looked all around the forum to find information about it)
~ I know nothing about the Database and how to use it except load the SQL files Vendors,Items,Portals,NPC.etc..)

The things i have tried:

1) I have tried reinstalling the pack and reinstalling the malls more then once.
2) I have tried different kind of malls and they all seem to give me the same error.
3) Tried different repacks with the same malls. (Epic Fail!)
4) I tried Reflections idea:

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;

5) The last not least i have tried adding the database by myself and it would still not work.


I understand that this might be a simple problem and can be fixed, but i really need your help. I am new to this stuff and willing to learn.

I would appreciate if i can get a link or something to help me out.
New Database would be a nice!

+Rep If you help!
Thanks

[kreegoth]

* MAJOR ERROR/WARNING *
* =================== *
* One of your creature_spawns table has the wrong column count. *
* arcemu has skipped loading this table in order to avoid crashing. *
* Please correct this, if you do not no spawns will show. *

Is caused by not having enough columns in your creature_spawns table.. its expecting say 80 and you have 79..

If you downloaded a revision make sure you ran all of the Sql updates that came with it for that revision.. Also you can try Designing the Table and adding in an extra column or two.

if you set your log files settings for world to 3 youll get more info out of the world screen and it will probably show you how many your missing and youc an post that here and ill help you sort it out..

Also if you post what REVISION of arcemu your using it would be helpful ..

Aside from that giving a list of what tables you have PRESENTLY in your creature_spawns table would be a good idea as well..

[George0wnz]

* MAJOR ERROR/WARNING *
* =================== *
* One of your creature_spawns table has the wrong column count. *
* arcemu has skipped loading this table in order to avoid crashing. *
* Please correct this, if you do not no spawns will show. *

Is caused by not having enough columns in your creature_spawns table.. its expecting say 80 and you have 79..

If you downloaded a revision make sure you ran all of the Sql updates that came with it for that revision.. Also you can try Designing the Table and adding in an extra column or two.

if you set your log files settings for world to 3 youll get more info out of the world screen and it will probably show you how many your missing and youc an post that here and ill help you sort it out..

Also if you post what REVISION of arcemu your using it would be helpful ..

Aside from that giving a list of what tables you have PRESENTLY in your creature_spawns table would be a good idea as well..

I am at work atm, but when i get home i will make sure to do so.

All i know and what i did is:

Youtube: how to make a privet server using ArcEmu for 2.4.3q.
DL that and follow the instructions they gave me in the Video
DL the Pack from mmo to get the mall.

If you can lead me step by step how to get it fixed or how for me to supply you the information that needed. I will do so.
Thanks for the help

[kreegoth]

Your best bet is to probably wait til tonight when your home from work and Add me to your MSN and ill try to help ya best i can that way its better than posting 400 times on here..

Just PM me your MSN info if you want help that way or we can attempt to do it through PMs here..

[George0wnz]

Alright sounds good I dont have MSN, but i might make one when i get home i do have AIM or Yahoo.

[Apartment Wolf]

creature_spawns table redownload one from a source and replace it!

[kreegoth]

Right but that would give him a blank creature table hes trying to use a Custom database with his version of Arcemu

[George0wnz]

I mean yeah i understand, but i have put a lot of work and time into my server and i dont want to delete anything on it, i just want to make sure the creature_spawn works. I dont mind getting a new database or a new Version with the latest database. JUST WANT IT TO WORK !

[George0wnz]

creature_spawns table redownload one from a source and replace it!

This is a good idea, but i am really new to all of this. I will need to have step my step instructions on where to get the latest data base and how to use the tool.bat to convert it.
Seems like i know what i am saying, but to tell you the truth i dont know how to do it lol.

[George0wnz]

bump the post.

[kreegoth]

Ok well since me and you cant seem to make our schedules work on MSN keep missing eachother ( i will be on tonight around 1030pm est for sure) What you will need to do is download a revision that matches your and run the Sql updates for it on your server should fix it for ya.. if it doesnt your missing a table you need to find out what table that is and add it or take out of the ones that doesnt belong.

[George0wnz]

Ok well since me and you cant seem to make our schedules work on MSN keep missing eachother ( i will be on tonight around 1030pm est for sure) What you will need to do is download a revision that matches your and run the Sql updates for it on your server should fix it for ya.. if it doesnt your missing a table you need to find out what table that is and add it or take out of the ones that doesnt belong.

Would u mind giving me a link where i can get a good emulator pack and revision for it.

Or just tell me what i need to DL where do i get it.
How to update the SQL.

[kreegoth]

Well what revision are you using.. Once you know that just download a precompile from the releases section here from Fantomas... He has alot of precompiles for all the revisions(make sure you pick the SAME revision as yours).. inside that .rar youll find a Folder called Sql_updates.. execute all of them in there into your database and it should fix it and keep your custom info.