Where to start - Page 2

neiv2 · #16 08-11-2016, 09:17 PM

No, I meant 18. I did 19 to drop the bot schema. Isn't reloading 18 required to "enable" bots prior to running 4?

neiv2 · #17 08-11-2016, 09:19 PM

And just to clarify, manually installing the sql in Heidi consists of File > Load SQL File ... ?

**Uleat** · #18 08-11-2016, 09:24 PM

If you're using the pre-built binaries..and you don't already have it currently downloaded, then yes.

Option 19 will not change your binaries back to non-BOTS enabled..only revert the database schema.

(And, yes, on the '> Load SQL File')

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

I'm going to setup a seperate non-bot server folder/db and try and replicate this whole
scenario of converting over to a bot enabled server to see how it goes.
Never tried it that way before (chuckle). Maybe I can get some insight on this.

neiv2 · #20 08-11-2016, 09:45 PM

Still no dice. Think I'll uninstall it and reinstall. Can you confirm this is the right place to be?

http://wiki.eqemulator.org/p?Akkas_P...ctions-windows

DanCanDo · #21 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...

>

neiv2 · #22 08-11-2016, 09:49 PM

Yeah, that looks like what I'm experiencing too.

**Uleat** · #23 08-11-2016, 09:55 PM

Not sure why the list is iterating backwards..it's checking for things before they have been installed...

you can do a manual install..

https://github.com/EQEmu/Server/blob...e_manifest.txt

Just install those sqls from 9000 to 9008..then run the updater to ensure that the other changes are made.

EDIT: ACTUALLY... Did you hit 4 again to apply the updates? (Needs to be hit twice..first for queuing and second for application)

DanCanDo · #24 08-11-2016, 10:00 PM

One thing that did happen, after grabbing the executables, the first time I hit #4, it told
me I did not have bots enabled and the script closed. I simply started the script up again,
hit 4 and it continued on.

Warkral · #25 08-14-2016, 05:02 PM

Having same problem here. Ran 18, then 4 twice. Bots still a no go:

**Uleat** · #26 08-14-2016, 07:29 PM

http://www.eqemulator.org/forums/sho...2&postcount=23

DanCanDo · #27 08-14-2016, 07:32 PM

I gave him a little help (in pm) which fixed the problem for him (one of my past solutions)
(chuckle)

Warkral · #28 08-15-2016, 11:00 AM

Opps sorry, forgot to update the post. Thanks again to DanCanDo!!!