Answers.Body: <p>I had a similar experience when I cleaned out and reverted to a slightly earlier CiviCRM DB because we had made a goof (no need to elaborate on that). When I imported the desired backup, I had neither ANY triggers nor the MySQL routine civicrm_strip_non_numeric. We are running Wordpress 4.7.3 and Civi 4.7.16. I was able to recreate <strong><em>both</em></strong> the routine and the 27 triggers we use for our install by executing one of the functions for a typical site migration, namely:
  {$SITE_URL}/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/menu/rebuild&amp;reset=1&amp;triggerRebuild=1 </p>
  
  <p>If you're running Drupal or Joomla, there's a similar invocation. I didn't quite understand how/why it worked, but glad I stumbled across it ;). Evidently, it not only recreates triggers if missing, but adds in the missing routine. Perhaps someone with a little more experience might weigh in. I was just about to pose a question to that effect when I stumbled on your post via a search for "trigger."</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-04T19:43:41.867Z
Answers.Text: I ran the rebuilt triggers URL as they showed as Not Enabled and it had no effect. Still showing Not Enabled.
Answers.UserDisplayName: Andy Burns
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-23T18:35:41.610Z
Answers.LastActivityDate: 2017-03-24T15:51:10.570Z
Answers.LastEditDate: 2017-03-24T15:51:10.570Z
Answers.UserDisplayName: Karl Rudnick
Body: <p>One of the user noticed the Summary Fields weren't being updated.  Upon investigation I see that the triggers didn't exist anymore.  My guess is an upgrade to 4.6.26 wiped them out.  Unfortunately, I don't really know when they disappeared other than we had last payment dates of Jan 31.  What's odd is the test environment still has the triggers.  TTest was copied from production and upgraded.   Than about a week later prod was upgraded.</p>
  
  <p>The configuration page for Summary Fields showed the Contribution Table Triggers: Enabled.  Funny since they didn't exist.  I can see that the job for summary fields ran every hour without any errors. </p>
  
  <p>Saving the configuration page and kicking off the job recreated them and seems have updated the fields.</p>
  
  <p>The question here is why didn't the job notice the triggers were missing and why did it report there were enabled?  Oh and I suppose what could have caused them to be deleted?</p>
  
Tags: <summaryfields>
Title: Triggers for Summary Fields disappeared
ThreadText: # Triggers for Summary Fields disappeared
  
  (Asked by: username_0 on 2017-03-21)
  
  One of the user noticed the Summary Fields weren't being updated. Upon investigation I see that the triggers didn't exist anymore. My guess is an upgrade to 4.6.26 wiped them out. Unfortunately, I don't really know when they disappeared other than we had last payment dates of Jan 31. What's odd is the test environment still has the triggers. TTest was copied from production and upgraded. Than about a week later prod was upgraded.
  
  The configuration page for Summary Fields showed the Contribution Table Triggers: Enabled. Funny since they didn't exist. I can see that the job for summary fields ran every hour without any errors.
  
  Saving the configuration page and kicking off the job recreated them and seems have updated the fields.
  
  The question here is why didn't the job notice the triggers were missing and why did it report there were enabled? Oh and I suppose what could have caused them to be deleted?
  
  **Tags:** summaryfields
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-03-23. Score: 2
  
  I had a similar experience when I cleaned out and reverted to a slightly earlier CiviCRM DB because we had made a goof (no need to elaborate on that). When I imported the desired backup, I had neither ANY triggers nor the MySQL routine civicrm\_strip\_non\_numeric. We are running Wordpress 4.7.3 and Civi 4.7.16. I was able to recreate ***both*** the routine and the 27 triggers we use for our install by executing one of the functions for a typical site migration, namely:
  {$SITE\_URL}/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1
  
  If you're running Drupal or Joomla, there's a similar invocation. I didn't quite understand how/why it worked, but glad I stumbled across it ;). Evidently, it not only recreates triggers if missing, but adds in the missing routine. Perhaps someone with a little more experience might weigh in. I was just about to pose a question to that effect when I stumbled on your post via a search for "trigger."
  
  > **Comments:**
  > **username_2**: I ran the rebuilt triggers URL as they showed as Not Enabled and it had no effect. Still showing Not Enabled.  
  
  ---
  
  