Questions tagged [db-logging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
31 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 ...
1
vote
1answer
39 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 ...
5
votes
3answers
135 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
1answer
129 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
vote
1answer
52 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 ...
1
vote
1answer
221 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
1answer
479 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 ...
2
votes
1answer
96 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 ...
10
votes
4answers
1k 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 ...
8
votes
6answers
360 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 ...
1
vote
2answers
61 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 ...