Questions tagged [logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
9
votes
2answers
304 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 ...
8
votes
6answers
457 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 ...
6
votes
3answers
145 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 ...
5
votes
1answer
67 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
3answers
189 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 ...
5
votes
2answers
342 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!
4
votes
3answers
372 views

Impossible to disable logging

I am on Civi 4.7.6 / Drupal 7.5 I have not been able to record any new phone numbers for some days (via Webform Integration). I realize that I have lost a number of log_civicrm_... tables (those ...
4
votes
3answers
94 views

Logging functionnality disabled

I used to have Logging functionnality activated on one of my civicrm instance but when i look at log_civicrm_address, nothing seems to be logged since quite a while. When i look at the config screen ...
3
votes
2answers
112 views

Switched “logging” on - now get 'Unable to reach server'?

I just switched logging on for a 4.7.27 install which was working just fine. Now, when clicking on 'Change Log' tab I get the 'Network Error' popup with the message about being unable to reach the ...
2
votes
2answers
95 views

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

CiviCRM 4.7.x We used CiviCRM for many years and relied upon the normal 'changelog' then we enabled 'Detailed Logging' a few weeks ago, and the old entries from the tab disappeared. Do they still ...
2
votes
1answer
87 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
2answers
35 views

combining log and error output

I want to combine the output written to the civicrm log file and php_error.log. This is because I cannot alway conclude based on the time stamp what the order is of the messages in those files. ...
2
votes
1answer
144 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. ...
2
votes
1answer
87 views

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

I've successfully improved the performance of the 'Change Log' by taking Eileen's advice here, converting 5 tables to InnoDB and adding indexes. In so doing, I almost blew the space limit on the host ...
2
votes
1answer
275 views

ARCHIVE not enabled by default on MariaDB 10.1

The ARCHIVE storage engine is enabled by default on MariaDB 10.0, but no longer from 10.1. Therefore, you get a DB unknown error when CiviCRM tries to create a logging db table when logging is active ...
2
votes
1answer
118 views

CiviCRM Community Forums

may I know where to report an issue with "CiviCRM Community Forums" (forum.civicrm.org) pls? I have been able to create an account and start a thread but one day later, impossible to log in again: ...
2
votes
1answer
88 views

Is it possible to enable/disable logging using cv?

Can the command line cv tool be used to enable/disable logging?
2
votes
1answer
106 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 ...
2
votes
0answers
13 views

Logging enabled and multilingual functionality?

After Missing view when logging set in a non-US English instance. , I wonder if anyone has investigated the effects of turning a site from multilingual to monolingual or vice-versa whilst logging was ...
2
votes
0answers
28 views

Detailed logging running continually

On some but not all records, we see over 2K change log entries. On this record, the change log started and ran continuously from 11-26-19 to 1-20-2020 Another instance I had imported to the ...
2
votes
3answers
115 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 ...
1
vote
3answers
46 views

Prevent automatic login after registration

When people register on my wordpress website using a civicrm profile, they get logged in automatically. As I first need an Administrator to approve the user, I would like users not to be logged in ...
1
vote
1answer
191 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 ...
1
vote
2answers
346 views

What settings are required to display detailed change logging?

I've got a site using CiviCRM 4.5.8 I've tried to enable detailed change logging in Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.) But the change log tab still shows the basic changed by ...
1
vote
1answer
32 views

How to get relationship changes logged?

On the 4.7 Drupal 7 Demo site I changed the middle letter of contact Kathleen Adams and it gets logged and becomes visible in the log tab. Then I make a change in the relationship tab, adding a Case ...
1
vote
2answers
20 views

Action Records for Civi

Overarching question - Is there a way to see the actions that a specific user has performed? For example, is there a way to see what records a user has exported? Details - We recently had an ...
1
vote
1answer
42 views

Attachment too large for mailing - should there have been a warning?

Recently had a user attach a .docx file that was 14 MB to a mailing. (Probably a single picture in the document was to blame.) As one would expect, the messages bounced rather than being delivered. ...
1
vote
1answer
83 views

Any OTHER way to disable DB logging (CiviCRM 4.6x)?

Enabled logging to a DB caused "TABLE log_xxx doesn't exists" similar to this issue ; Extension installation (which should re-create LOG_ tables) has failed by the same reason. A sneaky trick from ...
1
vote
1answer
586 views

Any way to avoid “deprecated function” messages in the Drupal dblog?

I am getting a LOT of entries in the Drupal dblog (watchdog) about a deprecated PHP function, as described here - Debug PseudoConstant I'm trying to debug a different issue and the presence of these ...
1
vote
1answer
60 views

How can we see change logs for events?

We are using Civi 4.7.13 with logging enabled. How can we access the logs specifically for events to see the user change history, when an event was deleted and possibly what changed?
1
vote
0answers
51 views

Contact Logging Problem

i have turned on contact logging on my civicrm for a while when it suddenly couldn't list the contact summary report and reported a DB Error. When I turned on the debug, the following trace came ...
1
vote
2answers
77 views

My custom fields are not visible on Contact's Activity Log

I try to show (first for the admin user) all changes for a contact. That works on Contact's Activity Log page. I can see the date and time of modifying my custom fields, but the old and the new values ...
1
vote
4answers
99 views

Log table: nativecode=1118 ** Row size too large. You have to change some columns to TEXT or BLOBs

Pretty strange, since column mentioned is already of type TEXT. Full error message: [debug_info] => ALTER TABLE `civicrm_logs`.log_civicrm_value_grants_external_application_45 MODIFY `...
0
votes
1answer
46 views

How to repair DB tables after faulty past upgrade?

System: WordPress 5.2.5, CiviCRM 5.21.1, PHP 7.2.18 Background: At some point in a previous upgrade - I suspect from 5.19.x - my database tables haven't updated properly. This resulted in my ...
0
votes
1answer
98 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 ...
0
votes
1answer
26 views

What is the purpose of logs for activities in civicrm_log table?

I am struggling with a large database and try to find ways to reduce data mess. I really wonder why there is no scheduled job to delete old log entries from civicrm_log but this is not my question. ...
0
votes
1answer
22 views

Best Way to Track Logs

I am running into two separate issues that I need to address with logging. I am having trouble with the MailChimp extension and turned on logging and I do not know the best way to get the logs. ...
0
votes
2answers
59 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 ...