Jump to content
TrinityCore

asura227

Plebs
  • Posts

    2
  • Joined

  • Last visited

asura227's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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...