Skip to main content

Questions tagged [db-logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
4 answers
132 views

CiviCRM Upgrade to 5.60, civicrm_job_log foreign key constraint

During the db upgrade portion of a D7+CiviCRM 5.58.1->5.60.0 upgrade, I'm hitting the error below. Anyone else? Clues? ALTER TABLE civicrm_job_log ADD CONSTRAINT FK_civicrm_job_log_job_id ...
1 vote
1 answer
60 views

Is it OK to truncate log tables?

I've got detailed logging turned on, and everything is getting stored in a separate DB, but it's getting pretty big. Is it OK simply to truncate the tables? Clearly I'll lose the data, and the ability ...
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 ...
1 vote
2 answers
139 views

Contact Logging Report crash - the table is full

I try to run Contact Logging Report, but I get an error message about there are no data in the logging table (Detailed logging is enabled, in the MySQL tables there are a lot of data, and on the ...
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 ...
0 votes
1 answer
59 views

New fields failed to get created properly, resulting in DB errors

In adding new custom fields to an existing set, things recently went wrong. New entries were added in the civicrm_custom_field table, but the corresponding columns were not added to that field set's ...
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 ...
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 ...
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 ...
5 votes
3 answers
299 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
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 ...
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 ...
1 vote
1 answer
367 views

"DB Error: unknown error" when adding (custom) field

Adding a new field to a set of fields results in an error DB Error: unknown error In ConfigAndLog (real names are replaced by , and ): Mar 16 05:19:37 [info] $backTrace = #0 /home/<domain&...
0 votes
1 answer
665 views

Site broken. How do I fix Couldn't repair table: civicrm.log_civicrm_status_pref?

On Drupal 7.52 and CiviCRM 4.7.13 Recently I discovered Civicrm couldn't connect to MySQL. This wonderful error popped up when registering someone for an event: DB Error: no database selected ...
12 votes
4 answers
2k views

MyISAM database but all civicrm_ tables are INNODB... is this a problem?

I just upgraded a large site to 4.7 (without any issues in the upgrade process by the way). The new "System Status" admin screen gives a warning as follows: "Your database is configured to use the ...
1 vote
2 answers
65 views

What causes periodic database errors while using logging, and what should I do about it?

Running a Drupal site with CiviCRM Logging enabled. It seems like once a month we get a crash. On investigation one of the log tables is corrupted. Since the tables are type Archive MYSQL provides ...