Roberto,

I'm noticing this error on our SF Ent Ver 3.1.3.615

Exception occurred during TFilterObject.LoadFilter: Access violation at address 005F30A8 in module 'SpamFilterSvc.exe'. Read of address 0000009C

Thanks,
Dan B

R,

I'm preforming direct database configuration of adding and removing domains and SF is not seeing the changes.  If I restart the service it will then see that a domain had been added or removed and load those settings.

Is this a bug?  Or are we not allowed to make direct changes to the database?

Thanks,
Dan B

R,  Here is a bug that I just fould.  Ver 3.5.3.654

From within the SF Setting GUI adding or editing a domain name it is limited to 12 chars.

Dan B

R,

Here is another Exceprion occurred error in the log file.  Ver 3.5.3.654

(872) Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size

Dan

Roberto,

I'm using MySQL 5.0.37 as the database.  SF GUI would not create the tables and triggers.  I had to manually run the sql script that was provided with the latest SF RC.  As to the tblreloadtableinfo it's inserting the records to which tables are being modified and I'm seeing SF load the new settings within the activity log window but if I'm in the SF Settings window and a change is made to some records by the database.  It's not refreshing the data automatically.  I have to close the SF settings window and reopen it and the new data will display.  i.e  SMTP settings, testing the port change and the local domains table top left of window adding new domains by database.

I have notice that If I try step 2 of the create / check database tables.  I get the following errors.

------------------------------------------------

================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
tbl_FilterSettingsPresent - not found
tbl_LocalDomainsPresent - not found
tblBL_AttachmentsPresent - not found
tblBL_CountriesPresent - not found
tblBL_DomainsPresent - not found
tblBL_EmailsFromPresent - not found
tblBL_EmailsToPresent - not found
tblBL_HoneypotblockedIPsPresent - not found
tblBL_HoneypotEmailsPresent - not found
tblBL_IPsPresent - not found
tblBL_KeywordsPresent - not found
tblBL_MAPSPresent - not found
tblBL_SURBLPresent - not found
tblReloadTableInfoPresent - not found
tblWL_AuthorizedTOEmailsPresent - not found
tblWL_AutoWhitelistForceDeliveryPresent - not found
tblWL_DomainsIPsPresent - not found
tblWL_EmailsFromPresent - not found
tblWL_EmailsToPresent - not found
tblWL_KeywordsPresent - not found
Some Enterprise Database tables not found - recreating...
===========Executing:============
-- mysql enterprise setup
-- drop table if exists `tblbl_domains`;
-- go
create table if not exists `tblbl_domains` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `domainname` varchar(255),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `domainname` (`domainname`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_emailsfrom`;
-- go
create table if not exists `tblbl_emailsfrom` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_emailsto`;
-- go
create table if not exists `tblbl_emailsto` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_maps`;
-- go
create table if not exists `tblbl_maps` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `server` varchar(255),
  `reverseip` tinyint(1) default 1,
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `server` (`server`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_keywords`;
-- go
create table if not exists `tblbl_keywords` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `keywords` varchar(1024),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_attachments`;
-- go
create table if not exists `tblbl_attachments` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `attachments` varchar(1024),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_surbl`;
-- go
create table if not exists `tblbl_surbl` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `server` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `server` (`server`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_ips`;
-- go
create table if not exists `tblbl_ips` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `ip` varchar(15),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `ip` (`ip`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_honeypotemails`;
-- go
create table if not exists `tblbl_honeypotemails` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_honeypotblockedips`;
-- go
create table if not exists `tblbl_honeypotblockedips` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `ip` varchar(15),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `ip` (`ip`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblbl_countries`;
-- go
create table if not exists `tblbl_countries` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `countrycode` varchar(2),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `countrycode` (`countrycode`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_authorizedtoemails`;
-- go
create table if not exists `tblwl_authorizedtoemails` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_keywords`;
-- go
create table if not exists `tblwl_keywords` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `keywords` varchar(1024),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_emailsfrom`;
-- go
create table if not exists `tblwl_emailsfrom` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_emailsto`;
-- go
create table if not exists `tblwl_emailsto` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_autowhitelistforcedelivery`;
-- go
create table if not exists `tblwl_autowhitelistforcedelivery` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `email` varchar(320),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `email` (`email`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblwl_domainsips`;
-- go
create table if not exists `tblwl_domainsips` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `loginid` int(11) default 0,
  `domain_or_ip` varchar(255),
  primary key  (`id`),
  key `domainid` (`domainid`),
  key `loginid` (`loginid`),
  key `domain_or_ip` (`domain_or_ip`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tblreloadtableinfo`;
-- go
create table if not exists `tblreloadtableinfo` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `tablename` varchar(45),
  `updatetable` tinyint(1) default 1,
  primary key  (`id`),
  key `tablename` (`tablename`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tbl_filtersettings`;
-- go
create table if not exists `tbl_filtersettings` (
  `id` int(11) not null auto_increment,
  `domainid` int(11) default 0,
  `bl_domainsforcedelete` tinyint(1) default 0,
  `bl_emailsfromforcedelete` tinyint(1) default 0,
  `bl_emailstoforcedelete` tinyint(1) default 0,
  `bl_countriesforcedelete` tinyint(1) default 0,
  `bl_mapsforcedelete` tinyint(1) default 0,
  `bl_keywordsforcedelete` tinyint(1) default 0,
  `bl_attachmentsforcedelete` tinyint(1) default 0,
  `bl_surblforcedelete` tinyint(1) default 0,
  `bl_ipsforcedelete` tinyint(1) default 0,
  `bl_honeypotemailsforcedelete` tinyint(1) default 0,
  `rejectnoreverseforcedelete` tinyint(1) default 0,
  `rejectnomxforcedelete` tinyint(1) default 0,
  `spffilterenableforcedelete` tinyint(1) default 0,
  `rejectemptymailfromforcedelete` tinyint(1) default 0,
  `rejectsametofromdomainforcedelete` tinyint(1) default 0,
  `rejectsametofromforcedelete` tinyint(1) default 0,
  `sfdbforcedelete` tinyint(1) default 0,
  `maxrcpt_toforcedelete` tinyint(1) default 0,
  `authorizedtoforcedelete` tinyint(1) default 0,
  `antivirusforcedelete` tinyint(1) default 0,
  `imageforcedelete` tinyint(1) default 0,
  `surblforcedelete` tinyint(1) default 0,
  `bayesianforcedelete` tinyint(1) default 0,
  `spffilterenable` tinyint(1) default 1,
  `spfneutralfilter` tinyint(1) default 0,
  `spfsoftfailfilter` tinyint(1) default 1,
  `spffailfilter` tinyint(1) default 1,
  `allowpercent` tinyint(1) default 0,
  `tagspam` tinyint(1) default 0,
  `tagspamsubject` tinyint(1) default 0,
  `tagspamandquarantine` tinyint(1) default 0,
  `rejectnoreverse` tinyint(1) default 1,
  `rejectnomx` tinyint(1) default 1,
  `rejectemptymailfrom` tinyint(1) default 0,
  `rejectsametofrom` tinyint(1) default 0,
  `rejectsametofromdomain` tinyint(1) default 0,
  `enableipcacheblacklist` tinyint(1) default 1,
  `autowhitelistforcedeliveryenabled` tinyint(1) default 1,
  `minmaps` int(11) default 1,
  `maxsubjectspaces` int(11) default 10,
  `spamimagethreshold` int(11) default 10,
  `sfdb_networkreliability` int(11) default 3,
  `sfdb_filtersall` tinyint(1) default 1,
  `sfdb_filterslist` varchar(255),
  `destsmtpserver` varchar(255) default '',
  `destsmtpserverport` int(11),
  primary key  (`id`),
  key `domainid` (`domainid`)
) type=innodb;

===========Done==================
===========Executing:============

-- drop table if exists `tbl_localdomains`;
-- go
create table if not exists `tbl_localdomains` (
  `id` int(11) not null auto_increment,
  `domainname` varchar(255),
  `destsmtpserver` varchar(255) default null,
  `destsmtpserverport` int(11) default null,
  `usedefaults` tinyint(1) not null default 1,
  primary key  (`id`),
  unique key `domainname` (`domainname`)
) type=innodb;

===========Done==================
===========Executing:============

alter table `tblbl_domains` add constraint `fktblbl_domains` foreign key `fktblbl_domains` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_emailsfrom` add constraint `fktblbl_emailsfrom` foreign key `fktblbl_emailsfrom` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_emailsto` add constraint `fktblbl_emailsto` foreign key `fktblbl_emailsto` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_maps` add constraint `fktblbl_maps` foreign key `fktblbl_maps` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_keywords` add constraint `fktblbl_keywords` foreign key `fktblbl_keywords` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_attachments` add constraint `fktblbl_attachments` foreign key `fktblbl_attachments` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_surbl` add constraint `fktblbl_surbl` foreign key `fktblbl_surbl` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_ips` add constraint `fktblbl_ips` foreign key `fktblbl_ips` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_honeypotemails` add constraint `fktblbl_honeypotemails` foreign key `fktblbl_honeypotemails` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblbl_honeypotblockedips` add constraint `fktblbl_honeypotblockedips` foreign key `fktblbl_honeypotblockedips` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_authorizedtoemails` add constraint `fktblwl_authorizedtoemails` foreign key `fktblwl_authorizedtoemails` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_keywords` add constraint `fktblwl_keywords` foreign key `fktblwl_keywords` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_emailsfrom` add constraint `fktblwl_emailsfrom` foreign key `fktblwl_emailsfrom` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_emailsto` add constraint `fktblwl_emailsto` foreign key `fktblwl_emailsto` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_autowhitelistforcedelivery` add constraint `fktblwl_autowhitelistforcedelivery` foreign key `fktblwl_autowhitelistforcedelivery` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
alter table `tblwl_domainsips` add constraint `fktblwl_domainsips` foreign key `fktblwl_domainsips` (`domainid`)
    references `tbl_localdomains` (`id`) on delete cascade;

******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)
===========Executing:============
insert into tbl_localdomains (domainname) values (' ALL DOMAINS');

******* Error:Duplicate entry ' ALL DOMAINS' for key 2
===========Executing:============

--  drop trigger tr_localdomains_au;
-- go
create trigger tr_localdomains_au
after update on tbl_localdomains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.id) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.id, 1, 'tbl_localdomains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_localdomains_ai;
-- go
create trigger tr_localdomains_ai
after insert on tbl_localdomains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.id) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.id, 1, 'tbl_localdomains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_localdomains_ad;
-- go
create trigger tr_localdomains_ad
after delete on tbl_localdomains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.id) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.id, 1, 'tbl_localdomains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_localdomains_bd;
-- go
create trigger tr_localdomains_bd
before delete on tbl_localdomains
for each row
begin
 if (old.domainname = ' ALL DOMAINS') then
   call error_unabletodeletesystem_alldomains_record();
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_authorizedtoemails_au;
-- go
create trigger trwl_authorizedtoemails_au
after update on tblwl_authorizedtoemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_authorizedtoemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_authorizedtoemails_ai;
-- go
create trigger trwl_authorizedtoemails_ai
after insert on tblwl_authorizedtoemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_authorizedtoemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_authorizedtoemails_ad;
-- go
create trigger trwl_authorizedtoemails_ad
after delete on tblwl_authorizedtoemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_authorizedtoemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_keywords_au;
-- go
create trigger trwl_keywords_au
after update on tblwl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_keywords_ai;
-- go
create trigger trwl_keywords_ai
after insert on tblwl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_keywords_ad;
-- go
create trigger trwl_keywords_ad
after delete on tblwl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsfrom_au;
-- go
create trigger trwl_emailsfrom_au
after update on tblwl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsfrom_ai;
-- go
create trigger trwl_emailsfrom_ai
after insert on tblwl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsfrom_ad;
-- go
create trigger trwl_emailsfrom_ad
after delete on tblwl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsto_au;
-- go
create trigger trwl_emailsto_au
after update on tblwl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsto_ai;
-- go
create trigger trwl_emailsto_ai
after insert on tblwl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_emailsto_ad;
-- go
create trigger trwl_emailsto_ad
after delete on tblwl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_domainsips_au;
-- go
create trigger trwl_domainsips_au
after update on tblwl_domainsips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_domainsips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_domainsips_ai;
-- go
create trigger trwl_domainsips_ai
after insert on tblwl_domainsips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_domainsips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_domainsips_ad;
-- go
create trigger trwl_domainsips_ad
after delete on tblwl_domainsips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_domainsips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_autowhitelistforcedelivery_au;
-- go
create trigger trwl_autowhitelistforcedelivery_au
after update on tblwl_autowhitelistforcedelivery
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_autowhitelistforcedelivery');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_autowhitelistforcedelivery_ai;
-- go
create trigger trwl_autowhitelistforcedelivery_ai
after insert on tblwl_autowhitelistforcedelivery
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblwl_autowhitelistforcedelivery');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trwl_autowhitelistforcedelivery_ad;
-- go
create trigger trwl_autowhitelistforcedelivery_ad
after delete on tblwl_autowhitelistforcedelivery
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblwl_autowhitelistforcedelivery');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_domains_au;
-- go
create trigger trbl_domains_au
after update on tblbl_domains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_domains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_domains_ai;
-- go
create trigger trbl_domains_ai
after insert on tblbl_domains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_domains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_domains_ad;
-- go
create trigger trbl_domains_ad
after delete on tblbl_domains
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_domains');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsfrom_au;
-- go
create trigger trbl_emailsfrom_au
after update on tblbl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsfrom_ai;
-- go
create trigger trbl_emailsfrom_ai
after insert on tblbl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsfrom_ad;
-- go
create trigger trbl_emailsfrom_ad
after delete on tblbl_emailsfrom
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_emailsfrom');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsto_au;
-- go
create trigger trbl_emailsto_au
after update on tblbl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsto_ai;
-- go
create trigger trbl_emailsto_ai
after insert on tblbl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_emailsto_ad;
-- go
create trigger trbl_emailsto_ad
after delete on tblbl_emailsto
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_emailsto');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_countries_au;
-- go
create trigger trbl_countries_au
after update on tblbl_countries
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_countries');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_countries_ai;
-- go
create trigger trbl_countries_ai
after insert on tblbl_countries
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_countries');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_countries_ad;
-- go
create trigger trbl_countries_ad
after delete on tblbl_countries
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_countries');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_maps_au;
-- go
create trigger trbl_maps_au
after update on tblbl_maps
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_maps');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_maps_ai;
-- go
create trigger trbl_maps_ai
after insert on tblbl_maps
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_maps');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_maps_ad;
-- go
create trigger trbl_maps_ad
after delete on tblbl_maps
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_maps');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_keywords_au;
-- go
create trigger trbl_keywords_au
after update on tblbl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_keywords_ai;
-- go
create trigger trbl_keywords_ai
after insert on tblbl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_keywords_ad;
-- go
create trigger trbl_keywords_ad
after delete on tblbl_keywords
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_keywords');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_attachments_au;
-- go
create trigger trbl_attachments_au
after update on tblbl_attachments
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_attachments');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_attachments_ai;
-- go
create trigger trbl_attachments_ai
after insert on tblbl_attachments
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_attachments');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_attachments_ad;
-- go
create trigger trbl_attachments_ad
after delete on tblbl_attachments
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_attachments');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_surbl_au;
-- go
create trigger trbl_surbl_au
after update on tblbl_surbl
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_surbl');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_surbl_ai;
-- go
create trigger trbl_surbl_ai
after insert on tblbl_surbl
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_surbl');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_surbl_ad;
-- go
create trigger trbl_surbl_ad
after delete on tblbl_surbl
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_surbl');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_ips_au;
-- go
create trigger trbl_ips_au
after update on tblbl_ips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_ips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_ips_ai;
-- go
create trigger trbl_ips_ai
after insert on tblbl_ips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_ips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_ips_ad;
-- go
create trigger trbl_ips_ad
after delete on tblbl_ips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_ips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotemails_au;
-- go
create trigger trbl_honeypotemails_au
after update on tblbl_honeypotemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_honeypotemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotemails_ai;
-- go
create trigger trbl_honeypotemails_ai
after insert on tblbl_honeypotemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_honeypotemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotemails_ad;
-- go
create trigger trbl_honeypotemails_ad
after delete on tblbl_honeypotemails
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_honeypotemails');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotblockedips_au;
-- go
create trigger trbl_honeypotblockedips_au
after update on tblbl_honeypotblockedips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_honeypotblockedips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotblockedips_ai;
-- go
create trigger trbl_honeypotblockedips_ai
after insert on tblbl_honeypotblockedips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tblbl_honeypotblockedips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger trbl_honeypotblockedips_ad;
-- go
create trigger trbl_honeypotblockedips_ad
after delete on tblbl_honeypotblockedips
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_honeypotblockedips');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_filtersettings_au;
-- go
create trigger tr_filtersettings_au
after update on tbl_filtersettings
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tbl_filtersettings');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_filtersettings_ai;
-- go
create trigger tr_filtersettings_ai
after insert on tbl_filtersettings
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = new.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (new.domainid, 1, 'tbl_filtersettings');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
===========Executing:============

--  drop trigger tr_filtersettings_ad;
-- go
create trigger tr_filtersettings_ad
after delete on tbl_filtersettings
for each row
begin
 if not exists (select * from tblreloadtableinfo r where (r.domainid = old.domainid) and (r.tablename = tablename)) then
   insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tbl_filtersettings');
 end if;
end;

******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121)

Duplicate entry ' ALL DOMAINS' for key 2

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
Retrieved ServerID from tblServers: 18
Done.

-----------------------------------------------------

Again,  we are using MySQL 5.0.37 a fresh install of SF and MySQL.

I hope this helps.

Thanks,
Dan B

R,

Here is a thought.  When SF is checking for the tables is it comparing case sensitive?  All my tables are lower case and they all exist.

Dan B.

Roberto,

  Excellent job on the new documentation. Looks really good. Can we use portions of it on our help docs for our customers? Working on a new cp for end users and some of the sections about how it works would be helpful.

One observation. It appears that once I unclick defaults, my only real option is to copy the files from the defaults (record 1) to get the same functionality as I had before for each domain. BUT, if I have 300 domains, then I get 300 copies of every single blacklist, whitelist, etc. in the database as well 

What would be great is if we could have a way to specify a default table (like keywords.txt for example) so that when the textfile was built it from the db it would take a list of keywords common to all domains and then look for any unqiue entries.

Another thing. Lets say that I want to add a new keyword and use it for every one of my 300 domains. Would I have to write a script to add it to each and every domains keywords entry in the db?

Another issue I just thought of. I did a file copy to one of my domains (from default) and in additon to bringin all the lists over it created the exact duplicate of our autowhitelistdelivery into the db with the domains id. The issue is there are over 34,000 lines in our autowhitelistdelivery file! I assume I would have to write a script that parses the current flatfile and creates a unique entry for each domain and then delete the flatfile before I did my final conversion.

All in all SFE is looking very good.

Let me try another example. Let say I have a domain and I want this one domain to whitelist 3 IP's that the 'All Domains' does not. The only way for me to do this would be to uncheck 'use defaults' and then manually copy all the standard settings from 'all domains' or some other domain, correct?

So if I choose just to make any one thing different for an individual domain (like whitelist an ip for example) that is different then the 'all domains', I have to uncheck the 'use defaults'.

Correct? Or am I missing something

I guess what I was trying to say is it would be nice to use the 'all domains' default and then add any individual addons for any one domain, but I can see this would become a coding nightmare pretty quickly.

I guess If I want my customers to be able to add/delete whitelist & blacklist items then I really do have to have have individual settings for each and every domain.

The more I think about it thats the only way it could work. Thanks!

OK, I just thought of another way to explain this. Lets say the keyword file has 100 entries. And lets say I did have 300 domains and wanted to have custom settings for each. The would mean for table

dbo"."tblbl_keywords" there would be 30000 entries. But suppose those same 100 entries are used in all 300 domains? How could we save the duplication?

Wouldn't it be great to be able to tell SFE, hey use the same 100 entries as domainid 1 (ALL DOMAINS) and here are a couple more. So instead of 30000 entries in that table there would be 300 (one for each domain telling it to use the default) and then whatever additional entries idividual domains where to use. Soemthing like this by adding a field to each list. here are the fields for the keyword table.

by adding a use_default entry domain 267 would inherit all the keywords from the ALL DOMAINS setting, plus some additional ones particular to only this domain.

Hate to see so much duplication, but each user situation is different. Thanks for listening.

R,

I found another bug in SFE and I'm using MySQL as the database.  When I copied a blacklist keywords file with regEx and pasted it in the blkeyword, bldomains, or attachments box.  When they were inserted into the database any where that were regEx, MySQL interpreted it as a command and did not insert it exactly as it was entered and all backslashes were removed.

 Dan B

R,

Yes we are running ver 654 and it's doing it on all RegEx.  I had to write a Cold Fusion app to read all the bl and wl txt files and do a find and replace on all \ and replace them with \\ and insert.  MySQL will strip the first one and leave the second and insert it correctly.

Dan B

R,

FYI:  I tested installing SFE on a pre existing SF server and during the switch from standard to enterprise it didn't look pretty.  In the above post about the domain name being max of 12 chars. It trunked to 12 chars and it only inserted only 7 out of 20 domain names in the database localdomains table.  All domains are set as default.

I also noticed that the domain matrix file still exists.  Is it suppose to be now in the database table filtersettings?

I'll post more after I dig deeper into it.

Thanks,
Dan B

R,

I just sent you an email about the info that you requested.  If you can supply me with it I can send you the zipped file.

Thanks,
Dan B.

R,

I have a question.  I have 4 licenses of SF, not all 4 have the same domains on them.  With SFE, how can I set certain domains to be on certain SFE servers and not on the rest?  I'm looking at the database and I do not see how each SFE can determine which domains need to be on each SFE Server.

Is this something that was overlook by me or by design?

PS:  About the above post.  I haven't received the ftp info to send you that zipped file.

Thanks,
Dan B

Roberto,

Don't know if this is a bug or not...  Is the ALL DOMAINS folder supose to have a space in front of the ALL DOMAINS title?  I also noticed it in the tbl_localdomains.  I tried to rename both locations without the space and restarted SFE and it recreated a new folder titled _ALL DOMAINS  (_ = space) and added a new record in the tbl_filtersettings with DomainID = -1

Oh, one more bug..  If you have data in the SFDB_FiltersList field on table tbl_filtersettings and you make a change in the SFE GUI.  It wipes out the data in the SFDB_FiltersList field.

Thanks,
Dan B

Roberto,

I have yet another bug.  This time it's with the BL_HoneypotBlockedIPs.txt  SFE is adding the black list ip's to the file but not updating the dabase table tblbl_honeypotblockedips.

Thanks,
Dan B

Roberto,

Bug:...

I'm still getting this error with 655 when I try to change the port address for the default "All Domains" on one of the test servers.  The other test server is not updating the database either and is generating this error:

Server 2 Error:  Exception occurred during TFilterObject.SaveFilterSettings: Query-based update failed because the row to update could not be found

Server 1 Error:  Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size

and it doesn't save it to the database.  The datatype and size within the tbl_localdomains is  DestSMTPServerPort= int(11)

Thanks,
Dan B

R,

I've sent you an email with the login info.

Dan B

Roberto,

Feature missing in SFE??  When SF is configured as Standard mode, you can enable or disable the Bayesian Filter per domain from the domain matix.  When you are in Enterprise mode, you lose that option.  The only option is enable it globally from the Bayesian Filter tab.  Within the database table there is a field called BAYESIANForceDelete but not the option to enable / disable per domain.

Am I missing it somewhere?

Thanks,
Dan B