Bot Update Error

[jpyou127]

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?


> 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/EQEmu/Server/master/utils/sql/git/bots/required/2016_04_08_bots_heal_rotations.sql

Should be: https://raw.githubusercontent.com/EQEmu/Server/utils/sql/git/bots/required/2016_04_08_bots_heal_rotations.sql



Celestial

[Uleat]

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?

[jpyou127]

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

[Uleat]

This was a new install for bots?

Curious as to why update '9000' isn't showing in that list..

[jpyou127]

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

[jpyou127]

"bot_commnad_settings"

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

Should I run the drop bots script?



Celestial

[jpyou127]

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

[jpyou127]

Ok that got me cleared on all counts =)

SO odd!


Celestial

[Uleat]

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.)

[jpyou127]

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

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


Celestial

[Uleat]

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.

[Tayton]

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/master/utils/sql/git/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.

[Uleat]

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

[Tayton]

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'

[jpyou127]

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


Celestial