Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [db-logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer

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 ...
Graham's user avatar
  • 4,055
2 votes
4 answers

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 ...
Alan Dixon's user avatar
  • 6,851
0 votes
1 answer

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
1 vote
2 answers

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
0 votes
1 answer

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 ...
alec's user avatar
  • 407
2 votes
1 answer

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
1 vote
2 answers

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 ...
Pál Rudan's user avatar
5 votes
3 answers

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
1 answer

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,777
1 vote
1 answer

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,051
1 vote
1 answer

"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&...
MarkDQ's user avatar
  • 493
0 votes
1 answer

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 ...
carclubadmin's user avatar
3 votes
1 answer

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
12 votes
4 answers

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 ...
Laryn's user avatar
  • 8,268
8 votes
6 answers

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
1 vote
2 answers

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 ...
user469's user avatar
  • 305