Bugs in Log?

[lerxst2112]

The only actual error I see is:

[07.18. - 12:30:13] [GUILDS__ERROR] Error loading guild member list 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE g.guild_id=1': #1146: Table 'peq.vwbotcharactermobs' doesn't exist

And it is because there is a problem with your database. That view would normally be created if you sourced load_bots.sql

[GLGanjika]

Originally Posted by lerxst2112

The only actual error I see is:



And it is because there is a problem with your database. That view would normally be created if you sourced load_bots.sql

I do remember doing that but i guess something didn't go through right - would i need to reload load_bots.sql
or drop everything and then load it? (I don't actually have
too many things worth losingyet so if it came do that
it wouldn't be all that bad.)

I saw this post:

http://new.eqemulator.net/forums/showthread.php?t=31402

but was confused by it telling me to add this:

In any case Is this a method of approaching this issue?

ALTER TABLE `botguildmembers` ADD `alt` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `public_note` ;

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;

where do i add this? peq/player_tables correct? I tried to apply
it to that location but nothing changed: might have done it wrong
since I'm still learning.

This is what mine looks like [I know its a mess xD] :

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,
ALTER TABLE `botguildmembers` ADD `alt` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `public_note` ;

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;