EQEmulator Forums
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Bots (https://www.eqemulator.org/forums/forumdisplay.php?f=676)
-   -   Where to start (https://www.eqemulator.org/forums/showthread.php?t=40826)

neiv2 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 08-11-2016 09:19 PM
And just to clarify, manually installing the sql in Heidi consists of File > Load SQL File ... ?

Uleat 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 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 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 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 08-11-2016 09:49 PM
Yeah, that looks like what I'm experiencing too.

Uleat 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 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 08-14-2016 05:02 PM
Having same problem here. Ran 18, then 4 twice. Bots still a no go:

http://img.photobucket.com/albums/v6...psyfjxms9q.jpg

Uleat 08-14-2016 07:29 PM
http://www.eqemulator.org/forums/sho...2&postcount=23

DanCanDo 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 08-15-2016 11:00 AM
Opps sorry, forgot to update the post. Thanks again to DanCanDo!!!


All times are GMT -4. The time now is 04:06 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.