Jump to content
TrinityCore

Database populating problem


asura227
 Share

Recommended Posts

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.

Edited by asura227
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By NeoTwoK
      Hello everyone,

      I have a problem with custom weapons.

      I created the weapons in the DB. (Here the SQL query)
      INSERT INTO `wow_335_dev_world`.`item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`) VALUES (70000, 2, 7, -1, 'Chronos GM Schwert', 45776, 5, 0, 0, 1, 0, 0, 13, -1, -1, 50, 70, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 5, 4, 9999, 3, 9999, 7, 9999, 5, 9999, 6, 9999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 2, 3, 4, 3, 3303, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0);

      And I also entered my custom weapon ID properly in the Items.dbc.

       
      The weapons work too.
      I also get an icon displayed and the weapon looks like it should. But if I equip the weapon now, it disappears. Only when I hold the weapons in my hand are they visible.
      Here some pictures of it. The first shows the weapons when I carry them on my back, the second picture as they are visible in my hand.


       
      Anyone know how to solve the problem?
       
      thank in advance
       
      best regards
      Neo2k
×
×
  • Create New...