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

 

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.