Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bots

Development::Bots Forum for bots.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2016, 04:27 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default Bot Update Error

I am getting this error when I run #4 on the updater. The specific tables do not exist, but it should create them? I think?

Code:
> 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'
Edit:

Ok, this one: https://raw.githubusercontent.com/EQ..._rotations.sql

Should be: https://raw.githubusercontent.com/EQ..._rotations.sql



Celestial
Reply With Quote
  #2  
Old 07-20-2016, 04:42 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I think you would have a different error if the table `bot_data` did not exist...

Do you have multiple bots with the same id in that table?
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #3  
Old 07-20-2016, 04:45 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Actually almost all those tables do not exist. I just tried to manual run an import and got the same error.

I downloaded them from the repo to see if I got a different result.

Celestial
Reply With Quote
  #4  
Old 07-20-2016, 04:57 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

This was a new install for bots?

Curious as to why update '9000' isn't showing in that list..
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #5  
Old 07-20-2016, 06:02 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

I have been running bots, but I have not done any updates till now. There were some standard DB updates that ran fine, as well as a few of the BOT updates also ran fine, just these are showing errors. Yep, its odd.


Edit: this was a 3rd run through for updates. Its actually showing that only one update is missing, but does try to install more than one.



Celestial
Reply With Quote
  #6  
Old 07-20-2016, 06:05 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

"bot_commnad_settings"

This is the only table for BOTs that I now have. Hmmmm.

Should I run the drop bots script?



Celestial
Reply With Quote
  #7  
Old 07-20-2016, 06:12 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

This is weird I am gonna run all the scripts in the required folder from oldest to newest as there are many tables that are missing.


Celestial
Reply With Quote
  #8  
Old 07-20-2016, 06:17 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Ok that got me cleared on all counts =)

SO odd!


Celestial
Reply With Quote
  #9  
Old 07-20-2016, 06:23 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

There are some peculiarities with the system, for sure...

One of the problems people have with updating an older system is that their tables are mal-formed and allow multiple bots with the same id - their table isn't keyed properly...

When the table importer encounters this, the process fails due to a foreign constract issue.

(Not saying that is the case here..but, one of the issues I've seen.)
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #10  
Old 07-20-2016, 06:26 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

Awesome BOT system you have created! I like the new commands!

I am at a loss as to the why...


Celestial
Reply With Quote
  #11  
Old 07-20-2016, 06:40 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I just copied the existing command system and merged the old bot command handler into it.

There are some pretty powerful features in it..but, it was mostly done to standardize the bot commands while reducing the duplication/specialization of/in their handlers.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #12  
Old 07-24-2016, 11:04 AM
Tayton
Fire Beetle
 
Join Date: Jul 2011
Location: Vancouver
Posts: 10
Default

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.
Reply With Quote
  #13  
Old 07-24-2016, 04:44 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Trying manually applying '2015_09_30_bots.sql' .. then re-run the update script and select option 4 again.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #14  
Old 07-25-2016, 03:39 PM
Tayton
Fire Beetle
 
Join Date: Jul 2011
Location: Vancouver
Posts: 10
Default

Thanks Uleat for your quick response.
I did as suggested but initially option 4 just closed the updater I think because of point #2 below.
To fix I did the following:
1) Downloaded lastest windows build with bots.
2) Went into DB version and changed bots version from 0 to 9000
3) I ran the bots sql file as you suggested.
4) I ran option 4 in the updater again.

These are the errors it produces. Havent tested yet if it works despite them.
---------------------------
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 `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")
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 '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'
Reply With Quote
  #15  
Old 07-25-2016, 03:46 PM
jpyou127's Avatar
jpyou127
Discordant
 
Join Date: Nov 2005
Posts: 270
Default

You can do as I described above and manually run all the bot scripts from oldest to newest. Super easy and just works.


Celestial
Reply With Quote
Reply

Tags
bots, database, error, heal, pet

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:21 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3