View Single Post
  #2  
Old 12-26-2009, 07:36 AM
eski2
Hill Giant
 
Join Date: May 2008
Location: sydney
Posts: 177
Default

I tried the bot sourcing again just in case:
Code:
C:\Program Files\MySQL\MySQL Server 5.1\bin\projecteqdb\peqdatabase>mysql -u roo
t -p
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.41-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> \u PEQ
Database changed
mysql> source load_bots.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.09 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Rows matched: 1  Changed: 0  Warnings: 0

ERROR 1062 (23000): Duplicate entry '1-Bots:BotManaRegen' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:BotFinishBuffing' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:CreateBotCount' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:SpawnBotCount' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:BotQuest' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:BotGroupBuffing' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1-Bots:BotSpellQuest' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry 'bot' for key 'PRIMARY'
ERROR 1050 (42S01): Table 'bots' already exists
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1091 (42000): Can't DROP 'PRIMARY'; check that column/key exists
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>
Does this mean that Bots should work? Do i need to change some flag?
Reply With Quote