Problems Upgrading to SFE |
Post Reply |
Author | |
Belvoir
Newbie Joined: 13 February 2006 Location: United Kingdom Status: Offline Points: 24 |
Post Options
Thanks(0)
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
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
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.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.121 seconds.