Where to start

DanCanDo · #19 08-11-2016, 09:48 PM

After using option 18 and getting the executables, this is what I got running
#4 on the update script (a few times) It showed 6 updates to grab from first
run and 1 update after 2nd and 3rd run, but all came with errors.

Code:

 Enter numbered option and press enter...

> 4
Retrieving latest bots database manifest...
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/bots_db_update_manifest.txt
        [Saved] :: db_update/db_update_manifest.txt
Reading manifest...

DB up to date with: 9008 - '2016_06_28_bots_inventory_charges_update.sql'
Missing DB Update 9007 '2016_06_23_bots_camel_case_name_rule.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_06_23_bots_camel_case_name_rule.sql
        [Saved] :: db_update/2016_06_23_bots_camel_case_name_rule.sql
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_command_settings' doesn't exist

Missing DB Update 9006 '2016_04_12_bots_inventory_window.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_12_bots_inventory_window.sql
        [Saved] :: db_update/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
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_command_settings' doesn't exist

Missing DB Update 9004 '2016_04_07_bots_heal_override_target.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_04_07_bots_heal_override_target.sql
        [Saved] :: db_update/2016_04_07_bots_heal_override_target.sql
ERROR 1146 (42S02) at line 1: Table 'peqtest.bot_pets' doesn't exist
DB up to date with: 9003 - '2016_04_05_bots_pet_spell_id_field.sql'
Missing DB Update 9002 '2016_03_24_bots_command_rules.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_03_24_bots_command_rules.sql
        [Saved] :: db_update/2016_03_24_bots_command_rules.sql
Missing DB Update 9001 '2016_03_24_bots_command_settings.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2016_03_24_bots_command_settings.sql
        [Saved] :: db_update/2016_03_24_bots_command_settings.sql

============================================================
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
============================================================
 1) [Backup Database] :: (Saves to Backups folder)
 2) [Backup Database Compressed] :: (Saves to Backups folder)
 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
 4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (6)
 5) [OPCodes] :: Download latest opcodes for each EQ Client
 6) [Maps] :: Download latest map and water files
 7) [Plugins (Perl)] :: Download latest Perl plugins
 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
 11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
 12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
 13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
 14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
 15) [Fetch Utility Scripts] :: Fetches server management utility scripts
 18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
 Bots
 19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
 20) [Update the updater] Force update this script (Redownload)
 0) Exit

 Enter numbered option and press enter...

> 4
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 'peqtest.bot_heal_rotations' (e
rrno: 150)
ERROR 1005 (HY000) at line 22: Can't create table 'peqtest.bot_heal_rotation_mem
bers' (errno: 150)
ERROR 1005 (HY000) at line 31: Can't create table 'peqtest.bot_heal_rotation_tar
gets' (errno: 150)
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 'peqtest.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'

============================================================
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
============================================================
 1) [Backup Database] :: (Saves to Backups folder)
 2) [Backup Database Compressed] :: (Saves to Backups folder)
 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
 4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
 5) [OPCodes] :: Download latest opcodes for each EQ Client
 6) [Maps] :: Download latest map and water files
 7) [Plugins (Perl)] :: Download latest Perl plugins
 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
 11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
 12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
 13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
 14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
 15) [Fetch Utility Scripts] :: Fetches server management utility scripts
 18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
 Bots
 19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
 20) [Update the updater] Force update this script (Redownload)
 0) Exit

 Enter numbered option and press enter...

> 4
Running Update: 9005 - 2016_04_08_bots_heal_rotations.sql
ERROR 1005 (HY000) at line 1: Can't create table 'peqtest.bot_heal_rotations' (e
rrno: 150)
ERROR 1005 (HY000) at line 22: Can't create table 'peqtest.bot_heal_rotation_mem
bers' (errno: 150)
ERROR 1005 (HY000) at line 31: Can't create table 'peqtest.bot_heal_rotation_tar
gets' (errno: 150)
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 'peqtest.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'

============================================================
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
============================================================
 1) [Backup Database] :: (Saves to Backups folder)
 2) [Backup Database Compressed] :: (Saves to Backups folder)
 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
 4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
 5) [OPCodes] :: Download latest opcodes for each EQ Client
 6) [Maps] :: Download latest map and water files
 7) [Plugins (Perl)] :: Download latest Perl plugins
 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
 11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrit
es existing .exe's, includes .dll's)
 12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
 13) [Windows Server Loginserver Setup] :: Download and install Windows Loginser
ver
 14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries a
nd removes them
 15) [Fetch Utility Scripts] :: Fetches server management utility scripts
 18) [Windows Server Build Bots] :: Download Latest and Stable Server Build with
 Bots
 19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to no
rmal state
 20) [Update the updater] Force update this script (Redownload)
 0) Exit

 Enter numbered option and press enter...

>