Jump to content
  • 0

Problem with updating sql databases using installdatabases.bat


tenarie

Question

 

I'm currently using the latest builds, the SQL Update codes just looks wrong to me also.
Anyone able to help me out : ) ?
Dump bellow

--------------------------------

 

_____________________________________________________________

 Applying Character DB updates
_____________________________________________________________

Character\Updates\Rel21\21000_00_Release_021_Initial.sql
ERROR 1146 (42S02) at line 2: Table 'character0.character_db_version' doesn't exist
Character\Updates\Rel21\21000_01_warden_action.sql
ERROR 1146 (42S02) at line 2: Table 'character0.character_db_version' doesn't exist
Character\Updates\Rel21\21000_02_db_version.sql
Character\Updates\Rel21\Rel21_2_0_honor_flush.sql
Error   1060    Duplicate column name 'used'
* UPDATE FAILED *       revision_refactor
Character\Updates\Rel21\Rel21_2_1_dbdocs_update.sql
* UPDATE FAILED *       Honor Counting
Character\Updates\Rel21\Rel21_3_1_fix_sor_paladin.sql
* UPDATE SKIPPED *      NULL    Honor Counting
Character\Updates\Rel21\Rel21_4_1_match_client_limits.sql
* UPDATE SKIPPED *      NULL    Honor Counting
Character\Updates\Rel21\Rel21_5_1_characters_pvpstats.sql
* UPDATE SKIPPED *      NULL    Honor Counting
Character\Updates\Rel21\Rel21_5_2_dbdocsTable.sql
* UPDATE SKIPPED *      NULL    Honor Counting
Character\Updates\Rel21\Rel21_5_3_Remove_field_from_dbDocs_Subtable.sql
* UPDATE SKIPPED *      Rel21_5_2 - IS NOT APPLIED      21_2_0 - Honor Counting

_____________________________________________________________

 Applying world DB updates
_____________________________________________________________

World\Updates\Rel21\Rel21_11_74_Item_13040_update.sql
* UPDATE COMPLETE *     Item_13040_update
World\Updates\Rel21\Rel21_11_75_Fix_Weapon_Damage.sql
* UPDATE COMPLETE *     fix_Weapon_Damage
World\Updates\Rel21\Rel21_11_76_bootybay_gnomeregan_teleport_fix.sql
* UPDATE COMPLETE *     bootybay_gnomeregan_teleport
World\Updates\Rel21\Rel21_11_77_Feast_of_Winter_Veil_part1.sql
* UPDATE COMPLETE *     Feast_of_Winter_Veil_part1
World\Updates\Rel21\Rel21_11_78_Start_up_fixes.sql
* UPDATE COMPLETE *     Start Up Fixes
World\Updates\Rel21\Rel21_11_79_Fix_Mailbox_Missing.sql
* UPDATE COMPLETE *     Fix Mailbox Missing
World\Updates\Rel21\Rel21_11_80_fix_druid_basemana.sql
* UPDATE COMPLETE *     fix_druid_basemana
World\Updates\Rel21\Rel21_11_81_fix_invalid_radius.sql
* UPDATE COMPLETE *     fix_invalid_radius
World\Updates\Rel21\Rel21_11_82_fix_Herb_nodes.sql
* UPDATE COMPLETE *     fix_Herb_nodes
World\Updates\Rel21\Rel21_12_01_autobroadcast.sql
* UPDATE COMPLETE *     AutoBroadcast
World\Updates\Rel21\Rel21_12_02_Fix_gossip_for_creature_6669.sql
* UPDATE COMPLETE *     Fix gossip for creature 6669
World\Updates\Rel21\Rel21_12_03_fixed_Onyxia_all_bugs.sql
* UPDATE COMPLETE *     fixed Onyxia all bugs
World\Updates\Rel21\Rel21_12_04_Encrypted_Letter.sql
* UPDATE COMPLETE *     Encrypted_Letter
World\Updates\Rel21\Rel21_12_05_fix_2017_Spring_Festival_start_and_end_time.sql
* UPDATE COMPLETE *     fix 2017 Spring Festival star
World\Updates\Rel21\Rel21_12_06_fix_some_bugs.sql
* UPDATE COMPLETE *     fix some bugs
World\Updates\Rel21\Rel21_13_001_schoolimmunitymask.sql
* UPDATE COMPLETE *     Implement SchoolImmunity Mask
World\Updates\Rel21\Rel21_13_002_Book_Images.sql
* UPDATE COMPLETE *     Book_Images
World\Updates\Rel21\Rel21_13_003_Lady_Moongazer.sql
* UPDATE COMPLETE *     Lady_Moongazer
World\Updates\Rel21\Rel21_13_004_Carnivous_the_Breaker.sql
* UPDATE COMPLETE *     Carnivous_ the_Breaker
World\Updates\Rel21\Rel21_13_005_Silithid_Mound.sql
* UPDATE COMPLETE *     Silithid_Mound
World\Updates\Rel21\Rel21_13_006_Darkshore_Cliffspring_Falls.sql
* UPDATE COMPLETE *     Darkshore_Cliffspring_Falls
World\Updates\Rel21\Rel21_13_007_Firecaller_Radison.sql
* UPDATE COMPLETE *     Firecaller_Radison
World\Updates\Rel21\Rel21_13_008_Fixed_[de]spawn_Buccaneers_Strongbox.sql
* UPDATE COMPLETE *     Fixed_(de)spawn_Buccaneers_St
World\Updates\Rel21\Rel21_13_009_Araga_drops_corrected.sql
* UPDATE COMPLETE *     Araga_drops_corrected
World\Updates\Rel21\Rel21_13_010_Fixed_models_of_rams_NPCs_4778_and_4780.sql
* UPDATE COMPLETE *     Fixed_models_of_rams
World\Updates\Rel21\Rel21_14_001_creature_equip_template_unique_indexes.sql
* UPDATE COMPLETE *     creature_equip_template_uniqu
World\Updates\Rel21\Rel21_14_002_MC,AQ20,AQ40_Equipment.sql
* UPDATE COMPLETE *     MC,AQ20,AQ40_Equipment

_____________________________________________________________

 Applying Realm DB updates
_____________________________________________________________

Realm\Updates\Rel21\20150409_Playerbot_and_Warden.sql
* UPDATE SKIPPED *      required_20140607_Realm_Resync  NULL
Realm\Updates\Rel21\20150412_01_warden_db_log.sql
* UPDATE SKIPPED *      required_20150409_Playerbot_and_Warden  NULL
Realm\Updates\Rel21\20150412_02_auth_realmlist.sql
ERROR 1146 (42S02) at line 4: Table 'realmd.realmd_db_version' doesn't exist
Realm\Updates\Rel21\20150420_03_warden_db_log.sql
* UPDATE SKIPPED *      required_20150412_auth_realmlist        NULL
Realm\Updates\Rel21\20150722_01_realmcharacters_remove_constraint.sql
ERROR 1146 (42S02) at line 4: Table 'realmd.realmd_db_version' doesn't exist
Realm\Updates\Rel21\20150816_01_db_version.sql
Realm\Updates\Rel21\Rel21_1_1_dbdocs_updates.sql
Error   1054    Unknown column 'subtablecontent' in 'field list'
* UPDATE FAILED *       revision_refactor
Realm\Updates\Rel21\Rel21_1_2_dbdocs_updates.sql
* UPDATE SKIPPED *      NULL    revision_refactor
Realm\Updates\Rel21\Rel21_1_3_Remove_field_from_dbDocs_Subtable.sql
* UPDATE SKIPPED *      Rel21_1_2 - IS NOT APPLIED      21_1_0 - revision_refactor

    __  __      _  _  ___  ___  ___
   |  \/  |__ _| \| |/ __|/ _ \/ __|    Database Setup
   | |\/| / _` | .` | (_ | (_) \__ \
   |_|  |_\__,_|_|\_|\___|\___/|___/  and World Loader

_____________________________________________________________

 Database Creation and Load complete
_____________________________________________________________

Done :)

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

first off, I would reclone your database repo as it's badly messed up, then run the installdatabase.bat from it's original location and not move any files.

The base databases are set at a certain start version and don't need every update that is in the updates folder.

Every now and then I 'redump' the base databases so that users do not need to run any updates after a base install.

Starting up mangos will tell you if It needs any additional updates

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use