Trying to load bots into a clean DB and getting the following:
If I use the load_bots.sql supplied with PEQ SVN 1038 I get the following error:
Code:
ERROR 1418 (HY000) at line 4 in file: 'player_tables/botadventuring.sql': This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
if I use the bots.sql file in the EQEMU SVN util/sql/svn folder I get the following error:
Code:
ERROR 1064 (42000) at line 74: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `GetMobTypeByName` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
' at line 1
Anyone know I can correct the PEQ one so I can source it in and get my new server rolling?
Thanks!