Questions tagged [logging]
The logging tag has no usage guidance.
51 questions
0
votes
1
answer
22
views
Cannot get filename from CRM_Core_Error::createDebugLogger() under 5.76.alpha1
$file_log = CRM_Core_Error::createDebugLogger();
$logFileName = $file_log->_filename;
under 5.74.4 gives the current log file.
Under my instance 5.76.alpha1 it $logFileName is null.
This is ...
0
votes
1
answer
41
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 ...
- 381
1
vote
1
answer
65
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 ...
- 590
0
votes
0
answers
59
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 ...
- 395
2
votes
1
answer
131
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 ...
- 317
1
vote
1
answer
19
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 ...
0
votes
1
answer
121
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 ...
- 4,135
3
votes
2
answers
45
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 ...
user6274
0
votes
0
answers
25
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....
- 3,014
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 &...
- 329
2
votes
0
answers
108
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 ...
- 457
1
vote
1
answer
42
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?
- 443
0
votes
1
answer
45
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 ...
- 193
1
vote
1
answer
85
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. ...
- 449
2
votes
2
answers
49
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. ...
- 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 ...
0
votes
2
answers
253
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 ...
- 363
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 ...
- 381
5
votes
1
answer
97
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 ...
- 39.5k
2
votes
1
answer
46
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 ...
- 3,711
0
votes
1
answer
146
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 ...
- 272
1
vote
1
answer
64
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,146
2
votes
3
answers
597
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 ...
- 83
2
votes
1
answer
183
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 ...
- 4,965
2
votes
1
answer
219
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,114
1
vote
0
answers
58
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 ...
- 665
5
votes
3
answers
316
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 ...
- 3,543
1
vote
2
answers
118
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 ...
- 453
1
vote
1
answer
320
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,807
3
votes
1
answer
132
views
Is it possible to enable/disable logging using cv?
Can the command line cv tool be used to enable/disable logging?
- 851
1
vote
1
answer
112
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,186
2
votes
3
answers
174
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 ...
- 4,965
3
votes
2
answers
117
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 ...
- 4,965
9
votes
2
answers
387
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 ...
- 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 ...
- 1,208
0
votes
1
answer
28
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.
...
- 907
2
votes
2
answers
120
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,807
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 ...
- 1,299
1
vote
1
answer
94
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?
- 13
2
votes
1
answer
395
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 ...
- 493
3
votes
1
answer
138
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
...
- 51
4
votes
3
answers
505
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,627
1
vote
4
answers
195
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 `...
- 2,186
5
votes
2
answers
393
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!
- 51
0
votes
1
answer
286
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 ...
- 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: ...
- 23
1
vote
2
answers
405
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,037
2
votes
1
answer
118
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 ...
- 39.5k
8
votes
6
answers
639
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 ...
- 4,965
7
votes
3
answers
220
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 ...
- 371