View Single Post
  #1  
Old 08-21-2009, 10:03 AM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default 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'
Reply With Quote