Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - New SpamFilter Enterprise Release Candida
  FAQ FAQ  Forum Search   Register Register  Login Login

New SpamFilter Enterprise Release Candida

 Post Reply Post Reply Page  <12
Author
dabull07 View Drop Down
Newbie
Newbie


Joined: 20 March 2007
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote dabull07 Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2007 at 1:21pm
send me spam: administrator@aps.lfca1.us
Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2007 at 12:03pm

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.

Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2007 at 12:01pm

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

 

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 6:21pm
Dan,

The changes to the database should be seen by SpamFilter within 5 seconds. This is done by making the use of triggers. Whenever an entry in a table is added/deleted/modified, a trigger within that table causes a new record to be created in the table "tblreloadtableinfo" that will contain the domain id being modified, and the table name that was changed. SpamFilter continuosly monitors this table, and as soon as there is a new entry SpamFilter will reload the right table. I hope the competition doesn't see this and get ideas from us....

This said, could you verify that this is indeed happening (the addition of new records inthe tblreloadtableinfo)? Please note that if there is already an existing record for the domainid/tablename combination, we won't add another one. If this is not happening, there may be a trigger missing from your database. This could be possible if you had an older version of SpamFilter Enterprise create the tables, as previous versions were indeed buggy (but so could this version...)

It is problem that your 1st and last posting are related.

In regards to the 12 char limit, we've had another report about it, but could not replicate it. What database platform and version are you using?
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 3:38pm

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

Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 2:04pm

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

 

Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 1:58pm

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

Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 1:52pm
Oops...  Ver 3.5.3.654
Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 105
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2007 at 1:51pm

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

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 18 March 2007 at 8:32am
I apologize, the expiration was a month off. The RC expires 5/1/07. We're so close to the release date we didn't notice...
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
__M__ View Drop Down
Groupie
Groupie


Joined: 30 August 2006
Location: Australia
Status: Offline
Points: 75
Post Options Post Options   Thanks (0) Thanks(0)   Quote __M__ Quote  Post ReplyReply Direct Link To This Post Posted: 18 March 2007 at 12:26am
Roberto, can you confirm when the beta expiry date is for 3.5.3.654.

Judging by the download page it looks like April 1st, considering I need to run the beta version of SFE on our live server to resolve the mail-splitting issue this could be a problem for me after April 1.


Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 13 March 2007 at 11:39pm
The new SpamFilter Enterprise 3.5.3.654 Release Candidate RC1 is now available in the registered user area. There is only one minor bug fix from the latest beta as can be seen in the release notes.

Perhaps the biggest change is the availability of a new manual and documentation. While this is still a work in progress, we hope it is pretty accurate as-is.

The release note for this last build is as follows:
// New to VersionNumber = '3.5.3.654';
{TODO -cFix : SpamFilter could send duplicate emails when executing the process that runs every 60 minutes that reprocesses emails in the queue, as it could re-send emails that were being delivered at that exact moment}

Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply Page  <12
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.383 seconds.