Hot answers tagged

11 votes

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

If logging is on then results will be retrieved from the log_xxx tables not civicm_log. Normally these tables use the archive engine - which is not indexable. We have in some cases selectively ...
user avatar
  • 1,920
6 votes

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

I was able to create a script to revert in bulk. I needed to look up the log_conn_id value associated with the bulk change I made. I made the change using the API import, but any change that happens ...
user avatar
5 votes

Impossible to disable logging

Fortunately, in CiviCRM 4.7 (and Civi 4.6.17+), installing ANY extension will recreate your missing logging tables. Not that enabling an extension isn't sufficient - you must install an extension. ...
user avatar
4 votes

How do I turn on Detailed Logging?

Logging can be turned on via Administer > System Settings > Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.). You will find the relevant page on the Drupal demo site here (NB, i am using the ...
user avatar
  • 27.2k
4 votes

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

As of CiviCRM 4.7, you can fix this by installing any extension; see CRM-15078. Schema differences are fixed on extension installation. If you are on an earlier version of CiviCRM, there's a trick ...
user avatar
4 votes

Large CiviCRM Logs

If you don't need the logs, you could delete them. Which engine are your log tables using? There is a useful article by Eileen about ARCHIVE vs INNODB: https://civicrm.org/blog/eileen/who-did-what-...
user avatar
  • 11.1k
3 votes

Data Protection / GDPR - deleting from logging tables

We wrote an extension a while back that anonymises contacts including entries in log tables. So you could anonymise the contact first and then delete them. As Xavier has mentioned, you will have to ...
user avatar
  • 3,337
3 votes

Data Protection / GDPR - deleting from logging tables

Just to be sure I understand you properly: this is about the right to erasure (a contact ask your organisation to remove any data about them), right? It's my understanding that indeed you should ...
user avatar
  • 10.1k
3 votes
Accepted

CiviCRM 'Detailed Logging' removes former 'Changelog' entries on contacts

By default the Report Contact Logging Report (Summary), that is used to display the detailed logging, requires the permission CiviCRM: administer CiviCRM. If you create a CiviCRM user without this ...
user avatar
3 votes

CiviCRM 'Detailed Logging' removes former 'Changelog' entries on contacts

They should still exist in the civicrm_log table if you have access to the DB.
user avatar
  • 2,396
3 votes

What settings are required to display detailed change logging?

I had the same problem - we run four different civi instances. Two had detailed change logs, two did not. Across all instances users had same privileges and all four instances had logging enabled. ...
user avatar
  • 624
3 votes

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

For people googling, I significantly increased the speed of the Change Log by following Eileen's advice in her answer: convert some tables (activity, activity_contact, contact, group, group_contact) ...
user avatar
  • 1,960
3 votes
Accepted

How to migrate database without logs

This can be done on the commandline. You can pass a list of tables to mysqldump and omit the tables starting with log_. (Below, testdb is the name of the DB we're using. You may want to add other ...
user avatar
3 votes
Accepted

Missing Log Tables Error

Most people who have this issue are on CiviCRM 5.3-5.6, and is caused by the "missing logging tables" check assuming that temp tables should have a logging table. There is a fix available on Github, ...
user avatar
3 votes
Accepted

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

Try disabling the logging functionality using API Explorer. Navigate from the menu link - Support -> Developer -> API Explorer. Or using Drush(if drupal) - drush cvapi Setting.create logging=0
user avatar
3 votes
Accepted

Delete Change Log for 1 contact

It depends on what you are trying to do. If you want the complete removal of the contact, together with related entities (like address, activities, event participations etc.), then permanently ...
user avatar
  • 867
3 votes

How do I get Detailed Logging working?

Reading around the issue reported above I came across this extension - https://github.com/eileenmcnaughton/nz.co.fuzion.innodbtriggers - which I've now installed, and it appears to have resolved my ...
user avatar
  • 3,664
2 votes

How to migrate database without logs

You may want to move log tables from main database to specially created database via settings in civicrm.settings.php. Of course, new empty database has to be created first. After that please find ...
user avatar
  • 1,350
2 votes
Accepted

Payment Processor Error 9003, and logging

Answering (2) only here. CiviCRM's payment processor logs vary in their location based on the CMS in use. These logfiles include a unique string per site, as the logfiles are located within the ...
user avatar
2 votes
Accepted

CiviCRM Community Forums

I would register an account on https://chat.civicrm.org (I don't think it shares logins with the rest of civicrm.org but maybe that's changed). Go into the "infrastructure" channel and someone should ...
user avatar
2 votes

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

Take a look at the INNODB logging extension. It converts the log table format from ARCHIVE to INNODB, adding indexes and speeding up as a result.
user avatar
2 votes

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

The log tables as originally implemented (I have checked for a few years if this is the case) also contain a large number of superfluous records due to writes that don't actually change the data. ...
user avatar
  • 6,671
2 votes

ARCHIVE not enabled by default on MariaDB 10.1

My strong advice to you would be to change the tables to be anything but ARCHIVE. Even InnoDB would be fine and preferred over ARHCIVE. We've had a number of sites have their entire audit schema's ...
user avatar
  • 2,396
2 votes

How to get relationship changes logged?

If you have enabled the detailed logging it is currently displayed under the target contact of that relationship. Arguably it would be better if it is shown on both contacts. You can view all ...
user avatar
2 votes

Missing Log Tables Error

Here is summary of our situation after ours reappeared. This was actually a wrong message shown on the status page. The logging is disabled on /civicrm/admin/setting/misc?reset=1. The flow which can ...
user avatar
  • 27.2k
2 votes

Is there a process to tidy the tables created by logging?

Writing "code" could be as simple as a cron script that runs daily and does mysql -u user -ppassword -e "DELETE FROM log_civicrm_group WHERE log_date < DATE_SUB(NOW(), INTERVAL 2 MONTH)" ...
user avatar
  • 18k
2 votes

Prevent automatic login after registration

CiviCRM relies on CMS(i.e WP) settings when creating users. By default WP doesn't provide any such settings so you may need to install some plugin which needs admin approval for newly created user. ...
user avatar
2 votes

Prevent automatic login after registration

You're running into the effects of this code which automatically logs the user in. Unfortunately there's no way to override this code at the moment - except to override the class file itself by ...
user avatar
2 votes

Prevent automatic login after registration

Thanks a lot guys. You got me on the right way and I looked for a wordpress solution instead of a civi one. I just added the following bits of code to my function.php file (in the child theme) to get ...
user avatar
  • 63
2 votes
Accepted

How to repair DB tables after faulty past upgrade?

It seems you already have is_active column added to civicrm_status_pref table. This was added in civi 5.19 version. From the backtrace, it seems the error is shown after civi tries to add the same ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible