Questions tagged [logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
173 views

Civi 5.9 - DB Error: no such table / cannot disable logging

Drupal 6 / Civi 5.9 / Aegir I deleted my log_civicrm_... tables and now am getting a "DB Error: no such table" across a range of CiviCRM actions including adding contacts, running cron etc. ...
7
votes
3answers
161 views

How to migrate database without logs

I’d like to move my CiviCRM installation from one Drupal server to another. But I enabled logging in the current server and I don’t want that data to be transferred to the new server. How can I delete ...
2
votes
1answer
96 views

How can I deal with a missing or corrupt binary ("advanced") log table?

Sometimes I install an extension that creates a new MySQL table, but it breaks because I have binary ("advanced") logging enabled. CiviCRM tries to write to the binary log, and it fails because the ...
2
votes
3answers
143 views

Change log crashes - table entity_log_civireport doesn't exist - how to fix?

After switching logging on, clicking the tab 'Change Log' hangs for ever and the following error occurs (full traceback availabe). This is, I guess, a temporary table that for some reason Civi has ...
8
votes
6answers
535 views

How can I improve the performance of the change log table?

Retrieving the change log for a contact takes ages for my client - maybe a response of 10 minutes to get just 79 records for one contact. The contact database has about 39K rows, but with about 950k ...
9
votes
2answers
314 views

Data Protection / GDPR - deleting from logging tables

With the new GDPR legislation taking effect in a matter on months, it dawns on me... how can we delete people permanently from the logging tables? My understanding is that the table types are a ...
5
votes
1answer
77 views

How can I revert a set of bulk changes to the database?

I made a bulk update of addresses that turned out to be incorrect. I have advanced logging enabled. I can go into each contact's change log and revert the mistake one by one; how can I do this for ...
5
votes
2answers
355 views

How do I turn on Detailed Logging?

The book tells about the advantages of Detailed Logging at length, but I don't see how to turn it on. Thanks!
5
votes
3answers
217 views

Missing Log Tables Error

It seems that daily, my System Status page is giving me the following error: Missing Log Tables You don't have logging enabled on some tables. This may cause errors on performing insert/update ...
2
votes
1answer
121 views

CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE'

I getting the following error when I try to dump my civicrm drupal database Couldn't read status information for table log_civicrm_install_canary () mysqldump: Couldn't execute 'show create table ...
1
vote
1answer
218 views

Large CiviCRM Logs

CiviCRM 4.7.31 (upgrading today) Drupal 7.x Our log_civicrm_group table crashed and needed repair. We had to run the repair twice from the command line for it to actually work. It's about 850MB large ...
0
votes
2answers
126 views

CiviRules triggers, but fails to send email

I'm using CiviCRM 5.18.4 on WordPress 5.4.1. I have been successfully using CiviRules to send a welcome email when a contact adds a (pending) membership. Now, I have created a rule that is ...
0
votes
1answer
104 views

Payment Processor Error 9003, and logging

I have the same issue that this person did, though I'm updated to 4.6.10 The issue is that when submitting payments, I get the 9003 error code, which says "MD5 Verification failed." I've reset the ...