Print Page | Close Window

Problem sending inital registration email

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6113
Printed Date: 17 October 2017 at 5:46am


Topic: Problem sending inital registration email
Posted By: corymckee
Subject: Problem sending inital registration email
Date Posted: 19 June 2007 at 12:56pm

All of my users are complaning that they do not get their registration emails. I even tried to choose the "Forgot Password" and this was unsuccessful. I ran a check on the database and (dont know if its related) this is what it showed.

================
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:============
-- if exists (select * from sysobjects where name = 'tblbl_domains') drop table [dbo].[tblbl_domains]
create table [dbo].[tblbl_domains] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [domainname] varchar(255),
  constraint [pk_tblbl_domains_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_emailsfrom') drop table [dbo].[tblbl_emailsfrom]
create table [dbo].[tblbl_emailsfrom] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblbl_emailsfrom_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_emailsto') drop table [dbo].[tblbl_emailsto]
create table [dbo].[tblbl_emailsto] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblbl_emailsto_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_maps') drop table [dbo].[tblbl_maps]
create table [dbo].[tblbl_maps] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [server] varchar(255),
  [reverseip] bit default 1,
  constraint [pk_tblbl_maps_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_keywords') drop table [dbo].[tblbl_keywords]
create table [dbo].[tblbl_keywords] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [keywords] varchar(1024),
  constraint [pk_tblbl_keywords_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_attachments') drop table [dbo].[tblbl_attachments]
create table [dbo].[tblbl_attachments] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [attachments] varchar(1024),
  constraint [pk_tblbl_attachments_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_surbl') drop table [dbo].[tblbl_surbl]
create table [dbo].[tblbl_surbl] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [server] varchar(320),
  constraint [pk_tblbl_surbl_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_ips') drop table [dbo].[tblbl_ips]
create table [dbo].[tblbl_ips] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [ip] varchar(15),
  constraint [pk_tblbl_ips_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_honeypotemails') drop table [dbo].[tblbl_honeypotemails]
create table [dbo].[tblbl_honeypotemails] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblbl_honeypotemails_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_honeypotblockedips') drop table [dbo].[tblbl_honeypotblockedips]
create table [dbo].[tblbl_honeypotblockedips] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [ip] varchar(15),
  constraint [pk_tblbl_honeypotblockedips_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblbl_countries') drop table [dbo].[tblbl_countries]
create table [dbo].[tblbl_countries] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [countrycode] varchar(2),
  constraint [pk_tblbl_countries_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_authorizedtoemails') drop table [dbo].[tblwl_authorizedtoemails]
create table [dbo].[tblwl_authorizedtoemails] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblwl_authorizedtoemails_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_keywords') drop table [dbo].[tblwl_keywords]
create table [dbo].[tblwl_keywords] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [keywords] varchar(1024),
  constraint [pk_tblwl_keywords_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_emailsfrom') drop table [dbo].[tblwl_emailsfrom]
create table [dbo].[tblwl_emailsfrom] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblwl_emailsfrom_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_emailsto') drop table [dbo].[tblwl_emailsto]
create table [dbo].[tblwl_emailsto] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblwl_emailsto_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_autowhitelistforcedelivery') drop table [dbo].[tblwl_autowhitelistforcedelivery]
create table [dbo].[tblwl_autowhitelistforcedelivery] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [email] varchar(320),
  constraint [pk_tblwl_autowhitelistforcedelivery_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblwl_domainsips') drop table [dbo].[tblwl_domainsips]
create table [dbo].[tblwl_domainsips] (
  [id] int not null identity,
  [domainid] int default 0,
  [loginid] int default 0,
  [domain_or_ip] varchar(255),
  constraint [pk_tblwl_domainsips_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tblreloadtableinfo') drop table [dbo].[tblreloadtableinfo]
create table [dbo].[tblreloadtableinfo] (
  [id] int not null identity,
  [domainid] int default 0,
  [tablename] varchar(45),
  [updatetable] bit default 1,
  constraint [pk_tblreloadtableinfo_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tbl_filtersettings') drop table [dbo].[tbl_filtersettings]
create table [dbo].[tbl_filtersettings] (
  [id] int not null identity,
  [domainid] int default 0,
  [bl_domainsforcedelete] bit default 0,
  [bl_emailsfromforcedelete] bit default 0,
  [bl_emailstoforcedelete] bit default 0,
  [bl_countriesforcedelete] bit default 0,
  [bl_mapsforcedelete] bit default 0,
  [bl_keywordsforcedelete] bit default 0,
  [bl_attachmentsforcedelete] bit default 0,
  [bl_surblforcedelete] bit default 0,
  [bl_ipsforcedelete] bit default 0,
  [bl_honeypotemailsforcedelete] bit default 0,
  [rejectnoreverseforcedelete] bit default 0,
  [rejectnomxforcedelete] bit default 0,
  [spffilterenableforcedelete] bit default 0,
  [rejectemptymailfromforcedelete] bit default 0,
  [rejectsametofromdomainforcedelete] bit default 0,
  [rejectsametofromforcedelete] bit default 0,
  [sfdbforcedelete] bit default 0,
  [maxrcpt_toforcedelete] bit default 0,
  [authorizedtoforcedelete] bit default 0,
  [antivirusforcedelete] bit default 0,
  [imageforcedelete] bit default 0,
  [surblforcedelete] bit default 0,
  [bayesianfilterenable] bit default 1,
  [bayesianforcedelete] bit default 0,
  [spffilterenable] bit default 1,
  [spfneutralfilter] bit default 0,
  [spfsoftfailfilter] bit default 1,
  [spffailfilter] bit default 1,
  [allowpercent] bit default 0,
  [tagspam] bit default 0,
  [tagspamsubject] bit default 0,
  [tagspamandquarantine] bit default 0,
  [rejectnoreverse] bit default 1,
  [rejectnomx] bit default 1,
  [rejectemptymailfrom] bit default 0,
  [rejectsametofrom] bit default 0,
  [rejectsametofromdomain] bit default 0,
  [enableipcacheblacklist] bit default 1,
  [autowhitelistforcedeliveryenabled] bit default 1,
  [minmaps] int default 1,
  [maxsubjectspaces] int default 10,
  [spamimagethreshold] int default 10,
  [sfdb_networkreliability] int default 3,
  [sfdb_filtersall] bit default 1,
  [sfdb_filterslist] varchar(255),
  constraint [pk_tbl_filtersettings_id] primary key  ([id]),
)
-- if exists (select * from sysobjects where name = 'tbl_localdomains') drop table [dbo].[tbl_localdomains]
create table [dbo].[tbl_localdomains] (
  [id] int not null identity,
  [domainname] varchar(255),
  [destsmtpserver] varchar(255),
  [destsmtpserverport] int,
  [usedefaults] bit not null default 1,
  constraint [pk_tbl_localdomains_id] primary key  ([id]),
)
create  index [domainid] on [dbo].[tblbl_domains]([domainid])
create  index [loginid] on [dbo].[tblbl_domains]([loginid])
create  index [domainname] on [dbo].[tblbl_domains]([domainname])
create  index [domainid] on [dbo].[tblbl_emailsfrom]([domainid])
create  index [loginid] on [dbo].[tblbl_emailsfrom]([loginid])
create  index [email] on [dbo].[tblbl_emailsfrom]([email])
create  index [domainid] on [dbo].[tblbl_emailsto]([domainid])
create  index [loginid] on [dbo].[tblbl_emailsto]([loginid])
create  index [email] on [dbo].[tblbl_emailsto]([email])
create  index [domainid] on [dbo].[tblbl_maps]([domainid])
create  index [loginid] on [dbo].[tblbl_maps]([loginid])
create  index [server] on [dbo].[tblbl_maps]([server])
create  index [domainid] on [dbo].[tblbl_keywords]([domainid])
create  index [loginid] on [dbo].[tblbl_keywords]([loginid])
create  index [domainid] on [dbo].[tblbl_attachments]([domainid])
create  index [loginid] on [dbo].[tblbl_attachments]([loginid])
create  index [domainid] on [dbo].[tblbl_surbl]([domainid])
create  index [loginid] on [dbo].[tblbl_surbl]([loginid])
create  index [server] on [dbo].[tblbl_surbl]([server])
create  index [domainid] on [dbo].[tblbl_ips]([domainid])
create  index [loginid] on [dbo].[tblbl_ips]([loginid])
create  index [ip] on [dbo].[tblbl_ips]([ip])
create  index [domainid] on [dbo].[tblbl_honeypotemails]([domainid])
create  index [loginid] on [dbo].[tblbl_honeypotemails]([loginid])
create  index [email] on [dbo].[tblbl_honeypotemails]([email])
create  index [domainid] on [dbo].[tblbl_honeypotblockedips]([domainid])
create  index [loginid] on [dbo].[tblbl_honeypotblockedips]([loginid])
create  index [ip] on [dbo].[tblbl_honeypotblockedips]([ip])
create  index [domainid] on [dbo].[tblbl_countries]([domainid])
create  index [loginid] on [dbo].[tblbl_countries]([loginid])
create  index [countrycode] on [dbo].[tblbl_countries]([countrycode])
create  index [domainid] on [dbo].[tblwl_authorizedtoemails]([domainid])
create  index [loginid] on [dbo].[tblwl_authorizedtoemails]([loginid])
create  index [email] on [dbo].[tblwl_authorizedtoemails]([email])
create  index [domainid] on [dbo].[tblwl_keywords]([domainid])
create  index [loginid] on [dbo].[tblwl_keywords]([loginid])
create  index [domainid] on [dbo].[tblwl_emailsfrom]([domainid])
create  index [loginid] on [dbo].[tblwl_emailsfrom]([loginid])
create  index [email] on [dbo].[tblwl_emailsfrom]([email])
create  index [domainid] on [dbo].[tblwl_emailsto]([domainid])
create  index [loginid] on [dbo].[tblwl_emailsto]([loginid])
create  index [email] on [dbo].[tblwl_emailsto]([email])
create  index [domainid] on [dbo].[tblwl_autowhitelistforcedelivery]([domainid])
create  index [loginid] on [dbo].[tblwl_autowhitelistforcedelivery]([loginid])
create  index [email] on [dbo].[tblwl_autowhitelistforcedelivery]([email])
create  index [domainid] on [dbo].[tblwl_domainsips]([domainid])
create  index [loginid] on [dbo].[tblwl_domainsips]([loginid])
create  index [domain_or_ip] on [dbo].[tblwl_domainsips]([domain_or_ip])
create  index [tablename] on [dbo].[tblreloadtableinfo]([tablename])
create  index [domainid] on [dbo].[tbl_filtersettings]([domainid])
create unique index [domainname] on [dbo].[tbl_localdomains]([domainname])
alter table [dbo].[tblbl_domains] add constraint [fktblbl_domains] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_emailsfrom] add constraint [fktblbl_emailsfrom] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_emailsto] add constraint [fktblbl_emailsto] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_maps] add constraint [fktblbl_maps] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_keywords] add constraint [fktblbl_keywords] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_attachments] add constraint [fktblbl_attachments] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_surbl] add constraint [fktblbl_surbl] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_ips] add constraint [fktblbl_ips] foreign key ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_honeypotemails] add constraint [fktblbl_honeypotemails] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblbl_honeypotblockedips] add constraint [fktblbl_honeypotblockedips] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_authorizedtoemails] add constraint [fktblwl_authorizedtoemails] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_keywords] add constraint [fktblwl_keywords] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_emailsfrom] add constraint [fktblwl_emailsfrom] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_emailsto] add constraint [fktblwl_emailsto] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_autowhitelistforcedelivery] add constraint [fktblwl_autowhitelistforcedelivery] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
alter table [dbo].[tblwl_domainsips] add constraint [fktblwl_domainsips] foreign key  ( [domainid] )
    references [dbo].[tbl_localdomains] ( [id] ) on delete cascade

******* Error:There is already an object named 'tblbl_domains' in the database
===========Executing:============

insert into tbl_localdomains (domainname) values (' ALL DOMAINS');

******* Error:Cannot insert duplicate key row in object 'dbo.tbl_localdomains' with unique index 'domainname'
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_localdomains_au' and type = 'tr') drop trigger[tr_localdomains_au];
-- go
create trigger [dbo].[tr_localdomains_au]
on [dbo].[tbl_localdomains]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.id, 1, 'tbl_localdomains' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.id) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_localdomains_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_localdomains_ai' and type = 'tr') drop trigger[tr_localdomains_ai];
-- go
create trigger [dbo].[tr_localdomains_ai]
on [dbo].[tbl_localdomains]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.id, 1, 'tbl_localdomains' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.id) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_localdomains_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_localdomains_ad' and type = 'tr') drop trigger[tr_localdomains_ad];
-- go
create trigger [dbo].[tr_localdomains_ad]
on [dbo].[tbl_localdomains]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.id, 1, 'tbl_localdomains' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.id) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_localdomains_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_localdomains_bd' and type = 'tr') drop trigger[tr_localdomains_bd];
-- go
create trigger [dbo].[tr_localdomains_bd]
on [dbo].[tbl_localdomains]
for delete
as
declare @domainname varchar(255)
select @domainname = domainname from deleted
if @domainname = ' ALL DOMAINS'
begin
 raiserror('unable to delete system record for "all domains"', 16, 1)
end

******* Error:There is already an object named 'tr_localdomains_bd' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_au' and type = 'tr') drop trigger[trwl_authorizedtoemails_au];
-- go
create trigger [dbo].[trwl_authorizedtoemails_au]
on [dbo].[tblwl_authorizedtoemails]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_authorizedtoemails' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_authorizedtoemails_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_ai' and type = 'tr') drop trigger[trwl_authorizedtoemails_ai];
-- go
create trigger [dbo].[trwl_authorizedtoemails_ai]
on [dbo].[tblwl_authorizedtoemails]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_authorizedtoemails' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_authorizedtoemails_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_ad' and type = 'tr') drop trigger[trwl_authorizedtoemails_ad];
-- go
create trigger [dbo].[trwl_authorizedtoemails_ad]
on [dbo].[tblwl_authorizedtoemails]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_authorizedtoemails' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_authorizedtoemails_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_keywords_au' and type = 'tr') drop trigger[trwl_keywords_au];
-- go
create trigger [dbo].[trwl_keywords_au]
on [dbo].[tblwl_keywords]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_keywords' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_keywords_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_keywords_ai' and type = 'tr') drop trigger[trwl_keywords_ai];
-- go
create trigger [dbo].[trwl_keywords_ai]
on [dbo].[tblwl_keywords]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_keywords' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_keywords_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_keywords_ad' and type = 'tr') drop trigger[trwl_keywords_ad];
-- go
create trigger [dbo].[trwl_keywords_ad]
on [dbo].[tblwl_keywords]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_keywords' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_keywords_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_au' and type = 'tr') drop trigger[trwl_emailsfrom_au];
-- go
create trigger [dbo].[trwl_emailsfrom_au]
on [dbo].[tblwl_emailsfrom]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsfrom' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsfrom_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_ai' and type = 'tr') drop trigger[trwl_emailsfrom_ai];
-- go
create trigger [dbo].[trwl_emailsfrom_ai]
on [dbo].[tblwl_emailsfrom]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_emailsfrom' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsfrom_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_ad' and type = 'tr') drop trigger[trwl_emailsfrom_ad];
-- go
create trigger [dbo].[trwl_emailsfrom_ad]
on [dbo].[tblwl_emailsfrom]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsfrom' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsfrom_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsto_au' and type = 'tr') drop trigger[trwl_emailsto_au];
-- go
create trigger [dbo].[trwl_emailsto_au]
on [dbo].[tblwl_emailsto]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsto' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsto_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsto_ai' and type = 'tr') drop trigger[trwl_emailsto_ai];
-- go
create trigger [dbo].[trwl_emailsto_ai]
on [dbo].[tblwl_emailsto]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_emailsto' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsto_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_emailsto_ad' and type = 'tr') drop trigger[trwl_emailsto_ad];
-- go
create trigger [dbo].[trwl_emailsto_ad]
on [dbo].[tblwl_emailsto]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsto' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_emailsto_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_domainsips_au' and type = 'tr') drop trigger[trwl_domainsips_au];
-- go
create trigger [dbo].[trwl_domainsips_au]
on [dbo].[tblwl_domainsips]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_domainsips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_domainsips_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_domainsips_ai' and type = 'tr') drop trigger[trwl_domainsips_ai];
-- go
create trigger [dbo].[trwl_domainsips_ai]
on [dbo].[tblwl_domainsips]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_domainsips' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_domainsips_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_domainsips_ad' and type = 'tr') drop trigger[trwl_domainsips_ad];
-- go
create trigger [dbo].[trwl_domainsips_ad]
on [dbo].[tblwl_domainsips]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_domainsips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_domainsips_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_au' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_au];
-- go
create trigger [dbo].[trwl_autowhitelistforcedelivery_au]
on [dbo].[tblwl_autowhitelistforcedelivery]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_autowhitelistforcedelivery' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_ai' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_ai];
-- go
create trigger [dbo].[trwl_autowhitelistforcedelivery_ai]
on [dbo].[tblwl_autowhitelistforcedelivery]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_autowhitelistforcedelivery' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_ad' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_ad];
-- go
create trigger [dbo].[trwl_autowhitelistforcedelivery_ad]
on [dbo].[tblwl_autowhitelistforcedelivery]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_autowhitelistforcedelivery' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_domains_au' and type = 'tr') drop trigger[trbl_domains_au];
-- go
create trigger [dbo].[trbl_domains_au]
on [dbo].[tblbl_domains]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_domains' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_domains_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_domains_ai' and type = 'tr') drop trigger[trbl_domains_ai];
-- go
create trigger [dbo].[trbl_domains_ai]
on [dbo].[tblbl_domains]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_domains' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_domains_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_domains_ad' and type = 'tr') drop trigger[trbl_domains_ad];
-- go
create trigger [dbo].[trbl_domains_ad]
on [dbo].[tblbl_domains]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_domains' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_domains_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_au' and type = 'tr') drop trigger[trbl_emailsfrom_au];
-- go
create trigger [dbo].[trbl_emailsfrom_au]
on [dbo].[tblbl_emailsfrom]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsfrom' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsfrom_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_ai' and type = 'tr') drop trigger[trbl_emailsfrom_ai];
-- go
create trigger [dbo].[trbl_emailsfrom_ai]
on [dbo].[tblbl_emailsfrom]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_emailsfrom' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsfrom_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_ad' and type = 'tr') drop trigger[trbl_emailsfrom_ad];
-- go
create trigger [dbo].[trbl_emailsfrom_ad]
on [dbo].[tblbl_emailsfrom]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsfrom' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsfrom_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsto_au' and type = 'tr') drop trigger[trbl_emailsto_au];
-- go
create trigger [dbo].[trbl_emailsto_au]
on [dbo].[tblbl_emailsto]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsto' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsto_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsto_ai' and type = 'tr') drop trigger[trbl_emailsto_ai];
-- go
create trigger [dbo].[trbl_emailsto_ai]
on [dbo].[tblbl_emailsto]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_emailsto' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsto_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_emailsto_ad' and type = 'tr') drop trigger[trbl_emailsto_ad];
-- go
create trigger [dbo].[trbl_emailsto_ad]
on [dbo].[tblbl_emailsto]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsto' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_emailsto_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_countries_au' and type = 'tr') drop trigger[trbl_countries_au];
-- go
create trigger [dbo].[trbl_countries_au]
on [dbo].[tblbl_countries]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_countries' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_countries_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_countries_ai' and type = 'tr') drop trigger[trbl_countries_ai];
-- go
create trigger [dbo].[trbl_countries_ai]
on [dbo].[tblbl_countries]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_countries' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_countries_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_countries_ad' and type = 'tr') drop trigger[trbl_countries_ad];
-- go
create trigger [dbo].[trbl_countries_ad]
on [dbo].[tblbl_countries]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_countries' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_countries_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_maps_au' and type = 'tr') drop trigger[trbl_maps_au];
-- go
create trigger [dbo].[trbl_maps_au]
on [dbo].[tblbl_maps]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_maps' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_maps_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_maps_ai' and type = 'tr') drop trigger[trbl_maps_ai];
-- go
create trigger [dbo].[trbl_maps_ai]
on [dbo].[tblbl_maps]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_maps' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_maps_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_maps_ad' and type = 'tr') drop trigger[trbl_maps_ad];
-- go
create trigger [dbo].[trbl_maps_ad]
on [dbo].[tblbl_maps]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_maps' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_maps_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_keywords_au' and type = 'tr') drop trigger[trbl_keywords_au];
-- go
create trigger [dbo].[trbl_keywords_au]
on [dbo].[tblbl_keywords]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_keywords' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_keywords_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_keywords_ai' and type = 'tr') drop trigger[trbl_keywords_ai];
-- go
create trigger [dbo].[trbl_keywords_ai]
on [dbo].[tblbl_keywords]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_keywords' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_keywords_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_keywords_ad' and type = 'tr') drop trigger[trbl_keywords_ad];
-- go
create trigger [dbo].[trbl_keywords_ad]
on [dbo].[tblbl_keywords]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_keywords' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_keywords_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_attachments_au' and type = 'tr') drop trigger[trbl_attachments_au];
-- go
create trigger [dbo].[trbl_attachments_au]
on [dbo].[tblbl_attachments]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_attachments' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_attachments_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_attachments_ai' and type = 'tr') drop trigger[trbl_attachments_ai];
-- go
create trigger [dbo].[trbl_attachments_ai]
on [dbo].[tblbl_attachments]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_attachments' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_attachments_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_attachments_ad' and type = 'tr') drop trigger[trbl_attachments_ad];
-- go
create trigger [dbo].[trbl_attachments_ad]
on [dbo].[tblbl_attachments]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_attachments' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_attachments_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_surbl_au' and type = 'tr') drop trigger[trbl_surbl_au];
-- go
create trigger [dbo].[trbl_surbl_au]
on [dbo].[tblbl_surbl]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_surbl' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_surbl_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_surbl_ai' and type = 'tr') drop trigger[trbl_surbl_ai];
-- go
create trigger [dbo].[trbl_surbl_ai]
on [dbo].[tblbl_surbl]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_surbl' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_surbl_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_surbl_ad' and type = 'tr') drop trigger[trbl_surbl_ad];
-- go
create trigger [dbo].[trbl_surbl_ad]
on [dbo].[tblbl_surbl]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_surbl' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_surbl_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_ips_au' and type = 'tr') drop trigger[trbl_ips_au];
-- go
create trigger [dbo].[trbl_ips_au]
on [dbo].[tblbl_ips]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_ips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_ips_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_ips_ai' and type = 'tr') drop trigger[trbl_ips_ai];
-- go
create trigger [dbo].[trbl_ips_ai]
on [dbo].[tblbl_ips]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_ips' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_ips_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_ips_ad' and type = 'tr') drop trigger[trbl_ips_ad];
-- go
create trigger [dbo].[trbl_ips_ad]
on [dbo].[tblbl_ips]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_ips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_ips_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_au' and type = 'tr') drop trigger[trbl_honeypotemails_au];
-- go
create trigger [dbo].[trbl_honeypotemails_au]
on [dbo].[tblbl_honeypotemails]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotemails' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotemails_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_ai' and type = 'tr') drop trigger[trbl_honeypotemails_ai];
-- go
create trigger [dbo].[trbl_honeypotemails_ai]
on [dbo].[tblbl_honeypotemails]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_honeypotemails' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotemails_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_ad' and type = 'tr') drop trigger[trbl_honeypotemails_ad];
-- go
create trigger [dbo].[trbl_honeypotemails_ad]
on [dbo].[tblbl_honeypotemails]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotemails' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotemails_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_au' and type = 'tr') drop trigger[trbl_honeypotblockedips_au];
-- go
create trigger [dbo].[trbl_honeypotblockedips_au]
on [dbo].[tblbl_honeypotblockedips]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotblockedips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotblockedips_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_ai' and type = 'tr') drop trigger[trbl_honeypotblockedips_ai];
-- go
create trigger [dbo].[trbl_honeypotblockedips_ai]
on [dbo].[tblbl_honeypotblockedips]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_honeypotblockedips' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotblockedips_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_ad' and type = 'tr') drop trigger[trbl_honeypotblockedips_ad];
-- go
create trigger [dbo].[trbl_honeypotblockedips_ad]
on [dbo].[tblbl_honeypotblockedips]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotblockedips' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'trbl_honeypotblockedips_ad' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_filtersettings_au' and type = 'tr') drop trigger[tr_filtersettings_au];
-- go
create trigger [dbo].[tr_filtersettings_au]
on [dbo].[tbl_filtersettings]
after update as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tbl_filtersettings' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_filtersettings_au' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_filtersettings_ai' and type = 'tr') drop trigger[tr_filtersettings_ai];
-- go
create trigger [dbo].[tr_filtersettings_ai]
on [dbo].[tbl_filtersettings]
for insert as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tbl_filtersettings' from inserted ins
   where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_filtersettings_ai' in the database
===========Executing:============

-- if exists (select * from sysobjects where name = 'tr_filtersettings_ad' and type = 'tr') drop trigger[tr_filtersettings_ad];
-- go
create trigger [dbo].[tr_filtersettings_ad]
on [dbo].[tbl_filtersettings]
after delete as
 insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tbl_filtersettings' from deleted del
   where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))

******* Error:There is already an object named 'tr_filtersettings_ad' in the database


There is already an object named 'tblbl_domains' in the database

Cannot insert duplicate key row in object 'dbo.tbl_localdomains' with unique index 'domainname'

There is already an object named 'tr_localdomains_au' in the database

There is already an object named 'tr_localdomains_ai' in the database

There is already an object named 'tr_localdomains_ad' in the database

There is already an object named 'tr_localdomains_bd' in the database

There is already an object named 'trwl_authorizedtoemails_au' in the database

There is already an object named 'trwl_authorizedtoemails_ai' in the database

There is already an object named 'trwl_authorizedtoemails_ad' in the database

There is already an object named 'trwl_keywords_au' in the database

There is already an object named 'trwl_keywords_ai' in the database

There is already an object named 'trwl_keywords_ad' in the database

There is already an object named 'trwl_emailsfrom_au' in the database

There is already an object named 'trwl_emailsfrom_ai' in the database

There is already an object named 'trwl_emailsfrom_ad' in the database

There is already an object named 'trwl_emailsto_au' in the database

There is already an object named 'trwl_emailsto_ai' in the database

There is already an object named 'trwl_emailsto_ad' in the database

There is already an object named 'trwl_domainsips_au' in the database

There is already an object named 'trwl_domainsips_ai' in the database

There is already an object named 'trwl_domainsips_ad' in the database

There is already an object named 'trwl_autowhitelistforcedelivery_au' in the database

There is already an object named 'trwl_autowhitelistforcedelivery_ai' in the database

There is already an object named 'trwl_autowhitelistforcedelivery_ad' in the database

There is already an object named 'trbl_domains_au' in the database

There is already an object named 'trbl_domains_ai' in the database

There is already an object named 'trbl_domains_ad' in the database

There is already an object named 'trbl_emailsfrom_au' in the database

There is already an object named 'trbl_emailsfrom_ai' in the database

There is already an object named 'trbl_emailsfrom_ad' in the database

There is already an object named 'trbl_emailsto_au' in the database

There is already an object named 'trbl_emailsto_ai' in the database

There is already an object named 'trbl_emailsto_ad' in the database

There is already an object named 'trbl_countries_au' in the database

There is already an object named 'trbl_countries_ai' in the database

There is already an object named 'trbl_countries_ad' in the database

There is already an object named 'trbl_maps_au' in the database

There is already an object named 'trbl_maps_ai' in the database

There is already an object named 'trbl_maps_ad' in the database

There is already an object named 'trbl_keywords_au' in the database

There is already an object named 'trbl_keywords_ai' in the database

There is already an object named 'trbl_keywords_ad' in the database

There is already an object named 'trbl_attachments_au' in the database

There is already an object named 'trbl_attachments_ai' in the database

There is already an object named 'trbl_attachments_ad' in the database

There is already an object named 'trbl_surbl_au' in the database

There is already an object named 'trbl_surbl_ai' in the database

There is already an object named 'trbl_surbl_ad' in the database

There is already an object named 'trbl_ips_au' in the database

There is already an object named 'trbl_ips_ai' in the database

There is already an object named 'trbl_ips_ad' in the database

There is already an object named 'trbl_honeypotemails_au' in the database

There is already an object named 'trbl_honeypotemails_ai' in the database

There is already an object named 'trbl_honeypotemails_ad' in the database

There is already an object named 'trbl_honeypotblockedips_au' in the database

There is already an object named 'trbl_honeypotblockedips_ai' in the database

There is already an object named 'trbl_honeypotblockedips_ad' in the database

There is already an object named 'tr_filtersettings_au' in the database

There is already an object named 'tr_filtersettings_ai' in the database

There is already an object named 'tr_filtersettings_ad' in the database
Retrieved ServerID from tblServers: 1
Done.




Replies:
Posted By: LogSat
Date Posted: 19 June 2007 at 9:48pm
Cory,

The errors in the above log are normal and appear because tables in the database exist already.

If there were delivery problems to your server, most of the times they will be logged in SpamFilter's activity logfile. If you can take note of the time of when you attempt to (unsuccessfully) send an email via the web interface, please zip and email us the 5 minutes prior and after that time of SpamFilter's activity logfile. We'll take a look and try to find out what happened.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP



Print Page | Close Window