Questions tagged [logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
3answers
33 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
34 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
62 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. ...
1
vote
0answers
35 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 ...
5
votes
3answers
115 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 ...
1
vote
2answers
60 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
1answer
107 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 ...
2
votes
1answer
62 views

Is it possible to enable/disable logging using cv?

Can the command line cv tool be used to enable/disable logging?
1
vote
1answer
46 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 ...
2
votes
3answers
98 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 ...
3
votes
2answers
108 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 ...
8
votes
2answers
284 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 ...
1
vote
1answer
31 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 ...
0
votes
1answer
17 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. ...
2
votes
2answers
80 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 ...
1
vote
1answer
394 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
41 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?
2
votes
1answer
206 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
93 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 ...
4
votes
3answers
297 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 ...
1
vote
4answers
75 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 `...
4
votes
2answers
299 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!
0
votes
1answer
85 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 ...
2
votes
1answer
54 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: ...
1
vote
2answers
264 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 ...
2
votes
1answer
72 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 ...
8
votes
6answers
332 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
131 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 ...
4
votes
3answers
88 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 ...