Author Topic: 4.3.3 multiple triggers with the same action time and event for one table (Read 3977 times)

FrTommy · May 11, 2013, 08:47:15 am

I just upgraded to 4.3.3 from 4.3.0. The upgrade went fine until the very end when I got this error:

DB Error: unknown error
Error Details
Database Error Code: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table', 1235
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_value_more_info_4_after_insert after insert ON civicrm_value_more_info_4 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1235 ** This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table']
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_value_more_info_4_after_insert after insert ON civicrm_value_more_info_4 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1235 ** This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_value_more_info_4_after_insert after insert ON civicrm_value_more_info_4 FOR EACH ROW BEGIN  
UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.entity_id;
 END [nativecode=1235 ** This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table']"]
)

My details for MySQL are:
Server version: 5.1.53-log

The user has trigger access. I checked the user and also the host to make sure and the only limitation they have is the following: Cannot set DEFINER as non-root user, please remove DEFINER='user'@'host' combo to create trigger.

So what's going on and how do I fix it?

FrTommy · May 11, 2013, 09:25:09 am

Well 4.3.3 has taken down my entire site. getting 500 server errors and nothing loads. <sigh>

Thankfully, I figured out it was civi but my webhost was having issues. I'm back up but i'm still getting the above error.

FrTommy · May 27, 2013, 07:15:28 am

Any reason this would be happening?

lolas · May 27, 2013, 12:30:21 pm

I am taking a guess here:
A Google search for that error turns up cases where a previous line with DROP TRIGGER IF EXISTS had failed so that the user was trying to define a second trigger on the table.
Can you check if you already have a TRIGGER defined for that table? Perhaps due to another failed upgrade? Does it have the same name as the trigger that the upgrade is trying to create?
Can you scan through the upgrade code and find where that line happens? Perhaps you will find a DROP TRIGGER statement before that line. If there is one I would try running that line to see if it fails, gives you an error or just leaves the trigger in place.

CiviCRM Community Forums (archive)

News:

Author Topic: 4.3.3 multiple triggers with the same action time and event for one table (Read 3977 times)

FrTommy

4.3.3 multiple triggers with the same action time and event for one table

FrTommy

Re: 4.3.3 multiple triggers with the same action time and event for one table

FrTommy

Re: 4.3.3 multiple triggers with the same action time and event for one table

lolas

Re: 4.3.3 multiple triggers with the same action time and event for one table