Everything done getting this error?

[Lancex]

//CLOSED//
So I have done EXACTLY everything it says here : Getting the source code - ArcEmu-Wiki I have done it part by part till the end, didn't do anything on my own. Only the MySQL names etc I changed. But when I try to start the server I get this error from the World.exe
------------------------------------------------------------------------------------------------------------
[02:10][Arcemu][2011-11-30 02:10:57]
[02:10][Arcemu]ArcEmu 4.0-TRUNK b9737de/Debug-Win32-X86 :: World Server
[02:10][Arcemu]Sql query failed due to [Table 'arc_world.world_db_version' doesn't exist], Query: [SELECT LastUpdate FROM world_db_version;]
[02:10][Arcemu]Database: World database is missing the table `world_db_version` OR the table doesn't contain any rows. Can't validate database version. Exiting.
[02:10][Arcemu]Database: You may need to update your database
[02:11][Arcemu][2011-11-30 02:11:05]
[02:11][Arcemu]ArcEmu 4.0-TRUNK b9737de/Debug-Win32-X86 :: World Server
[02:11][Arcemu]Sql query failed due to [Table 'arc_world.world_db_version' doesn't exist], Query: [SELECT LastUpdate FROM world_db_version;]
[02:11][Arcemu]Database: World database is missing the table `world_db_version` OR the table doesn't contain any rows. Can't validate database version. Exiting.
[02:11][Arcemu]Database: You may need to update your database
---------------------------------------------------------------------------------------------------------------
Now updating is something I still couldnt figure out from the arcemu site. Is this just because I need to update the database. I and playing on 3.3.5 so which database I should load, from where and how the updating is done?


Sorry, getting really frustrated cause I am making a server and I really can't begin untill the server is uo and runnign :S

[shumi]

Errors are good. They tell you what you did wrong.
Here you dodn't do anything wrong, you just didn't add the updates from the sql folder of your arcemu source code.

[stoneharry]

What shumi said,

If you go into your ArcEmu folder -> sql -> world -> and apply the relevant updates from there, then it should be good.

[Lancex]

Okay Im gonna try that I hope it works. Gonna info back soon and info if it worked thx

---------- Post added at 09:36 AM ---------- Previous post was at 09:29 AM ----------

Well when executing the sql in the "world_updates" folder it errors :"SQL Error (1146): Table 'arc_logon.items' doesn't exist .

When executing sql named "mail_flags,sql" from the "Character_updates" folder it errors "SQL Error (1146): Table 'arc_logon.mailbox' doesn't exost.

When executing sql named "saved_mail.sql" fron the same folder it errors "SQL Error (1146): Table 'arc_logon.playeritems' doesnt exist

Should I worry about these or.....

[shumi]

You are executing the updates to wrong databases. :|

Execute world update to world database and so on.
They don't have those name just for show.
Those names means something.

[Lancex]

Oops Yeah. Well still getting some errors.

In characters I get this :" SQL Error (1054) Unknown column 'read_flag' in 'mailbox'.
--||-- I get this: SQL Error (1060): Duplicate column name 'text'

Other updates executed fine!

---------- Post added at 10:51 AM ---------- Previous post was at 10:12 AM ----------

The world-error.log says the following about the error:

[17:36][Arcemu]Database: Last character database update doesn't match the required one which is 2011-11-16_22-00_saved_mail.
[17:36][Arcemu]Database: You need to apply the character update queries that are newer than 2011-11-12_20-00_initial. Exiting.
[17:36][Arcemu]Database: You can find the character update queries in the sql/character_updates sub-directory of your Arcemu source directory.

[stoneharry]

Apply the character updates in arcemu/sql/character folder to your char DB.

[Lancex]

I did and I get an error from executing the _mail_flags.sql :" SQL Error (1054) Unknown column 'read_flag' in 'mailbox'. "
and an error when executing the _saved_mail.sql :"SQL Error (1060): Duplicate column name 'text' "
These .sql's are from the Arcemu->sql->character_updates folder

[shumi]

you need to execute them in a order.
Not what you want.

[Lancex]

I have executed them in order from top to down. Still getting those errors. Should I know delete the database or create new one and once again import the data from arcemu to HeidiSQl and then execute those sql in order. Is the order from top to down or something else?

[stoneharry]

If you don't mind losing your characters, just drop the database and import the ArcEmu character structure.

If you do mind - you will need to find the older-SQL statements from before they did the GIT move to find what you are missing. You can find these deleted files here: https://github.com/arcemu/arcemu/com...b4e4b417b0da2f

Careful what you apply, and don't bother executing the DB version update as there's a new DB version system.

[Lancex]

Well I havent been able to play at the server yet so there should be no characters there so I think I am going to import the ArcEmu character Structure.....

---------- Post added at 03:04 PM ---------- Previous post was at 03:01 PM ----------

OKay I dopped it and executed the structure from the ArcEmu Folder. Now Is there a certain order in which I should execute those three .sql files to the character database?

[stoneharry]

The structure is up to date, so you shouldn't need to apply the updates.

[Lancex]

I dropped it, make a new one and copied the latest strusture from that site and started my logon.exe and world.exe.
World exe gives me the following error:

[22:41][Arcemu][2011-11-30 22:41:08]
[22:41][Arcemu]ArcEmu 4.0-TRUNK b9737de/Debug-Win32-X86 :: World Server
[22:41][Arcemu]*********************************************************************
[22:41][Arcemu]* MAJOR ERROR/WARNING *
[22:41][Arcemu]* =================== *
[22:41][Arcemu]* One or more of the DBC files are missing. *
[22:41][Arcemu]* These are absolutely necessary for the server to function. *
[22:41][Arcemu]* The server will not start without them. *
[22:41][Arcemu]*********************************************************************
[22:41][Arcemu]Server: SetInitialWorldSettings() failed. Something went wrong? Exiting.

---------- Post added at 03:43 PM ---------- Previous post was at 03:42 PM ----------

Is there now something wrong with my arc_world database ?

[stoneharry]

Did you extract the DBC files?

Extract this to your ArcEmu folder where you run the world.exe etc from:

https://www.assembla.com/code/maps_o...erealm/dbc.rar