EQEmulator Forums - Error sourcing load

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Bots (https://www.eqemulator.org/forums/forumdisplay.php?f=676)

- - Error sourcing load_bots (Rev 946) (https://www.eqemulator.org/forums/showthread.php?t=29294)

nosfentora

08-21-2009 10:03 AM

Error sourcing load_bots (Rev 946)

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

the load_bots.sql code is:

Code:

source player_tables/botinventory.sql;

source player_tables/botgroups.sql;

source player_tables/bots.sql;

The code should be:

Code:

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

08-21-2009 10:13 AM

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

08-21-2009 01:41 PM

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.

All times are GMT -4. The time now is 01:28 PM.