Mysql error on GM screen botbuffs table

[Nightrider84]

This is the error, I have to type it out best I can because I can't find the log.

Mysql error 1054: Unknown column 'Dot_rune' in 'field list' --INSTERT INTO
botbuffs [botid, spellid, CasterLevel, DurationFormula, TicsRemaining, PoisonCounters, DiseaseCounters, CurseCounters, CorruptionCounters, Hitcount, MeleeRune, MagicRune, dot_rune.
caston_x, Persistent, caston_y, caston_z, ExtraDIChance} VALUES {166,266,3,11,192,0,0,0,0,0,0,0,0,0,0,0,0,}

I did manage to fix it by adding in the unknown column dot_rune to my botbuffs table. there were another 3 1054 errors that popped up after that for other missing columns. Adding in the columns fixed my bots losing buffs after zoning issue as well. Hope this helps anybody with similar problems.

[rencro]

http://www.eqemulator.org/forums/sho...0&postcount=10

Unfortunately none of what I mentioned ever made it into emu's load_bots.sql BUT, in the peq daily dump from Feb 13, 2015, all these fixes are in except there is an error in that they they use dotRune instead of dot_rune.

(dont use the load_bots from the emu folder)

for the heck of it here is load_bots..I would drop_bots first...

-- This is pretty much a straight copy of the original files with fixes applied.
-- HeidiSQL does not like sub-directory references, so this should now run from there.
-- The 'headers' are left in place for reference only.

-- FILE:
-- source player_tables/botguildmembers.sql;
CREATE TABLE IF NOT EXISTS `botguildmembers` (
  `char_id` int(11) NOT NULL default '0',
  `guild_id` mediumint(8) unsigned NOT NULL default '0',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  `tribute_enable` tinyint(3) unsigned NOT NULL default '0',
  `total_tribute` int(10) unsigned NOT NULL default '0',
  `last_tribute` int(10) unsigned NOT NULL default '0',
  `banker` tinyint(3) unsigned NOT NULL default '0',
  `public_note` text NULL,
  `alt` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`char_id`)
) ENGINE=InnoDB;

-- FILE:
-- source player_tables/bots.sql;
update spawn2 set enabled = 1 where id in (59297,59298);

INSERT INTO rule_values VALUES ('1', 'Bots:BotManaRegen', '3.0', 'Adjust mana regen for bots, 1 is fast and higher numbers slow it down 3 is about the same as players.');
INSERT INTO rule_values VALUES ('1', 'Bots:BotFinishBuffing', 'false', 'Allow for buffs to complete even if the bot caster is out of mana.  Only affects buffing out of combat.');
INSERT INTO rule_values VALUES ('1', 'Bots:CreateBotCount', '150', 'Number of bots that each account can create');
INSERT INTO rule_values VALUES ('1', 'Bots:SpawnBotCount', '71', 'Number of bots a character can have spawned at one time, You + 71 bots is a 12 group raid');
INSERT INTO rule_values VALUES ('1', 'Bots:BotQuest', 'false', 'Optional quest method to manage bot spawn limits using the quest_globals name bot_spawn_limit, see: /bazaar/Aediles_Thrall.pl');
INSERT INTO rule_values VALUES ('1', 'Bots:BotGroupBuffing', 'false', 'Bots will cast single target buffs as group buffs, default is false for single. Does not make single target buffs work for MGB.');
INSERT INTO rule_values VALUES ('1', 'Bots:BotSpellQuest', 'false', 'Anita Thrall\'s (Anita_Thrall.pl) Bot Spell Scriber quests.');

-- this is a hack fix to maintain the original file process
delete from rule_values where rule_name like 'Bots%' and ruleset_id = 1;
INSERT INTO rule_values VALUES ('1', 'Bots:BotAAExpansion', '8', 'The expansion through which bots will obtain AAs');

-- field count has changed
-- INSERT INTO `commands` VALUES ('bot', '0', 'Type \"#bot help\" to the see the list of available commands for bots.');
INSERT INTO `commands` VALUES ('bot', '0');

CREATE TABLE  bots (
  `BotID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BotOwnerCharacterID` int(10) unsigned NOT NULL,
  `BotSpellsID` int(10) unsigned NOT NULL DEFAULT '0',
  `Name` varchar(64) NOT NULL,
  `LastName` varchar(32) DEFAULT NULL,
  `BotLevel` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `Race` smallint(5) NOT NULL DEFAULT '0',
  `Class` tinyint(2) NOT NULL DEFAULT '0',
  `Gender` tinyint(2) NOT NULL DEFAULT '0',
  `Size` float NOT NULL DEFAULT '0',
  `Face` int(10) NOT NULL DEFAULT '1',
  `LuclinHairStyle` int(10) NOT NULL DEFAULT '1',
  `LuclinHairColor` int(10) NOT NULL DEFAULT '1',
  `LuclinEyeColor` int(10) NOT NULL DEFAULT '1',
  `LuclinEyeColor2` int(10) NOT NULL DEFAULT '1',
  `LuclinBeardColor` int(10) NOT NULL DEFAULT '1',
  `LuclinBeard` int(10) NOT NULL DEFAULT '0',
  `DrakkinHeritage` int(10) NOT NULL DEFAULT '0',
  `DrakkinTattoo` int(10) NOT NULL DEFAULT '0',
  `DrakkinDetails` int(10) NOT NULL DEFAULT '0',
  `HP` INTEGER NOT NULL DEFAULT '0',
  `Mana` INTEGER NOT NULL DEFAULT '0',
  `MR` smallint(5) NOT NULL DEFAULT '0',
  `CR` smallint(5) NOT NULL DEFAULT '0',
  `DR` smallint(5) NOT NULL DEFAULT '0',
  `FR` smallint(5) NOT NULL DEFAULT '0',
  `PR` smallint(5) NOT NULL DEFAULT '0',
  `Corrup` SMALLINT(5) NOT NULL DEFAULT '0',
  `AC` smallint(5) NOT NULL DEFAULT '0',
  `STR` mediumint(8) NOT NULL DEFAULT '75',
  `STA` mediumint(8) NOT NULL DEFAULT '75',
  `DEX` mediumint(8) NOT NULL DEFAULT '75',
  `AGI` mediumint(8) NOT NULL DEFAULT '75',
  `_INT` mediumint(8) NOT NULL DEFAULT '80',
  `WIS` mediumint(8) NOT NULL DEFAULT '75',
  `CHA` mediumint(8) NOT NULL DEFAULT '75',
  `ATK` mediumint(9) NOT NULL DEFAULT '0',
  `BotCreateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `LastSpawnDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `TotalPlayTime` int(10) unsigned NOT NULL DEFAULT '0',
  `LastZoneId` smallint(6) NOT NULL DEFAULT '0',
  `BotInspectMessage` VARCHAR(256) NOT NULL DEFAULT '',
  PRIMARY KEY (`BotID`)
) ENGINE=InnoDB;

ALTER TABLE `group_id` DROP PRIMARY KEY, ADD PRIMARY KEY  USING BTREE(`groupid`, `charid`, `name`);
-- ALTER TABLE `guild_members` DROP PRIMARY KEY; -- rencro issue?

DROP VIEW IF EXISTS `vwGuildMembers`;
CREATE VIEW `vwGuildMembers` AS
  select 'C' as mobtype,
cm.char_id,
cm.guild_id,
cm.rank,
cm.tribute_enable,
cm.total_tribute,
cm.last_tribute,
cm.banker,
cm.public_note,
cm.alt
from guild_members as cm
union all
select 'B' as mobtype,
bm.char_id,
bm.guild_id,
bm.rank,
bm.tribute_enable,
bm.total_tribute,
bm.last_tribute,
bm.banker,
bm.public_note,
bm.alt
from botguildmembers as bm;

DROP VIEW IF EXISTS `vwBotCharacterMobs`;
CREATE VIEW `vwBotCharacterMobs` AS
   select _utf8'C' AS `mobtype`,
`c`.`id`,
`c`.`name`,
`c`.`class`,
`c`.`level`,
`c`.`last_login`,
`c`.`zone_id` 
from `character_data` `c` 
union all 
select _utf8'B' AS `mobtype`,
`b`.`BotID` AS `id`,
`b`.`Name` AS `name`,
`b`.`Class` AS `class`,
`b`.`BotLevel` AS `level`,
0 AS `timelaston`,
0 AS `zoneid` 
from `bots` `b`;

-- FILE:
-- source player_tables/botpetstatepersists.sql;
DROP TABLE IF EXISTS `botpetinventory`;
DROP TABLE IF EXISTS `botpetbuffs`;
DROP TABLE IF EXISTS `botpets`;

CREATE TABLE IF NOT EXISTS `botpets` (
  `BotPetsId` integer unsigned NOT NULL AUTO_INCREMENT,
  `PetId` integer unsigned NOT NULL DEFAULT '0',
  `BotId` integer unsigned NOT NULL DEFAULT '0',
  `Name` varchar(64) NULL,
  `Mana` integer NOT NULL DEFAULT '0',
  `HitPoints` integer NOT NULL DEFAULT '0',
  PRIMARY KEY (`BotPetsId`),
  KEY `FK_botpets_1` (`BotId`),
  CONSTRAINT `FK_botpets_1` FOREIGN KEY (`BotId`) REFERENCES `bots` (`BotID`),
  CONSTRAINT `U_botpets_1` UNIQUE (`BotId`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `botpetbuffs` (
  `BotPetBuffId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BotPetsId` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellId` int(10) unsigned NOT NULL DEFAULT '0',
  `CasterLevel` int(10) unsigned NOT NULL DEFAULT '0',
  `Duration` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`BotPetBuffId`),
  KEY `FK_botpetbuffs_1` (`BotPetsId`),
  CONSTRAINT `FK_botpetbuffs_1` FOREIGN KEY (`BotPetsId`) REFERENCES `botpets` (`BotPetsID`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `botpetinventory` (
  `BotPetInventoryId` integer unsigned NOT NULL AUTO_INCREMENT,
  `BotPetsId` integer unsigned NOT NULL DEFAULT '0',
  `ItemId` integer unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`BotPetInventoryId`),
  KEY `FK_botpetinventory_1` (`BotPetsId`),
  CONSTRAINT `FK_botpetinventory_1` FOREIGN KEY (`BotPetsId`) REFERENCES `botpets` (`BotPetsID`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

-- FILE:
-- source player_tables/botinventory.sql;
CREATE TABLE IF NOT EXISTS botinventory (
  BotInventoryID integer unsigned NOT NULL auto_increment,
  BotID integer unsigned NOT NULL DEFAULT '0',
  SlotID integer signed NOT NULL DEFAULT '0',
  ItemID integer unsigned NOT NULL DEFAULT '0',
  charges tinyint(3) unsigned DEFAULT 0,
  color integer unsigned NOT NULL DEFAULT 0,
  augslot1 mediumint(7) unsigned NOT NULL DEFAULT 0,
  augslot2 mediumint(7) unsigned NOT NULL DEFAULT 0,
  augslot3 mediumint(7) unsigned NOT NULL DEFAULT 0,
  augslot4 mediumint(7) unsigned NOT NULL DEFAULT 0,
  augslot5 mediumint(7) unsigned DEFAULT 0,
  instnodrop tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (BotInventoryID),
  KEY FK_botinventory_1 (BotID),
  CONSTRAINT FK_botinventory_1 FOREIGN KEY (BotID) REFERENCES bots (BotID)
) ENGINE=InnoDB; 

-- FILE:
-- source player_tables/botbuffs.sql;
DROP TABLE IF EXISTS `botbuffs`;
CREATE TABLE `botbuffs` (
  `BotBuffId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BotId` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellId` int(10) unsigned NOT NULL DEFAULT '0',
  `CasterLevel` int(10) unsigned NOT NULL DEFAULT '0',
  `DurationFormula` int(10) unsigned NOT NULL DEFAULT '0',
  `TicsRemaining` int(11) unsigned NOT NULL DEFAULT '0',
  `PoisonCounters` int(11) unsigned NOT NULL DEFAULT '0',
  `DiseaseCounters` int(11) unsigned NOT NULL DEFAULT '0',
  `CurseCounters` int(11) unsigned NOT NULL DEFAULT '0',
  `CorruptionCounters` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `HitCount` int(10) unsigned NOT NULL DEFAULT '0',
  `MeleeRune` int(10) unsigned NOT NULL DEFAULT '0',
  `MagicRune` int(10) unsigned NOT NULL DEFAULT '0',
  `dot_rune` int(10) unsigned NOT NULL DEFAULT '0',
  `caston_x` int(10) unsigned NOT NULL DEFAULT '0',
  `Persistent` tinyint(1) NOT NULL DEFAULT '0',
  `caston_y` int(10) unsigned NOT NULL DEFAULT '0',
  `caston_z` int(10) unsigned NOT NULL DEFAULT '0',
  `ExtraDIChance` int(10) unsigned NOT NULL DEFAULT '0', 
  PRIMARY KEY (`BotBuffId`),
  KEY `FK_botbuff_1` (`BotId`),
  CONSTRAINT `FK_botbuff_1` FOREIGN KEY (`BotId`) REFERENCES `bots` (`BotID`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

-- FILE:
-- source player_tables/botadventuring.sql;
DELIMITER $$

DROP FUNCTION IF EXISTS `GetMobType` $$
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 $$

DELIMITER ;

DROP VIEW IF EXISTS `vwGroups`;
CREATE VIEW `vwGroups` AS
   select `g`.`groupid` AS `groupid`,
`GetMobType`(`g`.`name`) AS `mobtype`,
`g`.`name` AS `name`,
`g`.`charid` AS `mobid`,
ifnull(`c`.`level`,`b`.`BotLevel`) AS `level` 
from ((`group_id` `g` 
left join `character_data` `c` on((`g`.`name` = `c`.`name`))) 
left join `bots` `b` on((`g`.`name` = `b`.`Name`)));

-- FILE:
-- source player_tables/botgroups.sql;
DROP TABLE IF EXISTS `botgroupmembers`;
DROP TABLE IF EXISTS `botgroup`;

CREATE TABLE IF NOT EXISTS `botgroup` (
  `BotGroupId` integer unsigned NOT NULL AUTO_INCREMENT,
  `BotGroupLeaderBotId` integer unsigned NOT NULL DEFAULT '0',
  `BotGroupName` varchar(64) NOT NULL,
  PRIMARY KEY  (`BotGroupId`),
  KEY FK_botgroup_1 (BotGroupLeaderBotId),
  CONSTRAINT FK_botgroup_1 FOREIGN KEY (BotGroupLeaderBotId) REFERENCES bots (BotID)
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS `botgroupmembers` (
  `BotGroupMemberId` integer unsigned NOT NULL AUTO_INCREMENT,
  `BotGroupId` integer unsigned NOT NULL DEFAULT '0',
  `BotId` integer unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY  (`BotGroupMemberId`),
  KEY FK_botgroupmembers_1 (BotGroupId),
  CONSTRAINT FK_botgroupmembers_1 FOREIGN KEY (BotGroupId) REFERENCES botgroup (BotGroupId),
  KEY FK_botgroupmembers_2 (BotId),
  CONSTRAINT FK_botgroupmembers_2 FOREIGN KEY (BotId) REFERENCES bots (BotID)
) ENGINE=InnoDB;

DROP VIEW IF EXISTS `vwBotGroups`;
CREATE VIEW `vwBotGroups` AS
select `g`.`BotGroupId` AS `BotGroupId`,
`g`.`BotGroupName` AS `BotGroupName`,
`g`.`BotGroupLeaderBotId` AS `BotGroupLeaderBotId`,
`b`.`Name` AS `BotGroupLeaderName`,
`b`.`BotOwnerCharacterID` AS `BotOwnerCharacterId`,
`c`.`name` AS `BotOwnerCharacterName` 
from ((`botgroup` `g` 
join `bots` `b` on((`g`.`BotGroupLeaderBotId` = `b`.`BotID`))) 
join `character_data` `c` on((`b`.`BotOwnerCharacterID` = `c`.`id`))) 
order by `b`.`BotOwnerCharacterID`,`g`.`BotGroupName`;

-- FILE:
-- source player_tables/botstances.sql;
CREATE TABLE  botstances (
  BotID int(10) unsigned NOT NULL default '0',
  StanceID tinyint unsigned NOT NULL default '0',
  PRIMARY KEY  (BotID),
  CONSTRAINT FK_botstances_1 FOREIGN KEY (BotID) REFERENCES bots (BotID)
);

-- FILE:
-- source player_tables/bottimers.sql;
CREATE TABLE bottimers (
BotID int(10) unsigned NOT NULL default '0',
TimerID int(10) unsigned NOT NULL default '0',
Value int(10) unsigned NOT NULL default '0',
PRIMARY KEY (BotID),
CONSTRAINT FK_bottimers_1 FOREIGN KEY (BotID) REFERENCES bots (BotID)
)