Thanks Uleat for your quick response.
I did as suggested but initially option 4 just closed the updater I think because of point #2 below.
To fix I did the following:
1) Downloaded lastest windows build with bots.
2) Went into DB version and changed bots version from 0 to 9000
3) I ran the bots sql file as you suggested.
4) I ran option 4 in the updater again.
These are the errors it produces. Havent tested yet if it works despite them.
---------------------------
Running Update: 9001 - 2016_03_24_bots_command_settings.sql
Running Update: 9002 - 2016_03_24_bots_command_rules.sql
Running Update: 9004 - 2016_04_07_bots_heal_override_target.sql
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")
Running Update: 9006 - 2016_04_12_bots_inventory_window.sql
Running Update: 9007 - 2016_06_23_bots_camel_case_name_rule.sql
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'
|