azerothcore / azerothcore/mod-transmog
Problem with Bot modules auto updating
- Dominant language
- C++
- Stars
- 189
- Forks
- 205
- PR merge metrics
- No merged PRs in 30d
Description
I ran into an issue deploying the server at first start. Loads of sql scripts where not auto updated. I had to manually copy then from the base/world files in the repo. I finally managed to get the server up and running but there are no bots. The modules folder doesn't appear to contain any modules. The acore_playerbots table does exist and is populated.
The following issues are displayed while launching the server:
Script named 'achievement_killed_exp_or_honor_target' is assigned in the database, but has no code!
Script named 'achievement_not_even_a_scratch' is assigned in the database, but has no code!
Script named 'achievement_resilient_victory' is assigned in the database, but has no code!
Script named 'achievement_sa_defense_of_the_ancients' is assigned in the database, but has no code!
Script named 'achievement_save_the_day' is assigned in the database, but has no code!
Script named 'achievement_sickly_gazelle' is assigned in the database, but has no code!
Script named 'achievement_tilted' is assigned in the database, but has no code!
Script named 'at_area_52_entrance' is assigned in the database, but has no code!
Script named 'at_brewfest' is assigned in the database, but has no code!
Script named 'at_coilfang_waterfall' is assigned in the database, but has no code!
Script named 'at_last_rites' is assigned in the database, but has no code!
Script named 'at_legion_teleporter' is assigned in the database, but has no code!
Script named 'at_nats_landing' is assigned in the database, but has no code!
Script named 'at_scent_larkorwi' is assigned in the database, but has no code!
Script named 'at_sentry_point' is assigned in the database, but has no code!
Script named 'at_stormwright_shelf' is assigned in the database, but has no code!
Script named 'boss_emeriss' is assigned in the database, but has no code!
Script named 'boss_lethon' is assigned in the database, but has no code!
Script named 'boss_taerar' is assigned in the database, but has no code!
Script named 'boss_ysondre' is assigned in the database, but has no code!
Script named 'go_amberpine_outhouse' is assigned in the database, but has no code!
Script named 'go_arcane_prison' is assigned in the database, but has no code!
Script named 'go_arena_ready_marker' is assigned in the database, but has no code!
Script named 'go_bashir_crystalforge' is assigned in the database, but has no code!
Script named 'go_bear_trap' is assigned in the database, but has no code!
Script named 'go_bells' is assigned in the database, but has no code!
Script named 'go_brewfest_music' is assigned in the database, but has no code!
Script named 'go_darkmoon_faire_music' is assigned in the database, but has no code!
Script named 'go_dragonflayer_cage' is assigned in the database, but has no code!
Script named 'go_duskwither_spire_power_source' is assigned in the database, but has no code!
Script named 'go_ethereum_prison' is assigned in the database, but has no code!
Script named 'go_ethereum_stasis' is assigned in the database, but has no code!
Script named 'go_evil_book_for_dummies' is assigned in the database, but has no code!
Script named 'go_fel_crystalforge' is assigned in the database, but has no code!
Script named 'go_flames' is assigned in the database, but has no code!
Script named 'go_gilded_brazier' is assigned in the database, but has no code!
Script named 'go_heat' is assigned in the database, but has no code!
Script named 'go_hive_pod' is assigned in the database, but has no code!
Script named 'go_jotunheim_cage' is assigned in the database, but has no code!
Script named 'go_jump_a_tron' is assigned in the database, but has no code!
Script named 'go_l70_etc_music' is assigned in the database, but has no code!
Script named 'go_massive_seaforium_charge' is assigned in the database, but has no code!
Script named 'go_midsummer_music' is assigned in the database, but has no code!
Script named 'go_necropolis' is assigned in the database, but has no code!
Script named 'go_pirate_day_music' is assigned in the database, but has no code!
Script named 'go_resonite_cask' is assigned in the database, but has no code!
Script named 'go_sacred_fire_of_life' is assigned in the database, but has no code!
Script named 'go_scourge_cage' is assigned in the database, but has no code!
Script named 'go_seer_of_zebhalak' is assigned in the database, but has no code!
Script named 'go_soulwell' is assigned in the database, but has no code!
Script named 'go_southfury_moonstone' is assigned in the database, but has no code!
Script named 'go_table_theka' is assigned in the database, but has no code!
Script named 'go_tablet_of_the_seven' is assigned in the database, but has no code!
Script named 'go_tadpole_cage' is assigned in the database, but has no code!
Script named 'go_tele_to_dalaran_crystal' is assigned in the database, but has no code!
Script named 'go_tele_to_violet_stand' is assigned in the database, but has no code!
Script named 'go_transport_the_iron_eagle' is assigned in the database, but has no code!
Script named 'go_transport_the_purple_princess' is assigned in the database, but has no code!
Script named 'go_transport_the_thundercaller' is assigned in the database, but has no code!
Script named 'go_veil_skith_cage' is assigned in the database, but has no code!
Script named 'go_witherbark_totem_bundle' is assigned in the database, but has no code!
Script named 'guard_shattrath_aldor' is assigned in the database, but has no code!
Script named 'guard_shattrath_scryer' is assigned in the database, but has no code!
Script named 'item_captured_frog' is assigned in the database, but has no code!
Script named 'item_disgusting_jar' is assigned in the database, but has no code!
Script named 'item_generic_limit_chance_above_60' is assigned in the database, but has no code!
Script named 'item_incendiary_explosives' is assigned in the database, but has no code!
Script named 'item_mysterious_egg' is assigned in the database, but has no code!
Script named 'item_only_for_flight' is assigned in the database, but has no code!
Script named 'item_petrov_cluster_bombs' is assigned in the database, but has no code!
Script named 'npc_air_force_bots' is assigned in the database, but has no code!
Script named 'npc_arcanite_dragonling' is assigned in the database, but has no code!
Script named 'npc_artorius' is assigned in the database, but has no code!
Script named 'npc_chicken_cluck' is assigned in the database, but has no code!
Script named 'npc_controller' is assigned in the database, but has no code!
Script named 'npc_crashin_thrashin_robot' is assigned in the database, but has no code!
Script named 'npc_cultist_engineer' is assigned in the database, but has no code!
Script named 'npc_dancing_flames' is assigned in the database, but has no code!
Script named 'npc_doctor' is assigned in the database, but has no code!
Script named 'npc_dream_fog' is assigned in the database, but has no code!
Script named 'npc_elder_clearwater' is assigned in the database, but has no code!
Script named 'npc_engineering_tele_trinket' is assigned in the database, but has no code!
Script named 'npc_experience' is assigned in the database, but has no code!
Script named 'npc_firework' is assigned in the database, but has no code!
Script named 'npc_flameshocker' is assigned in the database, but has no code!
Script named 'npc_franklin' is assigned in the database, but has no code!
Script named 'npc_garments_of_quests' is assigned in the database, but has no code!
Script named 'npc_guardian' is assigned in the database, but has no code!
Script named 'npc_herald_of_the_lich_king' is assigned in the database, but has no code!
Script named 'npc_injured_patient' is assigned in the database, but has no code!
Script named 'npc_innkeeper' is assigned in the database, but has no code!
Script named 'npc_locksmith' is assigned in the database, but has no code!
Script named 'npc_minion_spawner' is assigned in the database, but has no code!
Script named 'npc_necropolis' is assigned in the database, but has no code!
Script named 'npc_necropolis_health' is assigned in the database, but has no code!
Script named 'npc_necropolis_proxy' is assigned in the database, but has no code!
Script named 'npc_necropolis_relay' is assigned in the database, but has no code!
Script named 'npc_necrotic_shard' is assigned in the database, but has no code!
Script named 'npc_nelson' is assigned in the database, but has no code!
Script named 'npc_pallid_horror' is assigned in the database, but has no code!
Script named 'npc_pet_trainer' is assigned in the database, but has no code!
Script named 'npc_precious' is assigned in the database, but has no code!
Script named 'npc_prof_alchemy' is assigned in the database, but has no code!
Script named 'npc_prof_blacksmith' is assigned in the database, but has no code!
Script named 'npc_prof_leather' is assigned in the database, but has no code!
Script named 'npc_prof_tailor' is assigned in the database, but has no code!
Script named 'npc_riggle_bassbait' is assigned in the database, but has no code!
Script named 'npc_sayge' is assigned in the database, but has no code!
Script named 'npc_simone' is assigned in the database, but has no code!
Script named 'npc_spirit_shade' is assigned in the database, but has no code!
Script named 'npc_spring_rabbit' is assigned in the database, but has no code!
Script named 'npc_stable_master' is assigned in the database, but has no code!
Script named 'npc_steam_tonk' is assigned in the database, but has no code!
Script named 'npc_suns_reach_reclamation' is assigned in the database, but has no code!
Script named 'npc_sunwell_gate' is assigned in the database, but has no code!
Script named 'npc_target_dummy' is assigned in the database, but has no code!
Script named 'npc_taxi' is assigned in the database, but has no code!
Script named 'npc_training_dummy' is assigned in the database, but has no code!
Script named 'npc_traveler_mammoth_vendor' is assigned in the database, but has no code!
Script named 'npc_venomhide_hatchling' is assigned in the database, but has no code!
Script named 'npc_wormhole' is assigned in the database, but has no code!
Script named 'spell_communique_trigger' is assigned in the database, but has no code!
Script named 'spell_despawner_self' is assigned in the database, but has no code!
Script named 'spell_dream_fog_sleep' is assigned in the database, but has no code!
Script named 'spell_mark_of_nature' is assigned in the database, but has no code!
Script named 'spell_scourge_invasion_scourge_strike' is assigned in the database, but has no code!
Script named 'spell_shadow_bolt_whirl' is assigned in the database, but has no code!
Script named 'trigger_periodic' is assigned in the database, but has no code!
This is the only part of the installing process i have not done manually:
------------------------------------------------------------------------------------------------------------------------------------------------------------------
The server's auto-updater will populate most tables on first run. However, playerbots SQL files may need to be imported manually if the auto-updater does not pick them up:
# From the azerothcore-wotlk directory
mysql -u acore -p acore_characters < modules/mod-playerbots/sql/characters/base/playerbots_characters.sql
mysql -u acore -p acore_world < modules/mod-playerbots/sql/world/base/playerbots_world.sql
------------------------------------------------------------------------------------------------------------------------------------------------------------------
I dont fully understand where or how i am supposed to run these commands. I am unable to launch a cmd process from inside a folder on windows 10. Is this a Linux only thing?
Is it possible to get these files: playerbots_characters.sql and playerbots_world.sql and deploy them directly through HeidiSQL?
Any help would be appreciated.
I am at a loss as to how these issue occurred. I have no problem with the Azeroth core installation so i suspect there is something going wrong internally with the updater in the player bots fork.
I have now gone through the entire player bot modules sql files and confirm that these files are missing.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reviewing the first-run auto-updater behavior for modules/mod-playerbots/sql/characters/base/playerbots_characters.sql and modules/mod-playerbots/sql/world/base/playerbots_world.sql. Reproduce the Windows installation using the documented MySQL commands or HeidiSQL, then determine whether the files are imported and the playerbot modules load without the reported startup errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100