View Single Post
  #1  
Old 07-20-2016, 04:27 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default Bot Update Error

I am getting this error when I run #4 on the updater. The specific tables do not exist, but it should create them? I think?

Code:
> 4
Running Update: 9005 - 2016_04_08_bots_heal_rotations.sql
ERROR 1005 (HY000) at line 1: Can't create table `peq`.`bot_heal_rotations` (err
no: 150 "Foreign key constraint is incorrectly formed")
ERROR 1005 (HY000) at line 22: Can't create table `peq`.`bot_heal_rotation_membe
rs` (errno: 150 "Foreign key constraint is incorrectly formed")
ERROR 1005 (HY000) at line 31: Can't create table `peq`.`bot_heal_rotation_targe
ts` (errno: 150 "Foreign key constraint is incorrectly formed")
ERROR 1062 (23000) at line 39: Duplicate entry 'healrotationdelete' for key 'PRI
MARY'
DB up to date with: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
DB up to date with: 9007 - '2016_06_23_bots_camel_case_name_rule.sql'
DB up to date with: 9006 - '2016_04_12_bots_inventory_window.sql'
Missing DB Update 9005 '2016_04_08_bots_heal_rotations.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_08_bots_heal_rotations.sql
        [Saved] :: db_update/2016_04_08_bots_heal_rotations.sql
DB up to date with: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.bot_pets' doesn't exist
DB up to date with: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
DB up to date with: 9002 - '2016_03_24_bots_command_rules.sql'
DB up to date with: 9001 - '2016_03_24_bots_command_settings.sql'
Edit:

Ok, this one: https://raw.githubusercontent.com/EQ..._rotations.sql

Should be: https://raw.githubusercontent.com/EQ..._rotations.sql



Celestial
Reply With Quote