Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Problems Upgrading to SFE
  FAQ FAQ  Forum Search   Register Register  Login Login

Problems Upgrading to SFE

 Post Reply Post Reply
Author
Belvoir View Drop Down
Newbie
Newbie
Avatar

Joined: 13 February 2006
Location: United Kingdom
Status: Offline
Points: 24
Post Options Post Options   Thanks (0) Thanks(0)   Quote Belvoir Quote  Post ReplyReply Direct Link To This Post Topic: Problems Upgrading to SFE
    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
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: 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.136 seconds.