Page MenuHomePhabricator

Civi change log yielding server error 4/23/18
Closed, ResolvedPublic2 Estimated Story Points

Description

The change log is consistently not opening due to server errors today:

changelogerrorcid=17367529.jpg (552×2 px, 168 KB)

Civi otherwise is working normally.

@Ejegg reports: DB Error: no such table

Event Timeline

Looks like it's missing a table name - note that civicrm. entity_log_civireport has a space after the '.'

INSERT IGNORE INTO civicrm_temp_civireport_logsummary
SELECT entity_log_civireport.id as log_civicrm_entity_id, 1,
 entity_log_civireport.log_action as log_civicrm_entity_log_action,
 '' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id,
 entity_log_civireport.log_date as log_civicrm_entity_log_date,
 modified_contact_civireport.display_name as log_civicrm_entity_altered_contact,
 modified_contact_civireport.id as log_civicrm_entity_altered_contact_id,
 entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id,
 modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted,
 altered_by_contact_civireport.display_name as altered_by_contact_display_name
FROM `civicrm`. entity_log_civireport
INNER JOIN civicrm_contact modified_contact_civireport ON (entity_log_civireport.entity_id = modified_contact_civireport.id )
LEFT  JOIN civicrm_contact altered_by_contact_civireport ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id)
WHERE ( modified_contact_civireport.id = XXXXXXXX )
AND (entity_log_civireport.log_action != 'Initialization')
GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id
ORDER BY entity_log_civireport.log_date DESC

[nativecode=1146 ** Table 'civicrm.entity_log_civireport' doesn't exist]

Change 430023 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm/civicrm@master] Prevent error on logging report for custom table disabled for logging (here wmf_donor)

https://gerrit.wikimedia.org/r/430023

Change 430023 merged by jenkins-bot:
[wikimedia/fundraising/crm/civicrm@master] Prevent error on logging report for custom table disabled for logging (here wmf_donor)

https://gerrit.wikimedia.org/r/430023

Just deployed @Eileenmcnaughton's fix, and it looks like this is working!