Skip to main content

Questions tagged [logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

Entries in Log Tables

Some of our log tables are rather large and we're curious as to how the logging process works. We'll have static groups that have and 'Update' log entry during times when no one has actively updated ...
J. Rolfs's user avatar
  • 381
1 vote
1 answer
39 views

SOLVED - DB Error: insufficient permissions when separating log tables from main civiCRM DB

I have a site running civiCRM 5.72.1 on Joomla 3.10.12. My civicrm_log tables are huge, so I planned to separate them from the Joomla database where they have been 5+ years. To do this I: Created a ...
A. Block's user avatar
  • 555
0 votes
0 answers
51 views

Log Detail Report - DB Error when viewing an update to a contact

Developer question. Civi 5.71.1 on Drupal 10 with a separate db for CiviCRM logs. Symptom I'm getting many "DB Error: no such field" errors when viewing "update" changes in the Log ...
Justin657's user avatar
  • 365
0 votes
0 answers
38 views

MySQL ERROR 3161 at Change Log on Contact pages after db migration

After db migration, Change Log tab on Contact pages doesn't load due to error about creating temporary tables using memory engine. I could recreate the error with the following query: mysql> CREATE ...
kenorb's user avatar
  • 131
2 votes
1 answer
100 views

Log viewer issue after upgrading to 5.57.1

I just updated some CiviCRM staging/test sites to 5.57.1 and my log viewer seems to be broken. This is Drupal 7 site I get something like the following error for all sites: Unable to read entries from ...
tanbog's user avatar
  • 317
1 vote
1 answer
16 views

On contact : change history (logging) is empty

On contacts, the "Change log" tab is empty. It used to show the contact fields updated, with previous and new value. I checked the following : I have enabled logging at Administer - System ...
stackexchange user's user avatar
0 votes
1 answer
108 views

How do I get Detailed Logging working?

Using the documentation, I've created a new database for my detailed logging data - I already had one for the CMS (Drupal) and one for Civi - and I've added the details for that database into my ...
Graham's user avatar
  • 4,055
3 votes
2 answers
44 views

What is the status of the civicrm_membership_log table?

Our system is maintaining a membership log in the civicrm_membership_log table, even though detailed logging is switched off. This could actually be quite useful since I have been asked for some ...
user avatar
0 votes
0 answers
24 views

Why my log_civicrm_setting is keep growing with random entries?

I have noticed this since upgraded to 5.36.x that my log_civicrm_setting is kept growing in size with some random navigation enties. No idea what it is. Cannot find these in the civicrm_setting either....
Tapash's user avatar
  • 3,004
2 votes
1 answer
38 views

When enabling logging/auditing for multisite (multi-domain), does it need to be enabled for each site/domain?

When enabling "detailed logging" for a multisite (multi-domain) installation, does logging actually need to be enabled for each domain ID? Or is it sufficient to enable logging only on the &...
Martin_W's user avatar
  • 329
2 votes
0 answers
95 views

Log not created, viewer cannot find it

On my acceptance environment the Civicrm-log is not created. When I use Log Viewer, it cannot find it obviously. But the error message describes a specific file: Unable to read entries from logfile ...
Webmaster COVS's user avatar
1 vote
1 answer
40 views

Delete Change Log for 1 contact

We are trying to delete the change log for 1 user. We want to complete remove their address and information on our system. There a way to delete the change log for 1 contact in CiviCRM?
Scott Pulver's user avatar
0 votes
1 answer
43 views

Where is the Detailed Logging setting stored?

I am attempting to turn on detailed logging for a site (Administer -> System Settings -> Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.), the Logging option. When I save the change, I'm ...
RiverRunner's user avatar
1 vote
1 answer
77 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. ...
Tobias Krause's user avatar
2 votes
2 answers
47 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. ...
ruud's user avatar
  • 289
2 votes
0 answers
25 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 ...
Stephen Palmstrom's user avatar
0 votes
2 answers
237 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 ...
David Hyman's user avatar
1 vote
2 answers
24 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 ...
J. Rolfs's user avatar
  • 381
5 votes
1 answer
92 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 ...
Jon G - Megaphone Tech's user avatar
2 votes
1 answer
45 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 ...
Andy Burns's user avatar
  • 3,681
0 votes
1 answer
130 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 ...
Hugh's user avatar
  • 272
1 vote
1 answer
61 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. ...
G H's user avatar
  • 1,146
2 votes
3 answers
555 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 ...
Tuto's user avatar
  • 83
2 votes
1 answer
179 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 ...
Andy Clark's user avatar
  • 4,845
2 votes
1 answer
216 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. ...
Davy Ivins's user avatar
  • 1,114
1 vote
0 answers
57 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 ...
Clement Leong's user avatar
5 votes
3 answers
298 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 ...
themak's user avatar
  • 3,441
1 vote
2 answers
117 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 ...
Pál Rudan's user avatar
1 vote
1 answer
306 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 ...
Zachary's user avatar
  • 1,797
3 votes
1 answer
126 views

Is it possible to enable/disable logging using cv?

Can the command line cv tool be used to enable/disable logging?
lcdservices's user avatar
1 vote
1 answer
109 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 ...
yurg's user avatar
  • 2,053
2 votes
3 answers
167 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 ...
Andy Clark's user avatar
  • 4,845
3 votes
2 answers
116 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 ...
Andy Clark's user avatar
  • 4,845
9 votes
2 answers
361 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 ...
JohnFF's user avatar
  • 2,343
1 vote
1 answer
33 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 ...
ñull's user avatar
  • 1,208
0 votes
1 answer
27 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. ...
Josh's user avatar
  • 887
2 votes
2 answers
115 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 ...
Zachary's user avatar
  • 1,797
1 vote
1 answer
1k 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 ...
naomi's user avatar
  • 1,247
1 vote
1 answer
88 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?
Mary's user avatar
  • 13
2 votes
1 answer
385 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 ...
MarkDQ's user avatar
  • 493
3 votes
1 answer
136 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 ...
Steven's user avatar
  • 51
4 votes
3 answers
495 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 ...
Jacques-Marie Moranne's user avatar
1 vote
4 answers
188 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 `...
yurg's user avatar
  • 2,053
5 votes
2 answers
380 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!
Adam Sacks's user avatar
0 votes
1 answer
237 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 ...
naomisl's user avatar
  • 728
2 votes
1 answer
147 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: ...
Gilles1394's user avatar
1 vote
2 answers
403 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 ...
Craig Almond's user avatar
  • 2,037
2 votes
1 answer
112 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 ...
Jon G - Megaphone Tech's user avatar
8 votes
6 answers
621 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 ...
Andy Clark's user avatar
  • 4,845
7 votes
3 answers
214 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 ...
Cheryl's user avatar
  • 371