CRM/Upgrade/Incremental/sql/4.3.1.mysql.tpl

   1 -- CRM-12351
   2 UPDATE civicrm_dedupe_rule_group SET title = name WHERE title IS NULL;
   3
   4 -- CRM-12373
   5
   6 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns';
   7 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
   8     VALUES
   9       (@bounceTypeID, 'Host or domain name not found');
  10
  11 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host';
  12 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
  13     VALUES
  14       (@bounceTypeID, 'lost connection'),
  15       (@bounceTypeID, 'conversation with [^ ]* timed out while');
  16
  17 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay';
  18 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern)
  19     VALUES
  20       (@bounceTypeID, 'No route to host'),
  21       (@bounceTypeID, 'Network is unreachable');