Error sourcing load_bots (Rev 946)

[nosfentora]

Had a problem loading load_bots.sql in the 946 Rev of PEQ

the load_bots.sql code is:

source player_tables/botinventory.sql;
source player_tables/botgroups.sql;
source player_tables/bots.sql;


The code should be:


source player_tables/bots.sql;
source player_tables/botinventory.sql;
source player_tables/botgroups.sql;


the bots table needs to be sourced first, as the botinventory and botgroups tables have foriegn key constraints - they're looking for a table that doesn't exist yet, o/w you get Can't Create Table: XXXX 'errno: 150'

[So_1337]

I ran into that as well. Running the script a second time solved it, so people can use that fix in the meantime.

I noticed that there were two rules giving errors with this database revision on start-up. They were:

AA:MaxEffectSlots
Pathing:MaxNodesLeftForLOSCheck

It's an "unable to find/unable to interpret" rule error. Any idea what's going on there? They're in the database, so something must be missing in the binaries, I reckon.

[nosfentora]

Mine failed every time - because i was using

mysql -u<login> -p<pass> <db> < load_bots.sql

if one logs into mysql first, then runs
source load_bots.sql

it'll work the 2nd time.

I had the same 2 rule errors on a clean db install and compile of rev 946.