Details
Critical
Description
This is really worrying - it seems that for custom field groups we're missing some entries, even at the more recent end. Has anyone encountered this before?
mysql> select count(distinct(entity_id)) from log_civicrm_value_contact_reference_9;
----------------------------
| count(distinct(entity_id)) |
----------------------------
| 70071 |
----------------------------
1 row in set (0.25 sec)
mysql> select count(distinct(entity_id)) from civicrm_value_contact_reference_9;
----------------------------
| count(distinct(entity_id)) |
----------------------------
| 99997 |
----------------------------
1 row in set (0.44 sec)
mysql> select min(entity_id) from civicrm_value_contact_reference_9;
----------------
| min(entity_id) |
----------------
| 3881 |
----------------
1 row in set (0.00 sec)
mysql> select min(entity_id) from log_civicrm_value_contact_reference_9;
----------------
| min(entity_id) |
----------------
| 3881 |
----------------
1 row in set (0.00 sec)
mysql> select max(entity_id) from log_civicrm_value_contact_reference_9;
----------------
| max(entity_id) |
----------------
| 128791 |
----------------
1 row in set (0.17 sec)
mysql> select max(entity_id) from civicrm_value_contact_reference_9;
----------------
| max(entity_id) |
----------------
| 129328 |
----------------
1 row in set (0.00 sec)