Okay I have compiled once again after long time my own server. Everything fine until database and SQL stuff!
I am using WhyDB's latest rev which is : 158
After creating the databases to Heidi SQL ( world,logon and characters) and executed to them the base structures, extract WhyDB from tool and start logon.exe and world.exe.
Okay it says I need to update the world database since it's not up to date. DONE!
Try again and now it says the following:
[03-02-2013][04:09][Arcemu]ArcEmu 4.0-TRUNK 1ab335e/Debug-Win32-X86 :: World Server
[03-02-2013][04:09][Arcemu]Sql query failed due to [Table 'logon.character_db_version' doesn't exist], Query: [SELECT LastUpdate FROM character_db_version;]
[03-02-2013][04:09][Arcemu]Database: Character database is missing the table `character_db_version` OR the table doesn't contain any rows. Can't validate database version. Exiting.
[03-02-2013][04:09][Arcemu]Database: You may need to update your database
I fully understand what the error says but I think its wrong.
1. The Characters database DOES contain the character_db_version
2. At the character_db_version it says that the latest update was: 2011-11-16_22-00_saved_mail
3. At the ArcEmu/sql/character_updates/ there are 3 sql files :
2011-11-12_20-00_initial
2011-11-15_10-00_mail_flags
2011-11-16_22-00_saved_mail
And the database says that the last update IS in-fact 2011-11-16_22-00_saved_mail ??
How can I update the characters database when there is no newer update that the one that has already been executed to the database?
I have searched the web and people have figured this out by doing whole database thing from scratch and so have done I like 10 times without success, and ones that have found a solution to it have just thanked for the help and newer told what they did??
Gonna rep everyone who is helpful!!
----------------------------------------------------------------------
Tried to run the saved mail update AGAIN as it orders you to do, and I get error : duplicate column 'text'