3.3.5  characters update error menu

User Tag List

Results 1 to 2 of 2
  1. #1
    WOWAW's Avatar Sergeant
    Reputation
    10
    Join Date
    Dec 2011
    Posts
    42
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    3.3.5 characters update error

    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'
    Last edited by WOWAW; 03-01-2013 at 09:30 PM.

    3.3.5  characters update error
  2. #2
    XxXGenesisXxX's Avatar Sergeant Major
    Reputation
    67
    Join Date
    Apr 2012
    Posts
    154
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "logon.character_db_version' doesn't exist"

    Check the logon database for a character_db_version.

Similar Threads

  1. Mangos 3.3.2 Updates Errors
    By Emanuel095 in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 02-15-2010, 08:33 PM
  2. Updater errors
    By Severance01 in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 11-06-2009, 06:20 AM
  3. Need help update error
    By Noobcraft in forum World of Warcraft General
    Replies: 1
    Last Post: 10-25-2008, 02:34 AM
  4. [help] character creation error within SQL
    By arthars1 in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 06-06-2008, 09:30 PM
  5. Character to Creature and facial errors. Am I able to do/fix it?
    By Hyuuga-Aoshi in forum WoW ME Questions and Requests
    Replies: 3
    Last Post: 06-02-2007, 11:00 AM
All times are GMT -5. The time now is 06:40 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search