Got a hankerin for some eq again recently.
Friday I created a brand new server using the new install package (which I love). (DB version 9097)Works well but now I am trying to install the bots schema (option4). I got some errors during the install and when I tried to create bots, the system "gives failed to query name availability"
going into the db_update folder and checking the db_update_manifest lists some .sql files that are not in that folder.
Missing are:
2015_09_30_bots.sql
2016_04_05_bots_pet_spell_id_field.sql
2016_06_28_bots_inventory_charges_update.sql
I added the missing files from
https://github.com/EQEmu/Server/tree.../bots/required
I dropped the bots schema and reselected option 4
These were the results:
> 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'
At this point bots still don't work.