-
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.
-
Recommended Posts