View Single Post
  #1  
Old 02-24-2010, 04:10 PM
Eva Aisling
Sarnak
 
Join Date: Feb 2010
Posts: 49
Default Problem sourcing bots using setup guide on wiki

I'm having trouble sourcing "load_bots.sql" with peqdb_rev1180a-Bots. Sourcing "peqdb_rev1052.sql" and "load_player.sql" completed successfully. With "load_bots.sql" I get the following errors:

ERROR 1146 <42S02>: Table 'peq.bots' doesn't exist
Query OK, 0 rows affected, 1 warning <0.00 sec>

ERROR 1064 (42000): 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 NO
T EXISTS `vwGuildMembers` AS
select 'C' as mobtype,
cm.char_id,
cm.guild_' at line 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1064 (42000): 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 NO
T EXISTS `vwBotCharacterMobs` AS
select 'C' as mobtype,
c.id,
c.name,
c.c' at line 1
mysql>

I am using MySQL version 5.1. I would appreciate any help.
Reply With Quote