getting the following errors in that updated bot sql file
ideas? mysql 5.0.11
Quote:
SQL query:
ALTER TABLE `guild_members` DROP PRIMARY KEY;
MySQL said: Documentation
#1091 - Can't DROP 'PRIMARY'; check that column/key exists
|
and
Quote:
DELIMITER $$
CREATE FUNCTION `GetMobType` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
DECLARE Result CHAR(1);
SET Result = NULL;
IF (SELECT COUNT(*) FROM `character_data` WHERE `name` = mobname) > 0 THEN
SET Result = 'C';
ELSEIF (SELECT COUNT(*) FROM `bots` WHERE `Name` = mobname) > 0 THEN
SET Result = 'B';
END IF;
RETURN Result;
END$$
MySQL said: Documentation
#1548 - Cannot load from mysql.proc. The table is probably corrupted
|