Print Page | Close Window

Problems Upgrading to SFE

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=6969
Printed Date: 19 October 2017 at 2:25pm


Topic: Problems Upgrading to SFE
Posted By: Belvoir
Subject: Problems Upgrading to SFE
Date Posted: 11 July 2011 at 1:25pm
Hi
I am just in the process of upgrading my installation to SFE but am haviung a few problems.  My setup consists of Windows server 2003 R2 Standard Edition with SP2, MySQL 5.1.58-community edition and MySQL ODBC connector v3.51.12.  I have successfully activated SFE but when I click "Create/Check Database Tables" I get a whole bunch of errors similar to this:
 
******* Error:[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
07/11/11 18:18:21:753 -- ===========Executing:============
07/11/11 18:18:21:753 --  -- --  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 = 'tblbl_countries')) then --    insert into tblreloadtableinfo (domainid, updatetable, tablename) values (old.domainid, 1, 'tblbl_countries'); --  end if; -- end; --
07/11/11 18:18:21:753 -- ******* Error:[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
 
Followed by a bunch of errors similar to:
 
[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]Can't create table 'spamfilter.#sql-17dac_152' (errno: 121)
[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]Duplicate entry ' ALL DOMAINS' for key 'domainname'
[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
[MySQL][ODBC 3.51 Driver][mysqld-5.1.58-community]This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
What am I doing wrong?
 
Thanks for your help
 


-------------
Tradaweb Ltd

PO Box 30

St Neots

Cambridgeshire PE19 7GF

UK

http://www.tradaweb.co.uk" rel="nofollow - http://www.tradaweb.co.uk



Replies:
Posted By: LogSat
Date Posted: 11 July 2011 at 7:58pm
Belvoir,

Those errors can actually be ignored. Clicking on that button causes SpamFilter to attempt to re-create any missing tables/triggers/indexes. If they already exist, the script tries to re-create them anyways, and this may cause some errors to be logged.

If you would like to ensure that all the database patches are applied to the database (in case of restores/migrations these may sometimes be missing), you can stop SpamFilter, then find and remove the line starting with “DBPatchesApplied=” in the SpamFilter.ini file, and then restart SpamFilter. This will cause SpamFilter to download and apply all the patches that are available for the database. Again some errors may be logged, which is OK. If you'd like to email us the logfile to support at logsat dot com, we'd be happy to go over it to ensure there is nothing unusual going on.


-------------
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