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
57 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 ...
Graham's user avatar
  • 4,055
2 votes
4 answers
131 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 ...
Alan Dixon's user avatar
  • 6,851
0 votes
1 answer
104 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
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
0 votes
1 answer
58 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 ...
alec's user avatar
  • 407
2 votes
1 answer
178 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
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 ...
Pál Rudan's user avatar
5 votes
3 answers
293 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
1 answer
303 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,777
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,051
1 vote
1 answer
365 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&...
MarkDQ's user avatar
  • 493
0 votes
1 answer
662 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 ...
carclubadmin's user avatar
3 votes
1 answer
134 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
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 ...
Laryn's user avatar
  • 8,268
8 votes
6 answers
618 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
1 vote
2 answers
64 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 ...
user469's user avatar
  • 305