Jump to content

Endon

Members
 View Profile  See their activity

  • Posts

    28

  • Joined

  • Last visited

    Never

  • Donations

    0.00 GBP 

 Content Type 

Posts posted by Endon

  1. [GUIDE] Ubuntu/Debian/CentOS/RHEL Install Guide

    in OldInstallation, configuration & upgrades

    Posted

    So I managed to update all the way op to 8886_01_mangos_string without any error

    But when I start up worldd, thee errors start to appear again.

    I starts good with "AUTOCOMMIT SUCCESSFULLY SET TO 1"

    But then the trouble comes;

    SQL: SELECT 'required_8882_03_mangos_spell_bonus_data' in 'field list'
table 'db_version' have field 'required_8886_01_mangos_string' but expected 'required_8882_03_mangos_spell_bonus_data'! Not all sql updates applied?

    What to do?

  2. [GUIDE] Ubuntu/Debian/CentOS/RHEL Install Guide

    in OldInstallation, configuration & upgrades

    Posted

    First, you gotta find out which version of Mangos DB you're at. Easiest way, if you're on Linux, install phpmyadmin (GUI for managing database). On Ubuntu,

     sudo aptitude install phpmyadmin

    will do the trick.

    Login, and navigate to Mangos DB and click on "db_version" table. On the right side, you'll see something along the line of "required_####_..._mangos_..." where #### is where you're at. Work up from there.

    It says "required_8840_01_mangos_spell_proc_event" which is the highest available in the updates directory, So I guess that no updates are needed...?

    EDIT:

     ERROR 1054 (42S22) at line 1: Unknown column 'required_8731_01_mangos_creature_template' in 'db_version'

    means exactly what it says. You need 8731_01_mangos_creature_template.sql before you can import 8749_01_mangos_mail_loot_template.sql.

    Which requires 8726, which requires 8723, which requires, 8720 ....

    Thanks for your help :)

  3. [GUIDE] Ubuntu/Debian/CentOS/RHEL Install Guide

    in OldInstallation, configuration & upgrades

    Posted

    When I apply the patches with this command;

    XxX@XxX:/mangos/mangos/sql/updates# mysql -p(littleBIGsecret) mangos < 8749_01_mangos_mail_loot_template.sql

    I get this error:

    ERROR 1054 (42S22) at line 1: Unknown column 'required_8731_01_mangos_creature_template' in 'db_version'

    Tried the other bunch of updates in that directory which results into this:

    ERROR 1054 (42S22) at line 1: Unknown column 'required_8835_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8833_02_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8833_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8828_02_mangos_instance_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8818_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8815_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8803_02_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8803_01_mangos_playercreateinfo_spell' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8800_01_mangos_spell_elixir' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8777_02_mangos_gameobject' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8777_01_mangos_creature' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8775_03_mangos_gameobject' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8775_02_mangos_creature' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8775_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8770_01_mangos_quest_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8769_01_mangos_mail_level_reward' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8749_01_mangos_mail_loot_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8731_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8726_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8723_01_mangos_achievement_criteria_requirement' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8720_01_mangos_quest_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8693_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8688_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8676_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8618_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8608_02_mangos_battleground_events' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8608_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8607_02_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8607_01_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8600_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_10_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_09_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_08_mangos_item_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_07_mangos_spell_elixir' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_05_mangos_battleground_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_03_mangos_item_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_02_mangos_gameobject_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8589_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8573_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8549_03_mangos_battleground_events' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8548_02_mangos_gameobject_battleground' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8548_01_mangos_creature_battleground' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8521_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8514_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8511_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8504_02_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8504_01_mangos_playercreateinfo_spell' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8499_01_mangos_spell_elixir' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8498_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8488_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8488_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8487_02_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8487_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8482_01_mangos_spell_elixir' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8462_01_mangos_creature_ai_texts' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8451_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8444_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8416_01_mangos_spell_learn_spell' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8412_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8399_01_mangos_spell_elixir' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8397_02_mangos_spell_threat' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8397_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8394_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8392_02_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8392_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8377_01_mangos_spell_area' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8364_01_mangos_db_version' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8361_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8342_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8310_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8294_01_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8254_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8253_02_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8253_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8251_03_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8251_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8251_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8250_01_mangos_spell_threat' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8249_02_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8249_01_mangos_spell_proc_item_enchant' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8247_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8237_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8227_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8213_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8212_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8211_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8191_01_mangos_spell_affect' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8190_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8158_01_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8140_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8115_01_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8112_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8098_02_mangos_playercreateinfo_action' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8071_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8065_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8064_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8060_01_mangos_spell_pet_auras' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8053_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8050_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8050_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8030_03_mangos_npc_trainer' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8021_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_8016_01_mangos_npc_spellclick_spells' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_09_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_08_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_06_mangos_gameobject_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_05_mangos_item_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_04_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_03_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7988_01_mangos_item_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_7980_01_mangos_item_required_target' in 'db_version'

    As a Mangos newb, I have no idea what 2 do :P Anyone who can help me?

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use