Jump to content
TrinityCore

Report

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By asura227
      Hi Everyone! I'm trying to install the master branch. When running 'worldserver' for the first time, i get this:
      Using configuration file /home/trinity/server/etc/worldserver.conf.
      Using SSL version: OpenSSL 1.1.1c  28 May 2019 (library: OpenSSL 1.1.1c  28 May 2019)
      Using Boost version: 1.67.0
      Database Auth is empty, auto populating it...
      >> Applying '/home/trinity/TrinityCore/sql/base/auth_database.sql'...
      >> Done!
      Database Character is empty, auto populating it...
      >> Applying '/home/trinity/TrinityCore/sql/base/characters_database.sql'...
      >> Done!
      Database World is empty, auto populating it...
      >> Applying 'TDB_full_world_820.19071_2019_07_15.sql'...
      >> Done!
      Database Hotfixes is empty, auto populating it...
      >> Applying 'TDB_full_hotfixes_820.19071_2019_07_15.sql'...
      >> Done!
      Updating Auth database...
      >> Auth database is up-to-date! Containing 33 new and 115 archived updates.
      Updating Character database...
      >> Reapplying update "2020_02_17_00_characters.sql" 'E1519A8' -> '5FB4640' (it changed)...
      ERROR 1060 (42S21) at line 3: Duplicate column name 'selectedAzeriteEssences1azeriteEssenceId4'

      Applying of file '/home/trinity/TrinityCore/sql/updates/characters/master/2020_02_17_00_characters.sql' to database 'characters' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
      Could not update the Character database, see log for details.
      The content of '/home/trinity/TrinityCore/sql/updates/characters/master/2020_02_17_00_characters.sql' is as follows:
      UPDATE `character_inventory` SET `slot`=`slot`+4 WHERE `slot`>=47 AND `bag`=0;
      ALTER TABLE `item_instance_azerite`
        ADD `selectedAzeriteEssences1azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences1azeriteEssenceId3`,
        ADD `selectedAzeriteEssences2azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences2azeriteEssenceId3`,
        ADD `selectedAzeriteEssences3azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences3azeriteEssenceId3`,
        ADD `selectedAzeriteEssences4azeriteEssenceId4` int(10) unsigned NULL DEFAULT '0' AFTER `selectedAzeriteEssences4azeriteEssenceId3`;

      I'm using Ubuntu 19.10 in an LXC container on an Ubuntu 18.04 host,  mariadb 10.3, database 8.2.5/32978 from the releases page, as this was the file that worldserver requested. I did take a look through the FAQs related to the database. Any help you can offer would be greatly appreciated.
×
×
  • Create New...