Code:
>>> Database Menu
[backup_database] Back up database to backups/ directory
[backup_player_tables] Back up player tables to backups/ directory
[backup_database_compressed] Back up database compressed to backups/ directory
[check_db_updates] Checks for database updates manually
[check_bot_db_updates] Checks for bot database updates
[aa_tables] Downloads and installs clean slate AA data from PEQ
[remove_duplicate_rules] Removes duplicate rules from rule_values table
[drop_bots_db_schema] Removes bot database schema
> main - go back to main menu
Enter a command #> drop_bots_db_schema
[Database] Fetching drop_bots.sql...
[Download] Saved: (db_update/drop_bots.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/drop_bots.sql
ERROR 1217 (23000) at line 68: Cannot delete or update a parent row: a foreign key constraint fails
[Database] Removing bot database tables...
[Database] Done...
>>> Database Menu
[backup_database] Back up database to backups/ directory
[backup_player_tables] Back up player tables to backups/ directory
[backup_database_compressed] Back up database compressed to backups/ directory
[check_db_updates] Checks for database updates manually
[check_bot_db_updates] Checks for bot database updates
[aa_tables] Downloads and installs clean slate AA data from PEQ
[remove_duplicate_rules] Removes duplicate rules from rule_values table
[drop_bots_db_schema] Removes bot database schema
> main - go back to main menu
Enter a command #> main
Returning to main menu...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
[database] Enter database management menu
[assets] Manage server assets
[new_server] New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
[setup_bots] Enables bots on server - builds code and database requirements
exit
Enter a command #> setup_bots
[Update] Fetching Latest Windows Binaries with Bots...
[Download] Saved: (updates_staged/master_windows_build_bots.zip) from https://raw.githubusercontent.com/Akkadius/EQEmuInstall/master/master_windows_build_bots.zip
[Update] Fetched Latest Windows Binaries with Bots...
[Update] Extracting...
[Unzip] Extracting...
[Install] Installing :: common.lib
[Install] Installing :: eqlaunch.exe
[Install] Installing :: eqlaunch.ilk
[Install] Installing :: eqlaunch.pdb
[Install] Installing :: export_client_files.exe
[Install] Installing :: export_client_files.ilk
[Install] Installing :: export_client_files.pdb
[Install] Installing :: import_client_files.exe
[Install] Installing :: import_client_files.ilk
[Install] Installing :: import_client_files.pdb
[Install] Installing :: loginserver.exe
[Install] Installing :: loginserver.ilk
[Install] Installing :: loginserver.pdb
[Install] Installing :: luabind.lib
[Install] Installing :: queryserv.exe
[Install] Installing :: queryserv.ilk
[Install] Installing :: queryserv.pdb
[Install] Installing :: shared_memory.exe
[Install] Installing :: shared_memory.ilk
[Install] Installing :: shared_memory.pdb
[Install] Installing :: ucs.exe
[Install] Installing :: ucs.ilk
[Install] Installing :: ucs.pdb
[Install] Installing :: world.exe
[Install] Installing :: world.ilk
[Install] Installing :: world.pdb
[Install] Installing :: zone.exe
[Install] Installing :: zone.ilk
[Install] Installing :: zone.pdb
[Update] Done...
[Database] Retrieving latest bots database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/bots_db_update_manifest.txt
[Database] Reading manifest...
[Database] has update: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
[Database] missing update: 9007 '2016_06_23_bots_camel_case_name_rule.sql'
[Download] Saved: (db_update/2016_06_23_bots_camel_case_name_rule.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/required/2016_06_23_bots_camel_case_name_rule.sql
[Database] has update: 9006 - '2016_04_12_bots_inventory_window.sql'
[Database] has update: 9005 - '2016_04_08_bots_heal_rotations.sql'
[Database] has update: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.bot_pets' doesn't exist
[Database] has update: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
[Database] missing update: 9002 '2016_03_24_bots_command_rules.sql'
[Download] Saved: (db_update/2016_03_24_bots_command_rules.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/required/2016_03_24_bots_command_rules.sql
[Database] has update: 9001 - '2016_03_24_bots_command_settings.sql'
[Database] has update: 9000 - '2015_09_30_bots.sql'
[Database] Running Update: 9002 - 2016_03_24_bots_command_rules.sql
[Database] Running Update: 9007 - 2016_06_23_bots_camel_case_name_rule.sql
[Database] has update: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
[Database] has update: 9007 - '2016_06_23_bots_camel_case_name_rule.sql'
[Database] has update: 9006 - '2016_04_12_bots_inventory_window.sql'
[Database] has update: 9005 - '2016_04_08_bots_heal_rotations.sql'
[Database] has update: 9004 - '2016_04_07_bots_heal_override_target.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.bot_pets' doesn't exist
[Database] has update: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
[Database] has update: 9002 - '2016_03_24_bots_command_rules.sql'
[Database] has update: 9001 - '2016_03_24_bots_command_settings.sql'
[Database] has update: 9000 - '2015_09_30_bots.sql'
[Database] No updates need to be run...
[Database] Setting Database to Bots Binary Version (9008) if not already...
Bots should be setup, run your server and the #bot command should be available in-game
Returning to main menu...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
[database] Enter database management menu
[assets] Manage server assets
[new_server] New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
[setup_bots] Enables bots on server - builds code and database requirements
exit
I had bots running on the server a couple days ago. I tried removing them with the prompts like you said, but it looks like that had trouble. Reinstalling afterward didn't fix the error.
Is there a way to backup all of the changes I've made to the server and reinstall? So far I've added a few new race/class combos and a couple of starter quest NPC/Guildmasters. (Nothing too major.)