Thread: MySQL Errors
View Single Post
  #6  
Old 01-06-2010, 01:52 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

If you want bots, you have to source them after load_player.sql. It's in the readme :P Doing it in the reverse order will give you the table doesn't exist errors. Obviously, if you don't want bots on the server, you don't even need to source load_bots.sql. Also, you can't source both files if you already have a working database. In that case, you have to source in all the updates in the updates folder. Lastly, PEQ's DB repo is not compatible with EQEmu's DB updates. Every update found in the EQEmu repo is also in the PEQ repo, but due to the way each handles updates using both will cause conflicts. I recommend using PEQ to most people, unless they have a lot of custom content, then using the EQEmu updates may be best.

MySQL 5.0 sources in all files without the need to edit. If MySQL 5.5 was changed to require full paths, then that really sucks on their part!

As for the:
ERROR 1064 (42000): in load_bots.sql, I just copied the bots source from the EQEmu repo verbatim, so if there are problems sourcing blame the bots folks :P
Reply With Quote